The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure Insert_Acc_Rejection_Row(itemtype in varchar2,
itemkey in varchar2,
actid in number,
flag in varchar2);
Insert_Acc_Rejection_Row(itemtype, itemkey, actid, 'Y');
Insert_Acc_Rejection_Row(itemtype, itemkey, actid, 'N');
select poh.segment1 || '-' || poh.revision_num, polc.displayed_field, poh.agent_id,
poh.acceptance_required_flag, poh.acceptance_due_date, poh.org_id
into x_document_num, x_document_type, x_agent_id, x_acceptance_required_flag,
x_acceptance_due_date, x_org_id
from po_headers_all poh,
po_lookup_codes polc
where poh.po_header_id = x_document_id
and poh.type_lookup_code = polc.lookup_code
and polc.lookup_type = 'PO TYPE';
select por.release_num, por.agent_id, poh.segment1 || '-' || poh.revision_num, polc.displayed_field,
por.acceptance_required_flag, por.acceptance_due_date, por.agent_id
into x_release_num, x_agent_id, x_document_num, x_document_type, x_acceptance_required_flag,
x_acceptance_due_date, x_agent_id
from po_releases_all por,
po_headers_all poh,
po_lookup_codes polc
where por.po_release_id = x_document_id
and por.po_header_id = poh.po_header_id
and polc.lookup_type = 'DOCUMENT TYPE'
and polc.lookup_code = 'RELEASE';
Procedure Insert_Acc_Rejection_Row(itemtype in varchar2,
itemkey in varchar2,
actid in number,
flag in varchar2)
is
x_row_id varchar2(30);
x_Last_Update_Date date ;
x_Last_Updated_By number;
l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
-- SELECT po_acceptances_s.nextval into x_Acceptance_id FROM sys.dual;
select revision_num
into x_revision_num
from po_headers
where po_header_id = x_document_id;
select po_header_id, revision_num
into x_Po_Header_Id, x_revision_num
from po_releases
where po_release_id = x_document_id;
PO_ACCEPTANCES_INS_PVT.insert_row(
x_rowid => x_row_id,
x_acceptance_id => x_Acceptance_id,
x_Last_Update_Date => x_Last_Update_Date,
x_Last_Updated_By => x_Last_Updated_By,
x_Last_Update_Login => l_Last_Update_Login,
p_creation_date => x_Creation_Date,
p_created_by => x_Created_by,
p_po_header_id => x_Po_Header_Id,
p_po_release_id => x_Po_Release_Id,
p_action => x_Action,
p_action_date => x_Action_Date,
p_employee_id => x_Employee_Id,
p_revision_num => x_Revision_Num,
p_accepted_flag => x_Accepted_Flag,
p_acceptance_lookup_code=> x_Acceptance_Lookup_Code,
p_attribute_category => x_Attribute_Category,
p_attribute1 => x_Attribute1,
p_attribute2 => x_Attribute2,
p_attribute3 => x_Attribute3,
p_attribute4 => x_Attribute4,
p_attribute5 => x_Attribute5,
p_attribute6 => x_Attribute6,
p_attribute7 => x_Attribute7,
p_attribute8 => x_Attribute8,
p_attribute9 => x_Attribute9,
p_attribute10 => x_Attribute10,
p_attribute11 => x_Attribute11,
p_attribute12 => x_Attribute12,
p_attribute13 => x_Attribute13,
p_attribute14 => x_Attribute14,
p_attribute15 => x_Attribute15);
select nvl(acceptance_required_flag, 'N')
into x_acceptance_required
from po_releases
where po_release_id = document_id;
select nvl(acceptance_required_flag, 'N')
into x_acceptance_required
from po_headers
where po_header_id = document_id;