eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_RULE_8 dependencies on WMS_RULE_PVT

Line 4: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_put_type,

1: PACKAGE BODY WMS_RULE_8 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,

Line 167: 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

163: and base.INVENTORY_ITEM_ID = g_inventory_item_id
164: and (g_project_id = base.project_id OR base.project_id IS NULL)
165: and (g_task_id = base.task_id OR base.task_id IS NULL)
166: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
167: 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
168: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
169: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
170: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
171: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)

Line 312: 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

308: and base.INVENTORY_ITEM_ID = g_inventory_item_id
309: and (g_project_id = base.project_id OR base.project_id IS NULL)
310: and (g_task_id = base.task_id OR base.task_id IS NULL)
311: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
312: 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
313: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
314: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
315: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
316: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)

Line 456: 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

452: and base.INVENTORY_ITEM_ID = g_inventory_item_id
453: and (g_project_id = base.project_id OR base.project_id IS NULL)
454: and (g_task_id = base.task_id OR base.task_id IS NULL)
455: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
456: 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
457: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
458: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
459: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
460: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)

Line 606: 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

602: and base.INVENTORY_ITEM_ID = g_inventory_item_id
603: and (g_project_id = base.project_id OR base.project_id IS NULL)
604: and (g_task_id = base.task_id OR base.task_id IS NULL)
605: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
606: 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
607: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
608: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
609: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
610: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)

Line 752: 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

748: and base.INVENTORY_ITEM_ID = g_inventory_item_id
749: and (g_project_id = base.project_id OR base.project_id IS NULL)
750: and (g_task_id = base.task_id OR base.task_id IS NULL)
751: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
752: 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
753: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
754: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
755: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
756: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)

Line 900: 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

896: and base.INVENTORY_ITEM_ID = g_inventory_item_id
897: and (g_project_id = base.project_id OR base.project_id IS NULL)
898: and (g_task_id = base.task_id OR base.task_id IS NULL)
899: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
900: 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
901: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
902: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
903: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
904: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)

Line 1054: 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

1050: and base.INVENTORY_ITEM_ID = g_inventory_item_id
1051: and (g_project_id = base.project_id OR base.project_id IS NULL)
1052: and (g_task_id = base.task_id OR base.task_id IS NULL)
1053: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
1054: 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
1055: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1056: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1057: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1058: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)

Line 1205: 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

1201: and base.INVENTORY_ITEM_ID = g_inventory_item_id
1202: and (g_project_id = base.project_id OR base.project_id IS NULL)
1203: and (g_task_id = base.task_id OR base.task_id IS NULL)
1204: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
1205: 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
1206: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1207: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1208: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1209: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)

Line 1357: 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

1353: and base.INVENTORY_ITEM_ID = g_inventory_item_id
1354: and (g_project_id = base.project_id OR base.project_id IS NULL)
1355: and (g_task_id = base.task_id OR base.task_id IS NULL)
1356: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
1357: 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
1358: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1359: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1360: and omil.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1361: and omil.INVENTORY_LOCATION_ID = NVL(mptdtv.to_locator_id,base.locator_id)

Line 1395: p_cursor IN WMS_RULE_PVT.cv_put_type,

1391:
1392: END open_curs;
1393:
1394: PROCEDURE fetch_one_row(
1395: p_cursor IN WMS_RULE_PVT.cv_put_type,
1396: x_subinventory_code OUT NOCOPY VARCHAR2,
1397: x_locator_id OUT NOCOPY NUMBER,
1398: x_project_id OUT NOCOPY NUMBER,
1399: x_task_id OUT NOCOPY NUMBER,

Line 1418: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_put_type) IS

1414: end if;
1415:
1416: END fetch_one_row;
1417:
1418: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_put_type) IS
1419: BEGIN
1420: if p_cursor%ISOPEN then
1421: CLOSE p_cursor;
1422: end if;