Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need details or white paper for the function per_availability_details.get_schedule_duration

Received Response
113
Views
8
Comments
Biswajit Swain
Biswajit Swain Rank 1 - Community Starter
in Oracle Analytics Publisher

We need details on the parameters used in the function per_availability_details.get_schedule_duration.

Any document or white paper or any clue regarding the details of the parameters is appreciated.

Answers

  • Andrew_Schmitz
    Andrew_Schmitz Rank 5 - Community Champion

    I doubt you will get a response or answer, but this sounds like you should create an SR.

  • Gianni Ceresa
    Gianni Ceresa Mod

    That function doesn't sound like a standard Publisher function. Is that related to some other product? If yes, providing the name of the product increase the chances of a reply.

    If it's related to Fusion, you should ask in the forum in charge of Fusion: https://community.oracle.com/customerconnect

  • Karthick_J
    Karthick_J Rank 1 - Community Starter

    Did you get the answer or still you are looking for ?

  • Omnia-Oracle
    Omnia-Oracle Rank 1 - Community Starter

    This package function is needed in writing value sets of type table (Sql) for Oracle Absence validation. However, it needs more clarification for its parameters and how it is called.

  • User_O9529
    User_O9529 Rank 1 - Community Starter 
        FUNCTION get_schedule_duration(
    
                         p_resource_id             IN NUMBER
    
                        ,p_resource_type           IN VARCHAR2     DEFAULT 'ASSIGN'
    
                        ,p_period_start            IN DATE
    
                        ,p_period_end              IN DATE
    
                        ,p_use_sch_asg             IN CHAR         DEFAULT 'Y'
    
                        ,p_use_sch_inh             IN CHAR         DEFAULT 'Y'
    
                        ,p_include_noshift         IN CHAR         DEFAULT 'N'
    
                        ,p_include_calevents       IN CHAR         DEFAULT 'Y'
    
                        ,p_calc_units              IN CHAR         DEFAULT 'H'
    
                        ,p_get_full_pay_period     IN CHAR         DEFAULT 'N'
    
                        ,p_use_working_hour_method IN CHAR         DEFAULT 'N'
    
                        ,p_default_hours_per_day   IN NUMBER       DEFAULT 0
    
                        ,p_default_start_time      IN VARCHAR2     DEFAULT '08:30'  -- The format of time is 'hh24:mi'
    
                        ,p_default_work_week       IN VARCHAR2     DEFAULT '0-1-1-1-1-1-0'  -- work week starting from Sunday
    
                        ,p_use_alt_sch             IN CHAR         DEFAULT 'N' -- use an alternate work schedule instead of the primary work schedule
    
                        ,p_sch_category            IN VARCHAR2     DEFAULT null -- the category code of the alternate work schedule
    
			,p_hier_level              IN varchar2     DEFAULT 'ORA_ANC_WORK_PATTERN' --BPAD 14923
    
                        ) RETURN NUMBER;
  • Karthick_J
    Karthick_J Rank 1 - Community Starter

    Hi @User_O9529

    This is a package spec. Is there any way to get the package body to get more info about this function like which tables are used / what the business logic used behind the screen

    Regards,

    Karthick

  • User_O9529
    User_O9529 Rank 1 - Community Starter

    Hi, @Karthick_J.

    I was not able to find the package body. But the topic starter asked about parameters. I provided it from the spec.

  • Karthick_J
    Karthick_J Rank 1 - Community Starter
    edited Jan 29, 2025 1:40PM

    Hi @User_O9529,

    Yes, this post requestor looking for parameter.

    Just checking if you can get package body as well. Anyhow, Thanks for response.

    Regards,

    Karthick