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

Line 1: PACKAGE BODY PO_ACCEPTANCES_INS_PVT AS

1: PACKAGE BODY PO_ACCEPTANCES_INS_PVT AS
2: /* $Header: POXVIACB.pls 115.4 2004/05/09 15:49:40 jmojnida noship $*/
3:
4: -- Bug 2850566
5: -- Modified the parameters of the procedure to accomodate new columns

Line 58: FROM PO_ACCEPTANCES

54: -- SQL Why :To set the output parameter x_rowid
55: -- SQL Join :Acceptance_id
56: CURSOR c_rowid IS
57: SELECT rowid
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

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 63: -- SQL Why :To insert it as Acceptance_Id in the PO_ACCEPTANCES table

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;
67:

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;

Line 90: -- SQL What :Inserts a record into PO_ACCEPTANCES table

86: x_last_update_login := fnd_global.login_id;
87: end if;
88:
89: -- Bug 2850566 RBAIRRAJ
90: -- SQL What :Inserts a record into PO_ACCEPTANCES table
91: -- SQL Why :This acts as a rowhandler for the PO_ACCEPTANCES table
92: INSERT INTO PO_ACCEPTANCES(
93: ACCEPTANCE_ID,
94: LAST_UPDATE_DATE,

Line 91: -- SQL Why :This acts as a rowhandler for the PO_ACCEPTANCES table

87: end if;
88:
89: -- Bug 2850566 RBAIRRAJ
90: -- SQL What :Inserts a record into PO_ACCEPTANCES table
91: -- SQL Why :This acts as a rowhandler for the PO_ACCEPTANCES table
92: INSERT INTO PO_ACCEPTANCES(
93: ACCEPTANCE_ID,
94: LAST_UPDATE_DATE,
95: LAST_UPDATED_BY,

Line 92: INSERT INTO PO_ACCEPTANCES(

88:
89: -- Bug 2850566 RBAIRRAJ
90: -- SQL What :Inserts a record into PO_ACCEPTANCES table
91: -- SQL Why :This acts as a rowhandler for the PO_ACCEPTANCES table
92: INSERT INTO PO_ACCEPTANCES(
93: ACCEPTANCE_ID,
94: LAST_UPDATE_DATE,
95: LAST_UPDATED_BY,
96: LAST_UPDATE_LOGIN,

Line 190: END PO_ACCEPTANCES_INS_PVT;

186: WHEN OTHERS THEN
187: RAISE;
188: END insert_row;
189:
190: END PO_ACCEPTANCES_INS_PVT;