eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_WF_PO_NOTIFICATION dependencies on PO_WF_UTIL_PKG

Line 128: l_supplier := PO_WF_UTIL_PKG.GetItemAttrText

124: aname => 'NOTE');
125:
126: -- Show supplier and supplier site for
127: -- approval notifications
128: l_supplier := PO_WF_UTIL_PKG.GetItemAttrText
129: (itemtype => l_item_type,
130: itemkey => l_item_key,
131: aname => 'SUPPLIER');
132:

Line 133: l_supplier_site := PO_WF_UTIL_PKG.GetItemAttrText

129: (itemtype => l_item_type,
130: itemkey => l_item_key,
131: aname => 'SUPPLIER');
132:
133: l_supplier_site := PO_WF_UTIL_PKG.GetItemAttrText
134: (itemtype => l_item_type,
135: itemkey => l_item_key,
136: aname => 'SUPPLIER_SITE');
137: --

Line 587: l_draft_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => l_item_type,

583: itemkey => l_item_key,
584: aname => 'DOCUMENT_TYPE');
585:
586: -- CLM Apprvl
587: l_draft_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => l_item_type,
588: itemkey => l_item_key,
589: aname => 'DRAFT_ID');
590:
591: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --

Line 606: l_open_form_command := PO_WF_UTIL_PKG.GetItemAttrText

602: aname => 'FUNCTIONAL_CURRENCY');
603:
604:
605: -- Bug 3668188
606: l_open_form_command := PO_WF_UTIL_PKG.GetItemAttrText
607: (itemtype => l_item_type,
608: itemkey => l_item_key,
609: aname => 'OPEN_FORM_COMMAND');
610:

Line 613: l_view_po_url := PO_WF_UTIL_PKG.GetItemAttrText (

609: aname => 'OPEN_FORM_COMMAND');
610:
611: -- HTML Orders R12
612: -- Get the PO HTML Page URL's
613: l_view_po_url := PO_WF_UTIL_PKG.GetItemAttrText (
614: itemtype => l_item_type,
615: itemkey => l_item_key,
616: aname => 'VIEW_DOC_URL');
617:

Line 618: l_edit_po_url := PO_WF_UTIL_PKG.GetItemAttrText (

614: itemtype => l_item_type,
615: itemkey => l_item_key,
616: aname => 'VIEW_DOC_URL');
617:
618: l_edit_po_url := PO_WF_UTIL_PKG.GetItemAttrText (
619: itemtype => l_item_type,
620: itemkey => l_item_key,
621: aname => 'EDIT_DOC_URL');
622:

Line 1335: l_draft_id := po_wf_util_pkg.GetItemAttrNumber

1331: (itemtype => l_item_type,
1332: itemkey => l_item_key,
1333: aname => 'DOCUMENT_ID');
1334:
1335: l_draft_id := po_wf_util_pkg.GetItemAttrNumber
1336: (itemtype => l_item_type,
1337: itemkey => l_item_key,
1338: aname => 'DRAFT_ID');
1339:

Line 1369: l_open_form_command := PO_WF_UTIL_PKG.GetItemAttrText

1365:
1366: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
1367:
1368: -- Bug 3668188
1369: l_open_form_command := PO_WF_UTIL_PKG.GetItemAttrText
1370: (itemtype => l_item_type,
1371: itemkey => l_item_key,
1372: aname => 'OPEN_FORM_COMMAND');
1373:

Line 1376: l_view_po_url := PO_WF_UTIL_PKG.GetItemAttrText (

1372: aname => 'OPEN_FORM_COMMAND');
1373:
1374: -- HTML Orders R12
1375: -- Get the PO HTML Page URL's
1376: l_view_po_url := PO_WF_UTIL_PKG.GetItemAttrText (
1377: itemtype => l_item_type,
1378: itemkey => l_item_key,
1379: aname => 'VIEW_DOC_URL');
1380:

Line 1381: l_edit_po_url := PO_WF_UTIL_PKG.GetItemAttrText (

1377: itemtype => l_item_type,
1378: itemkey => l_item_key,
1379: aname => 'VIEW_DOC_URL');
1380:
1381: l_edit_po_url := PO_WF_UTIL_PKG.GetItemAttrText (
1382: itemtype => l_item_type,
1383: itemkey => l_item_key,
1384: aname => 'EDIT_DOC_URL');
1385:

Line 1394: max_actions_dsp:= PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_item_type,

1390: ** If the attribute does not exist or is null, then we would use default
1391: ** value of 20.
1392: */
1393:
1394: max_actions_dsp:= PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => l_item_type,
1395: itemkey => l_item_key,
1396: aname => 'ACT_HST_IN_NTF');
1397:
1398: if max_actions_dsp is NULL then

Line 1546: l_user_name := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_item_type,

1542: -- notifcation should not error out. Instead modified the code such that
1543: -- the action history column for change request will show the corresponding
1544: -- supplier name rather than supplier user name.
1545: IF l_user_name IS NULL THEN
1546: l_user_name := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_item_type,
1547: itemkey => l_item_key,
1548: aname => 'SUPPLIER');
1549:
1550: l_document := l_document || '' || l_user_name || '' || NL;

Line 1640: l_user_name := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_item_type,

1636: -- notifcation should not error out. Instead modified the code such that
1637: -- the action history column for change request will show the corresponding
1638: -- supplier name rather than supplier user name.
1639: IF l_user_name IS NULL THEN
1640: l_user_name := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => l_item_type,
1641: itemkey => l_item_key,
1642: aname => 'SUPPLIER');
1643:
1644: l_document := l_document || fnd_message.get_string('PO', 'PO_WF_NOTIF_EMPLOYEE') || l_user_name || NL;

Line 1746: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,

1742: IF (g_po_wf_debug = 'Y') THEN
1743: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'l_action : '||l_action);
1744: END IF;
1745:
1746: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
1747: itemkey => itemkey,
1748: aname => 'DOCUMENT_ID');
1749: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
1750: itemkey => itemkey,

Line 1749: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

1745:
1746: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
1747: itemkey => itemkey,
1748: aname => 'DOCUMENT_ID');
1749: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
1750: itemkey => itemkey,
1751: aname => 'DOCUMENT_TYPE');
1752: l_doc_sub_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
1753: itemkey => itemkey,

Line 1752: l_doc_sub_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

1748: aname => 'DOCUMENT_ID');
1749: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
1750: itemkey => itemkey,
1751: aname => 'DOCUMENT_TYPE');
1752: l_doc_sub_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
1753: itemkey => itemkey,
1754: aname => 'DOCUMENT_SUBTYPE');
1755:
1756: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,

Line 1756: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,

1752: l_doc_sub_type := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
1753: itemkey => itemkey,
1754: aname => 'DOCUMENT_SUBTYPE');
1755:
1756: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
1757: itemkey => itemkey,
1758: aname => 'DRAFT_ID');
1759: -- PAR Approval
1760: l_draft_type := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,

Line 1760: l_draft_type := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,

1756: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber( itemtype => itemtype,
1757: itemkey => itemkey,
1758: aname => 'DRAFT_ID');
1759: -- PAR Approval
1760: l_draft_type := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,
1761: itemkey => itemkey,
1762: aname => 'DRAFT_TYPE');
1763:
1764: IF (g_po_wf_debug = 'Y') THEN

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

2144: aname => 'DOCUMENT_TYPE');
2145:
2146: IF (l_doc_type='PO' OR l_doc_type='PA' OR l_doc_type='RELEASE' ) THEN
2147: l_note := wf_notification.GetAttrText(l_nid, 'NOTE_R');
2148: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
2149: itemkey => itemkey,
2150: aname => 'NOTE',
2151: avalue => l_note);
2152: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,

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

2148: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
2149: itemkey => itemkey,
2150: aname => 'NOTE',
2151: avalue => l_note);
2152: PO_WF_UTIL_PKG.SetItemAttrText(itemtype=>itemtype,
2153: itemkey => itemkey,
2154: aname => 'NOTE_R',
2155: avalue => NULL);
2156: wf_notification.SetAttrText(l_nid, 'NOTE', l_note);

Line 2174: l_draft_type := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,

2170: l_draft_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
2171: itemkey => itemkey,
2172: aname => 'DRAFT_ID');
2173: -- PAR Approval
2174: l_draft_type := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,
2175: itemkey => itemkey,
2176: aname => 'DRAFT_TYPE');
2177:
2178: l_progress := '007 start to update action history';

Line 2258: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,

2254: -- bug 4901406 : need to shift the setting of the preparer resp and appl id
2255: -- to here, it was not initialized inside the if condition if the control went to the
2256: -- else part.
2257: l_preparer_resp_id :=
2258: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,
2259: itemkey => itemkey,
2260: aname => 'RESPONSIBILITY_ID');
2261: l_preparer_appl_id :=
2262: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,

Line 2262: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,

2258: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,
2259: itemkey => itemkey,
2260: aname => 'RESPONSIBILITY_ID');
2261: l_preparer_appl_id :=
2262: PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype=>itemtype,
2263: itemkey => itemkey,
2264: aname => 'APPLICATION_ID');
2265:
2266: --

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

2282: */
2283:
2284:
2285:
2286: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2287: itemkey => itemkey,
2288: aname => 'RESPONDER_USER_ID',
2289: avalue => l_responder_id);
2290: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2286: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2287: itemkey => itemkey,
2288: aname => 'RESPONDER_USER_ID',
2289: avalue => l_responder_id);
2290: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2291: itemkey => itemkey,
2292: aname => 'RESPONDER_RESP_ID',
2293: avalue => l_preparer_resp_id);
2294: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2290: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2291: itemkey => itemkey,
2292: aname => 'RESPONDER_RESP_ID',
2293: avalue => l_preparer_resp_id);
2294: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2295: itemkey => itemkey,
2296: aname => 'RESPONDER_APPL_ID',
2297: avalue => l_preparer_appl_id);
2298: else

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

2298: else
2299: if (l_session_resp_id is null) THEN
2300: /* possible when the response is made from the default worklist
2301: without choosing a valid responsibility */
2302: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2303: itemkey => itemkey,
2304: aname => 'RESPONDER_USER_ID',
2305: avalue => l_responder_id);
2306: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2302: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2303: itemkey => itemkey,
2304: aname => 'RESPONDER_USER_ID',
2305: avalue => l_responder_id);
2306: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2307: itemkey => itemkey,
2308: aname => 'RESPONDER_RESP_ID',
2309: avalue => l_preparer_resp_id);
2310: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2306: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2307: itemkey => itemkey,
2308: aname => 'RESPONDER_RESP_ID',
2309: avalue => l_preparer_resp_id);
2310: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2311: itemkey => itemkey,
2312: aname => 'RESPONDER_APPL_ID',
2313: avalue => l_preparer_appl_id);
2314: else

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

2322: This may happen due to the fact that the mailer / background process
2323: carries the context set by the notification/wf it processed last*/
2324:
2325: if ( l_preserved_ctx = 'TRUE') then
2326: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2327: itemkey => itemkey,
2328: aname => 'RESPONDER_USER_ID',
2329: avalue => l_responder_id);
2330: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2326: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2327: itemkey => itemkey,
2328: aname => 'RESPONDER_USER_ID',
2329: avalue => l_responder_id);
2330: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2331: itemkey => itemkey,
2332: aname => 'RESPONDER_RESP_ID',
2333: avalue => l_session_resp_id);
2334: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2330: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2331: itemkey => itemkey,
2332: aname => 'RESPONDER_RESP_ID',
2333: avalue => l_session_resp_id);
2334: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2335: itemkey => itemkey,
2336: aname => 'RESPONDER_APPL_ID',
2337: avalue => l_session_appl_id);
2338: else

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

2335: itemkey => itemkey,
2336: aname => 'RESPONDER_APPL_ID',
2337: avalue => l_session_appl_id);
2338: else
2339: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2340: itemkey => itemkey,
2341: aname => 'RESPONDER_USER_ID',
2342: avalue => l_responder_id);
2343: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2339: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2340: itemkey => itemkey,
2341: aname => 'RESPONDER_USER_ID',
2342: avalue => l_responder_id);
2343: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2344: itemkey => itemkey,
2345: aname => 'RESPONDER_RESP_ID',
2346: avalue => l_preparer_resp_id);
2347: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,

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

2343: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2344: itemkey => itemkey,
2345: aname => 'RESPONDER_RESP_ID',
2346: avalue => l_preparer_resp_id);
2347: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype=>itemtype,
2348: itemkey => itemkey,
2349: aname => 'RESPONDER_APPL_ID',
2350: avalue => l_preparer_appl_id);
2351: end if;

Line 2472: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,

2468: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2469:
2470: -- HTML Orders R12
2471: -- Set the URL and form attributes
2472: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
2473: itemkey => itemkey,
2474: aname => 'OPEN_FORM_COMMAND' ,
2475: avalue => '');
2476:

Line 2478: /*PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,

2474: aname => 'OPEN_FORM_COMMAND' ,
2475: avalue => '');
2476:
2477: -- PO AME Project : VIEW_DOC_URL must always be seen even though po is in PRE-APPROVED state.
2478: /*PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
2479: itemkey => itemkey,
2480: aname => 'VIEW_DOC_URL' ,
2481: avalue => '');*/
2482:

Line 2483: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,

2479: itemkey => itemkey,
2480: aname => 'VIEW_DOC_URL' ,
2481: avalue => '');*/
2482:
2483: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemType,
2484: itemkey => itemkey,
2485: aname => 'EDIT_DOC_URL' ,
2486: avalue => '');
2487: END IF;

Line 2492: l_conterms_exist_flag := PO_WF_UTIL_PKG.GetItemAttrText(

2488:
2489:
2490: --
2491:
2492: l_conterms_exist_flag := PO_WF_UTIL_PKG.GetItemAttrText(
2493: itemtype => itemtype,
2494: itemkey => itemkey,
2495: aname => 'CONTERMS_EXIST_FLAG');
2496:

Line 2497: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText(

2493: itemtype => itemtype,
2494: itemkey => itemkey,
2495: aname => 'CONTERMS_EXIST_FLAG');
2496:
2497: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText(
2498: itemtype => itemtype,
2499: itemkey => itemkey,
2500: aname => 'DOCUMENT_SUBTYPE');
2501:

Line 2502: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

2498: itemtype => itemtype,
2499: itemkey => itemkey,
2500: aname => 'DOCUMENT_SUBTYPE');
2501:
2502: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
2503: itemtype => itemtype,
2504: itemkey => itemkey,
2505: aname => 'DOCUMENT_ID');
2506:

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

2524: (PO_COMMUNICATION_PVT.PO_COMMUNICATION_PROFILE = 'T')
2525: )
2526: THEN
2527:
2528: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
2529: itemkey => itemkey,
2530: aname => 'OKC_DOC_ATTACHMENT',
2531: avalue =>
2532: 'PLSQLBLOB:PO_COMMUNICATION_PVT.OKC_DOC_ATTACH/'||

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

2537: /* Contract terms are structured, or attached document is mergeable.
2538: * All contract terms will be in pdf; no need for other okc doc attachment.
2539: */
2540:
2541: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
2542: itemkey => itemkey,
2543: aname => 'OKC_DOC_ATTACHMENT',
2544: avalue => '');
2545:

Line 2622: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

2618: || username;
2619: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2620:
2621: if ((doctype is NULL) or (docsubtype is null)) then
2622: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
2623: itemkey => itemkey,
2624: aname => 'DOCUMENT_TYPE');
2625:
2626: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 2626: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

2622: l_doc_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
2623: itemkey => itemkey,
2624: aname => 'DOCUMENT_TYPE');
2625:
2626: l_doc_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
2627: itemkey => itemkey,
2628: aname => 'DOCUMENT_SUBTYPE');
2629: else
2630: l_doc_type := doctype;

Line 2636: l_ga_flag := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,

2632: end if;
2633:
2634: IF l_doc_type = 'PA' AND l_doc_subtype = 'BLANKET' THEN
2635:
2636: l_ga_flag := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,
2637: itemkey => itemkey,
2638: aname => 'GLOBAL_AGREEMENT_FLAG');
2639: END IF;
2640:

Line 2646: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber

2642: notification attribute 'REQUIRES_APPROVAL_MSG' and 'PO_GA_TYPE'.
2643: Deleted the previous code and revamped it.
2644: */
2645: --
2646: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber
2647: (itemtype => itemtype,
2648: itemkey => itemkey,
2649: aname => 'DOCUMENT_ID');
2650:

Line 2652: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber

2648: itemkey => itemkey,
2649: aname => 'DOCUMENT_ID');
2650:
2651: -- CLM Apprvl
2652: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber
2653: (itemtype => itemtype,
2654: itemkey => itemkey,
2655: aname => 'DRAFT_ID');
2656:

Line 2658: l_draft_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

2654: itemkey => itemkey,
2655: aname => 'DRAFT_ID');
2656:
2657: -- PAR Approval
2658: l_draft_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
2659: itemkey => itemkey,
2660: aname => 'DRAFT_TYPE');
2661:
2662: IF username is NULL THEN

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

2730: l_progress := 'PO_WF_PO_NOTIFICATION.GetDisplayValue: 100, type disp: '
2731: || l_doc_disp;
2732: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2733:
2734: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
2735: itemkey => itemkey,
2736: aname => 'DOCUMENT_TYPE_DISP',
2737: avalue => l_doc_disp);
2738: BEGIN

Line 2748: l_msg_text := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

2744: and fl.nls_language = l_language
2745: and fm.application_id = 201; -- Include application_id to better use PK index
2746: EXCEPTION
2747: WHEN OTHERS THEN
2748: l_msg_text := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
2749: itemkey => itemkey,
2750: aname => 'REQUIRES_APPROVAL_MSG');
2751: END;
2752:

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

2749: itemkey => itemkey,
2750: aname => 'REQUIRES_APPROVAL_MSG');
2751: END;
2752:
2753: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
2754: itemkey => itemkey,
2755: aname => 'REQUIRES_APPROVAL_MSG',
2756: avalue => l_msg_text );
2757:

Line 2770: l_msg_text := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

2766: and fl.nls_language = l_language
2767: and fm.application_id = 201;
2768: EXCEPTION
2769: WHEN OTHERS THEN
2770: l_msg_text := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
2771: itemkey => itemkey,
2772: aname => 'REQUIRES_REVIEW_MSG');
2773: END;
2774:

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

2771: itemkey => itemkey,
2772: aname => 'REQUIRES_REVIEW_MSG');
2773: END;
2774:
2775: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
2776: itemkey => itemkey,
2777: aname => 'REQUIRES_REVIEW_MSG',
2778: avalue => l_msg_text );
2779:

Line 2790: l_msg_text := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

2786: and fl.nls_language = l_language
2787: and fm.application_id = 201;
2788: EXCEPTION
2789: WHEN OTHERS THEN
2790: l_msg_text := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
2791: itemkey => itemkey,
2792: aname => 'REQUIRES_ESIGN_MSG');
2793: END;
2794:

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

2791: itemkey => itemkey,
2792: aname => 'REQUIRES_ESIGN_MSG');
2793: END;
2794:
2795: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
2796: itemkey => itemkey,
2797: aname => 'REQUIRES_ESIGN_MSG',
2798: avalue => l_msg_text );
2799: