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_RELEASES

Line 494: -- 'RELEASE': PO_RELEASES_ALL.po_release_id

490: --DocumentID
491: -- This value for this parameter depends on the DocumentType:
492: -- 'REQUISITION': PO_REQUISITION_HEADERS_ALL.requisition_header_id
493: -- 'PO' or 'PA': PO_HEADERS_ALL.po_header_id
494: -- 'RELEASE': PO_RELEASES_ALL.po_release_id
495: --DocumentNumber
496: -- (Obsolete) This parameter is ignored. This procedure will derive the
497: -- document number from DocumentID and DocumentType. (Bug 3284628)
498: --PreparerID

Line 507: -- 'RELEASE': PO_RELEASES_ALL.release_type

503: --DocumentSubType
504: -- The value for this parameter depends on the DocumentType:
505: -- 'REQUISITION': PO_REQUISITION_HEADERS_ALL.type_lookup_code
506: -- 'PO' or 'PA': PO_HEADERS_ALL.type_lookup_code
507: -- 'RELEASE': PO_RELEASES_ALL.release_type
508: --SubmitterAction
509: -- (Unused) This parameter is not currently used.
510: --ForwardToID
511: -- Requester (for Requisitions) or buyer (for other document types)

Line 567: -- or PO_RELEASES_ALL accordingly. This is used by HTML Orders. (Bug 5218538)

563: -- value (default). The corresponding value('REQUESTER'/'SUPPLIER') is used
564: -- to set INITIATOR wf attribute in RCO wf.
565: --p_xml_flag
566: -- If 'Y' or 'N', this procedure will update the xml_flag in PO_HEADERS_ALL
567: -- or PO_RELEASES_ALL accordingly. This is used by HTML Orders. (Bug 5218538)
568: -- If null, no updates will be made.
569: -- p_source_type_code VARCHAR2 DEFAULT null
570: -- For the internal change order for requisitions the value will be INVENTORY
571:

Line 631: l_release_num PO_RELEASES.release_num%TYPE; -- Bug 3215186

627:
628: l_userkey varchar2(40);
629: l_doc_num_rel varchar2(30);
630: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE; -- Bug 3215186
631: l_release_num PO_RELEASES.release_num%TYPE; -- Bug 3215186
632: l_revision_num PO_HEADERS.revision_num%TYPE; -- Bug 3215186
633: l_ga_flag varchar2(1) := null; -- FPI GA
634:
635: /* RETROACTIVE FPI START */

Line 761: UPDATE po_releases_all

757:
758: IF (p_xml_flag = 'Y') THEN
759:
760: IF (DocumentTypeCode = 'RELEASE') THEN
761: UPDATE po_releases_all
762: SET xml_flag = 'Y',
763: edi_processed_flag = 'N'
764: WHERE po_release_id = DocumentID;
765: ELSE

Line 775: UPDATE po_releases_all

771:
772: ELSIF (p_xml_flag = 'N') THEN
773:
774: IF (DocumentTypeCode = 'RELEASE') THEN
775: UPDATE po_releases_all
776: SET xml_flag = 'N'
777: WHERE po_release_id = DocumentID;
778: ELSE
779: update po_headers_all

Line 991: from po_releases por,

987: por.acceptance_due_date, por.agent_id
988: into x_acceptance_required_flag,
989: x_acceptance_due_date,
990: x_agent_id
991: from po_releases por,
992: po_headers_all poh --
993: where por.po_release_id = DocumentID
994: and por.po_header_id = poh.po_header_id;
995:

Line 1087: from po_releases POR,

1083: into l_revision_num,
1084: l_release_num,
1085: l_doc_display_name,
1086: l_document_number -- Bug 3284628
1087: from po_releases POR,
1088: po_headers_all POH --
1089: where POR.po_release_id = DocumentID
1090: and POR.po_header_id = POH.po_header_id; -- JOIN
1091:

Line 1322: from po_releases_all

1318:
1319: IF DocumentTypeCode = 'RELEASE' THEN
1320: select NVL(consigned_consumption_flag, 'N') -- Bug 3318625
1321: into l_consigned_flag
1322: from po_releases_all
1323: where po_release_id = DocumentId;
1324: ELSIF DocumentTypeCode = 'PO' THEN
1325: select NVL(consigned_consumption_flag, 'N')
1326: into l_consigned_flag

Line 1413: from po_releases por,po_headers poh,

1409: select pov.vendor_name,
1410: pvs.vendor_site_code
1411: into l_vendor,
1412: l_vendor_site_code
1413: from po_releases por,po_headers poh,
1414: po_vendors pov,po_vendor_sites_all pvs
1415: where por.po_release_id = DocumentId
1416: and por.po_header_id = poh.po_header_id
1417: and poh.vendor_id = pov.vendor_id

Line 1639: update po_releases

1635: -- while the workflow process is waiting for background engine to pick it up
1636:
1637: IF p_background_flag = 'Y' THEN
1638: IF DocumentTypeCode = 'RELEASE' THEN
1639: update po_releases
1640: set AUTHORIZATION_STATUS = 'IN PROCESS',
1641: last_updated_by = fnd_global.user_id,
1642: last_update_login = fnd_global.login_id,
1643: last_update_date = sysdate

Line 2003: -- Set the Command for the button that opens the Enter PO/Releases form

1999: avalue => userenv('LANG'));
2000:
2001: END IF;
2002:
2003: -- Set the Command for the button that opens the Enter PO/Releases form
2004: -- Note: the Open Form command for the requisition is hard-coded in the
2005: -- Requisition approval workflow.
2006:
2007: IF l_document_type IN ('PO', 'PA') THEN

Line 2270: ** for PO/Releases then we need to store REQUIRES REAPPROVAL as the original

2266: where PO_HEADER_ID = l_document_id;
2267:
2268: /* Bug#1810322: kagarwal
2269: ** Desc: If the original authorization status is IN PROCESS or PRE-APPROVED
2270: ** for PO/Releases then we need to store REQUIRES REAPPROVAL as the original
2271: ** authorization status if the revision number is greater than 0 else
2272: ** INCOMPLETE.
2273: */
2274:

Line 2287: from po_releases_all

2283: ELSIF l_document_type = 'RELEASE' THEN
2284:
2285: select AUTHORIZATION_STATUS, NVL(REVISION_NUM,0)
2286: into l_authorization_status, l_po_revision
2287: from po_releases_all
2288: where PO_RELEASE_ID = l_document_id;
2289:
2290: IF l_authorization_status IN ('IN PROCESS', 'PRE-APPROVED') THEN
2291: IF l_po_revision > 0 THEN

Line 2838: from PO_RELEASES

2834:
2835: ELSIF l_doc_type = 'RELEASE' THEN
2836:
2837: select NVL(authorization_status,'INCOMPLETE') into l_auth_stat
2838: from PO_RELEASES
2839: where po_release_id = l_doc_id;
2840:
2841: IF l_auth_stat <> 'APPROVED' THEN
2842: SetRelAuthStat(l_doc_id, itemtype,itemkey,NULL, l_orig_auth_stat );

Line 3153: from PO_RELEASES

3149:
3150: ELSIF l_doc_type = 'RELEASE' THEN
3151:
3152: select NVL(authorization_status,'INCOMPLETE') into l_auth_stat
3153: from PO_RELEASES
3154: where po_release_id = l_doc_id;
3155:
3156: END IF;
3157:

Line 3688: from po_releases

3684: where requisition_header_id= p_header_id;
3685:
3686: cursor rel_cursor(p_header_id number) is
3687: select wf_item_key
3688: from po_releases
3689: where po_release_id= p_header_id;
3690:
3691: BEGIN
3692:

Line 4677: from po_releases

4673: l_po_header_id := l_document_id;
4674:
4675: elsif (l_document_type = 'RELEASE') then
4676: select po_header_id into l_po_header_id
4677: from po_releases
4678: where po_release_id = l_document_id;
4679:
4680: else
4681: null;

Line 5030: from PO_RELEASES

5026:
5027: x_progress := '004';
5028:
5029: select NVL(authorization_status,'INCOMPLETE') into l_auth_stat
5030: from PO_RELEASES
5031: where po_release_id = l_doc_id;
5032:
5033: END IF;
5034:

Line 6007: update po_releases set

6003: ** or 'PRE-APPROVED', therefore we should update the status to IN PROCESS.
6004: */
6005: IF note = 'UPGRADE_TO_R11' THEN
6006:
6007: update po_releases set
6008: WF_ITEM_TYPE = itemtype,
6009: WF_ITEM_KEY = itemkey,
6010: last_updated_by = fnd_global.user_id,
6011: last_update_login = fnd_global.login_id,

Line 6017: update po_releases set

6013: where po_release_id = l_Release_header_id;
6014:
6015: ELSE
6016:
6017: update po_releases set
6018: AUTHORIZATION_STATUS = p_auth_status,
6019: WF_ITEM_TYPE = itemtype,
6020: WF_ITEM_KEY = itemkey,
6021: last_updated_by = fnd_global.user_id,

Line 6103: update po_releases set

6099: BEGIN
6100:
6101: x_progress := '001';
6102:
6103: update po_releases set
6104: WF_ITEM_TYPE = itemtype,
6105: WF_ITEM_KEY = itemkey,
6106: last_updated_by = fnd_global.user_id,
6107: last_update_login = fnd_global.login_id,

Line 6180: from po_releases_all

6176: where po_header_id = document_id;
6177:
6178: cursor get_release_orgid is
6179: select org_id
6180: from po_releases_all
6181: where po_release_id = document_id;
6182:
6183: x_progress varchar2(3):= '000';
6184:

Line 6352: from PO_RELEASES

6348: x_progress := '004';
6349:
6350: select NVL(authorization_status,'INCOMPLETE'),revision_num
6351: into l_auth_stat, l_revision_num
6352: from PO_RELEASES
6353: where po_release_id = p_doc_id;
6354:
6355: END IF;
6356:

Line 7735: po_releases rl,

7731: hd.SEGMENT1 || '-' ||
7732: rl.RELEASE_NUM
7733: into l_doc_string
7734: from po_headers hd,
7735: po_releases rl,
7736: po_lookup_codes ty,
7737: po_lookup_codes st
7738: where rl.po_release_id = l_document_id
7739: and rl.po_header_id = hd.po_header_id

Line 8333: Thus, we shall query acceptance_required_flag from po_headers/po_releases view.

8329: /*
8330: 1. Bug#2742276: To find out if acceptance is required, older version used to check workflow
8331: attribute ACCEPTANCE_REQUIRED.
8332: This may not be correct since acceptance_requried_flag may be updated in the DB.
8333: Thus, we shall query acceptance_required_flag from po_headers/po_releases view.
8334:
8335: */
8336: x_progress := '001';
8337:

Line 8358: from po_releases_all --bug 4764963

8354: where po_header_Id = l_document_id;
8355: else
8356: select acceptance_required_flag
8357: into l_acceptance_flag
8358: from po_releases_all --bug 4764963
8359: where po_release_Id = l_document_id;
8360: end if;
8361:
8362: /* BINDING FPJ START*/

Line 8387: from po_releases_all

8383: revision_num = l_revision_num;
8384: else
8385: select revision_num
8386: into l_revision_num
8387: from po_releases_all
8388: where po_release_id = l_document_id;
8389:
8390: select count(*)
8391: into l_responded_shipments

Line 8469: from po_releases por,

8465: and poh.po_header_id=x_document_id;
8466: else
8467: select pov.vendor_name, poh.po_header_id, por.revision_num --RDP
8468: into x_vendor,x_po_header_id,x_revision_num
8469: from po_releases por,
8470: po_headers_all poh, --
8471: po_vendors pov
8472: where por.po_release_id = x_document_id
8473: and por.po_header_id = poh.po_header_id

Line 8656: from po_releases por,

8652: por.revision_num
8653: into
8654: x_vendor,
8655: l_revision_num
8656: from po_releases por,
8657: po_headers_all poh, --
8658: po_vendors pov
8659: where por.po_release_id = x_document_id
8660: and por.po_header_id = poh.po_header_id

Line 8861: from po_releases

8857: x_Po_Release_Id := x_document_id;
8858:
8859: select po_header_id, revision_num,agent_id
8860: into x_Po_Header_Id, x_revision_num,x_employee_id
8861: from po_releases
8862: where po_release_id = x_document_id;
8863: end if;
8864:
8865: -- Bug 2850566 RBAIRRAJ

Line 8915: --Update the last update date when po_headers_all/po_releases_all tables are updated.

8911:
8912:
8913: -- Reset the Acceptance required Flag
8914: --Bug 6847039 - Start
8915: --Update the last update date when po_headers_all/po_releases_all tables are updated.
8916: if x_po_release_id is not null then
8917: update po_releases
8918: set acceptance_required_flag = 'N',
8919: LAST_UPDATE_DATE = SYSDATE,

Line 8917: update po_releases

8913: -- Reset the Acceptance required Flag
8914: --Bug 6847039 - Start
8915: --Update the last update date when po_headers_all/po_releases_all tables are updated.
8916: if x_po_release_id is not null then
8917: update po_releases
8918: set acceptance_required_flag = 'N',
8919: LAST_UPDATE_DATE = SYSDATE,
8920: acceptance_due_date = ''
8921: where po_release_id = x_po_release_id;

Line 10038: UPDATE po_releases_all pr

10034: BEGIN
10035:
10036: IF (p_doc_type = 'RELEASE') THEN
10037:
10038: UPDATE po_releases_all pr
10039: SET pr.printed_date = sysdate, pr.print_count = nvl(pr.print_count,0) + 1
10040: WHERE pr.po_release_id = p_doc_id ;
10041:
10042: ELSIF (p_doc_type in ('PO','PA')) THEN