APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PQP_UTILITIES

Line 324: IF pqp_utilities.pqp_gb_get_table_value (

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

Line 651: IF pqp_utilities.pqp_gb_get_table_value (

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

Line 688: IF pqp_utilities.pqp_gb_get_table_value (

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

Line 753: IF pqp_utilities.pqp_gb_get_table_value (

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

Line 816: IF pqp_utilities.pqp_gb_get_table_value (

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

Line 2877: 'Before calling function pqp_utilities.pqp_get_extra_element_info'

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

Line 2881: pqp_utilities.pqp_get_extra_element_info (

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

Line 2961: 'Before calling function pqp_utilities.pqp_get_extra_element_info'

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

Line 2965: pqp_utilities.pqp_get_extra_element_info (

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

Line 5179: l_event_details pqp_utilities.t_event_details_table_type;

5175: l_error_number NUMBER;
5176: l_error_text VARCHAR2 (200);
5177: l_return NUMBER;
5178: i NUMBER;
5179: l_event_details pqp_utilities.t_event_details_table_type;
5180:
5181: --
5182: BEGIN
5183: debug_enter (l_proc_name);

Line 5261: pqp_utilities.get_events (

5257: l_event_details.DELETE;
5258:
5259: IF l_inclusion_flag = 'Y'
5260: AND -- One or more HOUR CHANGE events have been found
5261: pqp_utilities.get_events (
5262: p_assignment_id=> p_assignment_id,
5263: p_business_group_id=> p_business_group_id,
5264: p_process_mode=> 'ENTRY_CREATION_DATE',
5265: p_event_group_name=> 'PQP_GB_CPX_HOUR_CHANGE',

Line 5304: pqp_utilities.get_events (

5300: p_effective_start_date=> g_effective_start_date,
5301: p_effective_end_date=> g_effective_end_date
5302: ) = 'Y'
5303: AND -- One or more HOUR CHANGE events have been found
5304: pqp_utilities.get_events (
5305: p_assignment_id=> l_secondary_asg_ids (i),
5306: p_business_group_id=> p_business_group_id,
5307: p_process_mode=> 'ENTRY_CREATION_DATE',
5308: p_event_group_name=> 'PQP_GB_CPX_HOUR_CHANGE',