DBA Data[Home] [Help]

APPS.OKE_DTS_WORKFLOW dependencies on OKE_DTS_WORKFLOW

Line 1: PACKAGE BODY OKE_DTS_WORKFLOW AS

1: PACKAGE BODY OKE_DTS_WORKFLOW AS
2: /* $Header: OKEDTSWB.pls 120.3 2008/03/25 09:12:27 serukull ship $ */
3:
4: Function Get_Location(P_Buy_Or_Sell Varchar2
5: , P_Direction Varchar2

Line 540: ( 'OKE_DTS_WORKFLOW'

536: , ItemKey => ItemKey
537: , AName => 'ERRORTEXT'
538: , AValue => sqlerrm );
539: WF_Core.Context
540: ( 'OKE_DTS_WORKFLOW'
541: , 'DUE_NTF_TO_SENT'
542: , ItemType
543: , ItemKey
544: , to_char(ActID)

Line 778: ( 'OKE_DTS_WORKFLOW'

774: , ItemKey => ItemKey
775: , AName => 'ERRORTEXT'
776: , AValue => sqlerrm );
777: WF_Core.Context
778: ( 'OKE_DTS_WORKFLOW'
779: , 'DUE_NTF_TO_SENT'
780: , ItemType
781: , ItemKey
782: , to_char(ActID)

Line 940: ( 'OKE_DTS_WORKFLOW'

936: , ItemKey => ItemKey
937: , AName => 'ERRORTEXT'
938: , AValue => sqlerrm );
939: WF_Core.Context
940: ( 'OKE_DTS_WORKFLOW'
941: , 'SELECT_DATE'
942: , ItemType
943: , ItemKey
944: , to_char(ActID)

Line 1049: ( 'OKE_DTS_WORKFLOW'

1045: , ItemKey => ItemKey
1046: , AName => 'ERRORTEXT'
1047: , AValue => sqlerrm );
1048: WF_Core.Context
1049: ( 'OKE_DTS_WORKFLOW'
1050: , 'READY_TO_SHIP'
1051: , ItemType
1052: , ItemKey
1053: , to_char(ActID)

Line 1101: ( 'OKE_DTS_WORKFLOW'

1097: , ItemKey => ItemKey
1098: , AName => 'ERRORTEXT'
1099: , AValue => sqlerrm );
1100: WF_Core.Context
1101: ( 'OKE_DTS_WORKFLOW'
1102: , 'READY_TO_SHIP'
1103: , ItemType
1104: , ItemKey
1105: , to_char(ActID)

Line 1209: ( 'OKE_DTS_WORKFLOW'

1205: , ItemKey => ItemKey
1206: , AName => 'ERRORTEXT'
1207: , AValue => sqlerrm );
1208: WF_Core.Context
1209: ( 'OKE_DTS_WORKFLOW'
1210: , 'READY_TO_CREATE_MDS'
1211: , ItemType
1212: , ItemKey
1213: , to_char(ActID)

Line 1261: ( 'OKE_DTS_WORKFLOW'

1257: , ItemKey => ItemKey
1258: , AName => 'ERRORTEXT'
1259: , AValue => sqlerrm );
1260: WF_Core.Context
1261: ( 'OKE_DTS_WORKFLOW'
1262: , 'READY_TO_CREATE_MDS'
1263: , ItemType
1264: , ItemKey
1265: , to_char(ActID)

Line 1341: ( 'OKE_DTS_WORKFLOW'

1337: , ItemKey => ItemKey
1338: , AName => 'ERRORTEXT'
1339: , AValue => sqlerrm );
1340: WF_Core.Context
1341: ( 'OKE_DTS_WORKFLOW'
1342: , 'READY_TO_PROCURE'
1343: , ItemType
1344: , ItemKey
1345: , to_char(ActID)

Line 1393: ( 'OKE_DTS_WORKFLOW'

1389: , ItemKey => ItemKey
1390: , AName => 'ERRORTEXT'
1391: , AValue => sqlerrm );
1392: WF_Core.Context
1393: ( 'OKE_DTS_WORKFLOW'
1394: , 'READY_TO_PROCURE'
1395: , ItemType
1396: , ItemKey
1397: , to_char(ActID)

Line 1599: ( 'OKE_DTS_WORKFLOW'

1595: , ItemKey => ItemKey
1596: , AName => 'ERRORTEXT'
1597: , AValue => sqlerrm );
1598: WF_Core.Context
1599: ( 'OKE_DTS_WORKFLOW'
1600: , 'LAUNCH_SHIP'
1601: , ItemType
1602: , ItemKey
1603: , to_char(ActID)

Line 1803: ( 'OKE_DTS_WORKFLOW'

1799: , ItemKey => ItemKey
1800: , AName => 'ERRORTEXT'
1801: , AValue => sqlerrm );
1802: WF_Core.Context
1803: ( 'OKE_DTS_WORKFLOW'
1804: , 'LAUNCH_PLAN'
1805: , ItemType
1806: , ItemKey
1807: , to_char(ActID)

Line 2009: ( 'OKE_DTS_WORKFLOW'

2005: , ItemKey => ItemKey
2006: , AName => 'ERRORTEXT'
2007: , AValue => sqlerrm );
2008: WF_Core.Context
2009: ( 'OKE_DTS_WORKFLOW'
2010: , 'LAUNCH_REQ'
2011: , ItemType
2012: , ItemKey
2013: , to_char(ActID)

Line 2078: ( 'OKE_DTS_WORKFLOW'

2074: , ItemKey => ItemKey
2075: , AName => 'ERRORTEXT'
2076: , AValue => sqlerrm );
2077: WF_Core.Context
2078: ( 'OKE_DTS_WORKFLOW'
2079: , 'READY_TO_COMPLETE'
2080: , ItemType
2081: , ItemKey
2082: , to_char(ActID)

Line 2165: ( 'OKE_DTS_WORKFLOW'

2161: , ItemKey => ItemKey
2162: , AName => 'ERRORTEXT'
2163: , AValue => sqlerrm );
2164: WF_Core.Context
2165: ( 'OKE_DTS_WORKFLOW'
2166: , 'REQ_EXISTED'
2167: , ItemType
2168: , ItemKey
2169: , to_char(ActID)

Line 2233: ( 'OKE_DTS_WORKFLOW'

2229: , ItemKey => ItemKey
2230: , AName => 'ERRORTEXT'
2231: , AValue => sqlerrm );
2232: WF_Core.Context
2233: ( 'OKE_DTS_WORKFLOW'
2234: , 'SHIP_EXISTED'
2235: , ItemType
2236: , ItemKey
2237: , to_char(ActID)

Line 2301: ( 'OKE_DTS_WORKFLOW'

2297: , ItemKey => ItemKey
2298: , AName => 'ERRORTEXT'
2299: , AValue => sqlerrm );
2300: WF_Core.Context
2301: ( 'OKE_DTS_WORKFLOW'
2302: , 'PLAN_EXISTED'
2303: , ItemType
2304: , ItemKey
2305: , to_char(ActID)

Line 2384: ( 'OKE_DTS_WORKFLOW'

2380: , ItemKey => ItemKey
2381: , AName => 'ERRORTEXT'
2382: , AValue => sqlerrm );
2383: WF_Core.Context
2384: ( 'OKE_DTS_WORKFLOW'
2385: , 'PERFORMER_EXISTED'
2386: , ItemType
2387: , ItemKey
2388: , to_char(ActID)

Line 2567: ( 'OKE_DTS_WORKFLOW'

2563: , ItemKey => ItemKey
2564: , AName => 'ERRORTEXT'
2565: , AValue => sqlerrm );
2566: WF_Core.Context
2567: ( 'OKE_DTS_WORKFLOW'
2568: , 'ELIGIBLE_TO_SEND'
2569: , ItemType
2570: , ItemKey
2571: , to_char(ActID)

Line 2625: ( 'OKE_DTS_WORKFLOW'

2621: , ItemKey => ItemKey
2622: , AName => 'ERRORTEXT'
2623: , AValue => sqlerrm );
2624: WF_Core.Context
2625: ( 'OKE_DTS_WORKFLOW'
2626: , 'LESS_THAN_TARGET_DATE'
2627: , ItemType
2628: , ItemKey
2629: , to_char(ActID)

Line 2636: END OKE_DTS_WORKFLOW;

2632: RAISE;
2633:
2634: END LESS_THAN_TARGET_DATE;
2635:
2636: END OKE_DTS_WORKFLOW;