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_CHANGED_ASSIGNMENTS

Line 6445: sqlstr := 'SELECT DISTINCT assignment_id FROM psp_enc_changed_assignments WHERE ';

6441: CLOSE enc_payrolls_cur;
6442: l_payroll_id := NULL;
6443: END IF;
6444:
6445: sqlstr := 'SELECT DISTINCT assignment_id FROM psp_enc_changed_assignments WHERE ';
6446: IF (l_payroll_id IS NOT NULL) THEN
6447: sqlstr := sqlstr || 'payroll_id = ' || fnd_number.number_to_canonical(l_payroll_id) || ' AND ';
6448: END IF;
6449:

Line 6459: FROM psp_enc_changed_assignments

6455: last_update_date, last_updated_by, last_update_login)
6456: SELECT DISTINCT pactid, assignment_id, payroll_id,
6457: 'I', l_last_update_date, l_last_updated_by,
6458: l_last_update_date, l_last_updated_by, l_last_updated_login
6459: FROM psp_enc_changed_assignments
6460: WHERE payroll_action_id = pactid;
6461:
6462: IF (SQL%ROWCOUNT = 0) THEN
6463: fnd_message.set_name('PSP', 'PSP_ENC_NO_LIN_UPD');

Line 6496: FROM psp_enc_changed_assignments

6492: end_asg IN NUMBER,
6493: p_chunk_num IN NUMBER) IS
6494: CURSOR get_assignments_cur IS
6495: SELECT DISTINCT assignment_id
6496: FROM psp_enc_changed_assignments
6497: WHERE assignment_id BETWEEN start_asg AND end_asg
6498: AND payroll_action_id = p_pactid;
6499:
6500: TYPE t_number_15 IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;

Line 6586: FROM psp_enc_changed_assignments peca

6582: CURSOR get_payroll_asg_cur IS
6583: SELECT DISTINCT payroll_id,
6584: assignment_id,
6585: change_date
6586: FROM psp_enc_changed_assignments peca
6587: WHERE assignment_id BETWEEN l_min_asg_id AND l_max_asg_id
6588: AND ( (l_process_mode = 'TERMINATE' AND change_type = 'TR')
6589: OR (l_process_mode = 'REGULAR' AND change_type <> 'TR'))
6590: AND payroll_id = NVL(l_payroll_id, payroll_id)

Line 6734: FROM psp_enc_changed_assignments

6730: ORDER BY business_group_id;
6731:
6732: CURSOR liq_only_asg_cur IS
6733: SELECT COUNT(1)
6734: FROM psp_enc_changed_assignments
6735: WHERE assignment_id = l_assignment_id
6736: AND payroll_id = l_payroll_id
6737: AND payroll_action_id = p_payroll_action_id
6738: AND change_type <> 'LQ';

Line 6742: FROM psp_enc_changed_assignments

6738: AND change_type <> 'LQ';
6739:
6740: CURSOR liq_all_cur IS
6741: SELECT COUNT(1)
6742: FROM psp_enc_changed_assignments
6743: WHERE assignment_id = l_assignment_id
6744: AND payroll_id = l_payroll_id
6745: AND payroll_action_id = p_payroll_action_id
6746: AND change_type = 'ZZ';

Line 7225: DELETE psp_enc_changed_assignments

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);
7224: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Updated lines to be liquidated');
7225: DELETE psp_enc_changed_assignments
7226: WHERE assignment_id = l_assignment_id
7227: AND payroll_id = l_payroll_id
7228: AND change_type = 'ZZ';
7229: ELSE

Line 7571: UPDATE psp_enc_changed_assignments peca

7567: WHERE payroll_action_id = p_payroll_action_id;
7568: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated summary columns in psp_enc_controls');
7569:
7570: IF (l_process_mode = 'TERMINATE') THEN
7571: UPDATE psp_enc_changed_assignments peca
7572: SET payroll_action_id = p_payroll_action_id
7573: WHERE EXISTS (SELECT 1
7574: FROM psp_enc_changed_assignments peca2
7575: WHERE peca2.assignment_id = peca.assignment_id

Line 7574: FROM psp_enc_changed_assignments peca2

7570: IF (l_process_mode = 'TERMINATE') THEN
7571: UPDATE psp_enc_changed_assignments peca
7572: SET payroll_action_id = p_payroll_action_id
7573: WHERE EXISTS (SELECT 1
7574: FROM psp_enc_changed_assignments peca2
7575: WHERE peca2.assignment_id = peca.assignment_id
7576: AND peca2.change_type = 'TR');
7577: END IF;
7578:

Line 7585: FROM psp_enc_changed_assignments peca

7581: creation_date, processed_flag, reference_id, action_type, payroll_action_id, change_date)
7582: SELECT l_request_id, peca.assignment_id, peca.payroll_id, peca.change_type,
7583: 'U', l_last_updated_by, l_last_update_date, NULL, NVL(peca.reference_id, 0),
7584: NVL(peca.action_type, 'U'), p_payroll_action_id, change_date
7585: FROM psp_enc_changed_assignments peca
7586: WHERE payroll_action_id = p_payroll_action_id;
7587: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_asg_history');
7588:
7589: DELETE psp_enc_changed_assignments peca

Line 7589: DELETE psp_enc_changed_assignments peca

7585: FROM psp_enc_changed_assignments peca
7586: WHERE payroll_action_id = p_payroll_action_id;
7587: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_asg_history');
7588:
7589: DELETE psp_enc_changed_assignments peca
7590: WHERE peca.payroll_action_id = p_payroll_action_id;
7591: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted processed change assignment records in psp_enc_change_assignments');
7592:
7593: UPDATE psp_enc_processes

Line 8679: INSERT INTO psp_enc_changed_assignments

8675:
8676:
8677: IF l_inc_exc_flag = 'Y' THEN
8678:
8679: INSERT INTO psp_enc_changed_assignments
8680: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8681: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
8682: FROM per_assignments_f pa
8683: WHERE pa.payroll_id = p_payroll_id

Line 8711: FROM psp_enc_changed_assignments peca

8707: AND pepa.set_of_books_id = pep.set_of_books_id
8708: AND pep.payroll_id = p_payroll_id
8709: AND pepa.assignment_id = pa.assignment_id)
8710: AND NOT EXISTS (SELECT 1
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

Line 8733: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');

8729: and ppa.date_earned between ptp.start_date and ptp.end_date
8730: and ptp.payroll_id = ppa.payroll_id),l_enc_begin_date))
8731: AND pesl.payroll_id = p_payroll_id);
8732:
8733: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
8734:
8735:
8736: -- Added this INSERT for bug 7188209
8737:

Line 8738: INSERT INTO psp_enc_changed_assignments

8734:
8735:
8736: -- Added this INSERT for bug 7188209
8737:
8738: INSERT INTO psp_enc_changed_assignments
8739: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8740: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
8741: FROM per_assignments_f pa
8742: WHERE pa.payroll_id = p_payroll_id

Line 8768: FROM psp_enc_changed_assignments peca

8764: AND pepa.set_of_books_id = pep.set_of_books_id
8765: AND pep.payroll_id = p_payroll_id
8766: AND pepa.assignment_id = pa.assignment_id)
8767: AND NOT EXISTS (SELECT 1
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

Line 8778: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');

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);
8777:
8778: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
8779:
8780: INSERT INTO psp_enc_changed_assignments
8781: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8782: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id

Line 8780: INSERT INTO psp_enc_changed_assignments

8776: AND pesl.payroll_id = p_payroll_id);
8777:
8778: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
8779:
8780: INSERT INTO psp_enc_changed_assignments
8781: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8782: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
8783: FROM per_assignments_f pa
8784: WHERE pa.payroll_id = p_payroll_id

Line 8822: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '20 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');

8818: WHERE pesl.assignment_id = pa.assignment_id
8819: AND pesl.status_code = 'N'
8820: AND pesl.payroll_id = p_payroll_id);
8821:
8822: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '20 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
8823:
8824: ELSE
8825:
8826: INSERT INTO psp_enc_changed_assignments

Line 8826: INSERT INTO psp_enc_changed_assignments

8822: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '20 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
8823:
8824: ELSE
8825:
8826: INSERT INTO psp_enc_changed_assignments
8827: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8828: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
8829: FROM psp_enc_payroll_assignments pepa,
8830: psp_enc_payrolls pep,

Line 8853: FROM psp_enc_changed_assignments peca

8849: and ptp.payroll_id = ppa.payroll_id),l_enc_begin_date))
8850: AND pep.payroll_id = p_payroll_id
8851: AND pep.enc_payroll_id = pepa.enc_payroll_id
8852: AND NOT EXISTS (SELECT 1
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

Line 8873: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');

8869: AND ppa.payroll_id = pesl.payroll_id
8870: AND ppa.action_type IN ( 'R','Q')
8871: AND paa.action_status(+) = 'C'),l_enc_begin_date)) );
8872:
8873: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
8874:
8875: -- Added for bug 7188209
8876: INSERT INTO psp_enc_changed_assignments
8877: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)

Line 8876: INSERT INTO psp_enc_changed_assignments

8872:
8873: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
8874:
8875: -- Added for bug 7188209
8876: INSERT INTO psp_enc_changed_assignments
8877: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8878: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
8879: FROM psp_enc_payroll_assignments pepa,
8880: psp_enc_payrolls pep,

Line 8901: FROM psp_enc_changed_assignments peca

8897: and ptp.payroll_id = ppa.payroll_id),l_enc_begin_date))
8898: AND pep.payroll_id = p_payroll_id
8899: AND pep.enc_payroll_id = pepa.enc_payroll_id
8900: AND NOT EXISTS (SELECT 1
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

Line 8910: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');

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:
8910: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
8911:
8912: INSERT INTO psp_enc_changed_assignments
8913: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8914: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id

Line 8912: INSERT INTO psp_enc_changed_assignments

8908: AND pesl.effective_date > l_prev_enc_end_date);
8909:
8910: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
8911:
8912: INSERT INTO psp_enc_changed_assignments
8913: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8914: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
8915: FROM per_assignments_f pa
8916: WHERE pa.payroll_id = p_payroll_id

Line 8953: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '40 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');

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');
8954: END IF;
8955:
8956: INSERT INTO psp_enc_changed_assignments
8957: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)

Line 8956: INSERT INTO psp_enc_changed_assignments

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');
8954: END IF;
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

Line 8978: FROM psp_enc_changed_assignments peca

8974: AND paa.action_status(+) = 'C'
8975: and ppa.date_earned between ptp.start_date and ptp.end_date
8976: and ptp.payroll_id = ppa.payroll_id),l_enc_begin_date))
8977: AND NOT EXISTS (SELECT 1
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

Line 9000: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '50 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');

8996: and ppa.date_earned between ptp.start_date and ptp.end_date
8997: and ptp.payroll_id = ppa.payroll_id),l_enc_begin_date))
8998: AND pesl2.payroll_id = p_payroll_id);
8999:
9000: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '50 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9001:
9002: UPDATE psp_enc_changed_assignments peca
9003: SET payroll_action_id = p_payroll_action_id
9004: WHERE payroll_action_id IS NULL

Line 9002: UPDATE psp_enc_changed_assignments peca

8998: AND pesl2.payroll_id = p_payroll_id);
8999:
9000: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '50 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9001:
9002: UPDATE psp_enc_changed_assignments peca
9003: SET payroll_action_id = p_payroll_action_id
9004: WHERE payroll_action_id IS NULL
9005: AND payroll_id = NVL(p_payroll_id, payroll_id)
9006: AND NOT EXISTS (SELECT 1

Line 9011: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Marked ' || SQL%ROWCOUNT || ' assignments in psp_enc_changed_assignments to be processed by this Create and Update process');

9007: FROM psp_enc_process_assignments pepa
9008: WHERE pepa.assignment_id = peca.assignment_id
9009: AND pepa.assignment_status NOT IN ('B', 'P')
9010: AND pepa.payroll_id = peca.payroll_id);
9011: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Marked ' || SQL%ROWCOUNT || ' assignments in psp_enc_changed_assignments to be processed by this Create and Update process');
9012:
9013: DELETE FROM psp_enc_changed_assignments
9014: WHERE payroll_action_id = p_payroll_action_id
9015: AND payroll_id = p_payroll_id

Line 9013: DELETE FROM psp_enc_changed_assignments

9009: AND pepa.assignment_status NOT IN ('B', 'P')
9010: AND pepa.payroll_id = peca.payroll_id);
9011: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Marked ' || SQL%ROWCOUNT || ' assignments in psp_enc_changed_assignments to be processed by this Create and Update process');
9012:
9013: DELETE FROM psp_enc_changed_assignments
9014: WHERE payroll_action_id = p_payroll_action_id
9015: AND payroll_id = p_payroll_id
9016: AND request_id = l_request_id
9017: and assignment_id IN(SELECT assignment_id from PSP_ENC_PAYROLL_ASSIGNMENT_V

Line 9024: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Deleted ' || SQL%ROWCOUNT || ' fresh excluded assignments in psp_enc_changed_assignments not to be processed by this Create and Update process');

9020: MINUS
9021: SELECT ASSIGNMENT_ID FROM psp_enc_changed_asg_history
9022: WHERE payroll_id = p_payroll_id);
9023:
9024: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Deleted ' || SQL%ROWCOUNT || ' fresh excluded assignments in psp_enc_changed_assignments not to be processed by this Create and Update process');
9025:
9026: OPEN in_process_asg_cur;
9027: LOOP
9028: FETCH in_process_asg_cur INTO l_assignment_id, l_payroll_action_id;

Line 9083: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS

9079: l_person_id3: ' || l_person_id3 || ' l_termination_date3: ' || fnd_date.date_to_canonical(l_termination_date3) || '
9080: l_person_id4: ' || l_person_id4 || ' l_termination_date4: ' || fnd_date.date_to_canonical(l_termination_date4) || '
9081: l_person_id5: ' || l_person_id5 || ' l_termination_date5: ' || fnd_date.date_to_canonical(l_termination_date5));
9082:
9083: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS
9084: (request_id, assignment_id, payroll_id, change_type, payroll_action_id, change_date)
9085: SELECT DISTINCT l_request_id,
9086: pesl.assignment_id,
9087: pesl.payroll_id,

Line 9100: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);

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
9102: OPEN in_process_term_cur(l_person_id1);
9103: LOOP
9104: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;

Line 9150: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS

9146: CLOSE in_process_term_cur;
9147: END IF;
9148:
9149: IF (l_person_id2 > 0) THEN
9150: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS
9151: (request_id, assignment_id, payroll_id, change_type, payroll_action_id, change_date)
9152: SELECT DISTINCT l_request_id,
9153: pesl.assignment_id,
9154: pesl.payroll_id,

Line 9167: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);

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
9169: OPEN in_process_term_cur(l_person_id2);
9170: LOOP
9171: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;

Line 9218: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS

9214: END IF;
9215: END IF;
9216:
9217: IF (l_person_id3 > 0) THEN
9218: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS
9219: (request_id, assignment_id, payroll_id, change_type, payroll_action_id, change_date)
9220: SELECT DISTINCT l_request_id,
9221: pesl.assignment_id,
9222: pesl.payroll_id,

Line 9235: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);

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
9237: OPEN in_process_term_cur(l_person_id3);
9238: LOOP
9239: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;

Line 9286: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS

9282: END IF;
9283: END IF;
9284:
9285: IF (l_person_id4 > 0) THEN
9286: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS
9287: (request_id, assignment_id, payroll_id, change_type, payroll_action_id, change_date)
9288: SELECT DISTINCT l_request_id,
9289: pesl.assignment_id,
9290: pesl.payroll_id,

Line 9303: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);

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
9305: OPEN in_process_term_cur(l_person_id4);
9306: LOOP
9307: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;

Line 9354: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS

9350: END IF;
9351: END IF;
9352:
9353: IF (l_person_id5 > 0) THEN
9354: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS
9355: (request_id, assignment_id, payroll_id, change_type, payroll_action_id, change_date)
9356: SELECT DISTINCT l_request_id,
9357: pesl.assignment_id,
9358: pesl.payroll_id,

Line 9371: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);

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
9373: OPEN in_process_term_cur(l_person_id5);
9374: LOOP
9375: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;

Line 9528: UPDATE psp_enc_changed_assignments

9524: SET assignment_status = 'B'
9525: WHERE payroll_action_id = p_payroll_action_id;
9526: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_process_assignments');
9527:
9528: UPDATE psp_enc_changed_assignments
9529: SET payroll_action_id = NULL
9530: WHERE payroll_action_id = p_payroll_action_id;
9531: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');
9532:

Line 9531: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');

9527:
9528: UPDATE psp_enc_changed_assignments
9529: SET payroll_action_id = NULL
9530: WHERE payroll_action_id = p_payroll_action_id;
9531: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');
9532:
9533: INSERT INTO psp_enc_changed_assignments
9534: (request_id, assignment_id, payroll_id, change_type,
9535: processed_flag, reference_id, action_type, change_date)

Line 9533: INSERT INTO psp_enc_changed_assignments

9529: SET payroll_action_id = NULL
9530: WHERE payroll_action_id = p_payroll_action_id;
9531: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');
9532:
9533: INSERT INTO psp_enc_changed_assignments
9534: (request_id, assignment_id, payroll_id, change_type,
9535: processed_flag, reference_id, action_type, change_date)
9536: SELECT l_request_id, pecah.assignment_id, pecah.payroll_id, pecah.change_type,
9537: NULL, NVL(pecah.reference_id, 0), pecah.action_type, change_date

Line 9541: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');

9537: NULL, NVL(pecah.reference_id, 0), pecah.action_type, change_date
9538: FROM psp_enc_changed_asg_history pecah
9539: WHERE payroll_action_id = p_payroll_action_id
9540: AND action_type NOT IN ('CR', 'LQ', 'TR');
9541: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
9542:
9543: DELETE psp_enc_changed_asg_history
9544: WHERE payroll_action_id = p_payroll_action_id;
9545: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');

Line 9545: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');

9541: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
9542:
9543: DELETE psp_enc_changed_asg_history
9544: WHERE payroll_action_id = p_payroll_action_id;
9545: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
9546: ELSE
9547: OPEN asg_cur(p_person_id1, p_assignment_id1);
9548: FETCH asg_cur BULK COLLECT INTO l_assignments;
9549: CLOSE asg_cur;

Line 9648: UPDATE psp_enc_changed_assignments

9644: WHERE payroll_action_id = p_payroll_action_id
9645: AND assignment_id = l_assignments(recno);
9646: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated assignment status to ''Rollback'' in psp_enc_process_assignments');
9647:
9648: UPDATE psp_enc_changed_assignments
9649: SET payroll_action_id = NULL
9650: WHERE payroll_action_id = p_payroll_action_id
9651: AND assignment_id = l_assignments(recno);
9652: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');

Line 9652: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');

9648: UPDATE psp_enc_changed_assignments
9649: SET payroll_action_id = NULL
9650: WHERE payroll_action_id = p_payroll_action_id
9651: AND assignment_id = l_assignments(recno);
9652: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');
9653:
9654: INSERT INTO psp_enc_changed_assignments
9655: (request_id, assignment_id, payroll_id, change_type,
9656: processed_flag, reference_id, action_type, change_date)

Line 9654: INSERT INTO psp_enc_changed_assignments

9650: WHERE payroll_action_id = p_payroll_action_id
9651: AND assignment_id = l_assignments(recno);
9652: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');
9653:
9654: INSERT INTO psp_enc_changed_assignments
9655: (request_id, assignment_id, payroll_id, change_type,
9656: processed_flag, reference_id, action_type, change_date)
9657: SELECT l_request_id, pecah.assignment_id, pecah.payroll_id, pecah.change_type,
9658: NULL, NVL(pecah.reference_id, 0), pecah.action_type, change_date

Line 9663: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');

9659: FROM psp_enc_changed_asg_history pecah
9660: WHERE payroll_action_id = p_payroll_action_id
9661: AND assignment_id = l_assignments(recno)
9662: AND action_type NOT IN ('CR', 'LQ', 'TR');
9663: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
9664:
9665: DELETE psp_enc_changed_asg_history
9666: WHERE payroll_action_id = p_payroll_action_id
9667: AND assignment_id = l_assignments(recno);

Line 9668: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');

9664:
9665: DELETE psp_enc_changed_asg_history
9666: WHERE payroll_action_id = p_payroll_action_id
9667: AND assignment_id = l_assignments(recno);
9668: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
9669: END LOOP;
9670:
9671: UPDATE psp_enc_processes
9672: SET process_status = 'B',