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 62: -- SQL What :selects the next avaiable sequence number from PO_ACCEPTANCES_S sequence

58: FROM PO_ACCEPTANCES
59: WHERE acceptance_id = l_id;
60:
61: -- Bug 2850566 RBAIRRAJ
62: -- SQL What :selects the next avaiable sequence number from PO_ACCEPTANCES_S sequence
63: -- SQL Why :To insert it as Acceptance_Id in the PO_ACCEPTANCES table
64: CURSOR c_next_id IS
65: SELECT PO_ACCEPTANCES_S.nextval
66: FROM SYS.DUAL;

Line 65: SELECT PO_ACCEPTANCES_S.nextval

61: -- Bug 2850566 RBAIRRAJ
62: -- SQL What :selects the next avaiable sequence number from PO_ACCEPTANCES_S sequence
63: -- SQL Why :To insert it as Acceptance_Id in the PO_ACCEPTANCES table
64: CURSOR c_next_id IS
65: SELECT PO_ACCEPTANCES_S.nextval
66: FROM SYS.DUAL;
67:
68: BEGIN
69:

Line 71: SELECT PO_ACCEPTANCES_S.nextval

67:
68: BEGIN
69:
70: IF (x_acceptance_id IS NULL) THEN
71: SELECT PO_ACCEPTANCES_S.nextval
72: INTO l_id
73: FROM SYS.DUAL;
74: ELSE
75: l_id := x_acceptance_id;