[Home] [Help]
1: PACKAGE BODY WMS_RULE_7 AS
2:
3: PROCEDURE open_curs (
4: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_put_type,
5: p_organization_id IN NUMBER,
6: p_inventory_item_id IN NUMBER,
7: p_transaction_type_id IN NUMBER,
8: p_subinventory_code IN VARCHAR2,
161: and base.INVENTORY_ITEM_ID = g_inventory_item_id
162: and (g_project_id = base.project_id OR base.project_id IS NULL)
163: and (g_task_id = base.task_id OR base.task_id IS NULL)
164: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
165: and Wms_Rule_Pvt.Match_Planning_Group(base.ORGANIZATION_ID,base.locator_id, g_project_id, mptdtv.project_id, mptdtv.task_id,g_transaction_type_id,g_inventory_item_id,base.project_id,base.task_id) = 1
166: and (
167: WMS_Parameter_PVT.GetTotalOnHand(
168: base.ORGANIZATION_ID
169: ,base.SUBINVENTORY_CODE
287: and base.INVENTORY_ITEM_ID = g_inventory_item_id
288: and (g_project_id = base.project_id OR base.project_id IS NULL)
289: and (g_task_id = base.task_id OR base.task_id IS NULL)
290: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
291: and Wms_Rule_Pvt.Match_Planning_Group(base.ORGANIZATION_ID,base.locator_id, g_project_id, mptdtv.project_id, mptdtv.task_id,g_transaction_type_id,g_inventory_item_id,base.project_id,base.task_id) = 1
292: and (
293: WMS_Parameter_PVT.GetTotalOnHand(
294: base.ORGANIZATION_ID
295: ,base.SUBINVENTORY_CODE
412: and base.INVENTORY_ITEM_ID = g_inventory_item_id
413: and (g_project_id = base.project_id OR base.project_id IS NULL)
414: and (g_task_id = base.task_id OR base.task_id IS NULL)
415: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
416: and Wms_Rule_Pvt.Match_Planning_Group(base.ORGANIZATION_ID,base.locator_id, g_project_id, mptdtv.project_id, mptdtv.task_id,g_transaction_type_id,g_inventory_item_id,base.project_id,base.task_id) = 1
417: and (
418: WMS_Parameter_PVT.GetTotalOnHand(
419: base.ORGANIZATION_ID
420: ,base.SUBINVENTORY_CODE
543: and base.INVENTORY_ITEM_ID = g_inventory_item_id
544: and (g_project_id = base.project_id OR base.project_id IS NULL)
545: and (g_task_id = base.task_id OR base.task_id IS NULL)
546: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
547: and Wms_Rule_Pvt.Match_Planning_Group(base.ORGANIZATION_ID,base.locator_id, g_project_id, mptdtv.project_id, mptdtv.task_id,g_transaction_type_id,g_inventory_item_id,base.project_id,base.task_id) = 1
548: and (
549: WMS_Parameter_PVT.GetTotalOnHand(
550: base.ORGANIZATION_ID
551: ,base.SUBINVENTORY_CODE
670: and base.INVENTORY_ITEM_ID = g_inventory_item_id
671: and (g_project_id = base.project_id OR base.project_id IS NULL)
672: and (g_task_id = base.task_id OR base.task_id IS NULL)
673: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
674: and Wms_Rule_Pvt.Match_Planning_Group(base.ORGANIZATION_ID,base.locator_id, g_project_id, mptdtv.project_id, mptdtv.task_id,g_transaction_type_id,g_inventory_item_id,base.project_id,base.task_id) = 1
675: and (
676: WMS_Parameter_PVT.GetTotalOnHand(
677: base.ORGANIZATION_ID
678: ,base.SUBINVENTORY_CODE
799: and base.INVENTORY_ITEM_ID = g_inventory_item_id
800: and (g_project_id = base.project_id OR base.project_id IS NULL)
801: and (g_task_id = base.task_id OR base.task_id IS NULL)
802: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
803: and Wms_Rule_Pvt.Match_Planning_Group(base.ORGANIZATION_ID,base.locator_id, g_project_id, mptdtv.project_id, mptdtv.task_id,g_transaction_type_id,g_inventory_item_id,base.project_id,base.task_id) = 1
804: and (
805: WMS_Parameter_PVT.GetTotalOnHand(
806: base.ORGANIZATION_ID
807: ,base.SUBINVENTORY_CODE
934: and base.INVENTORY_ITEM_ID = g_inventory_item_id
935: and (g_project_id = base.project_id OR base.project_id IS NULL)
936: and (g_task_id = base.task_id OR base.task_id IS NULL)
937: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
938: and Wms_Rule_Pvt.Match_Planning_Group(base.ORGANIZATION_ID,base.locator_id, g_project_id, mptdtv.project_id, mptdtv.task_id,g_transaction_type_id,g_inventory_item_id,base.project_id,base.task_id) = 1
939: and (
940: WMS_Parameter_PVT.GetTotalOnHand(
941: base.ORGANIZATION_ID
942: ,base.SUBINVENTORY_CODE
1066: and base.INVENTORY_ITEM_ID = g_inventory_item_id
1067: and (g_project_id = base.project_id OR base.project_id IS NULL)
1068: and (g_task_id = base.task_id OR base.task_id IS NULL)
1069: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
1070: and Wms_Rule_Pvt.Match_Planning_Group(base.ORGANIZATION_ID,base.locator_id, g_project_id, mptdtv.project_id, mptdtv.task_id,g_transaction_type_id,g_inventory_item_id,base.project_id,base.task_id) = 1
1071: and (
1072: WMS_Parameter_PVT.GetTotalOnHand(
1073: base.ORGANIZATION_ID
1074: ,base.SUBINVENTORY_CODE
1199: and base.INVENTORY_ITEM_ID = g_inventory_item_id
1200: and (g_project_id = base.project_id OR base.project_id IS NULL)
1201: and (g_task_id = base.task_id OR base.task_id IS NULL)
1202: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
1203: and Wms_Rule_Pvt.Match_Planning_Group(base.ORGANIZATION_ID,base.locator_id, g_project_id, mptdtv.project_id, mptdtv.task_id,g_transaction_type_id,g_inventory_item_id,base.project_id,base.task_id) = 1
1204: and (
1205: WMS_Parameter_PVT.GetTotalOnHand(
1206: base.ORGANIZATION_ID
1207: ,base.SUBINVENTORY_CODE
1220:
1221: END open_curs;
1222:
1223: PROCEDURE fetch_one_row(
1224: p_cursor IN WMS_RULE_PVT.cv_put_type,
1225: x_subinventory_code OUT NOCOPY VARCHAR2,
1226: x_locator_id OUT NOCOPY NUMBER,
1227: x_project_id OUT NOCOPY NUMBER,
1228: x_task_id OUT NOCOPY NUMBER,
1243: end if;
1244:
1245: END fetch_one_row;
1246:
1247: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_put_type) IS
1248: BEGIN
1249: if p_cursor%ISOPEN then
1250: CLOSE p_cursor;
1251: end if;