APPS.POS_WF_PO_ACKNOWLEDGE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

Procedure Insert_Acc_Rejection_Row(itemtype        in  varchar2,
                              	   itemkey         in  varchar2,
	                           actid           in  number,
				   flag		   in  varchar2);

Line: 88

  Insert_Acc_Rejection_Row(itemtype, itemkey, actid, 'Y');

Line: 126

  Insert_Acc_Rejection_Row(itemtype, itemkey, actid, 'N');

Line: 165

		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';

Line: 181

		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';

Line: 246

Procedure Insert_Acc_Rejection_Row(itemtype        in  varchar2,
                              	   itemkey         in  varchar2,
	                           actid           in  number,
				   flag		   in  varchar2)
is

   x_row_id             varchar2(30);

Line: 255

   x_Last_Update_Date   date ;

Line: 256

   x_Last_Updated_By    number;

Line: 257

   l_Last_Update_Login  PO_ACCEPTANCES.last_update_login%TYPE;

Line: 293

	--  SELECT po_acceptances_s.nextval into x_Acceptance_id FROM sys.dual;

Line: 314

		select revision_num
		into x_revision_num
		from po_headers
		where po_header_id = x_document_id;

Line: 321

		select po_header_id, revision_num
		into x_Po_Header_Id, x_revision_num
		from po_releases
		where po_release_id = x_document_id;

Line: 330

    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);

Line: 391

			select nvl(acceptance_required_flag, 'N')
			into x_acceptance_required
			from po_releases
			where po_release_id = document_id;

Line: 396

			select nvl(acceptance_required_flag, 'N')
			into x_acceptance_required
			from po_headers
			where po_header_id = document_id;