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.PO_ACCEPTANCES_INS_PVT dependencies on PO_ACCEPTANCES_S

Line 72: -- SQL What :selects the next avaiable sequence number from PO_ACCEPTANCES_S sequence

68: FROM PO_ACCEPTANCES
69: WHERE acceptance_id = l_id;
70:
71: -- Bug 2850566 RBAIRRAJ
72: -- SQL What :selects the next avaiable sequence number from PO_ACCEPTANCES_S sequence
73: -- SQL Why :To insert it as Acceptance_Id in the PO_ACCEPTANCES table
74: CURSOR c_next_id IS
75: SELECT PO_ACCEPTANCES_S.nextval
76: FROM SYS.DUAL;

Line 75: SELECT PO_ACCEPTANCES_S.nextval

71: -- Bug 2850566 RBAIRRAJ
72: -- SQL What :selects the next avaiable sequence number from PO_ACCEPTANCES_S sequence
73: -- SQL Why :To insert it as Acceptance_Id in the PO_ACCEPTANCES table
74: CURSOR c_next_id IS
75: SELECT PO_ACCEPTANCES_S.nextval
76: FROM SYS.DUAL;
77:
78: BEGIN
79:

Line 81: SELECT PO_ACCEPTANCES_S.nextval

77:
78: BEGIN
79:
80: IF (x_acceptance_id IS NULL) THEN
81: SELECT PO_ACCEPTANCES_S.nextval
82: INTO l_id
83: FROM SYS.DUAL;
84: ELSE
85: l_id := x_acceptance_id;