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_9 dependencies on WMS_RULE_PVT

Line 4: p_cursor IN OUT NOCOPY WMS_RULE_PVT.cv_put_type,

1: PACKAGE BODY WMS_RULE_9 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 168: 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

164: and base.INVENTORY_ITEM_ID = g_inventory_item_id
165: and (g_project_id = base.project_id OR base.project_id IS NULL)
166: and (g_task_id = base.task_id OR base.task_id IS NULL)
167: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
168: 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
169: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
170: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
171: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
172: and bmuom.UOM_CLASS = muom.UOM_CLASS

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

326: and base.INVENTORY_ITEM_ID = g_inventory_item_id
327: and (g_project_id = base.project_id OR base.project_id IS NULL)
328: and (g_task_id = base.task_id OR base.task_id IS NULL)
329: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
330: 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
331: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
332: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
333: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
334: and bmuom.UOM_CLASS = muom.UOM_CLASS

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

487: and base.INVENTORY_ITEM_ID = g_inventory_item_id
488: and (g_project_id = base.project_id OR base.project_id IS NULL)
489: and (g_task_id = base.task_id OR base.task_id IS NULL)
490: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
491: 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
492: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
493: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
494: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
495: and bmuom.UOM_CLASS = muom.UOM_CLASS

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

654: and base.INVENTORY_ITEM_ID = g_inventory_item_id
655: and (g_project_id = base.project_id OR base.project_id IS NULL)
656: and (g_task_id = base.task_id OR base.task_id IS NULL)
657: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
658: 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
659: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
660: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
661: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
662: and bmuom.UOM_CLASS = muom.UOM_CLASS

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

817: and base.INVENTORY_ITEM_ID = g_inventory_item_id
818: and (g_project_id = base.project_id OR base.project_id IS NULL)
819: and (g_task_id = base.task_id OR base.task_id IS NULL)
820: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
821: 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
822: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
823: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
824: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
825: and bmuom.UOM_CLASS = muom.UOM_CLASS

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

982: and base.INVENTORY_ITEM_ID = g_inventory_item_id
983: and (g_project_id = base.project_id OR base.project_id IS NULL)
984: and (g_task_id = base.task_id OR base.task_id IS NULL)
985: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
986: 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
987: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
988: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
989: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
990: and bmuom.UOM_CLASS = muom.UOM_CLASS

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

1153: and base.INVENTORY_ITEM_ID = g_inventory_item_id
1154: and (g_project_id = base.project_id OR base.project_id IS NULL)
1155: and (g_task_id = base.task_id OR base.task_id IS NULL)
1156: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
1157: 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
1158: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1159: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1160: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
1161: and bmuom.UOM_CLASS = muom.UOM_CLASS

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

1321: and base.INVENTORY_ITEM_ID = g_inventory_item_id
1322: and (g_project_id = base.project_id OR base.project_id IS NULL)
1323: and (g_task_id = base.task_id OR base.task_id IS NULL)
1324: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
1325: 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
1326: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1327: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1328: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
1329: and bmuom.UOM_CLASS = muom.UOM_CLASS

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

1490: and base.INVENTORY_ITEM_ID = g_inventory_item_id
1491: and (g_project_id = base.project_id OR base.project_id IS NULL)
1492: and (g_task_id = base.task_id OR base.task_id IS NULL)
1493: and mptdtv.PP_TRANSACTION_TEMP_ID = g_pp_transaction_temp_id
1494: 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
1495: and msi.ORGANIZATION_ID = mptdtv.TO_ORGANIZATION_ID
1496: and msi.INVENTORY_ITEM_ID = mptdtv.INVENTORY_ITEM_ID
1497: and muom.UOM_CODE = mptdtv.TRANSACTION_UOM
1498: and bmuom.UOM_CLASS = muom.UOM_CLASS

Line 1548: p_cursor IN WMS_RULE_PVT.cv_put_type,

1544:
1545: END open_curs;
1546:
1547: PROCEDURE fetch_one_row(
1548: p_cursor IN WMS_RULE_PVT.cv_put_type,
1549: x_subinventory_code OUT NOCOPY VARCHAR2,
1550: x_locator_id OUT NOCOPY NUMBER,
1551: x_project_id OUT NOCOPY NUMBER,
1552: x_task_id OUT NOCOPY NUMBER,

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

1567: end if;
1568:
1569: END fetch_one_row;
1570:
1571: PROCEDURE close_curs( p_cursor IN WMS_RULE_PVT.cv_put_type) IS
1572: BEGIN
1573: if p_cursor%ISOPEN then
1574: CLOSE p_cursor;
1575: end if;