eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_ACCEPTANCES

Line 8381: from PO_ACCEPTANCES

8377: where po_header_id = l_document_id;
8378:
8379: select count(*)
8380: into l_responded_shipments
8381: from PO_ACCEPTANCES
8382: where po_header_id = l_document_id and
8383: revision_num = l_revision_num;
8384: else
8385: select revision_num

Line 8392: from PO_ACCEPTANCES

8388: where po_release_id = l_document_id;
8389:
8390: select count(*)
8391: into l_responded_shipments
8392: from PO_ACCEPTANCES
8393: where po_release_id = l_document_id and
8394: revision_num = l_revision_num;
8395: end if;
8396:

Line 8804: x_acceptance_note PO_ACCEPTANCES.note%TYPE; --bug 2178922

8800: x_Accepted_Flag varchar2(1) := flag;
8801: -- x_Acceptance_Lookup_Code varchar2(25);
8802: x_document_id number;
8803: x_document_type_code varchar2(30);
8804: x_acceptance_note PO_ACCEPTANCES.note%TYPE; --bug 2178922
8805:
8806: -- Bug 2850566
8807: l_rowid ROWID;
8808: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;

Line 8808: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;

8804: x_acceptance_note PO_ACCEPTANCES.note%TYPE; --bug 2178922
8805:
8806: -- Bug 2850566
8807: l_rowid ROWID;
8808: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
8809: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
8810: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
8811: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
8812: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;

Line 8809: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;

8805:
8806: -- Bug 2850566
8807: l_rowid ROWID;
8808: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
8809: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
8810: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
8811: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
8812: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
8813: -- End of Bug 2850566

Line 8810: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;

8806: -- Bug 2850566
8807: l_rowid ROWID;
8808: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
8809: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
8810: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
8811: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
8812: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
8813: -- End of Bug 2850566
8814: l_rspndr_usr_name fnd_user.user_name%TYPE := '';

Line 8812: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;

8808: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
8809: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
8810: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
8811: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
8812: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
8813: -- End of Bug 2850566
8814: l_rspndr_usr_name fnd_user.user_name%TYPE := '';
8815: l_accepting_party varchar2(1);
8816: begin

Line 8818: -- Commented out the select statement as it is handled in the PO_ACCEPTANCES rowhandler

8814: l_rspndr_usr_name fnd_user.user_name%TYPE := '';
8815: l_accepting_party varchar2(1);
8816: begin
8817: -- Bug 2850566
8818: -- Commented out the select statement as it is handled in the PO_ACCEPTANCES rowhandler
8819: -- SELECT po_acceptances_s.nextval into x_Acceptance_id FROM sys.dual;
8820:
8821: -- commented out the usage of accptance_type (FPI)
8822: /* x_Acceptance_Lookup_Code := wf_engine.GetItemAttrText( itemtype => itemtype,

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

8815: l_accepting_party varchar2(1);
8816: begin
8817: -- Bug 2850566
8818: -- Commented out the select statement as it is handled in the PO_ACCEPTANCES rowhandler
8819: -- SELECT po_acceptances_s.nextval into x_Acceptance_id FROM sys.dual;
8820:
8821: -- commented out the usage of accptance_type (FPI)
8822: /* x_Acceptance_Lookup_Code := wf_engine.GetItemAttrText( itemtype => itemtype,
8823: itemkey => itemkey,

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

8862: where po_release_id = x_document_id;
8863: end if;
8864:
8865: -- Bug 2850566 RBAIRRAJ
8866: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table
8867: -- instead of writing an Insert statement.
8868:
8869: IF x_po_release_id IS NULL THEN
8870: l_acc_po_header_id := x_po_header_id;

Line 8891: PO_ACCEPTANCES_INS_PVT.insert_row(

8887: l_accepting_party := 'S'; --ack is always by supplier.
8888: end;
8889: l_Last_Update_Login := l_Last_Updated_By;
8890:
8891: PO_ACCEPTANCES_INS_PVT.insert_row(
8892: x_rowid => l_rowid,
8893: x_acceptance_id => l_acceptance_id,
8894: x_Last_Update_Date => l_Last_Update_Date,
8895: x_Last_Updated_By => l_Last_Updated_By,