[Home] [Help]
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
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)
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:
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
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
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
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
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:
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*/
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
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,
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