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_RULES_WORKBENCH_PVT dependencies on WMS_RULES_WORKBENCH_PVT

Line 1: Package BODY WMS_RULES_WORKBENCH_PVT AS

1: Package BODY WMS_RULES_WORKBENCH_PVT AS
2: /* $Header: WMSRLWBB.pls 120.16.12010000.2 2008/08/19 09:56:13 anviswan ship $ */
3:
4: -- File : WMSRLWBS.pls
5: -- Content : WMS_RULES_WORKBENCH_PVT package spec

Line 5: -- Content : WMS_RULES_WORKBENCH_PVT package spec

1: Package BODY WMS_RULES_WORKBENCH_PVT AS
2: /* $Header: WMSRLWBB.pls 120.16.12010000.2 2008/08/19 09:56:13 anviswan ship $ */
3:
4: -- File : WMSRLWBS.pls
5: -- Content : WMS_RULES_WORKBENCH_PVT package spec
6: -- Description : This API is created to handle all the procedures, function variables to be used by Rules WorkBench
7:
8: -- Notes :
9: -- List of Pl/SQL Tables,Functions and Procedures --------------------------

Line 41: g_pkg_name constant varchar2(30) := 'WMS_Rules_workbench_pvt';

37: -- procedure send_msg_to_pipe(p_debug_mode in Boolean, p_message in VARCHAR2);
38: -- Procedure get_customer_freight_details()
39: -----------------------------------------------------------------------------
40:
41: g_pkg_name constant varchar2(30) := 'WMS_Rules_workbench_pvt';
42: l_debug NUMBER;
43:
44: --
45: --Procedures for logging messages

Line 738: and decode(category_id,null,'N', 'Y') = decode(category_id,null,'N', WMS_RULES_WORKBENCH_PVT.get_Item_Cat(l_rec_mtrl.organization_id,

734: and nvl(uom_class, l_uom_class) = l_uom_class
735: and nvl(effective_from,to_date('01011900','ddmmyyyy')) <= trunc(sysdate)
736: and nvl(effective_to,to_date('31124000','ddmmyyyy')) >= trunc(sysdate)
737: and wms_datecheck_pvt.date_valid(l_from_organization_id,date_type_code,date_type_from,date_type_to,effective_from,effective_to) = 'Y' --Added bug 4081657
738: and decode(category_id,null,'N', 'Y') = decode(category_id,null,'N', WMS_RULES_WORKBENCH_PVT.get_Item_Cat(l_rec_mtrl.organization_id,
739: l_rec_mtrl.inventory_item_id,
740: category_set_id,
741: category_id )
742: )

Line 743: and decode(abc_class_id,null,'N', 'Y') = decode(abc_class_id,null,'N', WMS_RULES_WORKBENCH_PVT.get_group_class(l_rec_mtrl.inventory_item_id,

739: l_rec_mtrl.inventory_item_id,
740: category_set_id,
741: category_id )
742: )
743: and decode(abc_class_id,null,'N', 'Y') = decode(abc_class_id,null,'N', WMS_RULES_WORKBENCH_PVT.get_group_class(l_rec_mtrl.inventory_item_id,
744: assignment_group_id,
745: abc_class_id)
746: )
747:

Line 1144: and decode(category_id,null, 'N', 'Y') = decode(category_id, null, 'N', WMS_RULES_WORKBENCH_PVT.get_Item_Cat(l_rec_mtrl.organization_id,

1140: and nvl(uom_class, l_uom_class) = l_uom_class
1141: and nvl(effective_from,to_date('01011900','ddmmyyyy')) <= trunc(sysdate)
1142: and nvl(effective_to,to_date('31124000','ddmmyyyy')) >= trunc(sysdate)
1143: and wms_datecheck_pvt.date_valid(l_from_organization_id,date_type_code,date_type_from,date_type_to,effective_from,effective_to) = 'Y' --Added bug 4081657
1144: and decode(category_id,null, 'N', 'Y') = decode(category_id, null, 'N', WMS_RULES_WORKBENCH_PVT.get_Item_Cat(l_rec_mtrl.organization_id,
1145: l_rec_mtrl.inventory_item_id ,
1146: category_set_id,
1147: category_id ))
1148: and decode(abc_class_id,null,'N', 'Y') = decode(abc_class_id,null,'N', WMS_RULES_WORKBENCH_PVT.get_group_class(l_rec_mtrl.inventory_item_id,

Line 1148: and decode(abc_class_id,null,'N', 'Y') = decode(abc_class_id,null,'N', WMS_RULES_WORKBENCH_PVT.get_group_class(l_rec_mtrl.inventory_item_id,

1144: and decode(category_id,null, 'N', 'Y') = decode(category_id, null, 'N', WMS_RULES_WORKBENCH_PVT.get_Item_Cat(l_rec_mtrl.organization_id,
1145: l_rec_mtrl.inventory_item_id ,
1146: category_set_id,
1147: category_id ))
1148: and decode(abc_class_id,null,'N', 'Y') = decode(abc_class_id,null,'N', WMS_RULES_WORKBENCH_PVT.get_group_class(l_rec_mtrl.inventory_item_id,
1149: assignment_group_id,
1150: abc_class_id))
1151: order by sequence_number;
1152:

Line 1766: g_pkg_name constant VARCHAR2(50) := 'WMS_RULES_WORKBENCH_PVT';

1762: Function get_location_name(p_location_id IN NUMBER)
1763: Return VARCHAR2 is
1764:
1765: l_location_code VARCHAR2(50);
1766: g_pkg_name constant VARCHAR2(50) := 'WMS_RULES_WORKBENCH_PVT';
1767: l_api_name constant VARCHAR2(30) := 'GET_LOCATION_NAME';
1768: begin
1769: if l_debug = 1 then
1770: log_event(l_api_name,' Enter',l_api_name);

Line 1810: g_pkg_name constant VARCHAR2(50) := 'WMS_RULES_WORKBENCH_PVT';

1806: x_sequence_number OUT NOCOPY NUMBER,
1807: x_return_status OUT NOCOPY VARCHAR2)
1808: is
1809:
1810: g_pkg_name constant VARCHAR2(50) := 'WMS_RULES_WORKBENCH_PVT';
1811: l_api_version CONSTANT NUMBER := 1.0;
1812: l_api_name constant VARCHAR2(30) := 'cross_dock_search';
1813: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
1814:

Line 1838: WMS_RULES_WORKBENCH_PVT.get_group_class(p_inventory_item_id,

1834: AND NVL(user_id, NVL(p_user_id, -9)) = NVL(p_user_id, -9)
1835: AND NVL(uom_code, NVL(p_uom_code, '#')) = NVL(p_uom_code, '#')
1836: AND NVL(uom_class, NVL(p_uom_class, '#')) = NVL(p_uom_class, '#')
1837: AND DECODE(abc_class_id, NULL, 'N', 'Y') = DECODE(abc_class_id, NULL,'N',
1838: WMS_RULES_WORKBENCH_PVT.get_group_class(p_inventory_item_id,
1839: assignment_group_id,
1840: abc_class_id))
1841: ORDER BY sequence_number;
1842:

Line 1909: END WMS_RULES_WORKBENCH_PVT;

1905:
1906: --*******************************************************************************
1907:
1908:
1909: END WMS_RULES_WORKBENCH_PVT;