APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PQP_UTILITIES

Line 323: IF pqp_utilities.pqp_gb_get_table_value (

319:
320: DEBUG ('Get Initial Extract Date');
321: DEBUG ('Calling function pqp_gb_get_table_value');
322:
323: IF pqp_utilities.pqp_gb_get_table_value (
324: p_business_group_id=> g_business_group_id,
325: p_effective_date=> g_effective_date,
326: p_table_name=> g_extract_udt_name,
327: p_column_name=> 'Initial Extract Date',

Line 650: IF pqp_utilities.pqp_gb_get_table_value (

646:
647: DEBUG ('Get Pension Scheme Source Type');
648: DEBUG ('Calling function pqp_gb_get_table_value');
649:
650: IF pqp_utilities.pqp_gb_get_table_value (
651: p_business_group_id=> g_business_group_id,
652: p_effective_date=> g_effective_date,
653: p_table_name=> g_extract_udt_name,
654: p_column_name=> 'Attribute Location Type',

Line 687: IF pqp_utilities.pqp_gb_get_table_value (

683:
684: DEBUG ('Get Pension Scheme Source Name');
685: DEBUG ('Calling function pqp_gb_get_table_value');
686:
687: IF pqp_utilities.pqp_gb_get_table_value (
688: p_business_group_id=> g_business_group_id,
689: p_effective_date=> g_effective_date,
690: p_table_name=> g_extract_udt_name,
691: p_column_name=> 'Attribute Location Qualifier 1',

Line 752: IF pqp_utilities.pqp_gb_get_table_value (

748: || l_row_name (i)
749: || ' information');
750: DEBUG ('Calling function pqp_gb_get_table_value');
751:
752: IF pqp_utilities.pqp_gb_get_table_value (
753: p_business_group_id=> g_business_group_id,
754: p_effective_date=> g_effective_date,
755: p_table_name=> g_extract_udt_name,
756: p_column_name=> 'Attribute Location Qualifier 1',

Line 815: IF pqp_utilities.pqp_gb_get_table_value (

811: || l_row_name (i)
812: || ' information');
813: DEBUG ('Calling function pqp_gb_get_table_value');
814:
815: IF pqp_utilities.pqp_gb_get_table_value (
816: p_business_group_id=> g_business_group_id,
817: p_effective_date=> g_effective_date,
818: p_table_name=> g_extract_udt_name,
819: p_column_name=> 'Attribute Location Qualifier 1',

Line 2876: 'Before calling function pqp_utilities.pqp_get_extra_element_info'

2872: -- Get the scheme number from the element extra info type
2873: DEBUG ('Get the scheme number from the element EIT');
2874: -- Call function pqp_utility_function
2875: DEBUG (
2876: 'Before calling function pqp_utilities.pqp_get_extra_element_info'
2877: );
2878: l_return := 0;
2879: l_return :=
2880: pqp_utilities.pqp_get_extra_element_info (

Line 2880: pqp_utilities.pqp_get_extra_element_info (

2876: 'Before calling function pqp_utilities.pqp_get_extra_element_info'
2877: );
2878: l_return := 0;
2879: l_return :=
2880: pqp_utilities.pqp_get_extra_element_info (
2881: p_element_type_id=> g_ele_entry_details (p_assignment_id).element_type_id,
2882: p_information_type=> 'PQP_GB_PENSION_SCHEME_INFO',
2883: p_segment_name=> 'Scheme Number',
2884: p_value=> l_scheme_number,

Line 2960: 'Before calling function pqp_utilities.pqp_get_extra_element_info'

2956: -- Get the scheme number from the element extra info type
2957: DEBUG ('Get the employer number from the element EIT');
2958: -- Call function pqp_utility_function
2959: DEBUG (
2960: 'Before calling function pqp_utilities.pqp_get_extra_element_info'
2961: );
2962: l_return := 0;
2963: l_return :=
2964: pqp_utilities.pqp_get_extra_element_info (

Line 2964: pqp_utilities.pqp_get_extra_element_info (

2960: 'Before calling function pqp_utilities.pqp_get_extra_element_info'
2961: );
2962: l_return := 0;
2963: l_return :=
2964: pqp_utilities.pqp_get_extra_element_info (
2965: p_element_type_id=> g_ele_entry_details (p_assignment_id).element_type_id,
2966: p_information_type=> 'PQP_GB_PENSION_SCHEME_INFO',
2967: p_segment_name=> 'Employer Reference Number',
2968: p_value=> l_employer_ref_no,

Line 5152: l_event_details pqp_utilities.t_event_details_table_type;

5148: l_error_number NUMBER;
5149: l_error_text VARCHAR2 (200);
5150: l_return NUMBER;
5151: i NUMBER;
5152: l_event_details pqp_utilities.t_event_details_table_type;
5153:
5154: --
5155: BEGIN
5156: debug_enter (l_proc_name);

Line 5234: pqp_utilities.get_events (

5230: l_event_details.DELETE;
5231:
5232: IF l_inclusion_flag = 'Y'
5233: AND -- One or more HOUR CHANGE events have been found
5234: pqp_utilities.get_events (
5235: p_assignment_id=> p_assignment_id,
5236: p_business_group_id=> p_business_group_id,
5237: p_process_mode=> 'ENTRY_EFFECTIVE_DATE',
5238: p_event_group_name=> 'PQP_GB_CPX_HOUR_CHANGE',

Line 5277: pqp_utilities.get_events (

5273: p_effective_start_date=> g_effective_start_date,
5274: p_effective_end_date=> g_effective_end_date
5275: ) = 'Y'
5276: AND -- One or more HOUR CHANGE events have been found
5277: pqp_utilities.get_events (
5278: p_assignment_id=> l_secondary_asg_ids (i),
5279: p_business_group_id=> p_business_group_id,
5280: p_process_mode=> 'ENTRY_EFFECTIVE_DATE',
5281: p_event_group_name=> 'PQP_GB_CPX_HOUR_CHANGE',