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 3008: -- Mark pay_process_events to process

3004: debug('p_status: '||p_status);
3005: debug('p_start_date: '||fnd_date.date_to_canonical(p_start_date));
3006: debug('p_end_date: '||fnd_date.date_to_canonical(p_end_date));
3007: --
3008: -- Mark pay_process_events to process
3009: -- as determined by the date range. The maxmum allowed range
3010: -- is the pension year start date and a day before the current eff date
3011:
3012: UPDATE pay_process_events

Line 3012: UPDATE pay_process_events

3008: -- Mark pay_process_events to process
3009: -- as determined by the date range. The maxmum allowed range
3010: -- is the pension year start date and a day before the current eff date
3011:
3012: UPDATE pay_process_events
3013: SET retroactive_status = p_status
3014: ,status = p_status
3015: WHERE assignment_id = p_assignment_id
3016: AND change_type = 'REPORTS'

Line 3062: -- Mark pay_process_events to process

3058: debug('p_start_date: '||fnd_date.date_to_canonical(p_start_date));
3059: debug('p_end_date: '||fnd_date.date_to_canonical(p_end_date));
3060:
3061: --
3062: -- Mark pay_process_events to process
3063: -- as determined by the date range. The maxmum allowed range
3064: -- is the pension year start date and a day before the current eff date
3065:
3066: -- First update for PAY_ELEMENT_ENTRIES_F

Line 3067: UPDATE pay_process_events ppe

3063: -- as determined by the date range. The maxmum allowed range
3064: -- is the pension year start date and a day before the current eff date
3065:
3066: -- First update for PAY_ELEMENT_ENTRIES_F
3067: UPDATE pay_process_events ppe
3068: SET ppe.retroactive_status = p_status
3069: ,ppe.status = p_status
3070: WHERE ppe.assignment_id = p_assignment_id
3071: AND ppe.change_type = 'REPORTS'

Line 3091: UPDATE pay_process_events ppe

3087:
3088: debug(fnd_number.number_to_canonical(SQL%ROWCOUNT)||' PPE row(s) updated.');
3089:
3090: -- Now update for PAY_ELEMENT_ENTRY_VALUES_F
3091: UPDATE pay_process_events ppe
3092: SET ppe.retroactive_status = p_status
3093: ,ppe.status = p_status
3094: WHERE ppe.assignment_id = p_assignment_id
3095: AND ppe.change_type = 'REPORTS'

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

3566: debug_enter(l_proc_name);
3567: debug('p_effective_start_date: '||to_char(p_effective_start_date), 1) ;
3568: debug('p_effective_end_date: '||to_char(p_effective_end_date), 1) ;
3569:
3570: -- Update the events in pay_process_events to 'P' for "in process".
3571: -- Bug 3015917 : Removed set_pay_process.. as we now use the new style DTI
3572:
3573: -- Check for following leaver events here :
3574: -- Even if a leaver event is found, continue looking for more leaver evnts

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

4082: END LOOP; -- through elected pension change proration dates
4083:
4084: debug('After Teacher Status change check',240);
4085:
4086: -- Reset the events in pay_process_events to 'U' for "Unprocessed".
4087: -- Bug 3015917 : Removed set_pay_process.. as we now use the new style DTI
4088:
4089: l_proration_dates.DELETE;
4090: l_proration_changes.DELETE;

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

4149: debug_enter(l_proc_name);
4150: debug('p_effective_start_date '||p_effective_start_date);
4151: debug('p_effective_end_date '||p_effective_end_date);
4152:
4153: -- Update the events in pay_process_events to 'P' for "in process".
4154: -- Bug 3015917 : Removed set_pay_process.. as we now use the new style DTI
4155:
4156: -- Check for following restarter events here :
4157: -- Even if a restarter event is found, continue looking for more restarter events

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

4597: END LOOP; -- through elected pension change proration dates
4598:
4599: debug('After Teacher Status change check',160);
4600:
4601: -- Reset the events in pay_process_events to 'U' for "Unprocessed".
4602: -- Bug 3015917 : Removed set_pay_process.. as we now use the new style DTI
4603:
4604: l_proration_dates.DELETE;
4605: l_proration_changes.DELETE;

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

13258: --
13259: END LOOP; -- through change proration dates
13260: --
13261:
13262: -- UnMark Pay process events for this element entry
13263: -- Bug 3015917 : Removed set_pay_process.. as we now use the new style DTI
13264:
13265: END LOOP; -- Through element entries for this element type
13266: --

Line 13282: PROCEDURE set_pay_process_events(p_grade_id IN NUMBER

13278: RAISE;
13279: END; -- store_element_changes
13280:
13281: -- Added by sshetty
13282: PROCEDURE set_pay_process_events(p_grade_id IN NUMBER
13283: ,p_status IN VARCHAR2
13284: ,p_start_date IN DATE
13285: ,p_end_date IN DATE
13286: )

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

13285: ,p_end_date IN DATE
13286: )
13287: IS
13288: PRAGMA AUTONOMOUS_TRANSACTION;
13289: l_proc_name VARCHAR2(61):= 'set_pay_process_events_to_process';
13290:
13291: BEGIN
13292:
13293: debug_enter(l_proc_name);

Line 13295: UPDATE pay_process_events ppe

13291: BEGIN
13292:
13293: debug_enter(l_proc_name);
13294:
13295: UPDATE pay_process_events ppe
13296: SET ppe.retroactive_status = p_status
13297: ,ppe.status = p_status
13298: WHERE ppe.assignment_id IS NULL
13299: AND ppe.change_type = 'REPORTS'

Line 13317: END set_pay_process_events;

13313: COMMIT;
13314:
13315: debug_exit(l_proc_name);
13316:
13317: END set_pay_process_events;
13318: /**********************************************
13319: --get_grade_sp_type
13320: *******************************************/
13321:

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

13409: debug_enter(l_proc_name);
13410: debug('Start Date :'||to_char(p_start_date,'DD/MM/YYYY'), 10);
13411: debug('End Date :'||to_char(p_end_date,'DD/MM/YYYY'), 20);
13412:
13413: -- Update the events in pay_process_events to 'P' for "in process".
13414: -- Marking all events between
13415: -- Start : Later or (Pension year start date +1) and pension start date of the person
13416: -- End : pension year end date.
13417: -- Might need to change this to use earlier of pension year end date

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

13474: ,p_end_date => p_end_date
13475: );
13476:
13477:
13478: -- Reset the events in pay_process_events to 'U' for "Unprocessed".
13479: -- Bug 3015917 : Removed set_pay_proc_events_to_process as we now use the
13480: -- new style DTI call
13481:
13482: -- 7) Check for Element entry and entry value changes

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

13483: -- FS :
13484: -- Checking this after unmarking events for this assignment as
13485: -- this proc marks(and resets) events on the basis of element_entry_id
13486: -- for pensionable rate types.
13487: -- Warning : Please DONOT mark events to 'P' in pay process events
13488: -- b4 calling this proc.
13489: store_element_changes(p_assignment_id => p_assignment_id
13490: ,p_start_date => p_start_date
13491: ,p_end_date => p_end_date

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

13494: -- 8) Check for changes to value of a grade rate or spinal point
13495: -- FS :
13496: -- Checking this after unmarking events for this assignment as
13497: -- this proc marks(and resets) events
13498: -- Warning : Please DONOT mark events to 'P' in pay process events
13499: -- b4 calling this proc.
13500: -- Added by sshetty
13501: -- Bug 3015917 : Replaced old call to store_grade_sp_changes
13502: -- with this new call. The grade rule validations are now