DBA Data[Home] [Help]

APPS.POS_WF_PO_ACKNOWLEDGE dependencies on PO_ACCEPTANCES

Line 257: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;

253: x_Acceptance_id number;
254: -- Bug 2850566
255: x_Last_Update_Date date ;
256: x_Last_Updated_By number;
257: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
258: -- End of Bug 2850566
259: x_Creation_Date date := TRUNC(SYSDATE);
260: x_Created_By number := fnd_global.user_id;
261: x_Po_Header_Id number;

Line 293: -- SELECT po_acceptances_s.nextval into x_Acceptance_id FROM sys.dual;

289: -- Bug 2850566 RBAIRRAJ
290: -- Commenting out the code for selecting the Acceptance Id as it is
291: -- handled in the PO_ACCEPTANCE row handler
292:
293: -- SELECT po_acceptances_s.nextval into x_Acceptance_id FROM sys.dual;
294:
295: if flag = 'Y' then
296: x_Acceptance_Lookup_Code := 'Accepted Terms';
297: else

Line 328: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table

324: where po_release_id = x_document_id;
325: end if;
326:
327: -- Bug 2850566 RBAIRRAJ
328: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table
329: -- instead of writing an Insert statement.
330: PO_ACCEPTANCES_INS_PVT.insert_row(
331: x_rowid => x_row_id,
332: x_acceptance_id => x_Acceptance_id,

Line 330: PO_ACCEPTANCES_INS_PVT.insert_row(

326:
327: -- Bug 2850566 RBAIRRAJ
328: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table
329: -- instead of writing an Insert statement.
330: PO_ACCEPTANCES_INS_PVT.insert_row(
331: x_rowid => x_row_id,
332: x_acceptance_id => x_Acceptance_id,
333: x_Last_Update_Date => x_Last_Update_Date,
334: x_Last_Updated_By => x_Last_Updated_By,