APPS.PO_CHANGE_API1_S dependencies on PO_ACCEPTANCES

Line 40: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;

36: l_employee_id NUMBER := NULL;
37:
38: -- Bug 2850566
39: l_rowid ROWID;
40: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
41: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
42: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
43: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
44: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;

Line 41: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;

37:
38: -- Bug 2850566
39: l_rowid ROWID;
40: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
41: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
42: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
43: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
44: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
45: -- End of Bug 2850566

Line 42: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;

38: -- Bug 2850566
39: l_rowid ROWID;
40: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
41: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
42: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
43: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
44: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
45: -- End of Bug 2850566
46: l_org_id PO_HEADERS_ALL.org_id%type := p_org_id;

Line 44: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;

40: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
41: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
42: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
43: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
44: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
45: -- End of Bug 2850566
46: l_org_id PO_HEADERS_ALL.org_id%type := p_org_id;
47: CURSOR c_po_header IS
48: select PO_HEADER_ID

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

182: return l_result;
183: else
184:
185: -- Bug 2850566 RBAIRRAJ
186: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table
187: -- instead of writing an Insert statement.
188:
189: IF l_po_release_id IS NULL THEN
190: l_acc_po_header_id := l_po_header_id;

Line 195: PO_ACCEPTANCES_INS_PVT.insert_row(

191: ELSE
192: l_acc_po_header_id := NULL;
193: END IF;
194:
195: PO_ACCEPTANCES_INS_PVT.insert_row(
196: x_rowid => l_rowid,
197: x_acceptance_id => l_acceptance_id,
198: x_Last_Update_Date => l_Last_Update_Date,
199: x_Last_Updated_By => l_Last_Updated_By,