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.AHL_MEL_CDL_APPROVALS_PVT dependencies on WF_ENGINE

Line 116: l_object_id := wf_engine.getitemattrnumber

112: 'At the start of PLSQL procedure'
113: );
114: END IF;
115:
116: l_object_id := wf_engine.getitemattrnumber
117: (
118: itemtype => itemtype,
119: itemkey => itemkey,
120: aname => 'OBJECT_ID'

Line 123: l_object_ovn := wf_engine.getitemattrnumber

119: itemkey => itemkey,
120: aname => 'OBJECT_ID'
121: );
122:
123: l_object_ovn := wf_engine.getitemattrnumber
124: (
125: itemtype => itemtype,
126: itemkey => itemkey,
127: aname => 'OBJECT_VER'

Line 183: wf_engine.setitemattrtext

179: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
180: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
181: l_subject := fnd_message.get;
182:
183: wf_engine.setitemattrtext
184: (
185: itemtype => itemtype,
186: itemkey => itemkey,
187: aname => 'FORWARD_SUBJECT',

Line 209: wf_engine.setitemattrtext

205: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
206: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
207: l_subject := fnd_message.get;
208:
209: wf_engine.setitemattrtext
210: (
211: itemtype => itemtype,
212: itemkey => itemkey,
213: aname => 'APPROVAL_SUBJECT',

Line 235: wf_engine.setitemattrtext

231: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
232: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
233: l_subject := fnd_message.get;
234:
235: wf_engine.setitemattrtext
236: (
237: itemtype => itemtype,
238: itemkey => itemkey,
239: aname => 'REJECT_SUBJECT',

Line 261: wf_engine.setitemattrtext

257: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
258: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
259: l_subject := fnd_message.get;
260:
261: wf_engine.setitemattrtext
262: (
263: itemtype => itemtype,
264: itemkey => itemkey,
265: aname => 'APPROVED_SUBJECT',

Line 287: wf_engine.setitemattrtext

283: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
284: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
285: l_subject := fnd_message.get;
286:
287: wf_engine.setitemattrtext
288: (
289: itemtype => itemtype,
290: itemkey => itemkey,
291: aname => 'FINAL_SUBJECT',

Line 313: wf_engine.setitemattrtext

309: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
310: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
311: l_subject := fnd_message.get;
312:
313: wf_engine.setitemattrtext
314: (
315: itemtype => itemtype,
316: itemkey => itemkey,
317: aname => 'REMIND_SUBJECT',

Line 339: wf_engine.setitemattrtext

335: fnd_message.set_token('REV',l_mel_cdl_rec.revision, false);
336: fnd_message.set_token('TYPE',l_mel_cdl_rec.mel_cdl_type_code, false);
337: l_subject := fnd_message.get;
338:
339: wf_engine.setitemattrtext
340: (
341: itemtype => itemtype,
342: itemkey => itemkey,
343: aname => 'ERROR_SUBJECT',

Line 370: wf_engine.setitemattrnumber

366: );
367:
368: IF l_return_status = FND_API.G_RET_STS_SUCCESS
369: THEN
370: wf_engine.setitemattrnumber
371: (
372: itemtype => itemtype,
373: itemkey => itemkey,
374: aname => 'RULE_ID',

Line 388: wf_engine.setitemattrnumber

384: 'RULE_ID='||l_approval_rule_id
385: );
386: END IF;
387:
388: wf_engine.setitemattrnumber
389: (
390: itemtype => itemtype,
391: itemkey => itemkey,
392: aname => 'APPROVER_SEQ',

Line 541: l_object_type := wf_engine.getitemattrtext

537: l_hyphen_pos1 := INSTR (document_id, ':');
538: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
539: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
540:
541: l_object_type := wf_engine.getitemattrtext
542: (
543: itemtype => l_item_type,
544: itemkey => l_item_key,
545: aname => 'OBJECT_TYPE'

Line 548: l_object_id := wf_engine.getitemattrNumber

544: itemkey => l_item_key,
545: aname => 'OBJECT_TYPE'
546: );
547:
548: l_object_id := wf_engine.getitemattrNumber
549: (
550: itemtype => l_item_type,
551: itemkey => l_item_key,
552: aname => 'OBJECT_ID'

Line 555: l_approver := wf_engine.getitemattrtext

551: itemkey => l_item_key,
552: aname => 'OBJECT_ID'
553: );
554:
555: l_approver := wf_engine.getitemattrtext
556: (
557: itemtype => l_item_type,
558: itemkey => l_item_key,
559: aname => 'APPROVER'

Line 714: l_object_type := wf_engine.getitemattrtext

710: l_hyphen_pos1 := INSTR (document_id, ':');
711: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
712: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
713:
714: l_object_type := wf_engine.getitemattrtext
715: (
716: itemtype => l_item_type,
717: itemkey => l_item_key,
718: aname => 'OBJECT_TYPE'

Line 721: l_object_id := wf_engine.getitemattrNumber

717: itemkey => l_item_key,
718: aname => 'OBJECT_TYPE'
719: );
720:
721: l_object_id := wf_engine.getitemattrNumber
722: (
723: itemtype => l_item_type,
724: itemkey => l_item_key,
725: aname => 'OBJECT_ID'

Line 728: l_approver := wf_engine.getitemattrtext

724: itemkey => l_item_key,
725: aname => 'OBJECT_ID'
726: );
727:
728: l_approver := wf_engine.getitemattrtext
729: (
730: itemtype => l_item_type,
731: itemkey => l_item_key,
732: aname => 'APPROVER'

Line 886: l_object_type := wf_engine.getitemattrtext

882: l_hyphen_pos1 := INSTR (document_id, ':');
883: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
884: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
885:
886: l_object_type := wf_engine.getitemattrtext
887: (
888: itemtype => l_item_type,
889: itemkey => l_item_key,
890: aname => 'OBJECT_TYPE'

Line 893: l_object_id := wf_engine.getitemattrNumber

889: itemkey => l_item_key,
890: aname => 'OBJECT_TYPE'
891: );
892:
893: l_object_id := wf_engine.getitemattrNumber
894: (
895: itemtype => l_item_type,
896: itemkey => l_item_key,
897: aname => 'OBJECT_ID'

Line 1051: l_object_type := wf_engine.getitemattrtext

1047: l_hyphen_pos1 := INSTR (document_id, ':');
1048: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1049: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1050:
1051: l_object_type := wf_engine.getitemattrtext
1052: (
1053: itemtype => l_item_type,
1054: itemkey => l_item_key,
1055: aname => 'OBJECT_TYPE'

Line 1058: l_object_id := wf_engine.getitemattrNumber

1054: itemkey => l_item_key,
1055: aname => 'OBJECT_TYPE'
1056: );
1057:
1058: l_object_id := wf_engine.getitemattrNumber
1059: (
1060: itemtype => l_item_type,
1061: itemkey => l_item_key,
1062: aname => 'OBJECT_ID'

Line 1065: l_approver := wf_engine.getitemattrtext

1061: itemkey => l_item_key,
1062: aname => 'OBJECT_ID'
1063: );
1064:
1065: l_approver := wf_engine.getitemattrtext
1066: (
1067: itemtype => l_item_type,
1068: itemkey => l_item_key,
1069: aname => 'APPROVER'

Line 1225: l_object_type := wf_engine.getitemattrtext

1221: l_hyphen_pos1 := INSTR (document_id, ':');
1222: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1223: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1224:
1225: l_object_type := wf_engine.getitemattrtext
1226: (
1227: itemtype => l_item_type,
1228: itemkey => l_item_key,
1229: aname => 'OBJECT_TYPE'

Line 1232: l_object_id := wf_engine.getitemattrNumber

1228: itemkey => l_item_key,
1229: aname => 'OBJECT_TYPE'
1230: );
1231:
1232: l_object_id := wf_engine.getitemattrNumber
1233: (
1234: itemtype => l_item_type,
1235: itemkey => l_item_key,
1236: aname => 'OBJECT_ID'

Line 1239: l_requester := wf_engine.getitemattrtext

1235: itemkey => l_item_key,
1236: aname => 'OBJECT_ID'
1237: );
1238:
1239: l_requester := wf_engine.getitemattrtext
1240: (
1241: itemtype => l_item_type,
1242: itemkey => l_item_key,
1243: aname => 'REQUESTER'

Line 1246: l_requester_note := wf_engine.getitemattrtext

1242: itemkey => l_item_key,
1243: aname => 'REQUESTER'
1244: );
1245:
1246: l_requester_note := wf_engine.getitemattrtext
1247: (
1248: itemtype => l_item_type,
1249: itemkey => l_item_key,
1250: aname => 'REQUESTER_NOTE'

Line 1407: l_object_type := wf_engine.getitemattrtext

1403: l_hyphen_pos1 := INSTR (document_id, ':');
1404: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1405: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1406:
1407: l_object_type := wf_engine.getitemattrtext
1408: (
1409: itemtype => l_item_type,
1410: itemkey => l_item_key,
1411: aname => 'OBJECT_TYPE'

Line 1414: l_object_id := wf_engine.getitemattrNumber

1410: itemkey => l_item_key,
1411: aname => 'OBJECT_TYPE'
1412: );
1413:
1414: l_object_id := wf_engine.getitemattrNumber
1415: (
1416: itemtype => l_item_type,
1417: itemkey => l_item_key,
1418: aname => 'OBJECT_ID'

Line 1421: l_requester := wf_engine.getitemattrtext

1417: itemkey => l_item_key,
1418: aname => 'OBJECT_ID'
1419: );
1420:
1421: l_requester := wf_engine.getitemattrtext
1422: (
1423: itemtype => l_item_type,
1424: itemkey => l_item_key,
1425: aname => 'REQUESTER'

Line 1428: l_requester_note := wf_engine.getitemattrtext

1424: itemkey => l_item_key,
1425: aname => 'REQUESTER'
1426: );
1427:
1428: l_requester_note := wf_engine.getitemattrtext
1429: (
1430: itemtype => l_item_type,
1431: itemkey => l_item_key,
1432: aname => 'REQUESTER_NOTE'

Line 1587: l_object_type := wf_engine.getitemattrtext

1583: l_hyphen_pos1 := INSTR (document_id, ':');
1584: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1585: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1586:
1587: l_object_type := wf_engine.getitemattrtext
1588: (
1589: itemtype => l_item_type,
1590: itemkey => l_item_key,
1591: aname => 'OBJECT_TYPE'

Line 1594: l_object_id := wf_engine.getitemattrNumber

1590: itemkey => l_item_key,
1591: aname => 'OBJECT_TYPE'
1592: );
1593:
1594: l_object_id := wf_engine.getitemattrNumber
1595: (
1596: itemtype => l_item_type,
1597: itemkey => l_item_key,
1598: aname => 'OBJECT_ID'

Line 1601: l_error_msg := wf_engine.getitemattrText

1597: itemkey => l_item_key,
1598: aname => 'OBJECT_ID'
1599: );
1600:
1601: l_error_msg := wf_engine.getitemattrText
1602: (
1603: itemtype => l_item_type,
1604: itemkey => l_item_key,
1605: aname => 'ERROR_MSG'

Line 1774: l_object_id := wf_engine.getitemattrnumber

1770: --
1771: IF (funcmode = 'RUN')
1772: THEN
1773:
1774: l_object_id := wf_engine.getitemattrnumber
1775: (
1776: itemtype => itemtype,
1777: itemkey => itemkey,
1778: aname => 'OBJECT_ID'

Line 1781: l_object_ovn := wf_engine.getitemattrnumber

1777: itemkey => itemkey,
1778: aname => 'OBJECT_ID'
1779: );
1780:
1781: l_object_ovn := wf_engine.getitemattrnumber
1782: (
1783: itemtype => itemtype,
1784: itemkey => itemkey,
1785: aname => 'OBJECT_VER'

Line 1816: -- Changed wf_engine.GetItemAttrNumber to wf_engine.GetItemAttrText

1812: CLOSE get_mel_cdl_details;
1813:
1814: -- Priyan :
1815: -- Fix for Bug #5484980
1816: -- Changed wf_engine.GetItemAttrNumber to wf_engine.GetItemAttrText
1817:
1818: l_next_status := wf_engine.GetItemAttrText
1819: (
1820: itemtype => itemtype,

Line 1818: l_next_status := wf_engine.GetItemAttrText

1814: -- Priyan :
1815: -- Fix for Bug #5484980
1816: -- Changed wf_engine.GetItemAttrNumber to wf_engine.GetItemAttrText
1817:
1818: l_next_status := wf_engine.GetItemAttrText
1819: (
1820: itemtype => itemtype,
1821: itemkey => itemkey,
1822: aname => 'UPDATE_GEN_STATUS'

Line 1984: l_object_id := wf_engine.getitemattrnumber

1980: --
1981: IF (funcmode = 'RUN')
1982: THEN
1983:
1984: l_object_id := wf_engine.getitemattrnumber
1985: (
1986: itemtype => itemtype,
1987: itemkey => itemkey,
1988: aname => 'OBJECT_ID'

Line 1991: l_object_ovn := wf_engine.getitemattrnumber

1987: itemkey => itemkey,
1988: aname => 'OBJECT_ID'
1989: );
1990:
1991: l_object_ovn := wf_engine.getitemattrnumber
1992: (
1993: itemtype => itemtype,
1994: itemkey => itemkey,
1995: aname => 'OBJECT_VER'

Line 2024: l_next_status := wf_engine.getitemattrnumber

2020:
2021: END IF;
2022: CLOSE get_mel_cdl_details;
2023:
2024: l_next_status := wf_engine.getitemattrnumber
2025: (
2026: itemtype => itemtype,
2027: itemkey => itemkey,
2028: aname => 'ORG_STATUS_ID'

Line 2220: l_object_id := wf_engine.getitemattrnumber

2216: 'At the start of PLSQL procedure'
2217: );
2218: END IF;
2219:
2220: l_object_id := wf_engine.getitemattrnumber
2221: (
2222: itemtype => itemtype,
2223: itemkey => itemkey,
2224: aname => 'OBJECT_ID'

Line 2227: l_object_ovn := wf_engine.getitemattrnumber

2223: itemkey => itemkey,
2224: aname => 'OBJECT_ID'
2225: );
2226:
2227: l_object_ovn := wf_engine.getitemattrnumber
2228: (
2229: itemtype => itemtype,
2230: itemkey => itemkey,
2231: aname => 'OBJECT_VER'

Line 2323: wf_engine.setitemattrtext(

2319: );
2320: END IF;
2321:
2322: /* REQUESTER_NOTE */
2323: wf_engine.setitemattrtext(
2324: itemtype => itemtype
2325: ,itemkey => itemkey
2326: ,aname => 'REQUESTER_NOTE'
2327: ,avalue => l_requester_note

Line 2334: wf_engine.setitemattrtext

2330: /* FORWARD_SUBJECT */
2331: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FORWARD_SUBJ');
2332: l_subject := fnd_message.get || l_temp_subject;
2333:
2334: wf_engine.setitemattrtext
2335: (
2336: itemtype => itemtype,
2337: itemkey => itemkey,
2338: aname => 'FORWARD_SUBJECT',

Line 2356: wf_engine.setitemattrtext

2352: /* APPROVAL_SUBJECT */
2353: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_APPROVAL_SUBJ');
2354: l_subject := fnd_message.get || l_temp_subject;
2355:
2356: wf_engine.setitemattrtext
2357: (
2358: itemtype => itemtype,
2359: itemkey => itemkey,
2360: aname => 'APPROVAL_SUBJECT',

Line 2378: wf_engine.setitemattrtext

2374: /* REJECT_SUBJECT */
2375: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_REJECT_SUBJ');
2376: l_subject := fnd_message.get || l_temp_subject;
2377:
2378: wf_engine.setitemattrtext
2379: (
2380: itemtype => itemtype,
2381: itemkey => itemkey,
2382: aname => 'REJECT_SUBJECT',

Line 2400: wf_engine.setitemattrtext

2396: /* APPROVED_SUBJECT */
2397: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_APPROVED_SUBJ');
2398: l_subject := fnd_message.get || l_temp_subject;
2399:
2400: wf_engine.setitemattrtext
2401: (
2402: itemtype => itemtype,
2403: itemkey => itemkey,
2404: aname => 'APPROVED_SUBJECT',

Line 2422: wf_engine.setitemattrtext

2418: /* FINAL_SUBJECT */
2419: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_FINAL_SUBJ');
2420: l_subject := fnd_message.get || l_temp_subject;
2421:
2422: wf_engine.setitemattrtext
2423: (
2424: itemtype => itemtype,
2425: itemkey => itemkey,
2426: aname => 'FINAL_SUBJECT',

Line 2444: wf_engine.setitemattrtext

2440: /* REMIND_SUBJECT */
2441: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_REMIND_SUBJ');
2442: l_subject := fnd_message.get || l_temp_subject;
2443:
2444: wf_engine.setitemattrtext
2445: (
2446: itemtype => itemtype,
2447: itemkey => itemkey,
2448: aname => 'REMIND_SUBJECT',

Line 2466: wf_engine.setitemattrtext

2462: /* ERROR_SUBJECT */
2463: fnd_message.set_name('AHL', 'AHL_UMP_NR_NTF_ERROR_SUBJ');
2464: l_subject := fnd_message.get || l_temp_subject;
2465:
2466: wf_engine.setitemattrtext
2467: (
2468: itemtype => itemtype,
2469: itemkey => itemkey,
2470: aname => 'ERROR_SUBJECT',

Line 2497: wf_engine.setitemattrnumber

2493: );
2494:
2495: IF l_return_status = FND_API.G_RET_STS_SUCCESS
2496: THEN
2497: wf_engine.setitemattrnumber
2498: (
2499: itemtype => itemtype,
2500: itemkey => itemkey,
2501: aname => 'RULE_ID',

Line 2515: wf_engine.setitemattrnumber

2511: 'RULE_ID='||l_approval_rule_id
2512: );
2513: END IF;
2514:
2515: wf_engine.setitemattrnumber
2516: (
2517: itemtype => itemtype,
2518: itemkey => itemkey,
2519: aname => 'APPROVER_SEQ',

Line 2684: l_object_type := wf_engine.getitemattrtext

2680: l_hyphen_pos1 := INSTR (document_id, ':');
2681: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
2682: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
2683:
2684: l_object_type := wf_engine.getitemattrtext
2685: (
2686: itemtype => l_item_type,
2687: itemkey => l_item_key,
2688: aname => 'OBJECT_TYPE'

Line 2691: l_object_id := wf_engine.getitemattrNumber

2687: itemkey => l_item_key,
2688: aname => 'OBJECT_TYPE'
2689: );
2690:
2691: l_object_id := wf_engine.getitemattrNumber
2692: (
2693: itemtype => l_item_type,
2694: itemkey => l_item_key,
2695: aname => 'OBJECT_ID'

Line 2698: l_approver := wf_engine.getitemattrtext

2694: itemkey => l_item_key,
2695: aname => 'OBJECT_ID'
2696: );
2697:
2698: l_approver := wf_engine.getitemattrtext
2699: (
2700: itemtype => l_item_type,
2701: itemkey => l_item_key,
2702: aname => 'APPROVER'

Line 2705: l_requester_note := wf_engine.getitemattrtext

2701: itemkey => l_item_key,
2702: aname => 'APPROVER'
2703: );
2704:
2705: l_requester_note := wf_engine.getitemattrtext
2706: (
2707: itemtype => l_item_type
2708: ,itemkey => l_item_key
2709: ,aname => 'REQUESTER_NOTE'

Line 2851: l_object_type := wf_engine.getitemattrtext

2847: l_hyphen_pos1 := INSTR (document_id, ':');
2848: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
2849: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
2850:
2851: l_object_type := wf_engine.getitemattrtext
2852: (
2853: itemtype => l_item_type,
2854: itemkey => l_item_key,
2855: aname => 'OBJECT_TYPE'

Line 2858: l_object_id := wf_engine.getitemattrNumber

2854: itemkey => l_item_key,
2855: aname => 'OBJECT_TYPE'
2856: );
2857:
2858: l_object_id := wf_engine.getitemattrNumber
2859: (
2860: itemtype => l_item_type,
2861: itemkey => l_item_key,
2862: aname => 'OBJECT_ID'

Line 2865: l_approver := wf_engine.getitemattrtext

2861: itemkey => l_item_key,
2862: aname => 'OBJECT_ID'
2863: );
2864:
2865: l_approver := wf_engine.getitemattrtext
2866: (
2867: itemtype => l_item_type,
2868: itemkey => l_item_key,
2869: aname => 'APPROVER'

Line 2872: l_requester_note := wf_engine.getitemattrtext

2868: itemkey => l_item_key,
2869: aname => 'APPROVER'
2870: );
2871:
2872: l_requester_note := wf_engine.getitemattrtext
2873: (
2874: itemtype => l_item_type
2875: ,itemkey => l_item_key
2876: ,aname => 'REQUESTER_NOTE'

Line 3011: l_object_type := wf_engine.getitemattrtext

3007: l_hyphen_pos1 := INSTR (document_id, ':');
3008: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
3009: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
3010:
3011: l_object_type := wf_engine.getitemattrtext
3012: (
3013: itemtype => l_item_type,
3014: itemkey => l_item_key,
3015: aname => 'OBJECT_TYPE'

Line 3018: l_object_id := wf_engine.getitemattrNumber

3014: itemkey => l_item_key,
3015: aname => 'OBJECT_TYPE'
3016: );
3017:
3018: l_object_id := wf_engine.getitemattrNumber
3019: (
3020: itemtype => l_item_type,
3021: itemkey => l_item_key,
3022: aname => 'OBJECT_ID'

Line 3025: l_requester_note := wf_engine.getitemattrtext

3021: itemkey => l_item_key,
3022: aname => 'OBJECT_ID'
3023: );
3024:
3025: l_requester_note := wf_engine.getitemattrtext
3026: (
3027: itemtype => l_item_type
3028: ,itemkey => l_item_key
3029: ,aname => 'REQUESTER_NOTE'

Line 3167: l_object_type := wf_engine.getitemattrtext

3163: l_hyphen_pos1 := INSTR (document_id, ':');
3164: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
3165: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
3166:
3167: l_object_type := wf_engine.getitemattrtext
3168: (
3169: itemtype => l_item_type,
3170: itemkey => l_item_key,
3171: aname => 'OBJECT_TYPE'

Line 3174: l_object_id := wf_engine.getitemattrNumber

3170: itemkey => l_item_key,
3171: aname => 'OBJECT_TYPE'
3172: );
3173:
3174: l_object_id := wf_engine.getitemattrNumber
3175: (
3176: itemtype => l_item_type,
3177: itemkey => l_item_key,
3178: aname => 'OBJECT_ID'

Line 3181: l_approver := wf_engine.getitemattrtext

3177: itemkey => l_item_key,
3178: aname => 'OBJECT_ID'
3179: );
3180:
3181: l_approver := wf_engine.getitemattrtext
3182: (
3183: itemtype => l_item_type,
3184: itemkey => l_item_key,
3185: aname => 'APPROVER'

Line 3188: l_requester_note := wf_engine.getitemattrtext

3184: itemkey => l_item_key,
3185: aname => 'APPROVER'
3186: );
3187:
3188: l_requester_note := wf_engine.getitemattrtext
3189: (
3190: itemtype => l_item_type
3191: ,itemkey => l_item_key
3192: ,aname => 'REQUESTER_NOTE'

Line 3196: l_approver_note := wf_engine.getitemattrtext(

3192: ,aname => 'REQUESTER_NOTE'
3193: );
3194:
3195:
3196: l_approver_note := wf_engine.getitemattrtext(
3197: itemtype => l_item_type,
3198: itemkey => l_item_key,
3199: aname => 'APPROVER NOTE'
3200: );

Line 3335: l_object_type := wf_engine.getitemattrtext

3331: l_hyphen_pos1 := INSTR (document_id, ':');
3332: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
3333: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
3334:
3335: l_object_type := wf_engine.getitemattrtext
3336: (
3337: itemtype => l_item_type,
3338: itemkey => l_item_key,
3339: aname => 'OBJECT_TYPE'

Line 3342: l_object_id := wf_engine.getitemattrNumber

3338: itemkey => l_item_key,
3339: aname => 'OBJECT_TYPE'
3340: );
3341:
3342: l_object_id := wf_engine.getitemattrNumber
3343: (
3344: itemtype => l_item_type,
3345: itemkey => l_item_key,
3346: aname => 'OBJECT_ID'

Line 3349: l_requester := wf_engine.getitemattrtext

3345: itemkey => l_item_key,
3346: aname => 'OBJECT_ID'
3347: );
3348:
3349: l_requester := wf_engine.getitemattrtext
3350: (
3351: itemtype => l_item_type,
3352: itemkey => l_item_key,
3353: aname => 'REQUESTER'

Line 3356: l_requester_note := wf_engine.getitemattrtext

3352: itemkey => l_item_key,
3353: aname => 'REQUESTER'
3354: );
3355:
3356: l_requester_note := wf_engine.getitemattrtext
3357: (
3358: itemtype => l_item_type,
3359: itemkey => l_item_key,
3360: aname => 'REQUESTER_NOTE'

Line 3501: l_object_type := wf_engine.getitemattrtext

3497: l_hyphen_pos1 := INSTR (document_id, ':');
3498: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
3499: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
3500:
3501: l_object_type := wf_engine.getitemattrtext
3502: (
3503: itemtype => l_item_type,
3504: itemkey => l_item_key,
3505: aname => 'OBJECT_TYPE'

Line 3508: l_object_id := wf_engine.getitemattrNumber

3504: itemkey => l_item_key,
3505: aname => 'OBJECT_TYPE'
3506: );
3507:
3508: l_object_id := wf_engine.getitemattrNumber
3509: (
3510: itemtype => l_item_type,
3511: itemkey => l_item_key,
3512: aname => 'OBJECT_ID'

Line 3515: l_requester := wf_engine.getitemattrtext

3511: itemkey => l_item_key,
3512: aname => 'OBJECT_ID'
3513: );
3514:
3515: l_requester := wf_engine.getitemattrtext
3516: (
3517: itemtype => l_item_type,
3518: itemkey => l_item_key,
3519: aname => 'REQUESTER'

Line 3522: l_requester_note := wf_engine.getitemattrtext

3518: itemkey => l_item_key,
3519: aname => 'REQUESTER'
3520: );
3521:
3522: l_requester_note := wf_engine.getitemattrtext
3523: (
3524: itemtype => l_item_type,
3525: itemkey => l_item_key,
3526: aname => 'REQUESTER_NOTE'

Line 3685: l_object_type := wf_engine.getitemattrtext

3681: l_hyphen_pos1 := INSTR (document_id, ':');
3682: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
3683: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
3684:
3685: l_object_type := wf_engine.getitemattrtext
3686: (
3687: itemtype => l_item_type,
3688: itemkey => l_item_key,
3689: aname => 'OBJECT_TYPE'

Line 3692: l_object_id := wf_engine.getitemattrNumber

3688: itemkey => l_item_key,
3689: aname => 'OBJECT_TYPE'
3690: );
3691:
3692: l_object_id := wf_engine.getitemattrNumber
3693: (
3694: itemtype => l_item_type,
3695: itemkey => l_item_key,
3696: aname => 'OBJECT_ID'

Line 3699: l_error_msg := wf_engine.getitemattrText

3695: itemkey => l_item_key,
3696: aname => 'OBJECT_ID'
3697: );
3698:
3699: l_error_msg := wf_engine.getitemattrText
3700: (
3701: itemtype => l_item_type,
3702: itemkey => l_item_key,
3703: aname => 'ERROR_MSG'

Line 3706: l_requester_note := wf_engine.getitemattrtext(

3702: itemkey => l_item_key,
3703: aname => 'ERROR_MSG'
3704: );
3705:
3706: l_requester_note := wf_engine.getitemattrtext(
3707: itemtype => l_item_type
3708: ,itemkey => l_item_key
3709: ,aname => 'REQUESTER_NOTE'
3710: );

Line 3868: l_approval_status := wf_engine.getitemattrtext(

3864: MO_GLOBAL.init('AHL');
3865:
3866: IF (funcmode = 'RUN') THEN
3867:
3868: l_approval_status := wf_engine.getitemattrtext(
3869: itemtype => itemtype,
3870: itemkey => itemkey,
3871: aname => 'UPDATE_GEN_STATUS'
3872: );

Line 3874: l_object_id := wf_engine.getitemattrnumber(

3870: itemkey => itemkey,
3871: aname => 'UPDATE_GEN_STATUS'
3872: );
3873:
3874: l_object_id := wf_engine.getitemattrnumber(
3875: itemtype => itemtype,
3876: itemkey => itemkey,
3877: aname => 'OBJECT_ID'
3878: );

Line 3879: l_object_version_number := wf_engine.getitemattrnumber(

3875: itemtype => itemtype,
3876: itemkey => itemkey,
3877: aname => 'OBJECT_ID'
3878: );
3879: l_object_version_number := wf_engine.getitemattrnumber(
3880: itemtype => itemtype,
3881: itemkey => itemkey,
3882: aname => 'OBJECT_VER'
3883: );

Line 3884: l_approver_note := wf_engine.getitemattrtext(

3880: itemtype => itemtype,
3881: itemkey => itemkey,
3882: aname => 'OBJECT_VER'
3883: );
3884: l_approver_note := wf_engine.getitemattrtext(
3885: itemtype => itemtype,
3886: itemkey => itemkey,
3887: aname => 'APPROVER NOTE'
3888: );

Line 3920: l_new_status := wf_engine.getitemattrText(

3916: END IF;
3917:
3918: IF (l_approval_status IN( 'DEFERRED')) THEN
3919:
3920: l_new_status := wf_engine.getitemattrText(
3921: itemtype => itemtype,
3922: itemkey => itemkey,
3923: aname => 'NEW_STATUS_ID'
3924: );

Line 3976: l_new_status := wf_engine.getitemattrText(

3972: l_deferral_rec.ata_sequence_id,
3973: l_ue_rec.cs_incident_id,
3974: l_ue_rec.csi_item_instance_id);
3975: ELSE
3976: l_new_status := wf_engine.getitemattrText(
3977: itemtype => itemtype,
3978: itemkey => itemkey,
3979: aname => 'REJECT_STATUS_ID'
3980: );

Line 4174: l_object_id := wf_engine.getitemattrnumber

4170: --
4171: IF (funcmode = 'RUN')
4172: THEN
4173:
4174: l_object_id := wf_engine.getitemattrnumber
4175: (
4176: itemtype => itemtype,
4177: itemkey => itemkey,
4178: aname => 'OBJECT_ID'

Line 4181: l_object_ovn := wf_engine.getitemattrnumber

4177: itemkey => itemkey,
4178: aname => 'OBJECT_ID'
4179: );
4180:
4181: l_object_ovn := wf_engine.getitemattrnumber
4182: (
4183: itemtype => itemtype,
4184: itemkey => itemkey,
4185: aname => 'OBJECT_VER'

Line 4189: l_orig_status := wf_engine.getitemattrnumber

4185: aname => 'OBJECT_VER'
4186: );
4187:
4188:
4189: l_orig_status := wf_engine.getitemattrnumber
4190: (
4191: itemtype => itemtype,
4192: itemkey => itemkey,
4193: aname => 'ORG_STATUS_ID'