Need details or white paper for the function per_availability_details.get_schedule_duration

Biswajit Swain

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.

Andrew_Schmitz

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

Gianni Ceresa

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

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

Omnia-Oracle

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

    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

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

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

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