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_ASSIGNMENT_CHANGES dependencies on PSP_ENC_CHANGED_ASSIGNMENTS

Line 45: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table START

41:
42: l_element_type_id NUMBER DEFAULT NULL;
43: l_payroll_id NUMBER DEFAULT NULL;
44:
45: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table START
46: CURSOR check_enc_run_csr(p_payroll_id NUMBER) IS
47: SELECT 'Y'
48: FROM psp_enc_summary_lines
49: WHERE payroll_id = p_payroll_id

Line 55: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table END

51: AND status_code IN ('A', 'N')
52: AND ROWNUM = 1;
53:
54: check_enc_run_flag Varchar2(1);
55: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table END
56:
57: BEGIN
58: IF (use_ld_enc = 'Y') THEN
59: OPEN element_cur;

Line 67: -- INSERT INTO psp_enc_changed_assignments

63: OPEN PAYROLL_ID_CUR;
64: FETCH PAYROLL_ID_CUR INTO l_payroll_id;
65: CLOSE PAYROLL_ID_CUR;
66: /* Commented the following code for Bug 3451760 */
67: -- INSERT INTO psp_enc_changed_assignments
68: -- (assignment_id, payroll_id, change_type, processed_flag)
69: -- VALUES (p_assignment_id, l_payroll_id, 'ET', NULL);
70:
71: /* Added the the Following code for Bug 3451760 */

Line 75: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table

71: /* Added the the Following code for Bug 3451760 */
72:
73:
74: IF(l_payroll_id IS NOT NULL) THEN
75: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table
76: OPEN check_enc_run_csr(l_payroll_id);
77: FETCH check_enc_run_csr INTO check_enc_run_flag;
78: CLOSE check_enc_run_csr;
79: IF check_enc_run_flag = 'Y' THEN

Line 80: INSERT INTO psp_enc_changed_assignments

76: OPEN check_enc_run_csr(l_payroll_id);
77: FETCH check_enc_run_csr INTO check_enc_run_flag;
78: CLOSE check_enc_run_csr;
79: IF check_enc_run_flag = 'Y' THEN
80: INSERT INTO psp_enc_changed_assignments
81: (assignment_id, payroll_id, change_type, processed_flag)
82: VALUES (p_assignment_id, l_payroll_id, 'ET', NULL);
83: END IF;
84: END IF;

Line 123: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table START

119: WHERE assignment_id = p_assignment_id_o
120: --AND SYSDATE BETWEEN effective_start_date AND effective_end_date; Commented for Bug 3451760
121: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
122:
123: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table START
124: CURSOR check_enc_run_csr(p_payroll_id NUMBER) IS
125: SELECT 'Y'
126: FROM psp_enc_summary_lines
127: WHERE payroll_id = p_payroll_id

Line 133: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table END

129: AND status_code IN ('A', 'N')
130: AND ROWNUM = 1;
131:
132: check_enc_run_flag Varchar2(1);
133: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table END
134:
135: BEGIN
136:
137: IF (use_ld_enc = 'Y') THEN

Line 148: -- INSERT INTO psp_enc_changed_assignments

144: FETCH PAYROLL_ID_CUR INTO l_payroll_id;
145: CLOSE PAYROLL_ID_CUR;
146:
147: /* Commented the following code for Bug 3451760 */
148: -- INSERT INTO psp_enc_changed_assignments
149: -- (assignment_id, payroll_id, change_type, processed_flag)
150: -- VALUES (p_assignment_id_o, l_payroll_id, 'ET', NULL);
151:
152: /* Added the the Following code for Bug 3451760 */

Line 154: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table

150: -- VALUES (p_assignment_id_o, l_payroll_id, 'ET', NULL);
151:
152: /* Added the the Following code for Bug 3451760 */
153: IF(l_payroll_id IS NOT NULL) THEN
154: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table
155: OPEN check_enc_run_csr(l_payroll_id);
156: FETCH check_enc_run_csr INTO check_enc_run_flag;
157: CLOSE check_enc_run_csr;
158: IF check_enc_run_flag = 'Y' THEN

Line 159: INSERT INTO psp_enc_changed_assignments

155: OPEN check_enc_run_csr(l_payroll_id);
156: FETCH check_enc_run_csr INTO check_enc_run_flag;
157: CLOSE check_enc_run_csr;
158: IF check_enc_run_flag = 'Y' THEN
159: INSERT INTO psp_enc_changed_assignments
160: (assignment_id, payroll_id, change_type, processed_flag)
161: VALUES (p_assignment_id_o, l_payroll_id, 'ET', NULL);
162: END IF;
163: END IF;

Line 198: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table START

194: FROM per_all_assignments_f
195: WHERE assignment_id = p_assignment_id_o
196: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
197:
198: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table START
199: CURSOR check_enc_run_csr(p_payroll_id NUMBER) IS
200: SELECT 'Y'
201: FROM psp_enc_summary_lines
202: WHERE payroll_id = p_payroll_id

Line 208: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table END

204: AND status_code IN ('A', 'N')
205: AND ROWNUM = 1;
206:
207: check_enc_run_flag Varchar2(1);
208: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table END
209:
210: BEGIN
211: IF (use_ld_enc = 'Y') THEN
212: OPEN element_cur;

Line 221: /* INSERT INTO psp_enc_changed_assignments

217: FETCH payroll_id_cur INTO l_payroll_id;
218: CLOSE payroll_id_cur;
219:
220: /* Commented the following Code for Bug 3451760 */
221: /* INSERT INTO psp_enc_changed_assignments
222: (assignment_id, payroll_id, change_type, processed_flag)
223: VALUES (p_assignment_id_o, l_payroll_id, 'ET', NULL); */
224:
225: /* Added the follwoing Check for Bug 3451760 */

Line 227: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table

223: VALUES (p_assignment_id_o, l_payroll_id, 'ET', NULL); */
224:
225: /* Added the follwoing Check for Bug 3451760 */
226: IF ( l_payroll_id IS NOT NULL ) THEN
227: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table
228: OPEN check_enc_run_csr(l_payroll_id);
229: FETCH check_enc_run_csr INTO check_enc_run_flag;
230: CLOSE check_enc_run_csr;
231: IF check_enc_run_flag = 'Y' THEN

Line 232: INSERT INTO psp_enc_changed_assignments

228: OPEN check_enc_run_csr(l_payroll_id);
229: FETCH check_enc_run_csr INTO check_enc_run_flag;
230: CLOSE check_enc_run_csr;
231: IF check_enc_run_flag = 'Y' THEN
232: INSERT INTO psp_enc_changed_assignments
233: (assignment_id, payroll_id, change_type, processed_flag)
234: VALUES (p_assignment_id_o, l_payroll_id, 'ET', NULL);
235: END IF;
236: END IF;

Line 281: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table START

277: --added for bug 5977888
278: l_count1 integer;
279: l_count2 integer;
280:
281: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table START
282: /*
283: chk_old_pay_flg varchar2(1) := 'N';
284: chk_new_pay_flg varchar2(1) := 'N';
285:

Line 302: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table END

298: AND ROWNUM = 1;
299:
300: check_old_enc_run_flag Varchar2(1) := 'N';
301: check_new_enc_run_flag Varchar2(1) := 'N';
302: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table END
303:
304:
305:
306:

Line 369: INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)

365:
366: IF (NVL(p_old_payroll_id,0) <> NVL(p_new_payroll_id,0)) THEN
367:
368: IF (check_new_enc_run_flag = 'Y') THEN
369: INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)
370: VALUES (p_new_assignment_id,p_new_payroll_id,'AS',NULL);
371: END IF;
372:
373: IF (check_old_enc_run_flag = 'Y') then

Line 374: INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)

370: VALUES (p_new_assignment_id,p_new_payroll_id,'AS',NULL);
371: END IF;
372:
373: IF (check_old_enc_run_flag = 'Y') then
374: INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)
375: VALUES (p_new_assignment_id,p_old_payroll_id,'AS',NULL);
376: END IF;
377:
378: -- Else if for p_old_payroll_id <> p_new_payroll_id

Line 384: INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)

380: /************** Added for bug -- for bug 4719330 *****************/
381: ELSIF (NVL(p_old_grade_id,0) <> NVL(p_new_grade_id,0)) THEN
382: IF (check_new_enc_run_flag = 'Y') then
383:
384: INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)
385: VALUES (p_new_assignment_id,p_new_payroll_id,'AS',NULL);
386:
387: ElSIF (check_old_enc_run_flag = 'Y') then
388:

Line 389: INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)

385: VALUES (p_new_assignment_id,p_new_payroll_id,'AS',NULL);
386:
387: ElSIF (check_old_enc_run_flag = 'Y') then
388:
389: INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)
390: VALUES (p_new_assignment_id,p_old_payroll_id,'AS',NULL);
391:
392: END if;
393:

Line 461: -- INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)

457:
458: END IF;
459: /* commented the following code as the insert did nit have a check
460: whether payroll id is null for Bug 3432995 */
461: -- INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)
462: -- VALUES (p_new_assignment_id,p_new_payroll_id,'AS',NULL);
463:
464: /* Introduced the following code for Bug 3432995 */
465:

Line 468: INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)

464: /* Introduced the following code for Bug 3432995 */
465:
466: IF (check_new_enc_run_flag = 'Y') then
467:
468: INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)
469: VALUES (p_new_assignment_id,p_new_payroll_id,'AS',NULL);
470:
471: ElSIF (check_old_enc_run_flag = 'Y') then
472:

Line 473: INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)

469: VALUES (p_new_assignment_id,p_new_payroll_id,'AS',NULL);
470:
471: ElSIF (check_old_enc_run_flag = 'Y') then
472:
473: INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)
474: VALUES (p_new_assignment_id,p_old_payroll_id,'AS',NULL);
475:
476: END if;
477:

Line 539: /* INSERT INTO psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)

535:
536:
537:
538: /* Commenetd the following code for Bug 3432995 */
539: /* INSERT INTO psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)
540: VALUES (p_new_assignment_id,p_new_payroll_id,'AS',NULL); */
541:
542: /* Introduced the following code for Bug 3432995 */
543: IF ( check_new_enc_run_flag = 'Y') THEN

Line 545: INSERT INTO psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)

541:
542: /* Introduced the following code for Bug 3432995 */
543: IF ( check_new_enc_run_flag = 'Y') THEN
544:
545: INSERT INTO psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)
546: VALUES (p_new_assignment_id,p_new_payroll_id,'AS',NULL);
547:
548: ElSIF (check_old_enc_run_flag = 'Y') then
549:

Line 550: INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)

546: VALUES (p_new_assignment_id,p_new_payroll_id,'AS',NULL);
547:
548: ElSIF (check_old_enc_run_flag = 'Y') then
549:
550: INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)
551: VALUES (p_new_assignment_id,p_old_payroll_id,'AS',NULL);
552:
553: END IF;
554:

Line 566: INSERT INTO psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag,chk_asg_end_date_flag)

562: END;
563:
564: -- Added this code to track the status change to END for Bug 4203036
565: IF ( check_new_enc_run_flag = 'Y') THEN
566: INSERT INTO psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag,chk_asg_end_date_flag)
567: VALUES (p_new_assignment_id,p_new_payroll_id,'AS',NULL,'Y');
568: ElSIF (check_old_enc_run_flag = 'Y') then
569: INSERT INTO psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag,chk_asg_end_date_flag)
570: VALUES (p_new_assignment_id,p_old_payroll_id,'AS',NULL,'Y');

Line 569: INSERT INTO psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag,chk_asg_end_date_flag)

565: IF ( check_new_enc_run_flag = 'Y') THEN
566: INSERT INTO psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag,chk_asg_end_date_flag)
567: VALUES (p_new_assignment_id,p_new_payroll_id,'AS',NULL,'Y');
568: ElSIF (check_old_enc_run_flag = 'Y') then
569: INSERT INTO psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag,chk_asg_end_date_flag)
570: VALUES (p_new_assignment_id,p_old_payroll_id,'AS',NULL,'Y');
571: end if ;
572:
573:

Line 598: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table START

594: p_old_effective_end_date IN DATE --Bug 12969737
595: )
596:
597: IS
598: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table START
599: CURSOR check_enc_run_csr(p_payroll_id NUMBER) IS
600: SELECT 'Y'
601: FROM psp_enc_summary_lines
602: WHERE payroll_id = p_payroll_id

Line 608: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table END

604: AND status_code IN ('A', 'N')
605: AND ROWNUM = 1;
606:
607: check_enc_run_flag Varchar2(1);
608: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table END
609:
610: -- Bug 5526742
611:
612: CURSOR chk_asg_count is

Line 726: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table

722: End if; --Bug 12969737
723:
724: END IF ;
725:
726: -- Bug 4072324: Changes to avoid Extra Loging in psp_enc_changed_assignments Table
727: OPEN check_enc_run_csr(p_old_payroll_id);
728: FETCH check_enc_run_csr INTO check_enc_run_flag;
729: CLOSE check_enc_run_csr;
730: IF check_enc_run_flag = 'Y' THEN

Line 731: INSERT INTO psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)

727: OPEN check_enc_run_csr(p_old_payroll_id);
728: FETCH check_enc_run_csr INTO check_enc_run_flag;
729: CLOSE check_enc_run_csr;
730: IF check_enc_run_flag = 'Y' THEN
731: INSERT INTO psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)
732: VALUES(p_old_assignment_id,p_old_payroll_id,'AS',NULL);
733: END IF;
734: END IF;
735: END IF;

Line 782: INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)

778: FETCH check_enc_run_csr INTO check_new_enc_run_flag;
779: CLOSE check_enc_run_csr;
780:
781: IF (check_new_enc_run_flag = 'Y') THEN
782: INSERT into psp_enc_changed_assignments(assignment_id,payroll_id,change_type,processed_flag)
783: VALUES (p_assignment_id,pay_rec.payroll_id,'AS',NULL);
784: END IF;
785:
786: