DBA Data[Home] [Help]

APPS.PQP_GB_UNPAID_TEMPLATE dependencies on PQP_GB_OSP_TEMPLATE

Line 620: ,p_lookup_values pqp_gb_osp_Template.t_abs_types

616: -- PROCEDURE create_lookup
617: --======================================================================
618: PROCEDURE create_lookup (p_lookup_type varchar2
619: ,p_lookup_meaning varchar2
620: ,p_lookup_values pqp_gb_osp_Template.t_abs_types
621: ,p_security_group_id in number
622: ,p_effective_start_date in date
623: ) IS
624: --

Line 809: ,p_abs_type_lookup_value in pqp_gb_osp_template.t_abs_types

805: ,p_pay_src_pay_component in varchar2
806: ,p_ele_eff_start_date in date
807: ,p_ele_eff_end_date in date
808: ,p_abs_type_lookup_type in varchar2
809: ,p_abs_type_lookup_value in pqp_gb_osp_template.t_abs_types
810: ,p_security_group_id in number
811: ,p_bg_id in number
812: )
813: RETURN NUMBER IS

Line 1405: pqp_gb_osp_template.create_gap_lookup (

1401:
1402: -- Create GAP lookup dynamically
1403: l_lookup_type := 'PQP_GAP_ABSENCE_TYPES_LIST';
1404: l_lookup_meaning := l_lookup_type;
1405: pqp_gb_osp_template.create_gap_lookup (
1406: p_security_group_id => p_security_group_id
1407: ,p_ele_eff_start_date => p_ele_eff_start_date
1408: ,p_lookup_type => l_lookup_type
1409: ,p_lookup_meaning => l_lookup_meaning

Line 1520: pqp_gb_osp_template.automate_plan_setup

1516: ) ;
1517:
1518: --------
1519: IF p_abs_primary_yn = 'Y' THEN
1520: pqp_gb_osp_template.automate_plan_setup
1521: (p_pl_id => p_plan_id
1522: ,p_business_group_id => p_bg_id
1523: ,p_element_type_id => l_base_element_type_id
1524: ,p_effective_date => p_ele_eff_start_date

Line 2155: pqp_gb_osp_template.del_automated_plan_setup_data

2151: --Delete data created by auto plan setup
2152:
2153: IF p_abs_primary_yn = 'Y'
2154: THEN
2155: pqp_gb_osp_template.del_automated_plan_setup_data
2156: (p_pl_id => p_plan_id
2157: ,p_business_group_id => p_business_group_id
2158: ,p_effective_date => p_effective_date
2159: ,p_base_name => p_abs_ele_name