[Home] [Help]
1: PACKAGE BODY WMS_RULE_13 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: order by base.PROJECT_ID
167: ,base.TASK_ID
168: ;
169:
280: and base.INVENTORY_ITEM_ID = g_inventory_item_id
281: and (g_project_id = base.project_id OR base.project_id IS NULL)
282: and (g_task_id = base.task_id OR base.task_id IS NULL)
283: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
284: 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
285: and base.subinventory_code = g_subinventory_code
286: order by base.PROJECT_ID
287: ,base.TASK_ID
288: ;
398: and base.INVENTORY_ITEM_ID = g_inventory_item_id
399: and (g_project_id = base.project_id OR base.project_id IS NULL)
400: and (g_task_id = base.task_id OR base.task_id IS NULL)
401: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
402: 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
403: and base.subinventory_code = g_subinventory_code
404: and base.locator_id = g_locator_id
405: order by base.PROJECT_ID
406: ,base.TASK_ID
522: and base.INVENTORY_ITEM_ID = g_inventory_item_id
523: and (g_project_id = base.project_id OR base.project_id IS NULL)
524: and (g_task_id = base.task_id OR base.task_id IS NULL)
525: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
526: 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
527: order by base.PROJECT_ID
528: ,base.TASK_ID
529: ;
530: Elsif g_locator_id IS NULL Then
642: and base.INVENTORY_ITEM_ID = g_inventory_item_id
643: and (g_project_id = base.project_id OR base.project_id IS NULL)
644: and (g_task_id = base.task_id OR base.task_id IS NULL)
645: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
646: 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
647: and base.subinventory_code = g_subinventory_code
648: order by base.PROJECT_ID
649: ,base.TASK_ID
650: ;
764: and base.INVENTORY_ITEM_ID = g_inventory_item_id
765: and (g_project_id = base.project_id OR base.project_id IS NULL)
766: and (g_task_id = base.task_id OR base.task_id IS NULL)
767: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
768: 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
769: and base.subinventory_code = g_subinventory_code
770: and base.locator_id = g_locator_id
771: order by base.PROJECT_ID
772: ,base.TASK_ID
892: and base.INVENTORY_ITEM_ID = g_inventory_item_id
893: and (g_project_id = base.project_id OR base.project_id IS NULL)
894: and (g_task_id = base.task_id OR base.task_id IS NULL)
895: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
896: 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
897: order by base.PROJECT_ID
898: ,base.TASK_ID
899: ;
900:
1017: and base.INVENTORY_ITEM_ID = g_inventory_item_id
1018: and (g_project_id = base.project_id OR base.project_id IS NULL)
1019: and (g_task_id = base.task_id OR base.task_id IS NULL)
1020: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
1021: 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
1022: and base.subinventory_code = g_subinventory_code
1023: order by base.PROJECT_ID
1024: ,base.TASK_ID
1025: ;
1143: and base.INVENTORY_ITEM_ID = g_inventory_item_id
1144: and (g_project_id = base.project_id OR base.project_id IS NULL)
1145: and (g_task_id = base.task_id OR base.task_id IS NULL)
1146: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
1147: 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
1148: and base.subinventory_code = g_subinventory_code
1149: and base.locator_id = g_locator_id
1150: order by base.PROJECT_ID
1151: ,base.TASK_ID
1157:
1158: END open_curs;
1159:
1160: PROCEDURE fetch_one_row(
1161: p_cursor IN WMS_RULE_PVT.cv_put_type,
1162: x_subinventory_code OUT NOCOPY VARCHAR2,
1163: x_locator_id OUT NOCOPY NUMBER,
1164: x_project_id OUT NOCOPY NUMBER,
1165: x_task_id OUT NOCOPY NUMBER,
1180: end if;
1181:
1182: END fetch_one_row;
1183:
1184: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_put_type) IS
1185: BEGIN
1186: if p_cursor%ISOPEN then
1187: CLOSE p_cursor;
1188: end if;