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

Line 50: l_resale_batch_id := WF_ENGINE.GetItemAttrText(

46: l_resale_batch_id NUMBER;
47: l_temp_mesg VARCHAR2(2500);
48: BEGIN
49:
50: l_resale_batch_id := WF_ENGINE.GetItemAttrText(
51: itemtype => p_itemtype,
52: itemkey => p_itemkey,
53: aname => G_WF_ATTR_BATCH_ID);
54:

Line 76: WF_ENGINE.SetItemAttrText(

72: null;
73: END LOOP ;
74: x_error_msg := l_final_msg;
75:
76: WF_ENGINE.SetItemAttrText(
77: itemtype => p_itemtype,
78: itemkey => p_itemkey ,
79: aname => G_WF_ATTR_ERROR_MESG,
80: avalue => l_final_msg );

Line 116: l_user_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype

112: IF OZF_DEBUG_HIGH_ON THEN
113: OZF_UTILITY_PVT.debug_message('IN: Re_Initilize_Context' );
114: END IF;
115:
116: l_user_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype
117: ,itemkey => itemkey
118: ,aname => G_WF_ATTR_USER_ID
119: );
120:

Line 121: l_resp_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype

117: ,itemkey => itemkey
118: ,aname => G_WF_ATTR_USER_ID
119: );
120:
121: l_resp_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype
122: ,itemkey => itemkey
123: ,aname => G_WF_ATTR_RESP_ID
124: );
125:

Line 126: l_appl_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype

122: ,itemkey => itemkey
123: ,aname => G_WF_ATTR_RESP_ID
124: );
125:
126: l_appl_id := WF_ENGINE.GetItemAttrText( itemtype => itemtype
127: ,itemkey => itemkey
128: ,aname => G_WF_ATTR_APPL_ID
129: );
130:

Line 194: l_batch_org_id := WF_ENGINE.GetItemAttrText(

190: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
191: END IF;
192:
193: -- R12 MOAC Enhancement (+)
194: l_batch_org_id := WF_ENGINE.GetItemAttrText(
195: itemtype => itemtype,
196: itemkey => itemkey,
197: aname => 'OZF_BATCH_ORG_ID'
198: );

Line 229: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

225: -- p_access_mode => 'S',
226: -- p_org_id => l_batch_org_id
227: -- );
228:
229: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
230: itemkey => itemkey,
231: aname => G_WF_ATTR_BATCH_ID);
232: IF OZF_DEBUG_LOW_ON THEN
233: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);

Line 237: l_batch_type := WF_ENGINE.GetItemAttrText (itemtype => itemType,

233: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
234: END IF;
235:
236: IF l_batch_id IS NOT NULL THEN
237: l_batch_type := WF_ENGINE.GetItemAttrText (itemtype => itemType,
238: itemkey => itemKey,
239: aname => G_WF_ATTR_BATCH_TYPE);
240:
241: OPEN batch_status_csr(l_batch_id);

Line 274: WF_ENGINE.SetItemAttrText(

270: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273:
274: WF_ENGINE.SetItemAttrText(
275: itemtype => itemtype,
276: itemkey => itemkey ,
277: aname => G_WF_ATTR_BATCH_STATUS,
278: avalue => l_batch_return_status );

Line 377: l_batch_org_id := WF_ENGINE.GetItemAttrText(

373: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);
374: END IF;
375:
376: -- R12 MOAC Enhancement (+)
377: l_batch_org_id := WF_ENGINE.GetItemAttrText(
378: itemtype => itemtype,
379: itemkey => itemkey,
380: aname => 'OZF_BATCH_ORG_ID'
381: );

Line 512: l_batch_org_id := WF_ENGINE.GetItemAttrText(

508: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);
509: END IF;
510:
511: -- R12 MOAC Enhancement (+)
512: l_batch_org_id := WF_ENGINE.GetItemAttrText(
513: itemtype => itemtype,
514: itemkey => itemkey,
515: aname => 'OZF_BATCH_ORG_ID'
516: );

Line 541: l_batch_caller := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

537: -- R12 MOAC Enhancement (-)
538:
539: IF (funcmode = 'RUN') THEN
540: --
541: l_batch_caller := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
542: itemkey => itemkey,
543: aname => G_WF_ATTR_BATCH_CALLER);
544:
545: IF l_batch_caller is NULL THEN

Line 548: WF_ENGINE.SetItemAttrText(

544:
545: IF l_batch_caller is NULL THEN
546: -- default caller to be UI
547: l_batch_caller := G_WF_LKUP_UI;
548: WF_ENGINE.SetItemAttrText(
549: itemtype => itemtype,
550: itemkey => itemkey ,
551: aname => G_WF_ATTR_BATCH_CALLER,
552: avalue => l_batch_caller);

Line 562: l_batch_number := WF_ENGINE.GetItemAttrText(

558: RAISE FND_API.G_EXC_ERROR;
559: END IF;
560:
561: -- SET attribute OZF_BATCH_NUM_W_DATE for event key
562: l_batch_number := WF_ENGINE.GetItemAttrText(
563: itemtype => itemtype,
564: itemkey => itemkey,
565: aname => G_WF_ATTR_BATCH_NUMBER
566: );

Line 569: WF_ENGINE.SetItemAttrText(

565: aname => G_WF_ATTR_BATCH_NUMBER
566: );
567: l_batch_num_w_date :='ResaleBatch:'||l_batch_number||'-'|| to_char(sysdate,'MM/DD/YYYY HH:MI:SS');
568:
569: WF_ENGINE.SetItemAttrText(
570: itemtype => itemtype,
571: itemkey => itemkey ,
572: aname => G_WF_ATTR_BATCH_NUM_W_DATE,
573: avalue => l_batch_num_w_date);

Line 671: l_batch_org_id := WF_ENGINE.GetItemAttrText(

667: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);
668: END IF;
669:
670: -- R12 MOAC Enhancement (+)
671: l_batch_org_id := WF_ENGINE.GetItemAttrText(
672: itemtype => itemtype,
673: itemkey => itemkey,
674: aname => 'OZF_BATCH_ORG_ID'
675: );

Line 700: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

696: -- R12 MOAC Enhancement (-)
697:
698: IF (funcmode = 'RUN') THEN
699: --
700: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
701: itemkey => itemkey,
702: aname => G_WF_ATTR_BATCH_ID);
703:
704: OPEN batch_status_csr(l_batch_id);

Line 805: l_batch_org_id := WF_ENGINE.GetItemAttrText(

801: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);
802: END IF;
803:
804: -- R12 MOAC Enhancement (+)
805: l_batch_org_id := WF_ENGINE.GetItemAttrText(
806: itemtype => itemtype,
807: itemkey => itemkey,
808: aname => 'OZF_BATCH_ORG_ID'
809: );

Line 834: l_batch_type := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

830: -- R12 MOAC Enhancement (-)
831:
832: IF (funcmode = 'RUN') THEN
833: --
834: l_batch_type := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
835: itemkey => itemkey,
836: aname => G_WF_ATTR_BATCH_TYPE);
837:
838: IF l_batch_type NOT IN (G_WF_LKUP_CHARGEBACK, G_WF_LKUP_SPECIALPRICE, G_WF_LKUP_TRACING) OR

Line 954: l_resale_batch_id := WF_ENGINE.GetItemAttrText(

950: IF (funcmode = 'RUN') THEN
951: -- Clear the error stack for one time
952: FND_MSG_PUB.initialize;
953:
954: l_resale_batch_id := WF_ENGINE.GetItemAttrText(
955: itemtype => itemtype,
956: itemkey => itemkey,
957: aname => G_WF_ATTR_BATCH_ID
958: );

Line 973: WF_ENGINE.SetItemAttrText(

969: CLOSE batch_num_csr;
970:
971:
972:
973: WF_ENGINE.SetItemAttrText(
974: itemtype => itemtype,
975: itemkey => itemkey ,
976: aname => G_WF_ATTR_BATCH_NUMBER,
977: avalue => l_batch_number );

Line 979: WF_ENGINE.SetItemAttrText(

975: itemkey => itemkey ,
976: aname => G_WF_ATTR_BATCH_NUMBER,
977: avalue => l_batch_number );
978:
979: WF_ENGINE.SetItemAttrText(
980: itemtype => itemtype,
981: itemkey => itemkey ,
982: aname => G_WF_ATTR_BATCH_TYPE,
983: avalue => l_batch_type );

Line 985: WF_ENGINE.SetItemAttrText(

981: itemkey => itemkey ,
982: aname => G_WF_ATTR_BATCH_TYPE,
983: avalue => l_batch_type );
984:
985: WF_ENGINE.SetItemAttrText(
986: itemtype => itemtype,
987: itemkey => itemkey ,
988: aname => 'OZF_BATCH_ORG_ID',
989: avalue => l_batch_org_id

Line 1004: WF_ENGINE.SetItemAttrText(

1000: p_orig_system_id => l_emp_id ,
1001: p_name => l_user_name,
1002: p_display_name => l_display_name );
1003:
1004: WF_ENGINE.SetItemAttrText(
1005: itemtype => itemtype,
1006: itemkey => itemkey ,
1007: aname => G_WF_ATTR_WF_ADMINISTRATOR,
1008: avalue => l_user_name);

Line 1011: WF_ENGINE.SetItemOwner(

1007: aname => G_WF_ATTR_WF_ADMINISTRATOR,
1008: avalue => l_user_name);
1009:
1010: -- set workflow process owner
1011: WF_ENGINE.SetItemOwner(
1012: itemtype => itemtype,
1013: itemkey => itemkey,
1014: owner => l_user_name);
1015: */

Line 1108: l_batch_org_id := WF_ENGINE.GetItemAttrText(

1104: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1105: END IF;
1106:
1107: -- R12 MOAC Enhancement (+)
1108: l_batch_org_id := WF_ENGINE.GetItemAttrText(
1109: itemtype => itemtype,
1110: itemkey => itemkey,
1111: aname => 'OZF_BATCH_ORG_ID'
1112: );

Line 1137: l_resale_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

1133: -- R12 MOAC Enhancement (-)
1134:
1135: IF (funcmode = 'RUN') THEN
1136: --
1137: l_resale_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
1138: itemkey => itemkey,
1139: aname => G_WF_ATTR_BATCH_ID);
1140: OZF_RESALE_PVT.Initiate_Payment (
1141: p_api_version => 1.0

Line 1256: l_batch_org_id := WF_ENGINE.GetItemAttrText(

1252: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1253: END IF;
1254:
1255: -- R12 MOAC Enhancement (+)
1256: l_batch_org_id := WF_ENGINE.GetItemAttrText(
1257: itemtype => itemtype,
1258: itemkey => itemkey,
1259: aname => 'OZF_BATCH_ORG_ID'
1260: );

Line 1285: l_resale_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

1281: -- R12 MOAC Enhancement (-)
1282:
1283: IF (funcmode = 'RUN') THEN
1284: --
1285: l_resale_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
1286: itemkey => itemkey,
1287: aname => G_WF_ATTR_BATCH_ID);
1288: -- Fix for Bug#8867381 (+)
1289:

Line 1407: l_batch_org_id := WF_ENGINE.GetItemAttrText(

1403: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1404: END IF;
1405:
1406: -- R12 MOAC Enhancement (+)
1407: l_batch_org_id := WF_ENGINE.GetItemAttrText(
1408: itemtype => itemtype,
1409: itemkey => itemkey,
1410: aname => 'OZF_BATCH_ORG_ID'
1411: );

Line 1435: l_resale_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

1431: -- R12 MOAC Enhancement (-)
1432:
1433: IF (funcmode = 'RUN') THEN
1434: --
1435: l_resale_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
1436: itemkey => itemkey,
1437: aname => G_WF_ATTR_BATCH_ID);
1438:
1439: --//Bugfix : 10431933

Line 1543: l_resale_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

1539: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1540: END IF;
1541: IF (funcmode = 'RUN') THEN
1542: --
1543: l_resale_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
1544: itemkey => itemkey,
1545: aname => G_WF_ATTR_BATCH_ID);
1546:
1547: --//Bugfix : 10431933

Line 1653: l_batch_org_id := WF_ENGINE.GetItemAttrText(

1649: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1650: END IF;
1651:
1652: -- R12 MOAC Enhancement (+)
1653: l_batch_org_id := WF_ENGINE.GetItemAttrText(
1654: itemtype => itemtype,
1655: itemkey => itemkey,
1656: aname => 'OZF_BATCH_ORG_ID'
1657: );

Line 1682: l_resale_batch_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype,

1678: -- R12 MOAC Enhancement (-)
1679:
1680: IF (funcmode = 'RUN') THEN
1681: --
1682: l_resale_batch_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype,
1683: itemkey => itemkey,
1684: aname => G_WF_ATTR_BATCH_ID);
1685: OZF_CHARGEBACK_PVT.Process_Order(
1686: p_api_version => 1.0

Line 1790: l_batch_org_id := WF_ENGINE.GetItemAttrText(

1786: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1787: END IF;
1788:
1789: -- R12 MOAC Enhancement (+)
1790: l_batch_org_id := WF_ENGINE.GetItemAttrText(
1791: itemtype => itemtype,
1792: itemkey => itemkey,
1793: aname => 'OZF_BATCH_ORG_ID'
1794: );

Line 1819: l_resale_batch_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype,

1815: -- R12 MOAC Enhancement (-)
1816:
1817: IF (funcmode = 'RUN') THEN
1818: --
1819: l_resale_batch_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype,
1820: itemkey => itemkey,
1821: aname => G_WF_ATTR_BATCH_ID);
1822: OZF_RESALE_PVT.Process_Resale (
1823: p_api_version => 1

Line 1923: l_batch_org_id := WF_ENGINE.GetItemAttrText(

1919: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1920: END IF;
1921:
1922: -- R12 MOAC Enhancement (+)
1923: l_batch_org_id := WF_ENGINE.GetItemAttrText(
1924: itemtype => itemtype,
1925: itemkey => itemkey,
1926: aname => 'OZF_BATCH_ORG_ID'
1927: );

Line 1952: l_resale_batch_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype,

1948: -- R12 MOAC Enhancement (-)
1949:
1950: IF (funcmode = 'RUN') THEN
1951: --
1952: l_resale_batch_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype,
1953: itemkey => itemkey,
1954: aname => G_WF_ATTR_BATCH_ID);
1955: OZF_SPECIAL_PRICING_PVT.Process_Order(
1956: p_api_version => 1.0

Line 2059: l_batch_org_id := WF_ENGINE.GetItemAttrText(

2055: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2056: END IF;
2057:
2058: -- R12 MOAC Enhancement (+)
2059: l_batch_org_id := WF_ENGINE.GetItemAttrText(
2060: itemtype => itemtype,
2061: itemkey => itemkey,
2062: aname => 'OZF_BATCH_ORG_ID'
2063: );

Line 2088: l_resale_batch_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype,

2084: -- R12 MOAC Enhancement (-)
2085:
2086: IF (funcmode = 'RUN') THEN
2087: --
2088: l_resale_batch_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype,
2089: itemkey => itemkey,
2090: aname => G_WF_ATTR_BATCH_ID);
2091: OZF_TRACING_ORDER_PVT.Process_Order(
2092: p_api_version => 1.0

Line 2204: l_resale_batch_id := WF_ENGINE.GetItemAttrText(

2200: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2201: END IF;
2202: IF (funcmode = 'RUN') THEN
2203: --
2204: l_resale_batch_id := WF_ENGINE.GetItemAttrText(
2205: itemtype => itemtype,
2206: itemkey => itemkey,
2207: aname => G_WF_ATTR_BATCH_ID
2208: );

Line 2386: l_batch_org_id := WF_ENGINE.GetItemAttrText(

2382: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2383: END IF;
2384:
2385: -- R12 MOAC Enhancement (+)
2386: l_batch_org_id := WF_ENGINE.GetItemAttrText(
2387: itemtype => itemtype,
2388: itemkey => itemkey,
2389: aname => 'OZF_BATCH_ORG_ID'
2390: );

Line 2414: l_resale_batch_id := WF_ENGINE.GetItemAttrText(

2410: END IF;*/
2411: -- R12 MOAC Enhancement (-)
2412:
2413: IF (funcmode = 'RUN') THEN
2414: l_resale_batch_id := WF_ENGINE.GetItemAttrText(
2415: itemtype => itemtype,
2416: itemkey => itemkey,
2417: aname => G_WF_ATTR_BATCH_ID
2418: );

Line 2438: l_user_id := WF_ENGINE.GetItemAttrText(

2434: CLOSE wf_values_csr;
2435:
2436: ELSE
2437:
2438: l_user_id := WF_ENGINE.GetItemAttrText(
2439: itemtype => itemtype,
2440: itemkey => itemkey,
2441: aname => G_WF_ATTR_USER_ID
2442: );

Line 2444: l_resp_id := WF_ENGINE.GetItemAttrText(

2440: itemkey => itemkey,
2441: aname => G_WF_ATTR_USER_ID
2442: );
2443:
2444: l_resp_id := WF_ENGINE.GetItemAttrText(
2445: itemtype => itemtype,
2446: itemkey => itemkey,
2447: aname => G_WF_ATTR_RESP_ID
2448: );

Line 2483: WF_ENGINE.SetItemAttrText(

2479: p_name => l_user_name,
2480: p_display_name => l_display_name
2481: );
2482:
2483: WF_ENGINE.SetItemAttrText(
2484: itemtype => itemtype,
2485: itemkey => itemkey ,
2486: aname => G_WF_ATTR_WF_ADMINISTRATOR,
2487: avalue => l_user_name

Line 2491: WF_ENGINE.SetItemOwner(

2487: avalue => l_user_name
2488: );
2489:
2490: -- set workflow process owner
2491: WF_ENGINE.SetItemOwner(
2492: itemtype => itemtype,
2493: itemkey => itemkey,
2494: owner => l_user_name
2495: );

Line 2498: WF_ENGINE.setitemattrnumber(

2494: owner => l_user_name
2495: );
2496:
2497: --//Bugfix : 10431933
2498: WF_ENGINE.setitemattrnumber(
2499: itemtype => itemtype
2500: ,itemkey => itemkey
2501: ,aname => G_WF_ATTR_USER_ID
2502: ,avalue => l_wf_user_id

Line 2504: WF_ENGINE.setitemattrnumber(

2500: ,itemkey => itemkey
2501: ,aname => G_WF_ATTR_USER_ID
2502: ,avalue => l_wf_user_id
2503: );
2504: WF_ENGINE.setitemattrnumber(
2505: itemtype => itemtype
2506: ,itemkey => itemkey
2507: ,aname => G_WF_ATTR_RESP_ID
2508: ,avalue => l_resp_id

Line 2511: WF_ENGINE.setitemattrnumber(

2507: ,aname => G_WF_ATTR_RESP_ID
2508: ,avalue => l_resp_id
2509: );
2510:
2511: WF_ENGINE.setitemattrnumber(
2512: itemtype => itemtype
2513: ,itemkey => itemkey
2514: ,aname => G_WF_ATTR_APPL_ID
2515: ,avalue => 682

Line 2636: l_batch_org_id := WF_ENGINE.GetItemAttrText(

2632: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2633: END IF;
2634:
2635: -- R12 MOAC Enhancement (+)
2636: l_batch_org_id := WF_ENGINE.GetItemAttrText(
2637: itemtype => itemtype,
2638: itemkey => itemkey,
2639: aname => 'OZF_BATCH_ORG_ID'
2640: );

Line 2665: l_resale_batch_id := WF_ENGINE.GetItemAttrText(

2661: -- R12 MOAC Enhancement (-)
2662:
2663: IF (funcmode = 'RUN') THEN
2664: --
2665: l_resale_batch_id := WF_ENGINE.GetItemAttrText(
2666: itemtype => itemtype,
2667: itemkey => itemkey,
2668: aname => G_WF_ATTR_BATCH_ID);
2669:

Line 2824: l_batch_org_id := WF_ENGINE.GetItemAttrText(

2820: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2821: END IF;
2822:
2823: -- R12 MOAC Enhancement (+)
2824: l_batch_org_id := WF_ENGINE.GetItemAttrText(
2825: itemtype => itemtype,
2826: itemkey => itemkey,
2827: aname => 'OZF_BATCH_ORG_ID'
2828: );

Line 2853: l_resale_batch_id := WF_ENGINE.GetItemAttrText(

2849: -- R12 MOAC Enhancement (-)
2850:
2851: IF (funcmode = 'RUN') THEN
2852: --
2853: l_resale_batch_id := WF_ENGINE.GetItemAttrText(
2854: itemtype => itemtype,
2855: itemkey => itemkey,
2856: aname => G_WF_ATTR_BATCH_ID);
2857:

Line 3012: l_batch_org_id := WF_ENGINE.GetItemAttrText(

3008: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
3009: END IF;
3010:
3011: -- R12 MOAC Enhancement (+)
3012: l_batch_org_id := WF_ENGINE.GetItemAttrText(
3013: itemtype => itemtype,
3014: itemkey => itemkey,
3015: aname => 'OZF_BATCH_ORG_ID'
3016: );

Line 3041: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

3037: -- R12 MOAC Enhancement (-)
3038:
3039: IF (funcmode = 'RUN') THEN
3040: --
3041: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
3042: itemkey => itemkey,
3043: aname => G_WF_ATTR_BATCH_ID);
3044:
3045: IF OZF_DEBUG_LOW_ON THEN

Line 3159: l_batch_org_id := WF_ENGINE.GetItemAttrText(

3155: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
3156: END IF;
3157:
3158: -- R12 MOAC Enhancement (+)
3159: l_batch_org_id := WF_ENGINE.GetItemAttrText(
3160: itemtype => itemtype,
3161: itemkey => itemkey,
3162: aname => 'OZF_BATCH_ORG_ID'
3163: );

Line 3187: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

3183: -- R12 MOAC Enhancement (-)
3184:
3185: IF (funcmode = 'RUN') THEN
3186: --
3187: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
3188: itemkey => itemkey,
3189: aname => G_WF_ATTR_BATCH_ID);
3190:
3191: IF OZF_DEBUG_LOW_ON THEN

Line 3305: l_batch_org_id := WF_ENGINE.GetItemAttrText(

3301: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
3302: END IF;
3303:
3304: -- R12 MOAC Enhancement (+)
3305: l_batch_org_id := WF_ENGINE.GetItemAttrText(
3306: itemtype => itemtype,
3307: itemkey => itemkey,
3308: aname => 'OZF_BATCH_ORG_ID'
3309: );

Line 3334: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

3330: -- R12 MOAC Enhancement (-)
3331:
3332: IF (funcmode = 'RUN') THEN
3333: --
3334: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
3335: itemkey => itemkey,
3336: aname => G_WF_ATTR_BATCH_ID);
3337: IF OZF_DEBUG_LOW_ON THEN
3338: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);

Line 3450: l_batch_org_id := WF_ENGINE.GetItemAttrText(

3446: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
3447: END IF;
3448:
3449: -- R12 MOAC Enhancement (+)
3450: l_batch_org_id := WF_ENGINE.GetItemAttrText(
3451: itemtype => itemtype,
3452: itemkey => itemkey,
3453: aname => 'OZF_BATCH_ORG_ID'
3454: );

Line 3479: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

3475: -- R12 MOAC Enhancement (-)
3476:
3477: IF (funcmode = 'RUN') THEN
3478: --
3479: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
3480: itemkey => itemkey,
3481: aname => G_WF_ATTR_BATCH_ID);
3482: IF OZF_DEBUG_LOW_ON THEN
3483: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);

Line 3596: l_batch_org_id := WF_ENGINE.GetItemAttrText(

3592: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
3593: END IF;
3594:
3595: -- R12 MOAC Enhancement (+)
3596: l_batch_org_id := WF_ENGINE.GetItemAttrText(
3597: itemtype => itemtype,
3598: itemkey => itemkey,
3599: aname => 'OZF_BATCH_ORG_ID'
3600: );

Line 3625: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,

3621: -- R12 MOAC Enhancement (-)
3622:
3623: IF (funcmode = 'RUN') THEN
3624: --
3625: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
3626: itemkey => itemkey,
3627: aname => G_WF_ATTR_BATCH_ID);
3628: IF OZF_DEBUG_LOW_ON THEN
3629: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);

Line 3822: WF_ENGINE.CreateProcess(

3818: -- If value of profile "OZF: IDSM Batch Processing Mode" is set to Synchronous then Batch Process will be done synchronously
3819:
3820: IF l_batch_process_mode = 'SYNC' THEN
3821:
3822: WF_ENGINE.CreateProcess(
3823: itemType => l_itemtype,
3824: itemKey => l_itemkey,
3825: process => l_process
3826: );

Line 3828: WF_ENGINE.SetItemUserKey(

3824: itemKey => l_itemkey,
3825: process => l_process
3826: );
3827:
3828: WF_ENGINE.SetItemUserKey(
3829: itemType => l_itemtype,
3830: itemKey => l_itemkey,
3831: userKey => l_itemuserkey
3832: );

Line 3834: WF_ENGINE.SetItemOwner(

3830: itemKey => l_itemkey,
3831: userKey => l_itemuserkey
3832: );
3833:
3834: WF_ENGINE.SetItemOwner(
3835: itemtype => l_itemtype,
3836: itemkey => l_itemkey,
3837: owner => l_user_name
3838: );

Line 3840: WF_ENGINE.SetItemAttrText(

3836: itemkey => l_itemkey,
3837: owner => l_user_name
3838: );
3839:
3840: WF_ENGINE.SetItemAttrText(
3841: itemtype => l_itemtype,
3842: itemkey => l_itemkey ,
3843: aname => 'OZF_RESALE_BATCH_ID',
3844: avalue => p_resale_batch_id

Line 3847: WF_ENGINE.SetItemAttrText(

3843: aname => 'OZF_RESALE_BATCH_ID',
3844: avalue => p_resale_batch_id
3845: );
3846:
3847: WF_ENGINE.SetItemAttrText(
3848: itemtype => l_itemtype,
3849: itemkey => l_itemkey ,
3850: aname => 'WF_ADMINISTRATOR',
3851: avalue => l_user_name

Line 3854: WF_ENGINE.SetItemAttrText(

3850: aname => 'WF_ADMINISTRATOR',
3851: avalue => l_user_name
3852: );
3853:
3854: WF_ENGINE.SetItemAttrText(
3855: itemtype => l_itemtype,
3856: itemkey => l_itemkey ,
3857: aname => 'OZF_RESALE_BATCH_CALLER',
3858: avalue => p_caller_type

Line 3862: WF_ENGINE.SetItemAttrNumber(

3858: avalue => p_caller_type
3859: );
3860:
3861: --//Bugfix : 10312826
3862: WF_ENGINE.SetItemAttrNumber(
3863: itemtype => l_itemtype,
3864: itemkey => l_itemkey ,
3865: aname => 'OZF_USER_ID',
3866: avalue => l_wf_user_id

Line 3869: WF_ENGINE.SetItemAttrText(

3865: aname => 'OZF_USER_ID',
3866: avalue => l_wf_user_id
3867: );
3868:
3869: WF_ENGINE.SetItemAttrText(
3870: itemtype => l_itemtype,
3871: itemkey => l_itemkey ,
3872: aname => 'OZF_RESPONSIBILITY_ID',
3873: avalue => l_resp_id

Line 3876: WF_ENGINE.SetItemAttrText(

3872: aname => 'OZF_RESPONSIBILITY_ID',
3873: avalue => l_resp_id
3874: );
3875:
3876: WF_ENGINE.SetItemAttrText(
3877: itemtype => l_itemtype,
3878: itemkey => l_itemkey ,
3879: aname => 'OZF_APPLICATION_ID',
3880: avalue => l_appl_id

Line 3884: WF_ENGINE.SetItemAttrText(

3880: avalue => l_appl_id
3881: );
3882:
3883: -- nepanda : Fix for Bug 13819601
3884: WF_ENGINE.SetItemAttrText(
3885: itemtype => l_itemtype,
3886: itemkey => l_itemkey ,
3887: aname => 'OZF_BATCH_ORG_ID',
3888: avalue => l_batch_info.org_id

Line 3890: WF_ENGINE.StartProcess(

3886: itemkey => l_itemkey ,
3887: aname => 'OZF_BATCH_ORG_ID',
3888: avalue => l_batch_info.org_id
3889: );
3890: WF_ENGINE.StartProcess(
3891: itemtype => l_itemtype,
3892: itemkey => l_itemkey
3893: );
3894:

Line 4044: WF_ENGINE.CreateProcess(

4040:
4041:
4042: -- For Bug#8867381 making the workflow event asynchronous by creating an event
4043: /*
4044: WF_ENGINE.CreateProcess(
4045: itemType => l_itemtype,
4046: itemKey => l_itemkey,
4047: process => l_process
4048: );

Line 4050: WF_ENGINE.SetItemUserKey(

4046: itemKey => l_itemkey,
4047: process => l_process
4048: );
4049:
4050: WF_ENGINE.SetItemUserKey(
4051: itemType => l_itemtype,
4052: itemKey => l_itemkey,
4053: userKey => l_itemuserkey
4054: );

Line 4093: WF_ENGINE.SetItemOwner(

4089: );
4090:
4091: -- For Bug#8867381 making the workflow event asynchronous by creating an event
4092: /*
4093: WF_ENGINE.SetItemOwner(
4094: itemtype => l_itemtype,
4095: itemkey => l_itemkey,
4096: owner => l_user_name
4097: );

Line 4099: WF_ENGINE.SetItemAttrText(

4095: itemkey => l_itemkey,
4096: owner => l_user_name
4097: );
4098:
4099: WF_ENGINE.SetItemAttrText(
4100: itemtype => l_itemtype,
4101: itemkey => l_itemkey ,
4102: aname => 'OZF_RESALE_BATCH_ID',
4103: avalue => p_resale_batch_id

Line 4106: WF_ENGINE.SetItemAttrText(

4102: aname => 'OZF_RESALE_BATCH_ID',
4103: avalue => p_resale_batch_id
4104: );
4105:
4106: WF_ENGINE.SetItemAttrText(
4107: itemtype => l_itemtype,
4108: itemkey => l_itemkey ,
4109: aname => 'WF_ADMINISTRATOR',
4110: avalue => l_user_name

Line 4113: WF_ENGINE.SetItemAttrText(

4109: aname => 'WF_ADMINISTRATOR',
4110: avalue => l_user_name
4111: );
4112:
4113: WF_ENGINE.SetItemAttrText(
4114: itemtype => l_itemtype,
4115: itemkey => l_itemkey ,
4116: aname => 'OZF_RESALE_BATCH_CALLER',
4117: avalue => p_caller_type

Line 4120: WF_ENGINE.StartProcess(

4116: aname => 'OZF_RESALE_BATCH_CALLER',
4117: avalue => p_caller_type
4118: );
4119:
4120: WF_ENGINE.StartProcess(
4121: itemtype => l_itemtype,
4122: itemkey => l_itemkey
4123: );
4124: */

Line 4230: l_wf_user_id := WF_ENGINE.GetItemAttrText(

4226:
4227: BEGIN
4228:
4229:
4230: l_wf_user_id := WF_ENGINE.GetItemAttrText(
4231: itemtype => p_itemtype,
4232: itemkey => p_itemkey,
4233: aname => G_WF_ATTR_USER_ID
4234: );

Line 4236: l_wf_resp_id := WF_ENGINE.GetItemAttrText(

4232: itemkey => p_itemkey,
4233: aname => G_WF_ATTR_USER_ID
4234: );
4235:
4236: l_wf_resp_id := WF_ENGINE.GetItemAttrText(
4237: itemtype => p_itemtype,
4238: itemkey => p_itemkey,
4239: aname => G_WF_ATTR_RESP_ID
4240: );

Line 4242: l_wf_batch_org_id := WF_ENGINE.GetItemAttrText(

4238: itemkey => p_itemkey,
4239: aname => G_WF_ATTR_RESP_ID
4240: );
4241:
4242: l_wf_batch_org_id := WF_ENGINE.GetItemAttrText(
4243: itemtype => p_itemtype,
4244: itemkey => p_itemkey,
4245: aname => 'OZF_BATCH_ORG_ID'
4246: );