APPS.PQP_GB_SS_ABSENCE_TEMPLATE dependencies on PQP_GB_OSP_TEMPLATE

Line 227: ,P_ABSE_TYPE_LOOKUP_VALUE IN pqp_gb_osp_template.t_abs_types

223: ,P_BAND4_ELE_BASE_NAME IN VARCHAR2
224: ,P_EFFECTIVE_START_DATE IN DATE
225: ,P_EFFECTIVE_END_DATE IN DATE
226: ,P_ABSE_TYPE_LOOKUP_TYPE IN VARCHAR2
227: ,P_ABSE_TYPE_LOOKUP_VALUE IN pqp_gb_osp_template.t_abs_types
228: ,P_ELEMENT_TYPE_ID OUT NOCOPY NUMBER
229: ,P_REQUEST_ID OUT NOCOPY NUMBER
230: ,P_SECURITY_GROUP_ID IN NUMBER
231: ,P_BG_ID IN NUMBER

Line 236: l_lookup_table pqp_gb_osp_template.t_abs_types;

232: )
233: IS
234:
235: -- Table to pass as param to the create_osp_template proc.
236: l_lookup_table pqp_gb_osp_template.t_abs_types;
237:
238: l_element_type_id pay_element_types_f.element_type_id%TYPE;
239: l_sec_grp_id per_business_groups.security_group_id%TYPE;
240: i number;

Line 416: ,P_ABS_TYPE_LOOKUP_VALUE IN pqp_gb_osp_template.t_abs_types

412: ,P_ELE_EFF_START_DATE IN DATE
413: --,P_ELE_EFF_END_DATE IN VARCHAR2
414: ,P_ELE_EFF_END_DATE IN DATE
415: ,P_ABS_TYPE_LOOKUP_TYPE IN VARCHAR2
416: ,P_ABS_TYPE_LOOKUP_VALUE IN pqp_gb_osp_template.t_abs_types
417: ,P_ELEMENT_TYPE_ID OUT NOCOPY NUMBER
418: ,P_REQUEST_ID OUT NOCOPY NUMBER
419: ,P_SECURITY_GROUP_ID IN NUMBER
420: ,P_BG_ID IN NUMBER

Line 422: ,P_PLAN_TYPE_LOOKUP_VALUE IN pqp_gb_osp_template.t_plan_types --LG

418: ,P_REQUEST_ID OUT NOCOPY NUMBER
419: ,P_SECURITY_GROUP_ID IN NUMBER
420: ,P_BG_ID IN NUMBER
421: ,P_PLAN_TYPE_LOOKUP_TYPE IN VARCHAR2 --LG
422: ,P_PLAN_TYPE_LOOKUP_VALUE IN pqp_gb_osp_template.t_plan_types --LG
423: ,P_ENABLE_ENT_PRORATION IN VARCHAR2 DEFAULT NULL --LG
424: ,P_SCHEME_TYPE IN VARCHAR2 DEFAULT NULL -- LG
425: ,P_ABS_SCHEDULE_WP IN VARCHAR2 DEFAULT NULL -- LG
426: ,P_DUAL_ROLLING_DURATION IN NUMBER DEFAULT NULL -- LG

Line 435: l_lookup_table pqp_gb_osp_template.t_abs_types;

431: IS
432:
433:
434: -- Table to pass as param to the create_osp_template proc.
435: l_lookup_table pqp_gb_osp_template.t_abs_types;
436: l_lookup_table_plan_typ pqp_gb_osp_template.t_plan_types;
437:
438: --
439: -- Ref cursor to execute the statement that comes as param

Line 436: l_lookup_table_plan_typ pqp_gb_osp_template.t_plan_types;

432:
433:
434: -- Table to pass as param to the create_osp_template proc.
435: l_lookup_table pqp_gb_osp_template.t_abs_types;
436: l_lookup_table_plan_typ pqp_gb_osp_template.t_plan_types;
437:
438: --
439: -- Ref cursor to execute the statement that comes as param
440: --

Line 564: l_element_type_id := pqp_gb_osp_template.create_user_template

560: hr_utility.trace('l_sec_grp_id :' || l_sec_grp_id);
561: hr_utility.trace('Calling the create_user_template from my proc...');
562:
563:
564: l_element_type_id := pqp_gb_osp_template.create_user_template
565: (p_plan_id => P_PLAN_ID
566: ,p_plan_description => P_PLAN_DESCRIPTION
567: ,p_sch_cal_type => P_SCH_CAL_TYPE
568: ,p_sch_cal_duration => P_SCH_CAL_DURATION

Line 688: ,P_ABS_TYPE_LOOKUP_VALUE IN pqp_gb_osp_template.t_abs_types

684: ,P_PAY_SRC_PAY_COMPONENT IN VARCHAR2
685: ,P_ELE_EFF_START_DATE IN DATE
686: ,P_ELE_EFF_END_DATE IN DATE
687: ,P_ABS_TYPE_LOOKUP_TYPE IN VARCHAR2
688: ,P_ABS_TYPE_LOOKUP_VALUE IN pqp_gb_osp_template.t_abs_types
689: ,P_ELEMENT_TYPE_ID OUT NOCOPY NUMBER
690: ,P_REQUEST_ID OUT NOCOPY NUMBER
691: ,P_SECURITY_GROUP_ID IN NUMBER
692: ,P_BG_ID IN NUMBER

Line 699: l_lookup_table pqp_gb_osp_template.t_abs_types;

695: IS
696:
697:
698: -- Table to pass as param to the create_osp_template proc.
699: l_lookup_table pqp_gb_osp_template.t_abs_types;
700:
701: --
702: -- Ref cursor to execute the statement that comes as param
703: --