eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PQP_UTILITIES

Line 640: l_return := pqp_utilities.pqp_gb_get_table_value

636: BEGIN
637: --
638: debug_enter(l_proc_name);
639:
640: l_return := pqp_utilities.pqp_gb_get_table_value
641: (p_business_group_id => g_business_group_id
642: ,p_effective_date => p_effective_date
643: ,p_table_name => p_table_name
644: ,p_column_name => p_column_name

Line 659: l_element_type_id := pqp_utilities.pqp_get_element_type_id

655:
656: -- fetch the element type id information
657: debug ('User Value: ' || l_user_value, 10);
658:
659: l_element_type_id := pqp_utilities.pqp_get_element_type_id
660: (p_business_group_id => g_business_group_id
661: ,p_legislation_code => g_legislation_code
662: ,p_effective_date => p_effective_date
663: ,p_element_type_name => l_user_value

Line 740: l_return := pqp_utilities.pqp_gb_get_table_value

736: BEGIN
737: --
738: debug_enter (l_proc_name);
739:
740: l_return := pqp_utilities.pqp_gb_get_table_value
741: (p_business_group_id => g_business_group_id
742: ,p_effective_date => p_effective_date
743: ,p_table_name => p_table_name
744: ,p_column_name => p_column_name

Line 783: l_retval := pqp_utilities.pqp_get_ele_type_extra_info_id

779: l_token := 'Retention Allowance';
780:
781: -- RET1.a : start of block
782: -- get element_type_extra_info_id
783: l_retval := pqp_utilities.pqp_get_ele_type_extra_info_id
784: (p_element_type_id => l_element_type_id
785: ,p_information_type => 'PQP_UK_ELEMENT_ATTRIBUTION'
786: ,p_element_type_extra_info_id => l_element_type_extra_info_id
787: ,p_error_msg => l_error_msg

Line 967: l_return := pqp_utilities.pqp_gb_get_table_value

963: debug(l_proc_name, 30);
964: debug('p_effective_date: '|| p_effective_date,31);
965: debug('udT_name :' || l_udt_name,32);
966:
967: l_return := pqp_utilities.pqp_gb_get_table_value
968: (p_business_group_id => g_business_group_id
969: ,p_effective_date => p_effective_date
970: ,p_table_name => l_udt_name
971: ,p_column_name => 'Management Allowance Rate Type'

Line 1055: l_return := pqp_utilities.pqp_gb_get_table_value

1051: -- Check whether users have specified any rate type information
1052: -- for this salary scale
1053: debug(l_proc_name, 70);
1054:
1055: l_return := pqp_utilities.pqp_gb_get_table_value
1056: (p_business_group_id => g_business_group_id
1057: ,p_effective_date => p_effective_date
1058: ,p_table_name => l_udt_name
1059: ,p_column_name => 'Retention Allowance Rate Type'

Line 1099: l_retval := pqp_utilities.pqp_get_ele_type_extra_info_id

1095: END IF; -- End if of return <> -1 check from get table value func...
1096:
1097: -- RET1.a : start of block
1098: -- get element_type_extra_info_id
1099: l_retval := pqp_utilities.pqp_get_ele_type_extra_info_id
1100: (p_element_type_id => l_element_type_id
1101: ,p_information_type => 'PQP_UK_ELEMENT_ATTRIBUTION'
1102: ,p_element_type_extra_info_id => l_element_type_extra_info_id
1103: ,p_error_msg => l_error_msg

Line 1179: l_return := pqp_utilities.pqp_gb_get_table_value

1175: debug(l_proc_name, 30);
1176: debug('p_effective_date: '|| p_effective_date,110);
1177: debug('udT_name :' || l_udt_name,120);
1178:
1179: l_return := pqp_utilities.pqp_gb_get_table_value
1180: (p_business_group_id => g_business_group_id
1181: ,p_effective_date => p_effective_date
1182: ,p_table_name => l_udt_name
1183: ,p_column_name => 'TLR Allowance Rate Type'

Line 3379: debug('Calling pqp_utilities.get_events', 10);

3375: -- Bug 3015917 : Removed set_pay_proc... call, we now use new style DTI
3376:
3377: -- Now invoke the date track interpreter
3378: -- Bug 3015917 : New DTI call
3379: debug('Calling pqp_utilities.get_events', 10);
3380: debug('p_assignment_id: '||p_assignment_id);
3381: debug('p_element_entry_id: NULL');
3382: debug('p_business_group_id: '||p_business_group_id);
3383: debug('p_process_mode: ENTRY_CREATION_DATE');

Line 3388: l_no_of_events := pqp_utilities.get_events

3384: debug('p_event_group_name: PQP_GB_TP_IS_TEACHER');
3385: debug('p_start_date: '||g_last_effective_date);
3386: debug('p_end_date: '||g_effective_run_date);
3387:
3388: l_no_of_events := pqp_utilities.get_events
3389: (p_assignment_id => p_assignment_id
3390: ,p_element_entry_id => NULL
3391: ,p_business_group_id => p_business_group_id
3392: ,p_process_mode => 'ENTRY_CREATION_DATE'

Line 3577: debug('Calling pqp_utilities.get_events', 210);

3573: -- Now invoke the date track interpreter
3574: -- Bug 3015917 : Removed set_pay_proc.. call, now using new style DTI
3575:
3576: l_no_of_events := 0;
3577: debug('Calling pqp_utilities.get_events', 210);
3578: debug('p_assignment_id: '||p_assignment_id);
3579: debug('p_element_entry_id: NULL');
3580: debug('p_business_group_id: '||p_business_group_id);
3581: debug('p_process_mode: ENTRY_CREATION_DATE');

Line 3587: pqp_utilities.get_events

3583: debug('p_start_date: '||g_last_effective_date);
3584: debug('p_end_date: '||g_effective_run_date);
3585:
3586: l_no_of_events :=
3587: pqp_utilities.get_events
3588: (p_assignment_id => p_assignment_id
3589: ,p_element_entry_id => NULL
3590: ,p_business_group_id => p_business_group_id
3591: ,p_process_mode => 'ENTRY_CREATION_DATE'

Line 4193: l_return := pqp_utilities.pqp_gb_get_table_value

4189: BEGIN
4190: --
4191: debug_enter (l_proc_name);
4192:
4193: l_return := pqp_utilities.pqp_gb_get_table_value
4194: (p_business_group_id => g_business_group_id
4195: ,p_effective_date => p_effective_date
4196: ,p_table_name => p_table_name
4197: ,p_column_name => p_column_name