[Home] [Help]
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:
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 );
133: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
134: END IF;
135:
136: -- R12 MOAC Enhancement (+)
137: l_batch_org_id := WF_ENGINE.GetItemAttrText(
138: itemtype => itemtype,
139: itemkey => itemkey,
140: aname => 'OZF_BATCH_ORG_ID'
141: );
161: -- R12 MOAC Enhancement (-)
162:
163: IF (funcmode = 'RUN') THEN
164: --
165: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
166: itemkey => itemkey,
167: aname => G_WF_ATTR_BATCH_ID);
168: IF OZF_DEBUG_LOW_ON THEN
169: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
169: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
170: END IF;
171:
172: IF l_batch_id IS NOT NULL THEN
173: l_batch_type := WF_ENGINE.GetItemAttrText (itemtype => itemType,
174: itemkey => itemKey,
175: aname => G_WF_ATTR_BATCH_TYPE);
176:
177: OPEN batch_status_csr(l_batch_id);
206: OZF_UTILITY_PVT.error_message('OZF_RESALE_BATCH_ID_NULL');
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209:
210: WF_ENGINE.SetItemAttrText(
211: itemtype => itemtype,
212: itemkey => itemkey ,
213: aname => G_WF_ATTR_BATCH_STATUS,
214: avalue => l_batch_return_status );
309: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);
310: END IF;
311:
312: -- R12 MOAC Enhancement (+)
313: l_batch_org_id := WF_ENGINE.GetItemAttrText(
314: itemtype => itemtype,
315: itemkey => itemkey,
316: aname => 'OZF_BATCH_ORG_ID'
317: );
437: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);
438: END IF;
439:
440: -- R12 MOAC Enhancement (+)
441: l_batch_org_id := WF_ENGINE.GetItemAttrText(
442: itemtype => itemtype,
443: itemkey => itemkey,
444: aname => 'OZF_BATCH_ORG_ID'
445: );
465: -- R12 MOAC Enhancement (-)
466:
467: IF (funcmode = 'RUN') THEN
468: --
469: l_batch_caller := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
470: itemkey => itemkey,
471: aname => G_WF_ATTR_BATCH_CALLER);
472:
473: IF l_batch_caller is NULL THEN
472:
473: IF l_batch_caller is NULL THEN
474: -- default caller to be UI
475: l_batch_caller := G_WF_LKUP_UI;
476: WF_ENGINE.SetItemAttrText(
477: itemtype => itemtype,
478: itemkey => itemkey ,
479: aname => G_WF_ATTR_BATCH_CALLER,
480: avalue => l_batch_caller);
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488:
489: -- SET attribute OZF_BATCH_NUM_W_DATE for event key
490: l_batch_number := WF_ENGINE.GetItemAttrText(
491: itemtype => itemtype,
492: itemkey => itemkey,
493: aname => G_WF_ATTR_BATCH_NUMBER
494: );
493: aname => G_WF_ATTR_BATCH_NUMBER
494: );
495: l_batch_num_w_date :='ResaleBatch:'||l_batch_number||'-'|| to_char(sysdate,'MM/DD/YYYY HH:MI:SS');
496:
497: WF_ENGINE.SetItemAttrText(
498: itemtype => itemtype,
499: itemkey => itemkey ,
500: aname => G_WF_ATTR_BATCH_NUM_W_DATE,
501: avalue => l_batch_num_w_date);
595: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);
596: END IF;
597:
598: -- R12 MOAC Enhancement (+)
599: l_batch_org_id := WF_ENGINE.GetItemAttrText(
600: itemtype => itemtype,
601: itemkey => itemkey,
602: aname => 'OZF_BATCH_ORG_ID'
603: );
623: -- R12 MOAC Enhancement (-)
624:
625: IF (funcmode = 'RUN') THEN
626: --
627: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
628: itemkey => itemkey,
629: aname => G_WF_ATTR_BATCH_ID);
630:
631: OPEN batch_status_csr(l_batch_id);
728: OZF_UTILITY_PVT.debug_message('IN ' || l_api_name || ' Funcmode: ' || funcmode);
729: END IF;
730:
731: -- R12 MOAC Enhancement (+)
732: l_batch_org_id := WF_ENGINE.GetItemAttrText(
733: itemtype => itemtype,
734: itemkey => itemkey,
735: aname => 'OZF_BATCH_ORG_ID'
736: );
756: -- R12 MOAC Enhancement (-)
757:
758: IF (funcmode = 'RUN') THEN
759: --
760: l_batch_type := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
761: itemkey => itemkey,
762: aname => G_WF_ATTR_BATCH_TYPE);
763:
764: IF l_batch_type NOT IN (G_WF_LKUP_CHARGEBACK, G_WF_LKUP_SPECIALPRICE, G_WF_LKUP_TRACING) OR
876: IF (funcmode = 'RUN') THEN
877: -- Clear the error stack for one time
878: FND_MSG_PUB.initialize;
879:
880: l_resale_batch_id := WF_ENGINE.GetItemAttrText(
881: itemtype => itemtype,
882: itemkey => itemkey,
883: aname => G_WF_ATTR_BATCH_ID
884: );
895: CLOSE batch_num_csr;
896:
897:
898:
899: WF_ENGINE.SetItemAttrText(
900: itemtype => itemtype,
901: itemkey => itemkey ,
902: aname => G_WF_ATTR_BATCH_NUMBER,
903: avalue => l_batch_number );
901: itemkey => itemkey ,
902: aname => G_WF_ATTR_BATCH_NUMBER,
903: avalue => l_batch_number );
904:
905: WF_ENGINE.SetItemAttrText(
906: itemtype => itemtype,
907: itemkey => itemkey ,
908: aname => G_WF_ATTR_BATCH_TYPE,
909: avalue => l_batch_type );
907: itemkey => itemkey ,
908: aname => G_WF_ATTR_BATCH_TYPE,
909: avalue => l_batch_type );
910:
911: WF_ENGINE.SetItemAttrText(
912: itemtype => itemtype,
913: itemkey => itemkey ,
914: aname => 'OZF_BATCH_ORG_ID',
915: avalue => l_batch_org_id
926: p_orig_system_id => l_emp_id ,
927: p_name => l_user_name,
928: p_display_name => l_display_name );
929:
930: WF_ENGINE.SetItemAttrText(
931: itemtype => itemtype,
932: itemkey => itemkey ,
933: aname => G_WF_ATTR_WF_ADMINISTRATOR,
934: avalue => l_user_name);
933: aname => G_WF_ATTR_WF_ADMINISTRATOR,
934: avalue => l_user_name);
935:
936: -- set workflow process owner
937: WF_ENGINE.SetItemOwner(
938: itemtype => itemtype,
939: itemkey => itemkey,
940: owner => l_user_name);
941: */
1030: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1031: END IF;
1032:
1033: -- R12 MOAC Enhancement (+)
1034: l_batch_org_id := WF_ENGINE.GetItemAttrText(
1035: itemtype => itemtype,
1036: itemkey => itemkey,
1037: aname => 'OZF_BATCH_ORG_ID'
1038: );
1058: -- R12 MOAC Enhancement (-)
1059:
1060: IF (funcmode = 'RUN') THEN
1061: --
1062: l_resale_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
1063: itemkey => itemkey,
1064: aname => G_WF_ATTR_BATCH_ID);
1065: OZF_RESALE_PVT.Initiate_Payment (
1066: p_api_version => 1.0
1166: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1167: END IF;
1168:
1169: -- R12 MOAC Enhancement (+)
1170: l_batch_org_id := WF_ENGINE.GetItemAttrText(
1171: itemtype => itemtype,
1172: itemkey => itemkey,
1173: aname => 'OZF_BATCH_ORG_ID'
1174: );
1194: -- R12 MOAC Enhancement (-)
1195:
1196: IF (funcmode = 'RUN') THEN
1197: --
1198: l_resale_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
1199: itemkey => itemkey,
1200: aname => G_WF_ATTR_BATCH_ID);
1201: OZF_CHARGEBACK_PVT.Initiate_Payment (
1202: p_api_version => 1.0
1298: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1299: END IF;
1300:
1301: -- R12 MOAC Enhancement (+)
1302: l_batch_org_id := WF_ENGINE.GetItemAttrText(
1303: itemtype => itemtype,
1304: itemkey => itemkey,
1305: aname => 'OZF_BATCH_ORG_ID'
1306: );
1326: -- R12 MOAC Enhancement (-)
1327:
1328: IF (funcmode = 'RUN') THEN
1329: --
1330: l_resale_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
1331: itemkey => itemkey,
1332: aname => G_WF_ATTR_BATCH_ID);
1333: OZF_SPECIAL_PRICING_PVT.Initiate_Payment (
1334: p_api_version => 1.0
1427: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1428: END IF;
1429: IF (funcmode = 'RUN') THEN
1430: --
1431: l_resale_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
1432: itemkey => itemkey,
1433: aname => G_WF_ATTR_BATCH_ID);
1434: OZF_TRACING_ORDER_PVT.Initiate_Payment (
1435: p_api_version => 1.0
1530: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1531: END IF;
1532:
1533: -- R12 MOAC Enhancement (+)
1534: l_batch_org_id := WF_ENGINE.GetItemAttrText(
1535: itemtype => itemtype,
1536: itemkey => itemkey,
1537: aname => 'OZF_BATCH_ORG_ID'
1538: );
1558: -- R12 MOAC Enhancement (-)
1559:
1560: IF (funcmode = 'RUN') THEN
1561: --
1562: l_resale_batch_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype,
1563: itemkey => itemkey,
1564: aname => G_WF_ATTR_BATCH_ID);
1565: OZF_CHARGEBACK_PVT.Process_Order(
1566: p_api_version => 1.0
1666: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1667: END IF;
1668:
1669: -- R12 MOAC Enhancement (+)
1670: l_batch_org_id := WF_ENGINE.GetItemAttrText(
1671: itemtype => itemtype,
1672: itemkey => itemkey,
1673: aname => 'OZF_BATCH_ORG_ID'
1674: );
1694: -- R12 MOAC Enhancement (-)
1695:
1696: IF (funcmode = 'RUN') THEN
1697: --
1698: l_resale_batch_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype,
1699: itemkey => itemkey,
1700: aname => G_WF_ATTR_BATCH_ID);
1701: OZF_RESALE_PVT.Process_Resale (
1702: p_api_version => 1
1798: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1799: END IF;
1800:
1801: -- R12 MOAC Enhancement (+)
1802: l_batch_org_id := WF_ENGINE.GetItemAttrText(
1803: itemtype => itemtype,
1804: itemkey => itemkey,
1805: aname => 'OZF_BATCH_ORG_ID'
1806: );
1826: -- R12 MOAC Enhancement (-)
1827:
1828: IF (funcmode = 'RUN') THEN
1829: --
1830: l_resale_batch_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype,
1831: itemkey => itemkey,
1832: aname => G_WF_ATTR_BATCH_ID);
1833: OZF_SPECIAL_PRICING_PVT.Process_Order(
1834: p_api_version => 1.0
1933: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
1934: END IF;
1935:
1936: -- R12 MOAC Enhancement (+)
1937: l_batch_org_id := WF_ENGINE.GetItemAttrText(
1938: itemtype => itemtype,
1939: itemkey => itemkey,
1940: aname => 'OZF_BATCH_ORG_ID'
1941: );
1961: -- R12 MOAC Enhancement (-)
1962:
1963: IF (funcmode = 'RUN') THEN
1964: --
1965: l_resale_batch_id := WF_ENGINE.GetItemAttrNumber(itemtype => itemtype,
1966: itemkey => itemkey,
1967: aname => G_WF_ATTR_BATCH_ID);
1968: OZF_TRACING_ORDER_PVT.Process_Order(
1969: p_api_version => 1.0
2077: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2078: END IF;
2079: IF (funcmode = 'RUN') THEN
2080: --
2081: l_resale_batch_id := WF_ENGINE.GetItemAttrText(
2082: itemtype => itemtype,
2083: itemkey => itemkey,
2084: aname => G_WF_ATTR_BATCH_ID
2085: );
2244: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2245: END IF;
2246:
2247: -- R12 MOAC Enhancement (+)
2248: l_batch_org_id := WF_ENGINE.GetItemAttrText(
2249: itemtype => itemtype,
2250: itemkey => itemkey,
2251: aname => 'OZF_BATCH_ORG_ID'
2252: );
2271: END IF;
2272: -- R12 MOAC Enhancement (-)
2273:
2274: IF (funcmode = 'RUN') THEN
2275: l_resale_batch_id := WF_ENGINE.GetItemAttrText(
2276: itemtype => itemtype,
2277: itemkey => itemkey,
2278: aname => G_WF_ATTR_BATCH_ID
2279: );
2294: p_name => l_user_name,
2295: p_display_name => l_display_name
2296: );
2297:
2298: WF_ENGINE.SetItemAttrText(
2299: itemtype => itemtype,
2300: itemkey => itemkey ,
2301: aname => G_WF_ATTR_WF_ADMINISTRATOR,
2302: avalue => l_user_name
2302: avalue => l_user_name
2303: );
2304:
2305: -- set workflow process owner
2306: WF_ENGINE.SetItemOwner(
2307: itemtype => itemtype,
2308: itemkey => itemkey,
2309: owner => l_user_name
2310: );
2427: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2428: END IF;
2429:
2430: -- R12 MOAC Enhancement (+)
2431: l_batch_org_id := WF_ENGINE.GetItemAttrText(
2432: itemtype => itemtype,
2433: itemkey => itemkey,
2434: aname => 'OZF_BATCH_ORG_ID'
2435: );
2455: -- R12 MOAC Enhancement (-)
2456:
2457: IF (funcmode = 'RUN') THEN
2458: --
2459: l_resale_batch_id := WF_ENGINE.GetItemAttrText(
2460: itemtype => itemtype,
2461: itemkey => itemkey,
2462: aname => G_WF_ATTR_BATCH_ID);
2463:
2614: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2615: END IF;
2616:
2617: -- R12 MOAC Enhancement (+)
2618: l_batch_org_id := WF_ENGINE.GetItemAttrText(
2619: itemtype => itemtype,
2620: itemkey => itemkey,
2621: aname => 'OZF_BATCH_ORG_ID'
2622: );
2642: -- R12 MOAC Enhancement (-)
2643:
2644: IF (funcmode = 'RUN') THEN
2645: --
2646: l_resale_batch_id := WF_ENGINE.GetItemAttrText(
2647: itemtype => itemtype,
2648: itemkey => itemkey,
2649: aname => G_WF_ATTR_BATCH_ID);
2650:
2801: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2802: END IF;
2803:
2804: -- R12 MOAC Enhancement (+)
2805: l_batch_org_id := WF_ENGINE.GetItemAttrText(
2806: itemtype => itemtype,
2807: itemkey => itemkey,
2808: aname => 'OZF_BATCH_ORG_ID'
2809: );
2829: -- R12 MOAC Enhancement (-)
2830:
2831: IF (funcmode = 'RUN') THEN
2832: --
2833: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
2834: itemkey => itemkey,
2835: aname => G_WF_ATTR_BATCH_ID);
2836:
2837: IF OZF_DEBUG_LOW_ON THEN
2947: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
2948: END IF;
2949:
2950: -- R12 MOAC Enhancement (+)
2951: l_batch_org_id := WF_ENGINE.GetItemAttrText(
2952: itemtype => itemtype,
2953: itemkey => itemkey,
2954: aname => 'OZF_BATCH_ORG_ID'
2955: );
2975: -- R12 MOAC Enhancement (-)
2976:
2977: IF (funcmode = 'RUN') THEN
2978: --
2979: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
2980: itemkey => itemkey,
2981: aname => G_WF_ATTR_BATCH_ID);
2982:
2983: IF OZF_DEBUG_LOW_ON THEN
3093: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
3094: END IF;
3095:
3096: -- R12 MOAC Enhancement (+)
3097: l_batch_org_id := WF_ENGINE.GetItemAttrText(
3098: itemtype => itemtype,
3099: itemkey => itemkey,
3100: aname => 'OZF_BATCH_ORG_ID'
3101: );
3121: -- R12 MOAC Enhancement (-)
3122:
3123: IF (funcmode = 'RUN') THEN
3124: --
3125: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
3126: itemkey => itemkey,
3127: aname => G_WF_ATTR_BATCH_ID);
3128: IF OZF_DEBUG_LOW_ON THEN
3129: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
3237: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
3238: END IF;
3239:
3240: -- R12 MOAC Enhancement (+)
3241: l_batch_org_id := WF_ENGINE.GetItemAttrText(
3242: itemtype => itemtype,
3243: itemkey => itemkey,
3244: aname => 'OZF_BATCH_ORG_ID'
3245: );
3265: -- R12 MOAC Enhancement (-)
3266:
3267: IF (funcmode = 'RUN') THEN
3268: --
3269: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
3270: itemkey => itemkey,
3271: aname => G_WF_ATTR_BATCH_ID);
3272: IF OZF_DEBUG_LOW_ON THEN
3273: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
3382: OZF_UTILITY_PVT.debug_message('IN: ' || l_api_name || ' Funcmode: ' || funcmode);
3383: END IF;
3384:
3385: -- R12 MOAC Enhancement (+)
3386: l_batch_org_id := WF_ENGINE.GetItemAttrText(
3387: itemtype => itemtype,
3388: itemkey => itemkey,
3389: aname => 'OZF_BATCH_ORG_ID'
3390: );
3410: -- R12 MOAC Enhancement (-)
3411:
3412: IF (funcmode = 'RUN') THEN
3413: --
3414: l_batch_id := WF_ENGINE.GetItemAttrText(itemtype => itemtype,
3415: itemkey => itemkey,
3416: aname => G_WF_ATTR_BATCH_ID);
3417: IF OZF_DEBUG_LOW_ON THEN
3418: OZF_UTILITY_PVT.debug_message('Batch ID '|| l_batch_id);
3548: l_batch_info.batch_number||'-'||
3549: TO_CHAR(sysdate, 'YYYY-MMDD-HH24MISS');
3550:
3551:
3552: WF_ENGINE.CreateProcess(
3553: itemType => l_itemtype,
3554: itemKey => l_itemkey,
3555: process => l_process
3556: );
3554: itemKey => l_itemkey,
3555: process => l_process
3556: );
3557:
3558: WF_ENGINE.SetItemUserKey(
3559: itemType => l_itemtype,
3560: itemKey => l_itemkey,
3561: userKey => l_itemuserkey
3562: );
3571: p_name => l_user_name,
3572: p_display_name => l_display_name
3573: );
3574:
3575: WF_ENGINE.SetItemOwner(
3576: itemtype => l_itemtype,
3577: itemkey => l_itemkey,
3578: owner => l_user_name
3579: );
3577: itemkey => l_itemkey,
3578: owner => l_user_name
3579: );
3580:
3581: WF_ENGINE.SetItemAttrText(
3582: itemtype => l_itemtype,
3583: itemkey => l_itemkey ,
3584: aname => 'OZF_RESALE_BATCH_ID',
3585: avalue => p_resale_batch_id
3584: aname => 'OZF_RESALE_BATCH_ID',
3585: avalue => p_resale_batch_id
3586: );
3587:
3588: WF_ENGINE.SetItemAttrText(
3589: itemtype => l_itemtype,
3590: itemkey => l_itemkey ,
3591: aname => 'WF_ADMINISTRATOR',
3592: avalue => l_user_name
3591: aname => 'WF_ADMINISTRATOR',
3592: avalue => l_user_name
3593: );
3594:
3595: WF_ENGINE.SetItemAttrText(
3596: itemtype => l_itemtype,
3597: itemkey => l_itemkey ,
3598: aname => 'OZF_RESALE_BATCH_CALLER',
3599: avalue => p_caller_type
3598: aname => 'OZF_RESALE_BATCH_CALLER',
3599: avalue => p_caller_type
3600: );
3601:
3602: WF_ENGINE.StartProcess(
3603: itemtype => l_itemtype,
3604: itemkey => l_itemkey
3605: );
3606:
3684: l_batch_info.batch_number||'-'||
3685: TO_CHAR(sysdate, 'YYYY-MMDD-HH24MISS');
3686:
3687:
3688: WF_ENGINE.CreateProcess(
3689: itemType => l_itemtype,
3690: itemKey => l_itemkey,
3691: process => l_process
3692: );
3690: itemKey => l_itemkey,
3691: process => l_process
3692: );
3693:
3694: WF_ENGINE.SetItemUserKey(
3695: itemType => l_itemtype,
3696: itemKey => l_itemkey,
3697: userKey => l_itemuserkey
3698: );
3707: p_name => l_user_name,
3708: p_display_name => l_display_name
3709: );
3710:
3711: WF_ENGINE.SetItemOwner(
3712: itemtype => l_itemtype,
3713: itemkey => l_itemkey,
3714: owner => l_user_name
3715: );
3713: itemkey => l_itemkey,
3714: owner => l_user_name
3715: );
3716:
3717: WF_ENGINE.SetItemAttrText(
3718: itemtype => l_itemtype,
3719: itemkey => l_itemkey ,
3720: aname => 'OZF_RESALE_BATCH_ID',
3721: avalue => p_resale_batch_id
3720: aname => 'OZF_RESALE_BATCH_ID',
3721: avalue => p_resale_batch_id
3722: );
3723:
3724: WF_ENGINE.SetItemAttrText(
3725: itemtype => l_itemtype,
3726: itemkey => l_itemkey ,
3727: aname => 'WF_ADMINISTRATOR',
3728: avalue => l_user_name
3727: aname => 'WF_ADMINISTRATOR',
3728: avalue => l_user_name
3729: );
3730:
3731: WF_ENGINE.SetItemAttrText(
3732: itemtype => l_itemtype,
3733: itemkey => l_itemkey ,
3734: aname => 'OZF_RESALE_BATCH_CALLER',
3735: avalue => p_caller_type
3734: aname => 'OZF_RESALE_BATCH_CALLER',
3735: avalue => p_caller_type
3736: );
3737:
3738: WF_ENGINE.StartProcess(
3739: itemtype => l_itemtype,
3740: itemkey => l_itemkey
3741: );
3742: