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.PSP_ENC_CREATE_LINES dependencies on PSP_ENC_SUMMARY_LINES

Line 7219: FROM psp_enc_summary_lines pesl

7215: WHERE assignment_id = l_assignment_id
7216: AND payroll_id = l_payroll_id
7217: AND change_flag = 'U'
7218: AND EXISTS (SELECT 1
7219: FROM psp_enc_summary_lines pesl
7220: WHERE pesl.assignment_id = l_assignment_id
7221: AND pesl.payroll_id = l_payroll_id
7222: AND status_code = 'A'
7223: AND pesl.enc_summary_line_id = pelh.enc_summary_line_id);

Line 7236: FROM psp_enc_summary_lines pesl

7232: WHERE assignment_id = l_assignment_id
7233: AND payroll_id = l_payroll_id
7234: AND change_flag = 'U'
7235: AND EXISTS (SELECT 1
7236: FROM psp_enc_summary_lines pesl
7237: WHERE pesl.assignment_id = l_assignment_id
7238: AND pesl.payroll_id = l_payroll_id
7239: AND status_code = 'A'
7240: AND pesl.enc_summary_line_id = pelh.enc_summary_line_id

Line 7259: FROM psp_enc_summary_lines pesl

7255: WHERE assignment_id = l_assignment_id
7256: AND payroll_id = l_payroll_id
7257: AND change_flag = 'N'
7258: AND EXISTS (SELECT 1
7259: FROM psp_enc_summary_lines pesl
7260: WHERE pesl.assignment_id = l_assignment_id
7261: AND pesl.payroll_id = l_payroll_id
7262: AND status_code = 'A'
7263: AND pesl.enc_summary_line_id = pelh.enc_summary_line_id

Line 7321: FROM psp_enc_summary_lines pesl

7317: WHERE pepa.payroll_action_id = p_payroll_action_id
7318: AND pepa.assignment_id = t_assignments.asg_array(recno)
7319: AND pepa.payroll_id = t_assignments.payroll_array(recno)
7320: AND NOT EXISTS (SELECT 1
7321: FROM psp_enc_summary_lines pesl
7322: WHERE pesl.payroll_action_id = p_payroll_action_id
7323: AND pesl.assignment_id = t_assignments.asg_array(recno)
7324: AND pesl.payroll_id = t_assignments.payroll_array(recno));
7325:

Line 7333: FROM psp_enc_summary_lines pesl

7329: WHERE pepa.payroll_action_id = p_payroll_action_id
7330: AND pepa.assignment_id = t_assignments.asg_array(recno)
7331: AND pepa.payroll_id = t_assignments.payroll_array(recno)
7332: AND EXISTS (SELECT 1
7333: FROM psp_enc_summary_lines pesl
7334: WHERE pesl.payroll_action_id = p_payroll_action_id
7335: AND pesl.assignment_id = t_assignments.asg_array(recno)
7336: AND pesl.payroll_id = t_assignments.payroll_array(recno));
7337:

Line 7345: FROM psp_enc_summary_lines pesl

7341: WHERE pepa.payroll_action_id = p_payroll_action_id
7342: AND pepa.assignment_id = t_assignments.asg_array(recno)
7343: AND pepa.payroll_id = t_assignments.payroll_array(recno)
7344: AND EXISTS (SELECT 1
7345: FROM psp_enc_summary_lines pesl
7346: WHERE pesl.payroll_action_id = p_payroll_action_id
7347: AND pesl.superceded_line_id IS NOT NULL
7348: AND pesl.assignment_id = t_assignments.asg_array(recno)
7349: AND pesl.payroll_id = t_assignments.payroll_array(recno));

Line 7459: FROM psp_enc_summary_lines

7455: AND message_level = 'E';
7456:
7457: CURSOR st_count_cur Is
7458: SELECT COUNT(1)
7459: FROM psp_enc_summary_lines
7460: WHERE payroll_action_id = p_payroll_action_id
7461: AND status_code = 'N';
7462: BEGIN
7463: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_DEINIT payroll_action_id: ' || p_payroll_action_id);

Line 7512: FROM psp_enc_summary_lines pesl

7508: UPDATE psp_enc_process_assignments pepa
7509: SET assignment_status = 'B'
7510: WHERE payroll_action_id = p_payroll_action_id
7511: AND NOT EXISTS (SELECT 1
7512: FROM psp_enc_summary_lines pesl
7513: WHERE pesl.payroll_action_id = p_payroll_action_id
7514: AND pesl.assignment_id = pepa.assignment_id
7515: AND pesl.payroll_id = pepa.payroll_id
7516: AND pesl.status_code = 'N');

Line 7522: FROM psp_enc_summary_lines pesl

7518: UPDATE psp_enc_process_assignments pepa
7519: SET assignment_status = 'S'
7520: WHERE payroll_action_id = p_payroll_action_id
7521: AND EXISTS (SELECT 1
7522: FROM psp_enc_summary_lines pesl
7523: WHERE pesl.payroll_action_id = p_payroll_action_id
7524: AND pesl.assignment_id = pepa.assignment_id
7525: AND pesl.payroll_id = pepa.payroll_id
7526: AND pesl.status_code = 'N'

Line 7533: FROM psp_enc_summary_lines pesl

7529: UPDATE psp_enc_process_assignments pepa
7530: SET assignment_status = 'L'
7531: WHERE payroll_action_id = p_payroll_action_id
7532: AND EXISTS (SELECT 1
7533: FROM psp_enc_summary_lines pesl
7534: WHERE pesl.payroll_action_id = p_payroll_action_id
7535: AND pesl.assignment_id = pepa.assignment_id
7536: AND pesl.payroll_id = pepa.payroll_id
7537: AND pesl.status_code = 'N'

Line 7542: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');

7538: AND pesl.superceded_line_id IS NOT NULL);
7539:
7540: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_CONTROLS');
7541: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_LINES');
7542: fnd_stats.gather_table_stats('PSP', 'PSP_ENC_SUMMARY_LINES');
7543: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Completed Gather Statistics');
7544:
7545: DELETE FROM psp_enc_controls pec
7546: WHERE pec.payroll_action_id = p_payroll_action_id

Line 7603: FROM psp_enc_summary_lines pesl

7599: SET process_status = 'B',
7600: process_phase = 'no_summarize_transfer'
7601: WHERE payroll_action_id = p_payroll_action_id
7602: AND NOT EXISTS (SELECT 1
7603: FROM psp_enc_summary_lines pesl
7604: WHERE pesl.payroll_action_id = p_payroll_action_id
7605: AND pesl.status_code = 'N');
7606:
7607: UPDATE psp_enc_processes

Line 7611: FROM psp_enc_summary_lines pesl

7607: UPDATE psp_enc_processes
7608: SET process_phase = 'summarize_transfer'
7609: WHERE payroll_action_id = p_payroll_action_id
7610: AND EXISTS (SELECT 1
7611: FROM psp_enc_summary_lines pesl
7612: WHERE pesl.payroll_action_id = p_payroll_action_id
7613: AND pesl.status_code = 'N'
7614: AND pesl.superceded_line_id IS NULL);
7615:

Line 7620: FROM psp_enc_summary_lines pesl

7616: UPDATE psp_enc_processes
7617: SET process_phase = 'liquidate'
7618: WHERE payroll_action_id = p_payroll_action_id
7619: AND EXISTS (SELECT 1
7620: FROM psp_enc_summary_lines pesl
7621: WHERE pesl.payroll_action_id = p_payroll_action_id
7622: AND pesl.status_code = 'N'
7623: AND pesl.superceded_line_id is NOT NULL);
7624: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase in psp_enc_processes');

Line 8167: INSERT INTO psp_enc_summary_lines

8163: BEGIN
8164: l_last_updated_by := fnd_global.user_id;
8165: l_last_update_login := fnd_global.login_id;
8166:
8167: INSERT INTO psp_enc_summary_lines
8168: (enc_summary_line_id, business_group_id, set_of_books_id,
8169: enc_control_id, time_period_id, person_id,
8170: assignment_id, effective_date, gl_code_combination_id,
8171: project_id, task_id, award_id,

Line 8182: SELECT psp_enc_summary_lines_s.NEXTVAL,

8178: attribute9, attribute10, payroll_action_id,
8179: proposed_termination_date, last_update_date, last_updated_by,
8180: last_update_login, created_by, creation_date,
8181: update_flag, org_id)
8182: SELECT psp_enc_summary_lines_s.NEXTVAL,
8183: p_business_group_id,
8184: p_set_of_books_id,
8185: pesl.enc_control_id,
8186: pesl.time_period_id,

Line 8222: FROM psp_enc_summary_lines pesl

8218: l_last_updated_by,
8219: SYSDATE,
8220: DECODE(SIGN(TRUNC(effective_date)-TRUNC(p_enc_begin_date)), 1, 'U', 'L'),
8221: pesl.org_id
8222: FROM psp_enc_summary_lines pesl
8223: WHERE pesl.assignment_id = p_assignment_id
8224: AND pesl.payroll_id = p_payroll_id
8225: AND pesl.status_code = 'A'
8226: AND pesl.enc_summary_line_id IN (SELECT pelh.enc_summary_line_id

Line 8363: SELECT psp_enc_summary_lines_s.NEXTVAL INTO t_sum_lines.enc_summary_line_id(recno) FROM DUAL;

8359: CLOSE sum_lines_cur;
8360:
8361: FOR recno IN 1..t_sum_lines.enc_control_id.COUNT
8362: LOOP
8363: SELECT psp_enc_summary_lines_s.NEXTVAL INTO t_sum_lines.enc_summary_line_id(recno) FROM DUAL;
8364: END LOOP;
8365:
8366: FORALL recno IN 1..t_sum_lines.enc_control_id.COUNT
8367: INSERT INTO psp_enc_summary_lines

Line 8367: INSERT INTO psp_enc_summary_lines

8363: SELECT psp_enc_summary_lines_s.NEXTVAL INTO t_sum_lines.enc_summary_line_id(recno) FROM DUAL;
8364: END LOOP;
8365:
8366: FORALL recno IN 1..t_sum_lines.enc_control_id.COUNT
8367: INSERT INTO psp_enc_summary_lines
8368: (enc_summary_line_id, business_group_id, enc_control_id,
8369: time_period_id, person_id, assignment_id,
8370: effective_date, set_of_books_id, gl_code_combination_id,
8371: project_id, task_id, award_id,

Line 8582: FROM psp_enc_summary_lines pesl

8578: FROM psp_enc_processes pep,
8579: fnd_concurrent_requests fcr,
8580: fnd_concurrent_programs_tl fcpt
8581: WHERE EXISTS (SELECT 1
8582: FROM psp_enc_summary_lines pesl
8583: WHERE pesl.payroll_action_id = pep.payroll_action_id
8584: AND pesl.payroll_action_id = l_payroll_action_id)
8585: AND fcr.request_id = pep.request_id
8586: AND fcpt.concurrent_program_id = fcr.concurrent_program_id

Line 8594: FROM psp_enc_summary_lines pesl

8590: CURSOR in_process_term_cur (p_person_id IN NUMBER) IS
8591: SELECT DISTINCT assignment_id,
8592: payroll_id,
8593: payroll_action_id
8594: FROM psp_enc_summary_lines pesl
8595: WHERE pesl.person_id = p_person_id
8596: AND pesl.status_code = 'N';
8597:
8598: CURSOR in_process_asg_cur IS

Line 8715: FROM psp_enc_summary_lines pesl

8711: FROM psp_enc_changed_assignments peca
8712: WHERE peca.assignment_id = pa.assignment_id
8713: AND peca.payroll_id = p_payroll_id)
8714: AND NOT EXISTS (SELECT 1
8715: FROM psp_enc_summary_lines pesl
8716: WHERE pesl.assignment_id = pa.assignment_id
8717: AND pesl.status_code IN ('A', 'N')
8718: -- Bug 5642002: Replaced last Payroll Process date with last assignment Process date
8719: AND pesl.effective_date > (NVL((SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)

Line 8772: FROM psp_enc_summary_lines pesl

8768: FROM psp_enc_changed_assignments peca
8769: WHERE peca.assignment_id = pa.assignment_id
8770: AND peca.payroll_id = p_payroll_id)
8771: AND NOT EXISTS (SELECT 1
8772: FROM psp_enc_summary_lines pesl
8773: WHERE pesl.assignment_id = pa.assignment_id
8774: AND pesl.status_code IN ('A', 'N')
8775: AND pesl.effective_date > l_prev_enc_end_date
8776: AND pesl.payroll_id = p_payroll_id);

Line 8812: FROM psp_enc_summary_lines pesl

8808: AND pepa.set_of_books_id = pep.set_of_books_id
8809: AND pep.payroll_id = p_payroll_id
8810: AND pepa.assignment_id = pa.assignment_id)
8811: AND EXISTS (SELECT 1
8812: FROM psp_enc_summary_lines pesl
8813: WHERE pesl.assignment_id = pa.assignment_id
8814: AND pesl.status_code = 'A'
8815: AND pesl.payroll_id = p_payroll_id)
8816: AND NOT EXISTS (SELECT 1

Line 8817: FROM psp_enc_summary_lines pesl

8813: WHERE pesl.assignment_id = pa.assignment_id
8814: AND pesl.status_code = 'A'
8815: AND pesl.payroll_id = p_payroll_id)
8816: AND NOT EXISTS (SELECT 1
8817: FROM psp_enc_summary_lines pesl
8818: WHERE pesl.assignment_id = pa.assignment_id
8819: AND pesl.status_code = 'N'
8820: AND pesl.payroll_id = p_payroll_id);
8821:

Line 8857: FROM psp_enc_summary_lines pesl

8853: FROM psp_enc_changed_assignments peca
8854: WHERE peca.assignment_id = pepa.assignment_id
8855: AND peca.payroll_id = p_payroll_id)
8856: AND NOT EXISTS (SELECT 1
8857: FROM psp_enc_summary_lines pesl
8858: WHERE pesl.assignment_id = pa.assignment_id
8859: AND pesl.status_code IN ('A', 'N')
8860: -- Bug 5642002: Replaced last Payroll Process date with last assignment Process date
8861: AND pesl.effective_date > (NVL((SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)

Line 8905: FROM psp_enc_summary_lines pesl

8901: FROM psp_enc_changed_assignments peca
8902: WHERE peca.assignment_id = pepa.assignment_id
8903: AND peca.payroll_id = p_payroll_id)
8904: AND NOT EXISTS (SELECT 1
8905: FROM psp_enc_summary_lines pesl
8906: WHERE pesl.assignment_id = pa.assignment_id
8907: AND pesl.status_code IN ('A', 'N')
8908: AND pesl.effective_date > l_prev_enc_end_date);
8909:

Line 8944: FROM psp_enc_summary_lines pesl

8940: AND pepa.set_of_books_id = pep.set_of_books_id
8941: AND pep.payroll_id = p_payroll_id
8942: AND pepa.assignment_id = pa.assignment_id)
8943: AND EXISTS (SELECT 1
8944: FROM psp_enc_summary_lines pesl
8945: WHERE pesl.assignment_id = pa.assignment_id
8946: AND pesl.status_code = 'A'
8947: AND pesl.payroll_id = p_payroll_id)
8948: AND NOT EXISTS (SELECT 1

Line 8949: FROM psp_enc_summary_lines pesl

8945: WHERE pesl.assignment_id = pa.assignment_id
8946: AND pesl.status_code = 'A'
8947: AND pesl.payroll_id = p_payroll_id)
8948: AND NOT EXISTS (SELECT 1
8949: FROM psp_enc_summary_lines pesl
8950: WHERE pesl.assignment_id = pa.assignment_id
8951: AND pesl.status_code = 'N'
8952: AND pesl.payroll_id = p_payroll_id);
8953: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '40 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');

Line 8959: FROM psp_enc_summary_lines pesl

8955:
8956: INSERT INTO psp_enc_changed_assignments
8957: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8958: SELECT DISTINCT l_request_id, p_payroll_id, assignment_id, 'LQ', p_payroll_action_id
8959: FROM psp_enc_summary_lines pesl
8960: WHERE payroll_id = p_payroll_id
8961: AND business_group_id = l_business_group_id
8962: AND status_code = 'A'
8963: AND effective_date <= l_enc_begin_date

Line 8982: FROM psp_enc_summary_lines pesl2

8978: FROM psp_enc_changed_assignments peca
8979: WHERE peca.assignment_id = pesl.assignment_id
8980: AND peca.payroll_id = p_payroll_id)
8981: AND NOT EXISTS (SELECT 1
8982: FROM psp_enc_summary_lines pesl2
8983: WHERE pesl2.assignment_id = pesl.assignment_id
8984: AND pesl2.status_code = 'N'
8985: -- Bug 5642002: Replaced last Payroll Process date with last assignment Process date
8986: AND pesl2.effective_date <= (NVL((SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)

Line 9091: FROM psp_enc_summary_lines pesl

9087: pesl.payroll_id,
9088: 'TR',
9089: p_payroll_action_id,
9090: l_termination_date1
9091: FROM psp_enc_summary_lines pesl
9092: WHERE pesl.person_id = l_person_id1
9093: AND pesl.effective_date >= l_termination_date1
9094: AND pesl.award_id IS NOT NULL
9095: AND pesl.status_code = 'A'

Line 9097: FROM psp_enc_summary_lines pesl2

9093: AND pesl.effective_date >= l_termination_date1
9094: AND pesl.award_id IS NOT NULL
9095: AND pesl.status_code = 'A'
9096: AND NOT EXISTS (SELECT 1
9097: FROM psp_enc_summary_lines pesl2
9098: WHERE pesl2.person_id = l_person_id1
9099: AND pesl2.status_code = 'N');
9100: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9101: IF (SQL%ROWCOUNT = 0) THEN

Line 9158: FROM psp_enc_summary_lines pesl

9154: pesl.payroll_id,
9155: 'TR',
9156: p_payroll_action_id,
9157: l_termination_date2
9158: FROM psp_enc_summary_lines pesl
9159: WHERE pesl.person_id = l_person_id2
9160: AND pesl.effective_date >= l_termination_date2
9161: AND pesl.award_id IS NOT NULL
9162: AND pesl.status_code = 'A'

Line 9164: FROM psp_enc_summary_lines pesl2

9160: AND pesl.effective_date >= l_termination_date2
9161: AND pesl.award_id IS NOT NULL
9162: AND pesl.status_code = 'A'
9163: AND NOT EXISTS (SELECT 1
9164: FROM psp_enc_summary_lines pesl2
9165: WHERE pesl2.person_id = l_person_id2
9166: AND pesl2.status_code = 'N');
9167: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9168: IF (SQL%ROWCOUNT = 0) THEN

Line 9226: FROM psp_enc_summary_lines pesl

9222: pesl.payroll_id,
9223: 'TR',
9224: p_payroll_action_id,
9225: l_termination_date3
9226: FROM psp_enc_summary_lines pesl
9227: WHERE pesl.person_id = l_person_id3
9228: AND pesl.effective_date >= l_termination_date3
9229: AND pesl.award_id IS NOT NULL
9230: AND pesl.status_code = 'A'

Line 9232: FROM psp_enc_summary_lines pesl2

9228: AND pesl.effective_date >= l_termination_date3
9229: AND pesl.award_id IS NOT NULL
9230: AND pesl.status_code = 'A'
9231: AND NOT EXISTS (SELECT 1
9232: FROM psp_enc_summary_lines pesl2
9233: WHERE pesl2.person_id = l_person_id3
9234: AND pesl2.status_code = 'N');
9235: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9236: IF (SQL%ROWCOUNT = 0) THEN

Line 9294: FROM psp_enc_summary_lines pesl

9290: pesl.payroll_id,
9291: 'TR',
9292: p_payroll_action_id,
9293: l_termination_date4
9294: FROM psp_enc_summary_lines pesl
9295: WHERE pesl.person_id = l_person_id4
9296: AND pesl.effective_date >= l_termination_date4
9297: AND pesl.award_id IS NOT NULL
9298: AND pesl.status_code = 'A'

Line 9300: FROM psp_enc_summary_lines pesl2

9296: AND pesl.effective_date >= l_termination_date4
9297: AND pesl.award_id IS NOT NULL
9298: AND pesl.status_code = 'A'
9299: AND NOT EXISTS (SELECT 1
9300: FROM psp_enc_summary_lines pesl2
9301: WHERE pesl2.person_id = l_person_id4
9302: AND pesl2.status_code = 'N');
9303: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9304: IF (SQL%ROWCOUNT = 0) THEN

Line 9362: FROM psp_enc_summary_lines pesl

9358: pesl.payroll_id,
9359: 'TR',
9360: p_payroll_action_id,
9361: l_termination_date5
9362: FROM psp_enc_summary_lines pesl
9363: WHERE pesl.person_id = l_person_id5
9364: AND pesl.effective_date >= l_termination_date5
9365: AND pesl.award_id IS NOT NULL
9366: AND pesl.status_code = 'A'

Line 9368: FROM psp_enc_summary_lines pesl2

9364: AND pesl.effective_date >= l_termination_date5
9365: AND pesl.award_id IS NOT NULL
9366: AND pesl.status_code = 'A'
9367: AND NOT EXISTS (SELECT 1
9368: FROM psp_enc_summary_lines pesl2
9369: WHERE pesl2.person_id = l_person_id5
9370: AND pesl2.status_code = 'N');
9371: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9372: IF (SQL%ROWCOUNT = 0) THEN

Line 9480: FROM psp_enc_summary_lines pesl

9476: OR pepa.assignment_id = p_assignment_id);
9477:
9478: CURSOR superceded_line_cur (p_assignment_id IN NUMBER) IS
9479: SELECT superceded_line_id
9480: FROM psp_enc_summary_lines pesl
9481: WHERE pesl.payroll_action_id = p_payroll_action_id
9482: AND pesl.superceded_line_id IS NOT NULL
9483: AND assignment_id = p_assignment_id;
9484:

Line 9501: DELETE psp_enc_summary_lines

9497: SET change_flag = 'N'
9498: WHERE enc_summary_line_id = t_superceded_lines.enc_summary_line_id(recno);
9499: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');
9500:
9501: DELETE psp_enc_summary_lines
9502: WHERE payroll_action_id = p_payroll_action_id;
9503: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');
9504:
9505: DELETE psp_enc_lines

Line 9503: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');

9499: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');
9500:
9501: DELETE psp_enc_summary_lines
9502: WHERE payroll_action_id = p_payroll_action_id;
9503: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');
9504:
9505: DELETE psp_enc_lines
9506: WHERE payroll_action_id = p_payroll_action_id;
9507: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_lines');

Line 9619: DELETE psp_enc_summary_lines

9615: SET change_flag = 'N'
9616: WHERE enc_summary_line_id = t_superceded_lines.enc_summary_line_id(recno);
9617: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');
9618:
9619: DELETE psp_enc_summary_lines
9620: WHERE payroll_action_id = p_payroll_action_id
9621: AND assignment_id = l_assignments(recno);
9622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');
9623:

Line 9622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');

9618:
9619: DELETE psp_enc_summary_lines
9620: WHERE payroll_action_id = p_payroll_action_id
9621: AND assignment_id = l_assignments(recno);
9622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');
9623:
9624: DELETE psp_enc_lines
9625: WHERE payroll_action_id = p_payroll_action_id
9626: AND assignment_id = l_assignments(recno);

Line 9676: FROM psp_enc_summary_lines

9672: SET process_status = 'B',
9673: process_phase = 'rollback'
9674: WHERE payroll_action_id = p_payroll_action_id
9675: AND NOT EXISTS (SELECT 1
9676: FROM psp_enc_summary_lines
9677: WHERE payroll_action_id = p_payroll_action_id);
9678: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_processes');
9679: END IF;
9680: