APPS.PQP_GB_OMP_TEMPLATE dependencies on PQP_GB_OSP_TEMPLATE

Line 41: ,p_abse_type_lookup_value IN PQP_GB_OSP_TEMPLATE.T_ABS_TYPES

37: ,p_band4_ele_base_name IN VARCHAR2
38: ,p_effective_start_date IN DATE
39: ,p_effective_end_date IN DATE
40: ,p_abse_type_lookup_type IN VARCHAR2
41: ,p_abse_type_lookup_value IN PQP_GB_OSP_TEMPLATE.T_ABS_TYPES
42: ,p_security_group_id IN NUMBER
43: ,p_bg_id IN NUMBER
44: )
45: RETURN NUMBER IS

Line 653: ,p_lookup_values pqp_gb_osp_template.t_abs_types

649: -- PROCEDURE create_lookup
650: --======================================================================
651: PROCEDURE create_lookup (p_lookup_type varchar2
652: ,p_lookup_meaning varchar2
653: ,p_lookup_values pqp_gb_osp_template.t_abs_types
654: ) IS
655: --
656:
657: CURSOR csr_chk_uniq_type IS

Line 1505: pqp_gb_osp_template.create_gap_lookup (

1501:
1502: -- Create GAP lookup dynamically
1503: l_lookup_type := 'PQP_GAP_ABSENCE_TYPES_LIST';
1504: l_lookup_meaning := l_lookup_type;
1505: pqp_gb_osp_template.create_gap_lookup (
1506: p_security_group_id => p_security_group_id
1507: ,p_ele_eff_start_date => p_effective_start_date
1508: ,p_lookup_type => l_lookup_type
1509: ,p_lookup_meaning => l_lookup_meaning

Line 1600: pqp_gb_osp_template.automate_plan_setup

1596: ) ;
1597: --------
1598:
1599: IF p_abse_primary_yn = 'Y' THEN
1600: pqp_gb_osp_template.automate_plan_setup
1601: (p_pl_id => p_plan_id
1602: ,p_business_group_id => p_bg_id
1603: ,p_element_type_id => l_base_element_type_id
1604: ,p_effective_date => p_effective_start_date

Line 2136: pqp_gb_osp_template.del_automated_plan_setup_data

2132: --Delete data created by auto plan setup
2133:
2134: IF p_abse_primary_yn = 'Y'
2135: THEN
2136: pqp_gb_osp_template.del_automated_plan_setup_data
2137: (p_pl_id => p_plan_id
2138: ,p_business_group_id => p_business_group_id
2139: ,p_effective_date => p_effective_date
2140: ,p_base_name => p_pri_ele_name