[Home] [Help]
528:
529: /* Bug# 2616433 */
530: --
531: if l_doc_type = 'PA' AND l_doc_subtype IN ('BLANKET','CONTRACT') OR
532: l_doc_type = 'PO' AND l_doc_subtype = 'STANDARD' then
533:
534: l_doc_type_disp:= PO_DOC_STYLE_PVT.GET_STYLE_DISPLAY_NAME(l_doc_id);
535: else
536:
1395: --Locks:
1396: -- None.
1397: --Function:
1398: -- For each new Temp Labor line (i.e. line that has not been approved before)
1399: -- on a standard PO, starts the Notify Temp Labor Requester process to send
1400: -- a PO Approval notification to the requester.
1401: --Parameters:
1402: --IN:
1403: --itemtype
1409: --funcmode
1410: -- Workflow mode that this procedure is being called in: Run, Cancel, etc.
1411: --OUT:
1412: --resultout
1413: -- Standard result returned to Workflow: COMPLETED, ERROR, etc.
1414: --End of Comments
1415: -------------------------------------------------------------------------------
1416: PROCEDURE launch_notify_tl_requesters (
1417: itemtype IN VARCHAR2,
1486: g_pkg_name||'.'||l_proc_name||': document type: ' || l_document_type
1487: || ', document subtype: ' || l_document_subtype );
1488: END IF;
1489:
1490: -- This notification should only be sent for standard POs.
1491: IF (l_document_type = 'PO') AND (l_document_subtype = 'STANDARD') THEN
1492:
1493: l_progress := '010';
1494:
1487: || ', document subtype: ' || l_document_subtype );
1488: END IF;
1489:
1490: -- This notification should only be sent for standard POs.
1491: IF (l_document_type = 'PO') AND (l_document_subtype = 'STANDARD') THEN
1492:
1493: l_progress := '010';
1494:
1495: l_document_id := po_wf_util_pkg.GetItemAttrNumber (
1553: );
1554:
1555: END LOOP; -- l_temp_labor_requesters_csr
1556:
1557: END IF; -- Standard PO
1558:
1559: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1560:
1561: EXCEPTION