DBA Data[Home] [Help]

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PQP_UTILITIES

Line 3200: l_no_of_events := pqp_utilities.get_events

3196:
3197: -- Now invoke the date track interpreter
3198: -- Bug 3015917 : Replaced old DTI call with this new DTI call
3199: IF p_event_group <> 'PQP_GB_TP_GRADE_RULES' THEN
3200: l_no_of_events := pqp_utilities.get_events
3201: (p_assignment_id => p_assignment_id
3202: ,p_element_entry_id => p_element_entry_id
3203: ,p_business_group_id => l_business_group_id
3204: ,p_process_mode => 'ENTRY_EFFECTIVE_DATE'

Line 3216: l_no_of_events := pqp_utilities.get_events

3212: -- Added to pass assignment action ID for event PQP_GB_TP_GRADE_RULES(5547471)
3213: OPEN c_get_aact(p_assignment_id);
3214: FETCH c_get_aact INTO l_assignment_action_id;
3215: CLOSE c_get_aact;
3216: l_no_of_events := pqp_utilities.get_events
3217: (p_assignment_id => p_assignment_id,
3218: p_assignment_action_id => l_assignment_action_id
3219: ,p_element_entry_id => p_element_entry_id
3220: ,p_business_group_id => l_business_group_id

Line 17148: l_return := pqp_utilities.pqp_gb_get_table_value

17144: -- respective collections
17145: debug('User Row Name: '
17146: || l_user_row_name,20);
17147: debug('User Column Name: Management Allowance Element Type');
17148: l_return := pqp_utilities.pqp_gb_get_table_value
17149: (p_business_group_id => g_business_group_id
17150: ,p_effective_date => p_effective_date
17151: ,p_table_name => l_udt_name
17152: ,p_column_name => 'Attribute Location Type'

Line 17163: l_return := pqp_utilities.pqp_gb_get_table_value

17159: g_tab_lon_aln_eles.DELETE;
17160: EXIT;
17161: END IF;
17162: IF upper(l_user_value) in ('E','ELEMENT','R','RATE TYPE') THEN
17163: l_return := pqp_utilities.pqp_gb_get_table_value
17164: (p_business_group_id => g_business_group_id
17165: ,p_effective_date => p_effective_date
17166: ,p_table_name => l_udt_name
17167: ,p_column_name => 'Allowance Code'

Line 17229: l_return := pqp_utilities.pqp_gb_get_table_value

17225: -- respective collections
17226: debug('User Row Name: '
17227: || l_user_row_name,20);
17228: debug('User Column Name: Management Allowance Element Type');
17229: l_return := pqp_utilities.pqp_gb_get_table_value
17230: (p_business_group_id => g_business_group_id
17231: ,p_effective_date => p_effective_date
17232: ,p_table_name => l_udt_name
17233: ,p_column_name => 'Attribute Location Type'

Line 17246: l_return := pqp_utilities.pqp_gb_get_table_value

17242: EXIT;
17243: END IF;
17244:
17245: IF upper(l_user_value) in ('E','ELEMENT','R','RATE TYPE') THEN
17246: l_return := pqp_utilities.pqp_gb_get_table_value
17247: (p_business_group_id => g_business_group_id
17248: ,p_effective_date => p_effective_date
17249: ,p_table_name => l_udt_name
17250: ,p_column_name => 'Allowance Code'