DBA Data[Home] [Help]

APPS.PO_POAPPROVAL_INIT1 dependencies on PO_WF_UTIL_PKG

Line 155: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,

151: WHERE po_release_id = l_po_header_id;
152:
153: END IF;
154:
155: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,
156: itemkey => itemkey,
157: aname => 'OLD_PO_REVISION_NUM',
158: AVALUE => l_po_revision_num_orig);
159:

Line 160: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,

156: itemkey => itemkey,
157: aname => 'OLD_PO_REVISION_NUM',
158: AVALUE => l_po_revision_num_orig);
159:
160: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,
161: itemkey => itemkey,
162: aname => 'NEW_PO_REVISION_NUM',
163: AVALUE => l_po_revision_num_curr);
164:

Line 169: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,

165: IF (l_po_revision_num_orig >= 0 ) THEN
166:
167: IF l_po_revision_num_curr = l_po_revision_num_orig THEN
168:
169: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,
170: itemkey => itemkey,
171: aname => 'HAS_REVISION_NUM_INCREMENTED',
172: avalue => 'N');
173:

Line 176: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,

172: avalue => 'N');
173:
174: ELSE
175:
176: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,
177: itemkey => itemkey,
178: aname => 'HAS_REVISION_NUM_INCREMENTED',
179: avalue => 'Y');
180:

Line 185: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,

181: END IF;
182:
183: ELSE
184:
185: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,
186: itemkey => itemkey,
187: aname => 'HAS_REVISION_NUM_INCREMENTED',
188: avalue => 'Y');
189:

Line 294: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,

290: l_is_new_document := 'N'; --
291: END IF;
292:
293: --
294: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
295: itemkey => itemkey,
296: aname => 'IS_NEW_DOCUMENT',
297: avalue => l_is_new_document );
298:

Line 445: l_draft_id := po_wf_util_pkg. GetItemAttrNumber (itemtype => itemtype,

441: END IF;
442:
443:
444: -- CLM Aprvl
445: l_draft_id := po_wf_util_pkg. GetItemAttrNumber (itemtype => itemtype,
446: itemkey => itemkey,
447: aname => 'DRAFT_ID');
448: --Bug 13742477 :: If draft id is null, it should fetch the records from PO_HEADERS_ALL
449: If (l_draft_id = -1 OR l_draft_id is null) Then

Line 557: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,

553: IF (g_po_wf_debug = 'Y') THEN
554: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
555: END IF;
556: -- CLM Apprvl. The document_number has to be set to draft_id in case of modifications
557: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,
558: itemkey => itemkey,
559: aname => 'DRAFT_ID');
560:
561: l_ame_approval_id := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,

Line 561: l_ame_approval_id := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,

557: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,
558: itemkey => itemkey,
559: aname => 'DRAFT_ID');
560:
561: l_ame_approval_id := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,
562: itemkey => itemkey,
563: aname => 'AME_TRANSACTION_ID');
564:
565: -- CLM apprvl. In the approval notification the appropriate doc number in the correct document numbering format must be displayed.

Line 567: l_clm_document_number := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,

563: aname => 'AME_TRANSACTION_ID');
564:
565: -- CLM apprvl. In the approval notification the appropriate doc number in the correct document numbering format must be displayed.
566:
567: l_clm_document_number := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,
568: itemkey => itemkey,
569: aname => 'CLM_DOCUMENT_NUMBER');
570:
571: l_modification_number := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,

Line 571: l_modification_number := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,

567: l_clm_document_number := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,
568: itemkey => itemkey,
569: aname => 'CLM_DOCUMENT_NUMBER');
570:
571: l_modification_number := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,
572: itemkey => itemkey,
573: aname => 'MODIFICATION_NUMBER');
574:
575: if l_draft_id <> -1 then

Line 576: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,

572: itemkey => itemkey,
573: aname => 'MODIFICATION_NUMBER');
574:
575: if l_draft_id <> -1 then
576: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
577: itemkey => itemkey,
578: aname => 'DOCUMENT_NUMBER',
579: avalue => l_modification_number);
580: else

Line 581: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,

577: itemkey => itemkey,
578: aname => 'DOCUMENT_NUMBER',
579: avalue => l_modification_number);
580: else
581: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
582: itemkey => itemkey,
583: aname => 'DOCUMENT_NUMBER',
584: avalue => l_clm_document_number);
585: end if;

Line 702: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,

698: end if;
699:
700:
701: --bug 12396408
702: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
703: itemkey => itemkey,
704: aname => 'PO_AMOUNT_DSP_NUMERIC',
705: avalue => l_po_amount);
706:

Line 819: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,

815: END IF; --(lv_tax_region ='JAI')
816: ---------------------------------------------------------------------------
817: --Modified by Eric Ma for IL PO Notification on Apr-13,2009,End
818: --bug 12396408
819: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
820: itemkey => itemkey,
821: aname => 'TAX_AMOUNT_DSP_NUMERIC',
822: avalue => l_tax_amount );
823:

Line 859: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,

855:
856: l_total_funded_amount_disp := TO_CHAR(l_total_funded_amount,FND_CURRENCY.GET_FORMAT_MASK(
857: l_currency_code,30));
858:
859: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
860: itemkey => itemkey,
861: aname => 'FUNDED_AMOUNT_DISPLAY',
862: avalue => l_total_funded_amount_disp);
863:

Line 864: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,

860: itemkey => itemkey,
861: aname => 'FUNDED_AMOUNT_DISPLAY',
862: avalue => l_total_funded_amount_disp);
863:
864: po_wf_util_pkg.SetItemAttrText ( itemtype => itemtype,
865: itemkey => itemkey,
866: aname => 'FUNDED_TITLE_DSP',
867: avalue => 'Funded Value');
868: END IF;

Line 1709: l_document_type := po_wf_util_pkg.GetItemAttrText (

1705: resultout := wf_engine.eng_null;
1706: return;
1707: end if;
1708:
1709: l_document_type := po_wf_util_pkg.GetItemAttrText (
1710: itemtype => itemtype,
1711: itemkey => itemkey,
1712: aname => 'DOCUMENT_TYPE');
1713:

Line 1714: l_document_subtype := po_wf_util_pkg.GetItemAttrText (

1710: itemtype => itemtype,
1711: itemkey => itemkey,
1712: aname => 'DOCUMENT_TYPE');
1713:
1714: l_document_subtype := po_wf_util_pkg.GetItemAttrText (
1715: itemtype => itemtype,
1716: itemkey => itemkey,
1717: aname => 'DOCUMENT_SUBTYPE');
1718:

Line 1730: l_document_id := po_wf_util_pkg.GetItemAttrNumber (

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 (
1731: itemtype => itemtype,
1732: itemkey => itemkey,
1733: aname => 'DOCUMENT_ID' );
1734:

Line 1735: l_is_new_document := po_wf_util_pkg.GetItemAttrText (

1731: itemtype => itemtype,
1732: itemkey => itemkey,
1733: aname => 'DOCUMENT_ID' );
1734:
1735: l_is_new_document := po_wf_util_pkg.GetItemAttrText (
1736: itemtype => itemtype,
1737: itemkey => itemkey,
1738: aname => 'IS_NEW_DOCUMENT');
1739:

Line 1740: l_approver_user_name := po_wf_util_pkg.GetItemAttrText (

1736: itemtype => itemtype,
1737: itemkey => itemkey,
1738: aname => 'IS_NEW_DOCUMENT');
1739:
1740: l_approver_user_name := po_wf_util_pkg.GetItemAttrText (
1741: itemtype => itemtype,
1742: itemkey => itemkey,
1743: aname => 'APPROVER_USER_NAME');
1744:

Line 1747: l_clm_document_number := po_wf_util_pkg.GetItemAttrText (

1743: aname => 'APPROVER_USER_NAME');
1744:
1745: /* bug 12773562 In the approval notification the appropriate doc number in the correct
1746: document numbering format must be displayed.*/
1747: l_clm_document_number := po_wf_util_pkg.GetItemAttrText (
1748: itemtype => itemtype,
1749: itemkey => itemkey,
1750: aname => 'CLM_DOCUMENT_NUMBER');
1751:

Line 1882: po_wf_util_pkg.SetItemAttrNumber (itemtype => p_item_type,

1878:
1879: l_progress := '020';
1880:
1881: -- Set some workflow item attributes.
1882: po_wf_util_pkg.SetItemAttrNumber (itemtype => p_item_type,
1883: itemkey => p_item_key,
1884: aname => 'PO_LINE_ID',
1885: avalue => p_po_line_id);
1886:

Line 1887: po_wf_util_pkg.SetItemAttrNumber (itemtype => p_item_type,

1883: itemkey => p_item_key,
1884: aname => 'PO_LINE_ID',
1885: avalue => p_po_line_id);
1886:
1887: po_wf_util_pkg.SetItemAttrNumber (itemtype => p_item_type,
1888: itemkey => p_item_key,
1889: aname => 'REQUESTER_ID',
1890: avalue => p_requester_id);
1891:

Line 1892: po_wf_util_pkg.SetItemAttrText ( ItemType => p_item_type,

1888: itemkey => p_item_key,
1889: aname => 'REQUESTER_ID',
1890: avalue => p_requester_id);
1891:
1892: po_wf_util_pkg.SetItemAttrText ( ItemType => p_item_type,
1893: ItemKey => p_item_key,
1894: aname => 'REQUESTER_USER_NAME',
1895: avalue => l_requester_user_name );
1896:

Line 1897: po_wf_util_pkg.SetItemAttrText (itemtype => p_item_type,

1893: ItemKey => p_item_key,
1894: aname => 'REQUESTER_USER_NAME',
1895: avalue => l_requester_user_name );
1896:
1897: po_wf_util_pkg.SetItemAttrText (itemtype => p_item_type,
1898: itemkey => p_item_key,
1899: aname => 'CONTRACTOR_OR_JOB',
1900: avalue => p_contractor_or_job);
1901:

Line 1902: po_wf_util_pkg.SetItemAttrText (itemtype => p_item_type,

1898: itemkey => p_item_key,
1899: aname => 'CONTRACTOR_OR_JOB',
1900: avalue => p_contractor_or_job);
1901:
1902: po_wf_util_pkg.SetItemAttrText (itemtype => p_item_type,
1903: itemkey => p_item_key,
1904: aname => 'APPROVER_USER_NAME',
1905: avalue => p_approver_user_name);
1906:

Line 1908: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => p_item_type,

1904: aname => 'APPROVER_USER_NAME',
1905: avalue => p_approver_user_name);
1906:
1907: -- bug 12773562 : Assigning CLM_DOCUMENT_NUMBER to workflow atribute
1908: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => p_item_type,
1909: itemkey => p_item_key,
1910: aname => 'CLM_DOCUMENT_NUMBER',
1911: avalue => p_clm_document_number);
1912:

Line 1935: po_wf_util_pkg.SetItemAttrText ( ItemType => p_item_type,

1931: AND POL.po_header_id = POH.po_header_id -- JOIN
1932: AND POL.po_line_id = PLL.po_line_id -- JOIN
1933: AND PLL.line_location_id = PRL.line_location_id (+); -- JOIN
1934:
1935: po_wf_util_pkg.SetItemAttrText ( ItemType => p_item_type,
1936: ItemKey => p_item_key,
1937: aname => 'DOCUMENT_NUMBER',
1938: avalue => l_document_number );
1939:

Line 1941: po_wf_util_pkg.SetItemAttrText ( ItemType => p_item_type,

1937: aname => 'DOCUMENT_NUMBER',
1938: avalue => l_document_number );
1939:
1940: -- Show the 'View Purchase Order' link.
1941: po_wf_util_pkg.SetItemAttrText ( ItemType => p_item_type,
1942: ItemKey => p_item_key,
1943: aname => 'VIEW_PO_URL',
1944: avalue =>
1945: 'OA.jsp?OAFunc=POS_VIEW_ORDER&PoHeaderId='||l_po_header_id );

Line 1950: po_wf_util_pkg.SetItemAttrText ( ItemType => p_item_type,

1946:
1947: -- Show the 'View Requisition' link if there is a backing requisition.
1948: IF (l_req_header_id IS NOT NULL) THEN
1949:
1950: po_wf_util_pkg.SetItemAttrText ( ItemType => p_item_type,
1951: ItemKey => p_item_key,
1952: aname => 'VIEW_REQ_URL',
1953: avalue =>
1954: 'OA.jsp?OAFunc=ICX_POR_LAUNCH_IP&porMode=viewReq'

Line 1966: po_wf_util_pkg.SetItemAttrText ( ItemType => p_item_type,

1962: HR_PO_INFO.get_url_place_cwk ( p_po_line_id => p_po_line_id,
1963: p_destination => l_create_cwk_url );
1964:
1965: IF (l_create_cwk_url IS NOT NULL) THEN
1966: po_wf_util_pkg.SetItemAttrText ( ItemType => p_item_type,
1967: ItemKey => p_item_key,
1968: aname => 'CREATE_CWK_ASSIGNMENT_URL',
1969: avalue => l_create_cwk_url );
1970: END IF;