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_T1_PENSION_EXTRACTS dependencies on PAY_PROCESS_EVENTS

Line 3036: -- Mark pay_process_events to process

3032: debug('p_status: '||p_status);
3033: debug('p_start_date: '||fnd_date.date_to_canonical(p_start_date));
3034: debug('p_end_date: '||fnd_date.date_to_canonical(p_end_date));
3035: --
3036: -- Mark pay_process_events to process
3037: -- as determined by the date range. The maxmum allowed range
3038: -- is the pension year start date and a day before the current eff date
3039:
3040: UPDATE pay_process_events

Line 3040: UPDATE pay_process_events

3036: -- Mark pay_process_events to process
3037: -- as determined by the date range. The maxmum allowed range
3038: -- is the pension year start date and a day before the current eff date
3039:
3040: UPDATE pay_process_events
3041: SET retroactive_status = p_status
3042: ,status = p_status
3043: WHERE assignment_id = p_assignment_id
3044: AND change_type = 'REPORTS'

Line 3090: -- Mark pay_process_events to process

3086: debug('p_start_date: '||fnd_date.date_to_canonical(p_start_date));
3087: debug('p_end_date: '||fnd_date.date_to_canonical(p_end_date));
3088:
3089: --
3090: -- Mark pay_process_events to process
3091: -- as determined by the date range. The maxmum allowed range
3092: -- is the pension year start date and a day before the current eff date
3093:
3094: -- First update for PAY_ELEMENT_ENTRIES_F

Line 3095: UPDATE pay_process_events ppe

3091: -- as determined by the date range. The maxmum allowed range
3092: -- is the pension year start date and a day before the current eff date
3093:
3094: -- First update for PAY_ELEMENT_ENTRIES_F
3095: UPDATE pay_process_events ppe
3096: SET ppe.retroactive_status = p_status
3097: ,ppe.status = p_status
3098: WHERE ppe.assignment_id = p_assignment_id
3099: AND ppe.change_type = 'REPORTS'

Line 3119: UPDATE pay_process_events ppe

3115:
3116: debug(fnd_number.number_to_canonical(SQL%ROWCOUNT)||' PPE row(s) updated.');
3117:
3118: -- Now update for PAY_ELEMENT_ENTRY_VALUES_F
3119: UPDATE pay_process_events ppe
3120: SET ppe.retroactive_status = p_status
3121: ,ppe.status = p_status
3122: WHERE ppe.assignment_id = p_assignment_id
3123: AND ppe.change_type = 'REPORTS'

Line 3598: -- Update the events in pay_process_events to 'P' for "in process".

3594: debug_enter(l_proc_name);
3595: debug('p_effective_start_date: '||to_char(p_effective_start_date), 1) ;
3596: debug('p_effective_end_date: '||to_char(p_effective_end_date), 1) ;
3597:
3598: -- Update the events in pay_process_events to 'P' for "in process".
3599: -- Bug 3015917 : Removed set_pay_process.. as we now use the new style DTI
3600:
3601: -- Check for following leaver events here :
3602: -- Even if a leaver event is found, continue looking for more leaver evnts

Line 4114: -- Reset the events in pay_process_events to 'U' for "Unprocessed".

4110: END LOOP; -- through elected pension change proration dates
4111:
4112: debug('After Teacher Status change check',240);
4113:
4114: -- Reset the events in pay_process_events to 'U' for "Unprocessed".
4115: -- Bug 3015917 : Removed set_pay_process.. as we now use the new style DTI
4116:
4117: l_proration_dates.DELETE;
4118: l_proration_changes.DELETE;

Line 4181: -- Update the events in pay_process_events to 'P' for "in process".

4177: debug_enter(l_proc_name);
4178: debug('p_effective_start_date '||p_effective_start_date);
4179: debug('p_effective_end_date '||p_effective_end_date);
4180:
4181: -- Update the events in pay_process_events to 'P' for "in process".
4182: -- Bug 3015917 : Removed set_pay_process.. as we now use the new style DTI
4183:
4184: -- Check for following restarter events here :
4185: -- Even if a restarter event is found, continue looking for more restarter events

Line 4629: -- Reset the events in pay_process_events to 'U' for "Unprocessed".

4625: END LOOP; -- through elected pension change proration dates
4626:
4627: debug('After Teacher Status change check',160);
4628:
4629: -- Reset the events in pay_process_events to 'U' for "Unprocessed".
4630: -- Bug 3015917 : Removed set_pay_process.. as we now use the new style DTI
4631:
4632: l_proration_dates.DELETE;
4633: l_proration_changes.DELETE;

Line 13461: -- UnMark Pay process events for this element entry

13457: --
13458: END LOOP; -- through change proration dates
13459: --
13460:
13461: -- UnMark Pay process events for this element entry
13462: -- Bug 3015917 : Removed set_pay_process.. as we now use the new style DTI
13463:
13464: END LOOP; -- Through element entries for this element type
13465: --

Line 13481: PROCEDURE set_pay_process_events(p_grade_id IN NUMBER

13477: RAISE;
13478: END; -- store_element_changes
13479:
13480: -- Added by sshetty
13481: PROCEDURE set_pay_process_events(p_grade_id IN NUMBER
13482: ,p_status IN VARCHAR2
13483: ,p_start_date IN DATE
13484: ,p_end_date IN DATE
13485: )

Line 13488: l_proc_name VARCHAR2(61):= 'set_pay_process_events_to_process';

13484: ,p_end_date IN DATE
13485: )
13486: IS
13487: PRAGMA AUTONOMOUS_TRANSACTION;
13488: l_proc_name VARCHAR2(61):= 'set_pay_process_events_to_process';
13489:
13490: BEGIN
13491:
13492: debug_enter(l_proc_name);

Line 13494: UPDATE pay_process_events ppe

13490: BEGIN
13491:
13492: debug_enter(l_proc_name);
13493:
13494: UPDATE pay_process_events ppe
13495: SET ppe.retroactive_status = p_status
13496: ,ppe.status = p_status
13497: WHERE ppe.assignment_id IS NULL
13498: AND ppe.change_type = 'REPORTS'

Line 13516: END set_pay_process_events;

13512: COMMIT;
13513:
13514: debug_exit(l_proc_name);
13515:
13516: END set_pay_process_events;
13517: /**********************************************
13518: --get_grade_sp_type
13519: *******************************************/
13520:

Line 13612: -- Update the events in pay_process_events to 'P' for "in process".

13608: debug_enter(l_proc_name);
13609: debug('Start Date :'||to_char(p_start_date,'DD/MM/YYYY'), 10);
13610: debug('End Date :'||to_char(p_end_date,'DD/MM/YYYY'), 20);
13611:
13612: -- Update the events in pay_process_events to 'P' for "in process".
13613: -- Marking all events between
13614: -- Start : Later or (Pension year start date +1) and pension start date of the person
13615: -- End : pension year end date.
13616: -- Might need to change this to use earlier of pension year end date

Line 13677: -- Reset the events in pay_process_events to 'U' for "Unprocessed".

13673: ,p_end_date => p_end_date
13674: );
13675:
13676:
13677: -- Reset the events in pay_process_events to 'U' for "Unprocessed".
13678: -- Bug 3015917 : Removed set_pay_proc_events_to_process as we now use the
13679: -- new style DTI call
13680:
13681: -- 7) Check for Element entry and entry value changes

Line 13686: -- Warning : Please DONOT mark events to 'P' in pay process events

13682: -- FS :
13683: -- Checking this after unmarking events for this assignment as
13684: -- this proc marks(and resets) events on the basis of element_entry_id
13685: -- for pensionable rate types.
13686: -- Warning : Please DONOT mark events to 'P' in pay process events
13687: -- b4 calling this proc.
13688: store_element_changes(p_assignment_id => p_assignment_id
13689: ,p_start_date => p_start_date
13690: ,p_end_date => p_end_date

Line 13697: -- Warning : Please DONOT mark events to 'P' in pay process events

13693: -- 8) Check for changes to value of a grade rate or spinal point
13694: -- FS :
13695: -- Checking this after unmarking events for this assignment as
13696: -- this proc marks(and resets) events
13697: -- Warning : Please DONOT mark events to 'P' in pay process events
13698: -- b4 calling this proc.
13699: -- Added by sshetty
13700: -- Bug 3015917 : Replaced old call to store_grade_sp_changes
13701: -- with this new call. The grade rule validations are now