[Home] [Help]
640:
641: /* Bug# 2616433 */
642: --
643: if l_doc_type = 'PA' AND l_doc_subtype IN ('BLANKET','CONTRACT') OR
644: l_doc_type = 'PO' AND l_doc_subtype = 'STANDARD' then
645: -- CLM Apprvl. In case of modification documents that document type display needs to be 'Modification'
646: IF l_draft_id <> -1 then
647: l_doc_type_disp:= 'Modification';
648: ELSE
776: po_line_locations_all POLL
777: WHERE POD.po_header_id = POHdr_rec.po_header_id
778: AND POD.line_location_id=POLL.line_location_id
779: AND POD.po_header_id=POLL.po_header_id
780: AND Nvl(POD.distribution_type,'STANDARD') NOT IN ('PREPAYMENT') --11876122
781: AND POD.line_location_id IS NOT NULL; -- 13887381
782: /* Bug 11876122: Adding condition on distribution_type as in case of
783: complex PO's PREPAYMENT type distributions should not be considered
784: for calculating the tax amount to be shown in approver's window.
801: po_line_locations_all POLL
802: WHERE POD.po_header_id = POHdr_rec.po_header_id
803: AND POD.line_location_id=POLL.line_location_id
804: AND POD.po_header_id=POLL.po_header_id
805: AND Nvl(distribution_type,'STANDARD') NOT IN ('PREPAYMENT') -- 11876122
806: AND POD.line_location_id IS NOT NULL; -- 13887381
807: END IF;
808: EXCEPTION
809: WHEN NO_DATA_FOUND THEN
1627: --Locks:
1628: -- None.
1629: --Function:
1630: -- For each new Temp Labor line (i.e. line that has not been approved before)
1631: -- on a standard PO, starts the Notify Temp Labor Requester process to send
1632: -- a PO Approval notification to the requester.
1633: --Parameters:
1634: --IN:
1635: --itemtype
1641: --funcmode
1642: -- Workflow mode that this procedure is being called in: Run, Cancel, etc.
1643: --OUT:
1644: --resultout
1645: -- Standard result returned to Workflow: COMPLETED, ERROR, etc.
1646: --End of Comments
1647: -------------------------------------------------------------------------------
1648: PROCEDURE launch_notify_tl_requesters (
1649: itemtype IN VARCHAR2,
1721: g_pkg_name||'.'||l_proc_name||': document type: ' || l_document_type
1722: || ', document subtype: ' || l_document_subtype );
1723: END IF;
1724:
1725: -- This notification should only be sent for standard POs.
1726: IF (l_document_type = 'PO') AND (l_document_subtype = 'STANDARD') THEN
1727:
1728: l_progress := '010';
1729:
1722: || ', document subtype: ' || l_document_subtype );
1723: END IF;
1724:
1725: -- This notification should only be sent for standard POs.
1726: IF (l_document_type = 'PO') AND (l_document_subtype = 'STANDARD') THEN
1727:
1728: l_progress := '010';
1729:
1730: l_document_id := po_wf_util_pkg.GetItemAttrNumber (
1796: );
1797:
1798: END LOOP; -- l_temp_labor_requesters_csr
1799:
1800: END IF; -- Standard PO
1801:
1802: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1803:
1804: EXCEPTION