APPS.MSC_X_REPLENISH dependencies on WF_ENGINE

Line 650: wf_engine.ItemStatus

646:
647: -- abort previous unclosed Workflow process for this item/org/supplier
648: BEGIN
649: -- get the status of the previous open Workflow process
650: wf_engine.ItemStatus
651: ( itemtype => 'MSCXVMIR'
652: , itemkey => l_del_wf_key
653: , status => l_wf_status
654: , result => l_wf_result

Line 660: wf_engine.AbortProcess

656:
657: print_debug_info(' status of the above workflow process = ' || l_wf_status);
658: IF (l_wf_status = 'ACTIVE') THEN
659: print_debug_info(' abort the obsolete active workflow process');
660: wf_engine.AbortProcess
661: ( itemtype => 'MSCXVMIR'
662: , itemkey => l_del_wf_key
663: );
664: END IF;

Line 698: wf_engine.CreateProcess

694:
695: l_wf_process := 'STATUS_WORKFLOW1';
696:
697: -- create a Workflow process for the (item/org/supplier)
698: wf_engine.CreateProcess
699: ( itemtype => l_wf_type
700: , itemkey => l_wf_key
701: , process => l_wf_process
702: );

Line 704: wf_engine.SetItemAttrNumber

700: , itemkey => l_wf_key
701: , process => l_wf_process
702: );
703:
704: wf_engine.SetItemAttrNumber
705: ( itemtype => l_wf_type
706: , itemkey => l_wf_key
707: , aname => 'REPLENISH_TIME_FENCE'
708: , avalue => p_supplier_time_fence

Line 711: wf_engine.SetItemAttrNumber

707: , aname => 'REPLENISH_TIME_FENCE'
708: , avalue => p_supplier_time_fence
709: );
710:
711: wf_engine.SetItemAttrNumber
712: ( itemtype => l_wf_type
713: , itemkey => l_wf_key
714: , aname => 'INVENTORY_ITEM_ID'
715: , avalue => p_inventory_item_id

Line 718: wf_engine.SetItemAttrNumber

714: , aname => 'INVENTORY_ITEM_ID'
715: , avalue => p_inventory_item_id
716: );
717:
718: wf_engine.SetItemAttrNumber
719: ( itemtype => l_wf_type
720: , itemkey => l_wf_key
721: , aname => 'ORGANIZATION_ID'
722: , avalue => p_organization_id

Line 725: wf_engine.SetItemAttrNumber

721: , aname => 'ORGANIZATION_ID'
722: , avalue => p_organization_id
723: );
724:
725: wf_engine.SetItemAttrNumber
726: ( itemtype => l_wf_type
727: , itemkey => l_wf_key
728: , aname => 'PLAN_ID'
729: , avalue => p_plan_id

Line 732: wf_engine.SetItemAttrNumber

728: , aname => 'PLAN_ID'
729: , avalue => p_plan_id
730: );
731:
732: wf_engine.SetItemAttrNumber
733: ( itemtype => l_wf_type
734: , itemkey => l_wf_key
735: , aname => 'SR_INSTANCE_ID'
736: , avalue => p_sr_instance_id

Line 739: wf_engine.SetItemAttrNumber

735: , aname => 'SR_INSTANCE_ID'
736: , avalue => p_sr_instance_id
737: );
738:
739: wf_engine.SetItemAttrNumber
740: ( itemtype => l_wf_type
741: , itemkey => l_wf_key
742: , aname => 'SUPPLIER_ID'
743: , avalue => p_supplier_id

Line 746: wf_engine.SetItemAttrNumber

742: , aname => 'SUPPLIER_ID'
743: , avalue => p_supplier_id
744: );
745:
746: wf_engine.SetItemAttrNumber
747: ( itemtype => l_wf_type
748: , itemkey => l_wf_key
749: , aname => 'SUPPLIER_SITE_ID'
750: , avalue => p_supplier_site_id

Line 753: wf_engine.SetItemAttrNumber

749: , aname => 'SUPPLIER_SITE_ID'
750: , avalue => p_supplier_site_id
751: );
752:
753: wf_engine.SetItemAttrNumber
754: ( itemtype => l_wf_type
755: , itemkey => l_wf_key
756: , aname => 'REP_TRANSACTION_ID'
757: , avalue => l_rep_transaction_id

Line 760: wf_engine.SetItemAttrNumber

756: , aname => 'REP_TRANSACTION_ID'
757: , avalue => l_rep_transaction_id
758: );
759:
760: wf_engine.SetItemAttrNumber
761: ( itemtype => l_wf_type
762: , itemkey => l_wf_key
763: , aname => 'SCE_ORGANIZATION_ID'
764: , avalue => l_sce_organization_id

Line 767: wf_engine.SetItemAttrNumber

763: , aname => 'SCE_ORGANIZATION_ID'
764: , avalue => l_sce_organization_id
765: );
766:
767: wf_engine.SetItemAttrNumber
768: ( itemtype => l_wf_type
769: , itemkey => l_wf_key
770: , aname => 'SCE_SUPPLIER_SITE_ID'
771: , avalue => l_sce_supplier_site_id

Line 774: wf_engine.SetItemAttrNumber

770: , aname => 'SCE_SUPPLIER_SITE_ID'
771: , avalue => l_sce_supplier_site_id
772: );
773:
774: wf_engine.SetItemAttrNumber
775: ( itemtype => l_wf_type
776: , itemkey => l_wf_key
777: , aname => 'SCE_SUPPLIER_ID'
778: , avalue => l_sce_supplier_id

Line 964: wf_engine.SetItemAttrText

960: || '/' || l_supplier_name
961: || '/' || l_supplier_site_name
962: );
963:
964: wf_engine.SetItemAttrText
965: ( itemtype => l_wf_type
966: , itemkey => l_wf_key
967: , aname => 'SELLER_ROLE'
968: , avalue => l_seller_role_name

Line 971: wf_engine.SetItemAttrText

967: , aname => 'SELLER_ROLE'
968: , avalue => l_seller_role_name
969: );
970:
971: wf_engine.SetItemAttrText
972: ( itemtype => l_wf_type
973: , itemkey => l_wf_key
974: , aname => 'BUYER_ROLE'
975: , avalue => l_buyer_name

Line 978: wf_engine.SetItemAttrText

974: , aname => 'BUYER_ROLE'
975: , avalue => l_buyer_name
976: );
977:
978: wf_engine.SetItemAttrText
979: ( itemtype => l_wf_type
980: , itemkey => l_wf_key
981: , aname => 'CUSTOMER_ITEM_NAME'
982: , avalue => l_customer_item_name

Line 985: wf_engine.SetItemAttrText

981: , aname => 'CUSTOMER_ITEM_NAME'
982: , avalue => l_customer_item_name
983: );
984:
985: wf_engine.SetItemAttrText
986: ( itemtype => l_wf_type
987: , itemkey => l_wf_key
988: , aname => 'CUSTOMER_NAME'
989: , avalue => l_customer_name

Line 992: wf_engine.SetItemAttrText

988: , aname => 'CUSTOMER_NAME'
989: , avalue => l_customer_name
990: );
991:
992: wf_engine.SetItemAttrText
993: ( itemtype => l_wf_type
994: , itemkey => l_wf_key
995: , aname => 'CUSTOMER_SITE_NAME'
996: , avalue => l_customer_site_name

Line 999: wf_engine.SetItemAttrText

995: , aname => 'CUSTOMER_SITE_NAME'
996: , avalue => l_customer_site_name
997: );
998:
999: wf_engine.SetItemAttrText
1000: ( itemtype => l_wf_type
1001: , itemkey => l_wf_key
1002: , aname => 'SUPPLIER_NAME'
1003: , avalue => l_supplier_name

Line 1006: wf_engine.SetItemAttrText

1002: , aname => 'SUPPLIER_NAME'
1003: , avalue => l_supplier_name
1004: );
1005:
1006: wf_engine.SetItemAttrText
1007: ( itemtype => l_wf_type
1008: , itemkey => l_wf_key
1009: , aname => 'SUPPLIER_SITE_NAME'
1010: , avalue => l_supplier_site_name

Line 1016: wf_engine.StartProcess

1012:
1013: print_debug_info(' start workflow process');
1014:
1015: -- start Workflow process for item/org/supplier
1016: wf_engine.StartProcess
1017: ( itemtype => l_wf_type
1018: , itemkey => l_wf_key
1019: );
1020: END IF; -- end else delete old repl record

Line 1089: wf_engine.GetItemAttrNumber

1085: lv_instance_id number;
1086: l_offset_days number;
1087:
1088: l_replenish_time_fence NUMBER :=
1089: wf_engine.GetItemAttrNumber
1090: ( itemtype => itemtype
1091: , itemkey => itemkey
1092: , aname => 'REPLENISH_TIME_FENCE'
1093: );

Line 1096: wf_engine.GetItemAttrNumber

1092: , aname => 'REPLENISH_TIME_FENCE'
1093: );
1094:
1095: l_auto_release_flag NUMBER :=
1096: wf_engine.GetItemAttrNumber
1097: ( itemtype => itemtype
1098: , itemkey => itemkey
1099: , aname => 'AUTO_RELEASE_FLAG'
1100: );

Line 1103: wf_engine.GetItemAttrNumber

1099: , aname => 'AUTO_RELEASE_FLAG'
1100: );
1101:
1102: l_inventory_item_id NUMBER :=
1103: wf_engine.GetItemAttrNumber
1104: ( itemtype => itemtype
1105: , itemkey => itemkey
1106: , aname => 'INVENTORY_ITEM_ID'
1107: );

Line 1110: wf_engine.GetItemAttrNumber

1106: , aname => 'INVENTORY_ITEM_ID'
1107: );
1108:
1109: l_organization_id NUMBER :=
1110: wf_engine.GetItemAttrNumber
1111: ( itemtype => itemtype
1112: , itemkey => itemkey
1113: , aname => 'ORGANIZATION_ID'
1114: );

Line 1117: wf_engine.GetItemAttrNumber

1113: , aname => 'ORGANIZATION_ID'
1114: );
1115:
1116: l_plan_id NUMBER :=
1117: wf_engine.GetItemAttrNumber
1118: ( itemtype => itemtype
1119: , itemkey => itemkey
1120: , aname => 'PLAN_ID'
1121: );

Line 1124: wf_engine.GetItemAttrNumber

1120: , aname => 'PLAN_ID'
1121: );
1122:
1123: l_sr_instance_id NUMBER :=
1124: wf_engine.GetItemAttrNumber
1125: ( itemtype => itemtype
1126: , itemkey => itemkey
1127: , aname => 'SR_INSTANCE_ID'
1128: );

Line 1131: wf_engine.GetItemAttrNumber

1127: , aname => 'SR_INSTANCE_ID'
1128: );
1129:
1130: l_supplier_id NUMBER :=
1131: wf_engine.GetItemAttrNumber
1132: ( itemtype => itemtype
1133: , itemkey => itemkey
1134: , aname => 'SUPPLIER_ID'
1135: );

Line 1138: wf_engine.GetItemAttrNumber

1134: , aname => 'SUPPLIER_ID'
1135: );
1136:
1137: l_supplier_site_id NUMBER :=
1138: wf_engine.GetItemAttrNumber
1139: ( itemtype => itemtype
1140: , itemkey => itemkey
1141: , aname => 'SUPPLIER_SITE_ID'
1142: );

Line 1145: wf_engine.GetItemAttrNumber

1141: , aname => 'SUPPLIER_SITE_ID'
1142: );
1143:
1144: l_sce_organization_id NUMBER :=
1145: wf_engine.GetItemAttrNumber
1146: ( itemtype => itemtype
1147: , itemkey => itemkey
1148: , aname => 'SCE_ORGANIZATION_ID'
1149: );

Line 1152: wf_engine.GetItemAttrNumber

1148: , aname => 'SCE_ORGANIZATION_ID'
1149: );
1150:
1151: l_sce_supplier_site_id NUMBER :=
1152: wf_engine.GetItemAttrNumber
1153: ( itemtype => itemtype
1154: , itemkey => itemkey
1155: , aname => 'SCE_SUPPLIER_SITE_ID'
1156: );

Line 1159: wf_engine.GetItemAttrNumber

1155: , aname => 'SCE_SUPPLIER_SITE_ID'
1156: );
1157:
1158: l_sce_supplier_id NUMBER :=
1159: wf_engine.GetItemAttrNumber
1160: ( itemtype => itemtype
1161: , itemkey => itemkey
1162: , aname => 'SCE_SUPPLIER_ID'
1163: );

Line 1166: wf_engine.GetItemAttrText

1162: , aname => 'SCE_SUPPLIER_ID'
1163: );
1164:
1165: l_customer_item_name VARCHAR2(100) :=
1166: wf_engine.GetItemAttrText
1167: ( itemtype => itemtype
1168: , itemkey => itemkey
1169: , aname => 'CUSTOMER_ITEM_NAME'
1170: );

Line 1173: wf_engine.GetItemAttrText

1169: , aname => 'CUSTOMER_ITEM_NAME'
1170: );
1171:
1172: l_customer_name VARCHAR2(100) :=
1173: wf_engine.GetItemAttrText
1174: ( itemtype => itemtype
1175: , itemkey => itemkey
1176: , aname => 'CUSTOMER_NAME'
1177: );

Line 1180: wf_engine.GetItemAttrText

1176: , aname => 'CUSTOMER_NAME'
1177: );
1178:
1179: l_customer_site_name VARCHAR2(100) :=
1180: wf_engine.GetItemAttrText
1181: ( itemtype => itemtype
1182: , itemkey => itemkey
1183: , aname => 'CUSTOMER_SITE_NAME'
1184: );

Line 1187: wf_engine.GetItemAttrText

1183: , aname => 'CUSTOMER_SITE_NAME'
1184: );
1185:
1186: l_supplier_name VARCHAR2(100) :=
1187: wf_engine.GetItemAttrText
1188: ( itemtype => itemtype
1189: , itemkey => itemkey
1190: , aname => 'SUPPLIER_NAME'
1191: );

Line 1194: wf_engine.GetItemAttrText

1190: , aname => 'SUPPLIER_NAME'
1191: );
1192:
1193: l_supplier_site_name VARCHAR2(100) :=
1194: wf_engine.GetItemAttrText
1195: ( itemtype => itemtype
1196: , itemkey => itemkey
1197: , aname => 'SUPPLIER_SITE_NAME'
1198: );

Line 1201: wf_engine.GetItemAttrNumber

1197: , aname => 'SUPPLIER_SITE_NAME'
1198: );
1199:
1200: l_rep_transaction_id NUMBER :=
1201: wf_engine.GetItemAttrNumber
1202: ( itemtype => itemtype
1203: , itemkey => itemkey
1204: , aname => 'REP_TRANSACTION_ID'
1205: );

Line 1435: wf_engine.SetItemAttrText

1431: CLOSE c_item_name;
1432:
1433: print_user_info(' item name/item description = ' || l_item_name || '/' ||l_item_description);
1434:
1435: wf_engine.SetItemAttrText
1436: ( itemtype => itemtype
1437: , itemkey => itemkey
1438: , aname => 'ITEM_NAME'
1439: , avalue => l_item_name

Line 1442: wf_engine.SetItemAttrText

1438: , aname => 'ITEM_NAME'
1439: , avalue => l_item_name
1440: );
1441:
1442: wf_engine.SetItemAttrText
1443: ( itemtype => itemtype
1444: , itemkey => itemkey
1445: , aname => 'ITEM_DESCRIPTION'
1446: , avalue => l_item_description

Line 1461: wf_engine.SetItemAttrText

1457: );
1458: FETCH c_supplier_item_name INTO l_supplier_item_name;
1459: CLOSE c_supplier_item_name;
1460:
1461: wf_engine.SetItemAttrText
1462: ( itemtype => itemtype
1463: , itemkey => itemkey
1464: , aname => 'SUPPLIER_ITEM_NAME'
1465: , avalue => l_supplier_item_name

Line 1940: wf_engine.ItemStatus

1936:
1937: -- abort previous unclosed Workflow process for this item/org/supplier
1938: BEGIN
1939: -- get the status of the previous open Workflow process
1940: wf_engine.ItemStatus
1941: ( itemtype => 'MSCXVMIR'
1942: , itemkey => l_old_wf_key
1943: , status => l_wf_status
1944: , result => l_wf_result

Line 1950: wf_engine.AbortProcess

1946:
1947: print_debug_info(' status of old workflow process = ' || l_wf_status);
1948: IF (l_wf_status = 'ACTIVE') THEN
1949: print_debug_info(' abort old workflow process');
1950: wf_engine.AbortProcess
1951: ( itemtype => 'MSCXVMIR'
1952: , itemkey => l_old_wf_key
1953: );
1954: END IF;

Line 2011: wf_engine.SetItemAttrNumber

2007: END IF; -- IF (l_replenishment_row <> 0)
2008:
2009: print_debug_info(' set workflow item attributes');
2010:
2011: wf_engine.SetItemAttrNumber
2012: ( itemtype => itemtype
2013: , itemkey => itemkey
2014: , aname => 'ORDER_QUANTITY'
2015: , avalue => l_order_quantity

Line 2018: wf_engine.SetItemAttrNumber

2014: , aname => 'ORDER_QUANTITY'
2015: , avalue => l_order_quantity
2016: );
2017:
2018: wf_engine.SetItemAttrNumber
2019: ( itemtype => itemtype
2020: , itemkey => itemkey
2021: , aname => 'ALLOCATED_ONHAND_QUANTITY'
2022: , avalue => l_allocated_onhand_quantity

Line 2025: wf_engine.SetItemAttrNumber

2021: , aname => 'ALLOCATED_ONHAND_QUANTITY'
2022: , avalue => l_allocated_onhand_quantity
2023: );
2024:
2025: wf_engine.SetItemAttrNumber
2026: ( itemtype => itemtype
2027: , itemkey => itemkey
2028: , aname => 'MIN_MINMAX_QUANTITY'
2029: , avalue => l_min_minmax_quantity

Line 2032: wf_engine.SetItemAttrNumber

2028: , aname => 'MIN_MINMAX_QUANTITY'
2029: , avalue => l_min_minmax_quantity
2030: );
2031:
2032: wf_engine.SetItemAttrNumber
2033: ( itemtype => itemtype
2034: , itemkey => itemkey
2035: , aname => 'MAX_MINMAX_QUANTITY'
2036: , avalue => l_max_minmax_quantity

Line 2039: wf_engine.SetItemAttrText

2035: , aname => 'MAX_MINMAX_QUANTITY'
2036: , avalue => l_max_minmax_quantity
2037: );
2038:
2039: wf_engine.SetItemAttrText
2040: ( itemtype => itemtype
2041: , itemkey => itemkey
2042: , aname => 'CUSTOMER_UOM_CODE'
2043: , avalue => l_customer_uom_code

Line 2051: wf_engine.AbortProcess

2047: -- abort the Workflow process
2048: ELSE
2049: -- ELSIF (l_supply_shortage <= 0) THEN
2050: print_debug_info(' no supply shortage, abort the current workflow process');
2051: wf_engine.AbortProcess
2052: ( itemtype => itemtype
2053: , itemkey => itemkey
2054: );
2055:

Line 2146: wf_engine.GetItemAttrNumber

2142: l_instance_code VARCHAR2(100);
2143: l_a2m_dblink VARCHAR2(100);
2144:
2145: l_replenish_time_fence NUMBER :=
2146: wf_engine.GetItemAttrNumber
2147: ( itemtype => itemtype
2148: , itemkey => itemkey
2149: , aname => 'REPLENISH_TIME_FENCE'
2150: );

Line 2153: wf_engine.GetItemAttrNumber

2149: , aname => 'REPLENISH_TIME_FENCE'
2150: );
2151:
2152: l_auto_release_flag NUMBER :=
2153: wf_engine.GetItemAttrNumber
2154: ( itemtype => itemtype
2155: , itemkey => itemkey
2156: , aname => 'AUTO_RELEASE_FLAG'
2157: );

Line 2160: wf_engine.GetItemAttrNumber

2156: , aname => 'AUTO_RELEASE_FLAG'
2157: );
2158:
2159: l_inventory_item_id NUMBER :=
2160: wf_engine.GetItemAttrNumber
2161: ( itemtype => itemtype
2162: , itemkey => itemkey
2163: , aname => 'INVENTORY_ITEM_ID'
2164: );

Line 2167: wf_engine.GetItemAttrNumber

2163: , aname => 'INVENTORY_ITEM_ID'
2164: );
2165:
2166: l_organization_id NUMBER :=
2167: wf_engine.GetItemAttrNumber
2168: ( itemtype => itemtype
2169: , itemkey => itemkey
2170: , aname => 'ORGANIZATION_ID'
2171: );

Line 2174: wf_engine.GetItemAttrNumber

2170: , aname => 'ORGANIZATION_ID'
2171: );
2172:
2173: l_plan_id NUMBER :=
2174: wf_engine.GetItemAttrNumber
2175: ( itemtype => itemtype
2176: , itemkey => itemkey
2177: , aname => 'PLAN_ID'
2178: );

Line 2181: wf_engine.GetItemAttrNumber

2177: , aname => 'PLAN_ID'
2178: );
2179:
2180: l_sr_instance_id NUMBER :=
2181: wf_engine.GetItemAttrNumber
2182: ( itemtype => itemtype
2183: , itemkey => itemkey
2184: , aname => 'SR_INSTANCE_ID'
2185: );

Line 2188: wf_engine.GetItemAttrNumber

2184: , aname => 'SR_INSTANCE_ID'
2185: );
2186:
2187: l_supplier_site_id NUMBER :=
2188: wf_engine.GetItemAttrNumber
2189: ( itemtype => itemtype
2190: , itemkey => itemkey
2191: , aname => 'SUPPLIER_SITE_ID'
2192: );

Line 2195: wf_engine.GetItemAttrNumber

2191: , aname => 'SUPPLIER_SITE_ID'
2192: );
2193:
2194: l_supplier_id NUMBER :=
2195: wf_engine.GetItemAttrNumber
2196: ( itemtype => itemtype
2197: , itemkey => itemkey
2198: , aname => 'SUPPLIER_ID'
2199: );

Line 2202: wf_engine.GetItemAttrNumber

2198: , aname => 'SUPPLIER_ID'
2199: );
2200:
2201: l_order_quantity NUMBER :=
2202: wf_engine.GetItemAttrNumber
2203: ( itemtype => itemtype
2204: , itemkey => itemkey
2205: , aname => 'ORDER_QUANTITY'
2206: );

Line 2209: wf_engine.GetItemAttrText

2205: , aname => 'ORDER_QUANTITY'
2206: );
2207:
2208: l_customer_uom_code VARCHAR2(100) :=
2209: wf_engine.GetItemAttrText
2210: ( itemtype => itemtype
2211: , itemkey => itemkey
2212: , aname => 'CUSTOMER_UOM_CODE'
2213: );

Line 2216: wf_engine.GetItemAttrNumber

2212: , aname => 'CUSTOMER_UOM_CODE'
2213: );
2214:
2215: l_rep_transaction_id NUMBER :=
2216: wf_engine.GetItemAttrNumber
2217: ( itemtype => itemtype
2218: , itemkey => itemkey
2219: , aname => 'REP_TRANSACTION_ID'
2220: );

Line 2223: wf_engine.GetItemAttrNumber

2219: , aname => 'REP_TRANSACTION_ID'
2220: );
2221:
2222: l_sce_supplier_site_id NUMBER :=
2223: wf_engine.GetItemAttrNumber
2224: ( itemtype => itemtype
2225: , itemkey => itemkey
2226: , aname => 'SCE_SUPPLIER_SITE_ID'
2227: );

Line 2230: wf_engine.GetItemAttrNumber

2226: , aname => 'SCE_SUPPLIER_SITE_ID'
2227: );
2228:
2229: l_sce_supplier_id NUMBER :=
2230: wf_engine.GetItemAttrNumber
2231: ( itemtype => itemtype
2232: , itemkey => itemkey
2233: , aname => 'SCE_SUPPLIER_ID'
2234: );

Line 2237: wf_engine.GetItemAttrNumber

2233: , aname => 'SCE_SUPPLIER_ID'
2234: );
2235:
2236: l_sce_organization_id NUMBER :=
2237: wf_engine.GetItemAttrNumber
2238: ( itemtype => itemtype
2239: , itemkey => itemkey
2240: , aname => 'SCE_ORGANIZATION_ID'
2241: );

Line 2669: wf_engine.GetItemAttrNumber

2665:
2666: l_vmi_replenishment_approval VARCHAR2(30);
2667:
2668: l_inventory_item_id NUMBER :=
2669: wf_engine.GetItemAttrNumber
2670: ( itemtype => itemtype
2671: , itemkey => itemkey
2672: , aname => 'INVENTORY_ITEM_ID'
2673: );

Line 2676: wf_engine.GetItemAttrNumber

2672: , aname => 'INVENTORY_ITEM_ID'
2673: );
2674:
2675: l_organization_id NUMBER :=
2676: wf_engine.GetItemAttrNumber
2677: ( itemtype => itemtype
2678: , itemkey => itemkey
2679: , aname => 'ORGANIZATION_ID'
2680: );

Line 2683: wf_engine.GetItemAttrNumber

2679: , aname => 'ORGANIZATION_ID'
2680: );
2681:
2682: l_plan_id NUMBER :=
2683: wf_engine.GetItemAttrNumber
2684: ( itemtype => itemtype
2685: , itemkey => itemkey
2686: , aname => 'PLAN_ID'
2687: );

Line 2690: wf_engine.GetItemAttrNumber

2686: , aname => 'PLAN_ID'
2687: );
2688:
2689: l_sr_instance_id NUMBER :=
2690: wf_engine.GetItemAttrNumber
2691: ( itemtype => itemtype
2692: , itemkey => itemkey
2693: , aname => 'SR_INSTANCE_ID'
2694: );

Line 2697: wf_engine.GetItemAttrNumber

2693: , aname => 'SR_INSTANCE_ID'
2694: );
2695:
2696: l_supplier_site_id NUMBER :=
2697: wf_engine.GetItemAttrNumber
2698: ( itemtype => itemtype
2699: , itemkey => itemkey
2700: , aname => 'SUPPLIER_SITE_ID'
2701: );

Line 2704: wf_engine.GetItemAttrNumber

2700: , aname => 'SUPPLIER_SITE_ID'
2701: );
2702:
2703: l_supplier_id NUMBER :=
2704: wf_engine.GetItemAttrNumber
2705: ( itemtype => itemtype
2706: , itemkey => itemkey
2707: , aname => 'SUPPLIER_ID'
2708: );

Line 2771: wf_engine.GetItemAttrNumber

2767:
2768: l_vmi_replenishment_approval VARCHAR2(30);
2769:
2770: l_inventory_item_id NUMBER :=
2771: wf_engine.GetItemAttrNumber
2772: ( itemtype => itemtype
2773: , itemkey => itemkey
2774: , aname => 'INVENTORY_ITEM_ID'
2775: );

Line 2778: wf_engine.GetItemAttrNumber

2774: , aname => 'INVENTORY_ITEM_ID'
2775: );
2776:
2777: l_organization_id NUMBER :=
2778: wf_engine.GetItemAttrNumber
2779: ( itemtype => itemtype
2780: , itemkey => itemkey
2781: , aname => 'ORGANIZATION_ID'
2782: );

Line 2785: wf_engine.GetItemAttrNumber

2781: , aname => 'ORGANIZATION_ID'
2782: );
2783:
2784: l_plan_id NUMBER :=
2785: wf_engine.GetItemAttrNumber
2786: ( itemtype => itemtype
2787: , itemkey => itemkey
2788: , aname => 'PLAN_ID'
2789: );

Line 2792: wf_engine.GetItemAttrNumber

2788: , aname => 'PLAN_ID'
2789: );
2790:
2791: l_sr_instance_id NUMBER :=
2792: wf_engine.GetItemAttrNumber
2793: ( itemtype => itemtype
2794: , itemkey => itemkey
2795: , aname => 'SR_INSTANCE_ID'
2796: );

Line 2799: wf_engine.GetItemAttrNumber

2795: , aname => 'SR_INSTANCE_ID'
2796: );
2797:
2798: l_supplier_site_id NUMBER :=
2799: wf_engine.GetItemAttrNumber
2800: ( itemtype => itemtype
2801: , itemkey => itemkey
2802: , aname => 'SUPPLIER_SITE_ID'
2803: );

Line 2806: wf_engine.GetItemAttrNumber

2802: , aname => 'SUPPLIER_SITE_ID'
2803: );
2804:
2805: l_supplier_id NUMBER :=
2806: wf_engine.GetItemAttrNumber
2807: ( itemtype => itemtype
2808: , itemkey => itemkey
2809: , aname => 'SUPPLIER_ID'
2810: );

Line 2869: l_inventory_item_id NUMBER := wf_engine.GetItemAttrNumber

2865: , actid in number
2866: , funcmode in varchar2
2867: , resultout out nocopy varchar2
2868: ) IS
2869: l_inventory_item_id NUMBER := wf_engine.GetItemAttrNumber
2870: ( itemtype => itemtype
2871: , itemkey => itemkey
2872: , aname => 'INVENTORY_ITEM_ID'
2873: );

Line 2874: l_organization_id NUMBER := wf_engine.GetItemAttrNumber

2870: ( itemtype => itemtype
2871: , itemkey => itemkey
2872: , aname => 'INVENTORY_ITEM_ID'
2873: );
2874: l_organization_id NUMBER := wf_engine.GetItemAttrNumber
2875: ( itemtype => itemtype
2876: , itemkey => itemkey
2877: , aname => 'ORGANIZATION_ID'
2878: );

Line 2879: l_plan_id NUMBER := wf_engine.GetItemAttrNumber

2875: ( itemtype => itemtype
2876: , itemkey => itemkey
2877: , aname => 'ORGANIZATION_ID'
2878: );
2879: l_plan_id NUMBER := wf_engine.GetItemAttrNumber
2880: ( itemtype => itemtype
2881: , itemkey => itemkey
2882: , aname => 'PLAN_ID'
2883: );

Line 2884: l_sr_instance_id NUMBER := wf_engine.GetItemAttrNumber

2880: ( itemtype => itemtype
2881: , itemkey => itemkey
2882: , aname => 'PLAN_ID'
2883: );
2884: l_sr_instance_id NUMBER := wf_engine.GetItemAttrNumber
2885: ( itemtype => itemtype
2886: , itemkey => itemkey
2887: , aname => 'SR_INSTANCE_ID'
2888: );

Line 2889: l_sce_supplier_site_id NUMBER := wf_engine.GetItemAttrNumber

2885: ( itemtype => itemtype
2886: , itemkey => itemkey
2887: , aname => 'SR_INSTANCE_ID'
2888: );
2889: l_sce_supplier_site_id NUMBER := wf_engine.GetItemAttrNumber
2890: ( itemtype => itemtype
2891: , itemkey => itemkey
2892: , aname => 'SCE_SUPPLIER_SITE_ID'
2893: );

Line 2895: l_sce_supplier_id NUMBER := wf_engine.GetItemAttrNumber

2891: , itemkey => itemkey
2892: , aname => 'SCE_SUPPLIER_SITE_ID'
2893: );
2894:
2895: l_sce_supplier_id NUMBER := wf_engine.GetItemAttrNumber
2896: ( itemtype => itemtype
2897: , itemkey => itemkey
2898: , aname => 'SCE_SUPPLIER_ID'
2899: );

Line 2900: l_sce_organization_id NUMBER := wf_engine.GetItemAttrNumber

2896: ( itemtype => itemtype
2897: , itemkey => itemkey
2898: , aname => 'SCE_SUPPLIER_ID'
2899: );
2900: l_sce_organization_id NUMBER := wf_engine.GetItemAttrNumber
2901: ( itemtype => itemtype
2902: , itemkey => itemkey
2903: , aname => 'SCE_ORGANIZATION_ID'
2904: );

Line 2906: l_req_transaction_id NUMBER := wf_engine.GetItemAttrNumber

2902: , itemkey => itemkey
2903: , aname => 'SCE_ORGANIZATION_ID'
2904: );
2905: /*
2906: l_req_transaction_id NUMBER := wf_engine.GetItemAttrNumber
2907: ( itemtype => itemtype
2908: , itemkey => itemkey
2909: , aname => 'REQ_TRANSACTION_ID'
2910: );

Line 2912: l_rep_transaction_id NUMBER := wf_engine.GetItemAttrNumber

2908: , itemkey => itemkey
2909: , aname => 'REQ_TRANSACTION_ID'
2910: );
2911: */
2912: l_rep_transaction_id NUMBER := wf_engine.GetItemAttrNumber
2913: ( itemtype => itemtype
2914: , itemkey => itemkey
2915: , aname => 'REP_TRANSACTION_ID'
2916: );