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 184: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table

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

Line 193: PO_ACCEPTANCES_INS_PVT.insert_row(

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