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 422: process and this is used in the insert statement of PSP_ENC_CHANGED_ASSIGNMENTS.

418: Purpose : 1)
419: In this mechanism we have used 2 functions GET_ASG_PAY_END_DATE and
420: get_payroll_pay_end_date. GET_ASG_PAY_END_DATE is used for both ORACLE
421: and NON ORACLE PAYROLL in order to increase the performance of the CUEL
422: process and this is used in the insert statement of PSP_ENC_CHANGED_ASSIGNMENTS.
423: For this we have created a temp table PSP_ASG_END_DATES in order
424: to hold assignment information until the CUEL process completes.
425:
426: Before this process was introduced the cursor query of

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

6697: CLOSE enc_payrolls_cur;
6698: l_payroll_id := NULL;
6699: END IF;
6700:
6701: sqlstr := 'SELECT DISTINCT assignment_id FROM psp_enc_changed_assignments WHERE ';
6702: IF (l_payroll_id IS NOT NULL) THEN
6703: sqlstr := sqlstr || 'payroll_id = ' || fnd_number.number_to_canonical(l_payroll_id) || ' AND ';
6704: END IF;
6705:

Line 6715: FROM psp_enc_changed_assignments

6711: last_update_date, last_updated_by, last_update_login)
6712: SELECT DISTINCT pactid, assignment_id, payroll_id,
6713: 'I', l_last_update_date, l_last_updated_by,
6714: l_last_update_date, l_last_updated_by, l_last_updated_login
6715: FROM psp_enc_changed_assignments
6716: WHERE payroll_action_id = pactid;
6717:
6718: IF (SQL%ROWCOUNT = 0) THEN
6719: fnd_message.set_name('PSP', 'PSP_ENC_NO_LIN_UPD');

Line 6753: FROM psp_enc_changed_assignments

6749: end_asg IN NUMBER,
6750: p_chunk_num IN NUMBER) IS
6751: CURSOR get_assignments_cur IS
6752: SELECT DISTINCT assignment_id
6753: FROM psp_enc_changed_assignments
6754: WHERE assignment_id BETWEEN start_asg AND end_asg
6755: AND payroll_action_id = p_pactid;
6756:
6757: TYPE t_number_15 IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;

Line 6843: FROM psp_enc_changed_assignments peca

6839: CURSOR get_payroll_asg_cur IS
6840: SELECT DISTINCT payroll_id,
6841: assignment_id,
6842: change_date
6843: FROM psp_enc_changed_assignments peca
6844: WHERE assignment_id BETWEEN l_min_asg_id AND l_max_asg_id
6845: AND ( (l_process_mode = 'TERMINATE' AND change_type = 'TR')
6846: OR (l_process_mode = 'REGULAR' AND change_type <> 'TR'))
6847: AND payroll_id = NVL(l_payroll_id, payroll_id)

Line 7011: FROM psp_enc_changed_assignments

7007: ORDER BY business_group_id;
7008:
7009: CURSOR liq_only_asg_cur IS
7010: SELECT COUNT(1)
7011: FROM psp_enc_changed_assignments
7012: WHERE assignment_id = l_assignment_id
7013: AND payroll_id = l_payroll_id
7014: AND payroll_action_id = p_payroll_action_id
7015: AND change_type <> 'LQ';

Line 7019: FROM psp_enc_changed_assignments

7015: AND change_type <> 'LQ';
7016:
7017: CURSOR liq_all_cur IS
7018: SELECT COUNT(1)
7019: FROM psp_enc_changed_assignments
7020: WHERE assignment_id = l_assignment_id
7021: AND payroll_id = l_payroll_id
7022: AND payroll_action_id = p_payroll_action_id
7023: AND change_type = 'ZZ';

Line 7550: DELETE psp_enc_changed_assignments

7546: AND pesl.payroll_id = l_payroll_id
7547: AND status_code = 'A'
7548: AND pesl.enc_summary_line_id = pelh.enc_summary_line_id);
7549: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Updated lines to be liquidated');
7550: DELETE psp_enc_changed_assignments
7551: WHERE assignment_id = l_assignment_id
7552: AND payroll_id = l_payroll_id
7553: AND change_type = 'ZZ';
7554: ELSE

Line 7883: UPDATE psp_enc_changed_assignments peca

7879: WHERE payroll_action_id = p_payroll_action_id;
7880: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated summary columns in psp_enc_controls');
7881:
7882: IF (l_process_mode = 'TERMINATE') THEN
7883: UPDATE psp_enc_changed_assignments peca
7884: SET payroll_action_id = p_payroll_action_id
7885: WHERE EXISTS (SELECT 1
7886: FROM psp_enc_changed_assignments peca2
7887: WHERE peca2.assignment_id = peca.assignment_id

Line 7886: FROM psp_enc_changed_assignments peca2

7882: IF (l_process_mode = 'TERMINATE') THEN
7883: UPDATE psp_enc_changed_assignments peca
7884: SET payroll_action_id = p_payroll_action_id
7885: WHERE EXISTS (SELECT 1
7886: FROM psp_enc_changed_assignments peca2
7887: WHERE peca2.assignment_id = peca.assignment_id
7888: AND peca2.change_type = 'TR');
7889: END IF;
7890:

Line 7897: FROM psp_enc_changed_assignments peca

7893: creation_date, processed_flag, reference_id, action_type, payroll_action_id, change_date)
7894: SELECT l_request_id, peca.assignment_id, peca.payroll_id, peca.change_type,
7895: 'U', l_last_updated_by, l_last_update_date, NULL, NVL(peca.reference_id, 0),
7896: NVL(peca.action_type, 'U'), p_payroll_action_id, change_date
7897: FROM psp_enc_changed_assignments peca
7898: WHERE payroll_action_id = p_payroll_action_id;
7899: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_asg_history');
7900:
7901: DELETE psp_enc_changed_assignments peca

Line 7901: DELETE psp_enc_changed_assignments peca

7897: FROM psp_enc_changed_assignments peca
7898: WHERE payroll_action_id = p_payroll_action_id;
7899: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_asg_history');
7900:
7901: DELETE psp_enc_changed_assignments peca
7902: WHERE peca.payroll_action_id = p_payroll_action_id;
7903: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted processed change assignment records in psp_enc_change_assignments');
7904:
7905: UPDATE psp_enc_processes

Line 8937: SELECT /*+INDEX(peca PSP_ENC_CHANGED_ASSIGNMENTS_N3)

8933: p_payroll_id NUMBER,
8934: p_business_group_id NUMBER,
8935: p_payroll_action_id NUMBER,
8936: l_request_id NUMBER) IS
8937: SELECT /*+INDEX(peca PSP_ENC_CHANGED_ASSIGNMENTS_N3)
8938:
8939: */
8940: peca.assignment_id
8941: FROM psp_enc_changed_assignments peca

Line 8941: FROM psp_enc_changed_assignments peca

8937: SELECT /*+INDEX(peca PSP_ENC_CHANGED_ASSIGNMENTS_N3)
8938:
8939: */
8940: peca.assignment_id
8941: FROM psp_enc_changed_assignments peca
8942: WHERE payroll_action_id = p_payroll_action_id
8943: AND payroll_id = p_payroll_id
8944: AND request_id = l_request_id
8945: AND assignment_id IN

Line 9069: INSERT INTO psp_enc_changed_assignments

9065: g_payroll_mode := 'Y'; --This helps to choose the query for oracle payroll in get_asg_pay_end_date function ----13566809
9066:
9067: IF l_inc_exc_flag = 'Y' THEN
9068:
9069: INSERT INTO psp_enc_changed_assignments
9070: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9071: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
9072: FROM per_assignments_f pa
9073: WHERE pa.payroll_id = p_payroll_id

Line 9092: FROM psp_enc_changed_assignments peca

9088: AND pepa.set_of_books_id = pep.set_of_books_id
9089: AND pep.payroll_id = p_payroll_id
9090: AND pepa.assignment_id = pa.assignment_id)
9091: AND NOT EXISTS (SELECT 1
9092: FROM psp_enc_changed_assignments peca
9093: WHERE peca.assignment_id = pa.assignment_id
9094: AND peca.payroll_id = p_payroll_id)
9095: AND NOT EXISTS (SELECT 1
9096: FROM psp_enc_summary_lines pesl

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

9101: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9102: ),l_enc_begin_date))
9103: AND pesl.payroll_id = p_payroll_id);
9104:
9105: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9106:
9107:
9108: -- Added this INSERT for bug 7188209
9109:

Line 9110: INSERT INTO psp_enc_changed_assignments

9106:
9107:
9108: -- Added this INSERT for bug 7188209
9109:
9110: INSERT INTO psp_enc_changed_assignments
9111: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9112: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
9113: FROM per_assignments_f pa
9114: WHERE pa.payroll_id = p_payroll_id

Line 9131: FROM psp_enc_changed_assignments peca

9127: AND pepa.set_of_books_id = pep.set_of_books_id
9128: AND pep.payroll_id = p_payroll_id
9129: AND pepa.assignment_id = pa.assignment_id)
9130: AND NOT EXISTS (SELECT 1
9131: FROM psp_enc_changed_assignments peca
9132: WHERE peca.assignment_id = pa.assignment_id
9133: AND peca.payroll_id = p_payroll_id)
9134: AND NOT EXISTS (SELECT 1
9135: FROM psp_enc_summary_lines pesl

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

9137: AND pesl.status_code IN ('A', 'N')
9138: AND pesl.effective_date > l_prev_enc_end_date
9139: AND pesl.payroll_id = p_payroll_id);
9140:
9141: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9142:
9143: INSERT INTO psp_enc_changed_assignments
9144: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9145: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id

Line 9143: INSERT INTO psp_enc_changed_assignments

9139: AND pesl.payroll_id = p_payroll_id);
9140:
9141: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9142:
9143: INSERT INTO psp_enc_changed_assignments
9144: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9145: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
9146: FROM per_assignments_f pa
9147: WHERE pa.payroll_id = p_payroll_id

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

9172: WHERE pesl.assignment_id = pa.assignment_id
9173: AND pesl.status_code = 'N'
9174: AND pesl.payroll_id = p_payroll_id);
9175:
9176: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '20 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9177:
9178: ELSE
9179: -- Modified the following statement for bug 9862281
9180: INSERT INTO psp_enc_changed_assignments

Line 9180: INSERT INTO psp_enc_changed_assignments

9176: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '20 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9177:
9178: ELSE
9179: -- Modified the following statement for bug 9862281
9180: INSERT INTO psp_enc_changed_assignments
9181: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9182: SELECT /*+
9183: index(Pepa PSP_ENC_PAYROLL_ASSIGNMENTS_N1)
9184: index(PA PER_ASSIGNMENTS_F_PK)

Line 9202: FROM psp_enc_changed_assignments peca

9198: ),l_enc_begin_date))
9199: AND pep.payroll_id = p_payroll_id
9200: AND pep.enc_payroll_id = pepa.enc_payroll_id
9201: AND NOT EXISTS (SELECT 1
9202: FROM psp_enc_changed_assignments peca
9203: WHERE peca.assignment_id = pepa.assignment_id
9204: AND peca.payroll_id = p_payroll_id)
9205: AND NOT EXISTS (SELECT 1
9206: FROM psp_enc_summary_lines pesl

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

9212: ),l_enc_begin_date)) );
9213:
9214:
9215:
9216: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9217:
9218: -- Added for bug 7188209
9219: INSERT INTO psp_enc_changed_assignments
9220: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)

Line 9219: INSERT INTO psp_enc_changed_assignments

9215:
9216: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9217:
9218: -- Added for bug 7188209
9219: INSERT INTO psp_enc_changed_assignments
9220: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9221: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
9222: FROM psp_enc_payroll_assignments pepa,
9223: psp_enc_payrolls pep,

Line 9235: FROM psp_enc_changed_assignments peca

9231: ),l_enc_begin_date))
9232: AND pep.payroll_id = p_payroll_id
9233: AND pep.enc_payroll_id = pepa.enc_payroll_id
9234: AND NOT EXISTS (SELECT 1
9235: FROM psp_enc_changed_assignments peca
9236: WHERE peca.assignment_id = pepa.assignment_id
9237: AND peca.payroll_id = p_payroll_id)
9238: AND NOT EXISTS (SELECT 1
9239: FROM psp_enc_summary_lines pesl

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

9240: WHERE pesl.assignment_id = pa.assignment_id
9241: AND pesl.status_code IN ('A', 'N')
9242: AND pesl.effective_date > l_prev_enc_end_date);
9243:
9244: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9245:
9246: INSERT INTO psp_enc_changed_assignments
9247: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9248: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id

Line 9246: INSERT INTO psp_enc_changed_assignments

9242: AND pesl.effective_date > l_prev_enc_end_date);
9243:
9244: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9245:
9246: INSERT INTO psp_enc_changed_assignments
9247: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9248: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
9249: FROM per_assignments_f pa
9250: WHERE pa.payroll_id = p_payroll_id

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

9274: FROM psp_enc_summary_lines pesl
9275: WHERE pesl.assignment_id = pa.assignment_id
9276: AND pesl.status_code = 'N'
9277: AND pesl.payroll_id = p_payroll_id);
9278: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '40 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9279: END IF;
9280:
9281: INSERT INTO psp_enc_changed_assignments
9282: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)

Line 9281: INSERT INTO psp_enc_changed_assignments

9277: AND pesl.payroll_id = p_payroll_id);
9278: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '40 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9279: END IF;
9280:
9281: INSERT INTO psp_enc_changed_assignments
9282: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9283: SELECT DISTINCT l_request_id, p_payroll_id, assignment_id, 'LQ', p_payroll_action_id
9284: FROM psp_enc_summary_lines pesl
9285: WHERE payroll_id = p_payroll_id

Line 9294: FROM psp_enc_changed_assignments peca

9290: AND pesl.effective_date <= (NVL((get_asg_pay_end_date(g_payroll_mode,p_payroll_action_id,pesl.assignment_id,pesl.business_group_id,pesl.payroll_id) --13566809
9291: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9292: ),l_enc_begin_date))
9293: AND NOT EXISTS (SELECT 1
9294: FROM psp_enc_changed_assignments peca
9295: WHERE peca.assignment_id = pesl.assignment_id
9296: AND peca.payroll_id = p_payroll_id)
9297: AND NOT EXISTS (SELECT /*+INDEX(pesl2 PSP_ENC_SUMMARY_LINES_N6)*/ 1
9298: FROM psp_enc_summary_lines pesl2

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

9302: AND pesl2.effective_date <= (NVL((get_asg_pay_end_date(g_payroll_mode,p_payroll_action_id,pesl2.assignment_id,pesl2.business_group_id,pesl2.payroll_id) --13566809
9303: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9304: ),l_enc_begin_date))
9305: AND pesl2.payroll_id = p_payroll_id);
9306: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '50 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9307:
9308: ELSE -- NOn-Oracle Payroll profile is set to YES (For Stanford type of customers)
9309: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Using Non-Oracle Payroll');
9310:

Line 9315: INSERT INTO psp_enc_changed_assignments

9311: g_payroll_mode := 'N'; --this helps to choose the query for non oracle payroll in get_asg_pay_end_date function --13566809
9312:
9313: IF l_inc_exc_flag = 'Y' THEN
9314:
9315: INSERT INTO psp_enc_changed_assignments
9316: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9317: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
9318: FROM per_assignments_f pa
9319: WHERE pa.payroll_id = p_payroll_id

Line 9338: FROM psp_enc_changed_assignments peca

9334: AND pepa.set_of_books_id = pep.set_of_books_id
9335: AND pep.payroll_id = p_payroll_id
9336: AND pepa.assignment_id = pa.assignment_id)
9337: AND NOT EXISTS (SELECT 1
9338: FROM psp_enc_changed_assignments peca
9339: WHERE peca.assignment_id = pa.assignment_id
9340: AND peca.payroll_id = p_payroll_id)
9341: AND NOT EXISTS (SELECT 1
9342: FROM psp_enc_summary_lines pesl

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

9347: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9348: ),l_enc_begin_date)) --13566809
9349: AND pesl.payroll_id = p_payroll_id);
9350:
9351: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9352:
9353: -- Added this INSERT for bug 7188209
9354:
9355: INSERT INTO psp_enc_changed_assignments

Line 9355: INSERT INTO psp_enc_changed_assignments

9351: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9352:
9353: -- Added this INSERT for bug 7188209
9354:
9355: INSERT INTO psp_enc_changed_assignments
9356: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9357: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
9358: FROM per_assignments_f pa
9359: WHERE pa.payroll_id = p_payroll_id

Line 9376: FROM psp_enc_changed_assignments peca

9372: AND pepa.set_of_books_id = pep.set_of_books_id
9373: AND pep.payroll_id = p_payroll_id
9374: AND pepa.assignment_id = pa.assignment_id)
9375: AND NOT EXISTS (SELECT 1
9376: FROM psp_enc_changed_assignments peca
9377: WHERE peca.assignment_id = pa.assignment_id
9378: AND peca.payroll_id = p_payroll_id)
9379: AND NOT EXISTS (SELECT 1
9380: FROM psp_enc_summary_lines pesl

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

9382: AND pesl.status_code IN ('A', 'N')
9383: AND pesl.effective_date > l_prev_enc_end_date
9384: AND pesl.payroll_id = p_payroll_id);
9385:
9386: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9387:
9388: INSERT INTO psp_enc_changed_assignments
9389: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9390: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id

Line 9388: INSERT INTO psp_enc_changed_assignments

9384: AND pesl.payroll_id = p_payroll_id);
9385:
9386: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '10-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9387:
9388: INSERT INTO psp_enc_changed_assignments
9389: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9390: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
9391: FROM per_assignments_f pa
9392: WHERE pa.payroll_id = p_payroll_id

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

9417: WHERE pesl.assignment_id = pa.assignment_id
9418: AND pesl.status_code = 'N'
9419: AND pesl.payroll_id = p_payroll_id);
9420:
9421: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '20 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9422:
9423: ELSE
9424: -- Modified the following statement for bug 9862281
9425: INSERT INTO psp_enc_changed_assignments

Line 9425: INSERT INTO psp_enc_changed_assignments

9421: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '20 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9422:
9423: ELSE
9424: -- Modified the following statement for bug 9862281
9425: INSERT INTO psp_enc_changed_assignments
9426: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9427: SELECT /*+
9428: index(Pepa PSP_ENC_PAYROLL_ASSIGNMENTS_N1)
9429: index(PA PER_ASSIGNMENTS_F_PK)

Line 9447: FROM psp_enc_changed_assignments peca

9443: ),l_enc_begin_date))
9444: AND pep.payroll_id = p_payroll_id
9445: AND pep.enc_payroll_id = pepa.enc_payroll_id
9446: AND NOT EXISTS (SELECT 1
9447: FROM psp_enc_changed_assignments peca
9448: WHERE peca.assignment_id = pepa.assignment_id
9449: AND peca.payroll_id = p_payroll_id)
9450: AND NOT EXISTS (SELECT 1
9451: FROM psp_enc_summary_lines pesl

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

9473: and ptp.payroll_id = ppa.payroll_id),l_enc_begin_date)) );
9474:
9475:
9476:
9477: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9478:
9479: -- Added for bug 7188209
9480: INSERT INTO psp_enc_changed_assignments
9481: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)

Line 9480: INSERT INTO psp_enc_changed_assignments

9476:
9477: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-A Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9478:
9479: -- Added for bug 7188209
9480: INSERT INTO psp_enc_changed_assignments
9481: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9482: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
9483: FROM psp_enc_payroll_assignments pepa,
9484: psp_enc_payrolls pep,

Line 9496: FROM psp_enc_changed_assignments peca

9492: ),l_enc_begin_date))
9493: AND pep.payroll_id = p_payroll_id
9494: AND pep.enc_payroll_id = pepa.enc_payroll_id
9495: AND NOT EXISTS (SELECT 1
9496: FROM psp_enc_changed_assignments peca
9497: WHERE peca.assignment_id = pepa.assignment_id
9498: AND peca.payroll_id = p_payroll_id)
9499: AND NOT EXISTS (SELECT 1
9500: FROM psp_enc_summary_lines pesl

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

9501: WHERE pesl.assignment_id = pa.assignment_id
9502: AND pesl.status_code IN ('A', 'N')
9503: AND pesl.effective_date > l_prev_enc_end_date);
9504:
9505: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9506:
9507: INSERT INTO psp_enc_changed_assignments
9508: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9509: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id

Line 9507: INSERT INTO psp_enc_changed_assignments

9503: AND pesl.effective_date > l_prev_enc_end_date);
9504:
9505: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '30-B Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9506:
9507: INSERT INTO psp_enc_changed_assignments
9508: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9509: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
9510: FROM per_assignments_f pa
9511: WHERE pa.payroll_id = p_payroll_id

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

9535: FROM psp_enc_summary_lines pesl
9536: WHERE pesl.assignment_id = pa.assignment_id
9537: AND pesl.status_code = 'N'
9538: AND pesl.payroll_id = p_payroll_id);
9539: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '40 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9540: END IF;
9541:
9542: INSERT INTO psp_enc_changed_assignments
9543: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)

Line 9542: INSERT INTO psp_enc_changed_assignments

9538: AND pesl.payroll_id = p_payroll_id);
9539: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '40 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9540: END IF;
9541:
9542: INSERT INTO psp_enc_changed_assignments
9543: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9544: SELECT DISTINCT l_request_id, p_payroll_id, assignment_id, 'LQ', p_payroll_action_id
9545: FROM psp_enc_summary_lines pesl
9546: WHERE payroll_id = p_payroll_id

Line 9555: FROM psp_enc_changed_assignments peca

9551: AND pesl.effective_date <= (NVL((get_asg_pay_end_date(g_payroll_mode,p_payroll_action_id,pesl.assignment_id,pesl.business_group_id,pesl.payroll_id) --13566809
9552: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9553: ),l_enc_begin_date))
9554: AND NOT EXISTS (SELECT 1
9555: FROM psp_enc_changed_assignments peca
9556: WHERE peca.assignment_id = pesl.assignment_id
9557: AND peca.payroll_id = p_payroll_id)
9558: AND NOT EXISTS (SELECT /*+INDEX(pesl2 PSP_ENC_SUMMARY_LINES_N6)*/ 1
9559: FROM psp_enc_summary_lines pesl2

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

9563: AND pesl2.effective_date <= (NVL((get_asg_pay_end_date(g_payroll_mode,p_payroll_action_id,pesl2.assignment_id,pesl2.business_group_id,pesl2.payroll_id)--13566809
9564: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9565: ),l_enc_begin_date))
9566: AND pesl2.payroll_id = p_payroll_id);
9567: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '50 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9568:
9569: END IF; -- End of Oracle Payroll Profile
9570:
9571: UPDATE psp_enc_changed_assignments peca

Line 9571: UPDATE psp_enc_changed_assignments peca

9567: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || '50 Inserted ' || SQL%ROWCOUNT || ' assignments into psp_enc_changed_assignments');
9568:
9569: END IF; -- End of Oracle Payroll Profile
9570:
9571: UPDATE psp_enc_changed_assignments peca
9572: SET payroll_action_id = p_payroll_action_id
9573: WHERE payroll_action_id IS NULL
9574: AND payroll_id = NVL(p_payroll_id, payroll_id)
9575: AND NOT EXISTS (SELECT 1

Line 9580: 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');

9576: FROM psp_enc_process_assignments pepa
9577: WHERE pepa.assignment_id = peca.assignment_id
9578: AND pepa.assignment_status NOT IN ('B', 'P')
9579: AND pepa.payroll_id = peca.payroll_id);
9580: 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');
9581:
9582: /*
9583: DELETE FROM psp_enc_changed_assignments
9584: WHERE payroll_action_id = p_payroll_action_id

Line 9583: DELETE FROM psp_enc_changed_assignments

9579: AND pepa.payroll_id = peca.payroll_id);
9580: 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');
9581:
9582: /*
9583: DELETE FROM psp_enc_changed_assignments
9584: WHERE payroll_action_id = p_payroll_action_id
9585: AND payroll_id = p_payroll_id
9586: AND request_id = l_request_id
9587: and assignment_id IN(SELECT assignment_id from PSP_ENC_PAYROLL_ASSIGNMENT_V

Line 9616: DELETE FROM psp_enc_changed_assignments

9612: AND ROWNUM < 2;
9613: EXCEPTION
9614: WHEN no_data_found THEN
9615:
9616: DELETE FROM psp_enc_changed_assignments
9617: WHERE payroll_action_id = p_payroll_action_id
9618: AND payroll_id = p_payroll_id
9619: AND request_id = l_request_id
9620: and assignment_id = asg_id_tab(rec_i);

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

9624:
9625: CLOSE exc_asg_cur;
9626: END;
9627: -- Modified the delete statement for bug 9862281 end
9628: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Deleted new excluded assignments in psp_enc_changed_assignments not to be processed by this Create and Update process');
9629:
9630: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' opening in_process_asg_cur fpr payroll_id: '||p_payroll_id);
9631:
9632:

Line 9706: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS

9702: l_person_id3: ' || l_person_id3 || ' l_termination_date3: ' || fnd_date.date_to_canonical(l_termination_date3) || '
9703: l_person_id4: ' || l_person_id4 || ' l_termination_date4: ' || fnd_date.date_to_canonical(l_termination_date4) || '
9704: l_person_id5: ' || l_person_id5 || ' l_termination_date5: ' || fnd_date.date_to_canonical(l_termination_date5));
9705:
9706: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS
9707: (request_id, assignment_id, payroll_id, change_type, payroll_action_id, change_date)
9708: SELECT DISTINCT l_request_id,
9709: pesl.assignment_id,
9710: pesl.payroll_id,

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

9720: AND NOT EXISTS (SELECT 1
9721: FROM psp_enc_summary_lines pesl2
9722: WHERE pesl2.person_id = l_person_id1
9723: AND pesl2.status_code = 'N');
9724: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9725: IF (SQL%ROWCOUNT = 0) THEN
9726: OPEN in_process_term_cur(l_person_id1);
9727: LOOP
9728: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;

Line 9774: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS

9770: CLOSE in_process_term_cur;
9771: END IF;
9772:
9773: IF (l_person_id2 > 0) THEN
9774: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS
9775: (request_id, assignment_id, payroll_id, change_type, payroll_action_id, change_date)
9776: SELECT DISTINCT l_request_id,
9777: pesl.assignment_id,
9778: pesl.payroll_id,

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

9788: AND NOT EXISTS (SELECT 1
9789: FROM psp_enc_summary_lines pesl2
9790: WHERE pesl2.person_id = l_person_id2
9791: AND pesl2.status_code = 'N');
9792: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9793: IF (SQL%ROWCOUNT = 0) THEN
9794: OPEN in_process_term_cur(l_person_id2);
9795: LOOP
9796: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;

Line 9843: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS

9839: END IF;
9840: END IF;
9841:
9842: IF (l_person_id3 > 0) THEN
9843: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS
9844: (request_id, assignment_id, payroll_id, change_type, payroll_action_id, change_date)
9845: SELECT DISTINCT l_request_id,
9846: pesl.assignment_id,
9847: pesl.payroll_id,

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

9857: AND NOT EXISTS (SELECT 1
9858: FROM psp_enc_summary_lines pesl2
9859: WHERE pesl2.person_id = l_person_id3
9860: AND pesl2.status_code = 'N');
9861: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9862: IF (SQL%ROWCOUNT = 0) THEN
9863: OPEN in_process_term_cur(l_person_id3);
9864: LOOP
9865: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;

Line 9912: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS

9908: END IF;
9909: END IF;
9910:
9911: IF (l_person_id4 > 0) THEN
9912: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS
9913: (request_id, assignment_id, payroll_id, change_type, payroll_action_id, change_date)
9914: SELECT DISTINCT l_request_id,
9915: pesl.assignment_id,
9916: pesl.payroll_id,

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

9926: AND NOT EXISTS (SELECT 1
9927: FROM psp_enc_summary_lines pesl2
9928: WHERE pesl2.person_id = l_person_id4
9929: AND pesl2.status_code = 'N');
9930: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
9931: IF (SQL%ROWCOUNT = 0) THEN
9932: OPEN in_process_term_cur(l_person_id4);
9933: LOOP
9934: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;

Line 9981: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS

9977: END IF;
9978: END IF;
9979:
9980: IF (l_person_id5 > 0) THEN
9981: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS
9982: (request_id, assignment_id, payroll_id, change_type, payroll_action_id, change_date)
9983: SELECT DISTINCT l_request_id,
9984: pesl.assignment_id,
9985: pesl.payroll_id,

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

9995: AND NOT EXISTS (SELECT 1
9996: FROM psp_enc_summary_lines pesl2
9997: WHERE pesl2.person_id = l_person_id5
9998: AND pesl2.status_code = 'N');
9999: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Inserted termination assignments into psp_enc_changed_assignments ' || SQL%ROWCOUNT);
10000: IF (SQL%ROWCOUNT = 0) THEN
10001: OPEN in_process_term_cur(l_person_id5);
10002: LOOP
10003: FETCH in_process_term_cur INTO l_assignment_id, l_payroll_id, l_payroll_action_id;

Line 10157: UPDATE psp_enc_changed_assignments

10153: SET assignment_status = 'B'
10154: WHERE payroll_action_id = p_payroll_action_id;
10155: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process status to ''Rollback'' in psp_enc_process_assignments');
10156:
10157: UPDATE psp_enc_changed_assignments
10158: SET payroll_action_id = NULL
10159: WHERE payroll_action_id = p_payroll_action_id;
10160: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');
10161:

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

10156:
10157: UPDATE psp_enc_changed_assignments
10158: SET payroll_action_id = NULL
10159: WHERE payroll_action_id = p_payroll_action_id;
10160: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');
10161:
10162: INSERT INTO psp_enc_changed_assignments
10163: (request_id, assignment_id, payroll_id, change_type,
10164: processed_flag, reference_id, action_type, change_date)

Line 10162: INSERT INTO psp_enc_changed_assignments

10158: SET payroll_action_id = NULL
10159: WHERE payroll_action_id = p_payroll_action_id;
10160: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');
10161:
10162: INSERT INTO psp_enc_changed_assignments
10163: (request_id, assignment_id, payroll_id, change_type,
10164: processed_flag, reference_id, action_type, change_date)
10165: SELECT l_request_id, pecah.assignment_id, pecah.payroll_id, pecah.change_type,
10166: NULL, NVL(pecah.reference_id, 0), pecah.action_type, change_date

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

10166: NULL, NVL(pecah.reference_id, 0), pecah.action_type, change_date
10167: FROM psp_enc_changed_asg_history pecah
10168: WHERE payroll_action_id = p_payroll_action_id
10169: AND action_type NOT IN ('CR', 'LQ', 'TR');
10170: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
10171:
10172: DELETE psp_enc_changed_asg_history
10173: WHERE payroll_action_id = p_payroll_action_id;
10174: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');

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

10170: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
10171:
10172: DELETE psp_enc_changed_asg_history
10173: WHERE payroll_action_id = p_payroll_action_id;
10174: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
10175: ELSE
10176: OPEN asg_cur(p_person_id1, p_assignment_id1);
10177: FETCH asg_cur BULK COLLECT INTO l_assignments;
10178: CLOSE asg_cur;

Line 10277: UPDATE psp_enc_changed_assignments

10273: WHERE payroll_action_id = p_payroll_action_id
10274: AND assignment_id = l_assignments(recno);
10275: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated assignment status to ''Rollback'' in psp_enc_process_assignments');
10276:
10277: UPDATE psp_enc_changed_assignments
10278: SET payroll_action_id = NULL
10279: WHERE payroll_action_id = p_payroll_action_id
10280: AND assignment_id = l_assignments(recno);
10281: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');

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

10277: UPDATE psp_enc_changed_assignments
10278: SET payroll_action_id = NULL
10279: WHERE payroll_action_id = p_payroll_action_id
10280: AND assignment_id = l_assignments(recno);
10281: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');
10282:
10283: INSERT INTO psp_enc_changed_assignments
10284: (request_id, assignment_id, payroll_id, change_type,
10285: processed_flag, reference_id, action_type, change_date)

Line 10283: INSERT INTO psp_enc_changed_assignments

10279: WHERE payroll_action_id = p_payroll_action_id
10280: AND assignment_id = l_assignments(recno);
10281: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated payroll_action_id in psp_enc_changed_assignments');
10282:
10283: INSERT INTO psp_enc_changed_assignments
10284: (request_id, assignment_id, payroll_id, change_type,
10285: processed_flag, reference_id, action_type, change_date)
10286: SELECT l_request_id, pecah.assignment_id, pecah.payroll_id, pecah.change_type,
10287: NULL, NVL(pecah.reference_id, 0), pecah.action_type, change_date

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

10288: FROM psp_enc_changed_asg_history pecah
10289: WHERE payroll_action_id = p_payroll_action_id
10290: AND assignment_id = l_assignments(recno)
10291: AND action_type NOT IN ('CR', 'LQ', 'TR');
10292: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
10293:
10294: DELETE psp_enc_changed_asg_history
10295: WHERE payroll_action_id = p_payroll_action_id
10296: AND assignment_id = l_assignments(recno);

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

10293:
10294: DELETE psp_enc_changed_asg_history
10295: WHERE payroll_action_id = p_payroll_action_id
10296: AND assignment_id = l_assignments(recno);
10297: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied change assignment records to psp_enc_changed_assignments');
10298: END LOOP;
10299:
10300: UPDATE psp_enc_processes
10301: SET process_status = 'B',