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 7456: FROM PO_ACCEPTANCES

7452: FROM po_headers_all
7453: WHERE po_header_id = l_document_id;
7454: SELECT COUNT(*)
7455: INTO l_responded_shipments
7456: FROM PO_ACCEPTANCES
7457: WHERE po_header_id = l_document_id
7458: AND revision_num = l_revision_num;
7459: ELSE
7460: SELECT revision_num

Line 7466: FROM PO_ACCEPTANCES

7462: FROM po_releases_all
7463: WHERE po_release_id = l_document_id;
7464: SELECT COUNT(*)
7465: INTO l_responded_shipments
7466: FROM PO_ACCEPTANCES
7467: WHERE po_release_id = l_document_id
7468: AND revision_num = l_revision_num;
7469: END IF;
7470: IF(l_responded_shipments > 0) THEN

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

7772: x_Accepted_Flag VARCHAR2(1) := flag;
7773: -- x_Acceptance_Lookup_Code varchar2(25);
7774: x_document_id NUMBER;
7775: x_document_type_code VARCHAR2(30);
7776: x_acceptance_note PO_ACCEPTANCES.note%TYPE; --bug 2178922
7777: -- Bug 2850566
7778: l_rowid ROWID;
7779: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
7780: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;

Line 7779: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;

7775: x_document_type_code VARCHAR2(30);
7776: x_acceptance_note PO_ACCEPTANCES.note%TYPE; --bug 2178922
7777: -- Bug 2850566
7778: l_rowid ROWID;
7779: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
7780: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
7781: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
7782: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
7783: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;

Line 7780: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;

7776: x_acceptance_note PO_ACCEPTANCES.note%TYPE; --bug 2178922
7777: -- Bug 2850566
7778: l_rowid ROWID;
7779: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
7780: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
7781: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
7782: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
7783: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
7784: -- End of Bug 2850566

Line 7781: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;

7777: -- Bug 2850566
7778: l_rowid ROWID;
7779: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
7780: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
7781: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
7782: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
7783: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
7784: -- End of Bug 2850566
7785: l_rspndr_usr_name fnd_user.user_name%TYPE := '';

Line 7783: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;

7779: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
7780: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
7781: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
7782: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
7783: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
7784: -- End of Bug 2850566
7785: l_rspndr_usr_name fnd_user.user_name%TYPE := '';
7786: l_accepting_party VARCHAR2(1);
7787: BEGIN

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

7785: l_rspndr_usr_name fnd_user.user_name%TYPE := '';
7786: l_accepting_party VARCHAR2(1);
7787: BEGIN
7788: -- Bug 2850566
7789: -- Commented out the select statement as it is handled in the PO_ACCEPTANCES rowhandler
7790: -- SELECT po_acceptances_s.nextval into x_Acceptance_id FROM sys.dual;
7791: -- commented out the usage of accptance_type (FPI)
7792: /* x_Acceptance_Lookup_Code := wf_engine.GetItemAttrText( itemtype => itemtype,
7793: itemkey => itemkey,

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

7786: l_accepting_party VARCHAR2(1);
7787: BEGIN
7788: -- Bug 2850566
7789: -- Commented out the select statement as it is handled in the PO_ACCEPTANCES rowhandler
7790: -- SELECT po_acceptances_s.nextval into x_Acceptance_id FROM sys.dual;
7791: -- commented out the usage of accptance_type (FPI)
7792: /* x_Acceptance_Lookup_Code := wf_engine.GetItemAttrText( itemtype => itemtype,
7793: itemkey => itemkey,
7794: aname => 'ACCEPTANCE_LOOKUP_CODE'); */

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

7823: FROM po_releases
7824: WHERE po_release_id = x_document_id;
7825: END IF;
7826: -- Bug 2850566 RBAIRRAJ
7827: -- Calling the Acceptances row handler to insert into the PO_ACCEPTANCES table
7828: -- instead of writing an Insert statement.
7829: IF x_po_release_id IS NULL THEN
7830: l_acc_po_header_id := x_po_header_id;
7831: ELSE

Line 7849: PO_ACCEPTANCES_INS_PVT.insert_row( x_rowid => l_rowid, x_acceptance_id => l_acceptance_id,

7845: l_Last_Updated_By := x_created_by;
7846: l_accepting_party := 'S'; --ack is always by supplier.
7847: END;
7848: l_Last_Update_Login := l_Last_Updated_By;
7849: PO_ACCEPTANCES_INS_PVT.insert_row( x_rowid => l_rowid, x_acceptance_id => l_acceptance_id,
7850: x_Last_Update_Date => l_Last_Update_Date, x_Last_Updated_By => l_Last_Updated_By,
7851: x_Last_Update_Login => l_Last_Update_Login, p_creation_date => x_Creation_Date,
7852: p_created_by => l_Last_Updated_By, p_po_header_id => l_acc_po_header_id, p_po_release_id => x_Po_Release_Id,
7853: p_action => x_Action, p_action_date => x_Action_Date, p_employee_id => NULL, p_revision_num => x_Revision_Num,