APPS.PQP_GB_SS_ABSENCE_TEMPLATE dependencies on PQP_GB_OSP_TEMPLATE

Line 225: ,P_ABSE_TYPE_LOOKUP_VALUE IN pqp_gb_osp_template.t_abs_types

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

Line 234: l_lookup_table pqp_gb_osp_template.t_abs_types;

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

Line 414: ,P_ABS_TYPE_LOOKUP_VALUE IN pqp_gb_osp_template.t_abs_types

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

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

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

Line 433: l_lookup_table pqp_gb_osp_template.t_abs_types;

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

Line 434: l_lookup_table_plan_typ pqp_gb_osp_template.t_plan_types;

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

Line 562: l_element_type_id := pqp_gb_osp_template.create_user_template

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

Line 690: ,P_ABS_TYPE_LOOKUP_VALUE IN pqp_gb_osp_template.t_abs_types

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

Line 701: l_lookup_table pqp_gb_osp_template.t_abs_types;

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