APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_RELEASES_ALL

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

562: --DocumentID
563: -- This value for this parameter depends on the DocumentType:
564: -- 'REQUISITION': PO_REQUISITION_HEADERS_ALL.requisition_header_id
565: -- 'PO' or 'PA': PO_HEADERS_ALL.po_header_id
566: -- 'RELEASE': PO_RELEASES_ALL.po_release_id
567: --DocumentNumber
568: -- (Obsolete) This parameter is ignored. This procedure will derive the
569: -- document number from DocumentID and DocumentType. (Bug 3284628)
570: --PreparerID

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

575: --DocumentSubType
576: -- The value for this parameter depends on the DocumentType:
577: -- 'REQUISITION': PO_REQUISITION_HEADERS_ALL.type_lookup_code
578: -- 'PO' or 'PA': PO_HEADERS_ALL.type_lookup_code
579: -- 'RELEASE': PO_RELEASES_ALL.release_type
580: --SubmitterAction
581: -- (Unused) This parameter is not currently used.
582: --ForwardToID
583: -- Requester (for Requisitions) or buyer (for other document types)

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

635: -- value (default). The corresponding value('REQUESTER'/'SUPPLIER') is used
636: -- to set INITIATOR wf attribute in RCO wf.
637: --p_xml_flag
638: -- If 'Y' or 'N', this procedure will update the xml_flag in PO_HEADERS_ALL
639: -- or PO_RELEASES_ALL accordingly. This is used by HTML Orders. (Bug 5218538)
640: -- If null, no updates will be made.
641: -- p_source_type_code VARCHAR2 DEFAULT null
642: -- For the internal change order for requisitions the value will be INVENTORY
643: --End of Comments

Line 839: UPDATE po_releases_all

835: PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,x_progress);
836: END IF;
837: IF (p_xml_flag = 'Y') THEN
838: IF (DocumentTypeCode = 'RELEASE') THEN
839: UPDATE po_releases_all
840: SET xml_flag = 'Y',
841: edi_processed_flag = 'N'
842: WHERE po_release_id = DocumentID;
843: ELSE

Line 851: UPDATE po_releases_all SET xml_flag = 'N' WHERE po_release_id = DocumentID;

847: WHERE po_header_id = DocumentID;
848: END IF;
849: ELSIF (p_xml_flag = 'N') THEN
850: IF (DocumentTypeCode = 'RELEASE') THEN
851: UPDATE po_releases_all SET xml_flag = 'N' WHERE po_release_id = DocumentID;
852: ELSE
853: UPDATE po_headers_all SET xml_flag = 'N' WHERE po_header_id = DocumentID;
854: END IF;
855: END IF; -- p_xml_flag = 'Y'

Line 1395: FROM po_releases_all

1391: l_consigned_flag := 'N';
1392: IF DocumentTypeCode = 'RELEASE' THEN
1393: SELECT NVL(consigned_consumption_flag, 'N') -- Bug 3318625
1394: INTO l_consigned_flag
1395: FROM po_releases_all
1396: WHERE po_release_id = DocumentId;
1397: ELSIF DocumentTypeCode = 'PO' THEN
1398: SELECT NVL(consigned_consumption_flag, 'N')
1399: INTO l_consigned_flag

Line 2066: FROM po_releases_all

2062: SELECT AUTHORIZATION_STATUS,
2063: NVL(REVISION_NUM,0)
2064: INTO l_authorization_status,
2065: l_po_revision
2066: FROM po_releases_all
2067: WHERE PO_RELEASE_ID = l_document_id;
2068: IF l_authorization_status IN ('IN PROCESS', 'PRE-APPROVED') THEN
2069: IF l_po_revision > 0 THEN
2070: l_authorization_status := 'REQUIRES REAPPROVAL';

Line 4920: UPDATE po_releases_all

4916:
4917: -- added for bug 9072034 (to update revision number for releases.)
4918: ELSIF l_doc_type in ('RELEASE') THEN
4919:
4920: UPDATE po_releases_all
4921: SET comm_rev_num = l_po_revision_num_curr
4922: WHERE po_release_id = l_po_header_id;
4923:
4924: END IF;

Line 5258: SELECT org_id FROM po_releases_all WHERE po_release_id = document_id;

5254: IS
5255: SELECT org_id FROM po_headers_all WHERE po_header_id = document_id;
5256: CURSOR get_release_orgid
5257: IS
5258: SELECT org_id FROM po_releases_all WHERE po_release_id = document_id;
5259:
5260: x_progress VARCHAR2(3):= '000';
5261: BEGIN
5262: x_progress := '001';

Line 7437: FROM po_releases_all --bug 4764963

7433: WHERE po_header_Id = l_document_id;
7434: ELSE
7435: SELECT acceptance_required_flag
7436: INTO l_acceptance_flag
7437: FROM po_releases_all --bug 4764963
7438: WHERE po_release_Id = l_document_id;
7439: END IF;
7440: /* BINDING FPJ START*/
7441: IF NVL(l_acceptance_flag,'N') <> 'N' THEN

Line 7462: FROM po_releases_all

7458: AND revision_num = l_revision_num;
7459: ELSE
7460: SELECT revision_num
7461: INTO l_revision_num
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

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

7854: p_accepted_flag => x_Accepted_Flag, p_note => x_acceptance_note, p_accepting_party => l_accepting_party );
7855: -- End of Bug 2850566 RBAIRRAJ
7856: -- Reset the Acceptance required Flag
7857: --Bug 6847039 - Start
7858: --Update the last update date when po_headers_all/po_releases_all tables are updated.
7859: IF x_po_release_id IS NOT NULL THEN
7860: UPDATE po_releases
7861: SET acceptance_required_flag = 'N',
7862: LAST_UPDATE_DATE = SYSDATE,

Line 8797: -- from Cancel as the Cancel code also updates the po_headers_all/po_releases_all tables

8793:
8794: --
8795: -- Made the procedure non-autonomous
8796: -- There was deadlock error occurring when the communication was invoked
8797: -- from Cancel as the Cancel code also updates the po_headers_all/po_releases_all tables
8798: -- and the Commit/Rollback will not happen when the communication is invoked.
8799: PROCEDURE update_print_count( p_doc_id NUMBER,
8800: p_doc_type VARCHAR2 )
8801: IS

Line 8805: UPDATE po_releases_all pr

8801: IS
8802:
8803: BEGIN
8804: IF (p_doc_type = 'RELEASE') THEN
8805: UPDATE po_releases_all pr
8806: SET pr.printed_date = sysdate,
8807: pr.print_count = NVL(pr.print_count,0) + 1
8808: WHERE pr.po_release_id = p_doc_id ;
8809: ELSIF (p_doc_type IN ('PO','PA')) THEN

Line 9086: UPDATE po_releases_all

9082:
9083: -- added for bug 9072034 (to update revision number for releases.)
9084: ELSIF l_doc_type in ('RELEASE') THEN
9085:
9086: UPDATE po_releases_all
9087: SET comm_rev_num = l_po_revision_num_curr
9088: WHERE po_release_id = l_po_header_id;
9089:
9090: END IF;