DBA Data[Home] [Help]

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PQP_UTILITIES

Line 3228: l_no_of_events := pqp_utilities.get_events

3224:
3225: -- Now invoke the date track interpreter
3226: -- Bug 3015917 : Replaced old DTI call with this new DTI call
3227: IF p_event_group <> 'PQP_GB_TP_GRADE_RULES' THEN
3228: l_no_of_events := pqp_utilities.get_events
3229: (p_assignment_id => p_assignment_id
3230: ,p_element_entry_id => p_element_entry_id
3231: ,p_business_group_id => l_business_group_id
3232: ,p_process_mode => 'ENTRY_EFFECTIVE_DATE'

Line 3244: l_no_of_events := pqp_utilities.get_events

3240: -- Added to pass assignment action ID for event PQP_GB_TP_GRADE_RULES(5547471)
3241: OPEN c_get_aact(p_assignment_id);
3242: FETCH c_get_aact INTO l_assignment_action_id;
3243: CLOSE c_get_aact;
3244: l_no_of_events := pqp_utilities.get_events
3245: (p_assignment_id => p_assignment_id,
3246: p_assignment_action_id => l_assignment_action_id
3247: ,p_element_entry_id => p_element_entry_id
3248: ,p_business_group_id => l_business_group_id

Line 17517: l_return := pqp_utilities.pqp_gb_get_table_value

17513: -- respective collections
17514: debug('User Row Name: '
17515: || l_user_row_name,20);
17516: debug('User Column Name: Management Allowance Element Type');
17517: l_return := pqp_utilities.pqp_gb_get_table_value
17518: (p_business_group_id => g_business_group_id
17519: ,p_effective_date => p_effective_date
17520: ,p_table_name => l_udt_name
17521: ,p_column_name => 'Attribute Location Type'

Line 17532: l_return := pqp_utilities.pqp_gb_get_table_value

17528: g_tab_lon_aln_eles.DELETE;
17529: EXIT;
17530: END IF;
17531: IF upper(l_user_value) in ('E','ELEMENT','R','RATE TYPE') THEN
17532: l_return := pqp_utilities.pqp_gb_get_table_value
17533: (p_business_group_id => g_business_group_id
17534: ,p_effective_date => p_effective_date
17535: ,p_table_name => l_udt_name
17536: ,p_column_name => 'Allowance Code'

Line 17598: l_return := pqp_utilities.pqp_gb_get_table_value

17594: -- respective collections
17595: debug('User Row Name: '
17596: || l_user_row_name,20);
17597: debug('User Column Name: Management Allowance Element Type');
17598: l_return := pqp_utilities.pqp_gb_get_table_value
17599: (p_business_group_id => g_business_group_id
17600: ,p_effective_date => p_effective_date
17601: ,p_table_name => l_udt_name
17602: ,p_column_name => 'Attribute Location Type'

Line 17615: l_return := pqp_utilities.pqp_gb_get_table_value

17611: EXIT;
17612: END IF;
17613:
17614: IF upper(l_user_value) in ('E','ELEMENT','R','RATE TYPE') THEN
17615: l_return := pqp_utilities.pqp_gb_get_table_value
17616: (p_business_group_id => g_business_group_id
17617: ,p_effective_date => p_effective_date
17618: ,p_table_name => l_udt_name
17619: ,p_column_name => 'Allowance Code'