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.24.12020000.2 2012/07/24 10:00:41 azjain 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.24.12020000.2 2012/07/24 10:00:41 azjain 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 42: g_pkg_name constant varchar2(30) := 'WMS_Rules_workbench_pvt';

38: -- Procedure get_customer_freight_details()
39: -- Function get_order_type_id( p_move_order_line_id IN NUMBER, p_transaction_source_type_id IN NUMBER, p_reference_id IN NUMBER ) return NUMBER;
40: -----------------------------------------------------------------------------
41:
42: g_pkg_name constant varchar2(30) := 'WMS_Rules_workbench_pvt';
43: l_debug NUMBER;
44:
45: --
46: --Procedures for logging messages

Line 767: WMS_RULES_WORKBENCH_PVT.get_item_type(mtrl1.organization_id,mtrl1.inventory_item_id) = l_item_type

763: AND wdd.customer_id = l_customer_id
764: )
765: )
766: AND ( NVL(l_item_type,'1') = '1' OR
767: WMS_RULES_WORKBENCH_PVT.get_item_type(mtrl1.organization_id,mtrl1.inventory_item_id) = l_item_type
768: )
769: AND ( NVL(l_uom_class,'aaa') = 'aaa' OR
770: WMS_RULES_WORKBENCH_PVT.get_uom_class(mtrl1.uom_code) = l_uom_class
771: )

Line 770: WMS_RULES_WORKBENCH_PVT.get_uom_class(mtrl1.uom_code) = l_uom_class

766: AND ( NVL(l_item_type,'1') = '1' OR
767: WMS_RULES_WORKBENCH_PVT.get_item_type(mtrl1.organization_id,mtrl1.inventory_item_id) = l_item_type
768: )
769: AND ( NVL(l_uom_class,'aaa') = 'aaa' OR
770: WMS_RULES_WORKBENCH_PVT.get_uom_class(mtrl1.uom_code) = l_uom_class
771: )
772: AND ( NVL(l_order_type_id,-999)= -999 OR
773: WMS_RULES_WORKBENCH_PVT.get_order_type_id(mtrl1.line_id,mtrl1.transaction_source_type_id,mtrl1.reference_id) = l_order_type_id
774: )

Line 773: WMS_RULES_WORKBENCH_PVT.get_order_type_id(mtrl1.line_id,mtrl1.transaction_source_type_id,mtrl1.reference_id) = l_order_type_id

769: AND ( NVL(l_uom_class,'aaa') = 'aaa' OR
770: WMS_RULES_WORKBENCH_PVT.get_uom_class(mtrl1.uom_code) = l_uom_class
771: )
772: AND ( NVL(l_order_type_id,-999)= -999 OR
773: WMS_RULES_WORKBENCH_PVT.get_order_type_id(mtrl1.line_id,mtrl1.transaction_source_type_id,mtrl1.reference_id) = l_order_type_id
774: )
775: AND ( mtrl1.transaction_source_type_id <> 1 OR
776: NVL(l_vendor_id,-999) = -999 OR
777: WMS_RULES_WORKBENCH_PVT.get_vendor_id(mtrl1.reference,mtrl1.reference_id) = l_vendor_id

Line 777: WMS_RULES_WORKBENCH_PVT.get_vendor_id(mtrl1.reference,mtrl1.reference_id) = l_vendor_id

773: WMS_RULES_WORKBENCH_PVT.get_order_type_id(mtrl1.line_id,mtrl1.transaction_source_type_id,mtrl1.reference_id) = l_order_type_id
774: )
775: AND ( mtrl1.transaction_source_type_id <> 1 OR
776: NVL(l_vendor_id,-999) = -999 OR
777: WMS_RULES_WORKBENCH_PVT.get_vendor_id(mtrl1.reference,mtrl1.reference_id) = l_vendor_id
778: )
779: AND (l_category_id IS NULL OR WMS_RULES_WORKBENCH_PVT.get_Item_Cat(mtrl1.organization_id,
780: mtrl1.inventory_item_id,
781: l_category_set_id,

Line 779: AND (l_category_id IS NULL OR WMS_RULES_WORKBENCH_PVT.get_Item_Cat(mtrl1.organization_id,

775: AND ( mtrl1.transaction_source_type_id <> 1 OR
776: NVL(l_vendor_id,-999) = -999 OR
777: WMS_RULES_WORKBENCH_PVT.get_vendor_id(mtrl1.reference,mtrl1.reference_id) = l_vendor_id
778: )
779: AND (l_category_id IS NULL OR WMS_RULES_WORKBENCH_PVT.get_Item_Cat(mtrl1.organization_id,
780: mtrl1.inventory_item_id,
781: l_category_set_id,
782: l_category_id )='Y'
783: )

Line 784: AND (l_abc_class_id IS NULL OR WMS_RULES_WORKBENCH_PVT.get_group_class(mtrl1.inventory_item_id,

780: mtrl1.inventory_item_id,
781: l_category_set_id,
782: l_category_id )='Y'
783: )
784: AND (l_abc_class_id IS NULL OR WMS_RULES_WORKBENCH_PVT.get_group_class(mtrl1.inventory_item_id,
785: l_assignment_group_id,
786: l_abc_class_id)='Y'
787: );
788:

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

840: and nvl(uom_class, l_uom_class) = l_uom_class
841: and nvl(effective_from,to_date('01011900','ddmmyyyy')) <= trunc(sysdate)
842: and nvl(effective_to,to_date('31124000','ddmmyyyy')) >= trunc(sysdate)
843: 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
844: and decode(category_id,null,'N', 'Y') = decode(category_id,null,'N', WMS_RULES_WORKBENCH_PVT.get_Item_Cat(l_rec_mtrl.organization_id,
845: l_rec_mtrl.inventory_item_id,
846: category_set_id,
847: category_id )
848: )

Line 849: 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,

845: l_rec_mtrl.inventory_item_id,
846: category_set_id,
847: category_id )
848: )
849: 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,
850: assignment_group_id,
851: abc_class_id)
852: )
853:

Line 1340: and decode(category_id,null, 'N', 'Y') = decode(category_id, null, 'N', WMS_RULES_WORKBENCH_PVT.get_Item_Cat(l_from_organization_id, -- 14071820

1336: and nvl(uom_class, l_uom_class) = l_uom_class
1337: and nvl(effective_from,to_date('01011900','ddmmyyyy')) <= trunc(sysdate)
1338: and nvl(effective_to,to_date('31124000','ddmmyyyy')) >= trunc(sysdate)
1339: 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
1340: and decode(category_id,null, 'N', 'Y') = decode(category_id, null, 'N', WMS_RULES_WORKBENCH_PVT.get_Item_Cat(l_from_organization_id, -- 14071820
1341: l_rec_mtrl.inventory_item_id ,
1342: category_set_id,
1343: category_id ))
1344: 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 1344: 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,

1340: and decode(category_id,null, 'N', 'Y') = decode(category_id, null, 'N', WMS_RULES_WORKBENCH_PVT.get_Item_Cat(l_from_organization_id, -- 14071820
1341: l_rec_mtrl.inventory_item_id ,
1342: category_set_id,
1343: category_id ))
1344: 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,
1345: assignment_group_id,
1346: abc_class_id))
1347: order by sequence_number;
1348:

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

2061: Function get_location_name(p_location_id IN NUMBER)
2062: Return VARCHAR2 is
2063:
2064: l_location_code VARCHAR2(50);
2065: g_pkg_name constant VARCHAR2(50) := 'WMS_RULES_WORKBENCH_PVT';
2066: l_api_name constant VARCHAR2(30) := 'GET_LOCATION_NAME';
2067: begin
2068: if l_debug = 1 then
2069: log_event(l_api_name,' Enter',l_api_name);

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

2105: x_sequence_number OUT NOCOPY NUMBER,
2106: x_return_status OUT NOCOPY VARCHAR2)
2107: is
2108:
2109: g_pkg_name constant VARCHAR2(50) := 'WMS_RULES_WORKBENCH_PVT';
2110: l_api_version CONSTANT NUMBER := 1.0;
2111: l_api_name constant VARCHAR2(30) := 'cross_dock_search';
2112: l_debug_mode BOOLEAN := inv_pp_debug.is_debug_mode;
2113:

Line 2137: WMS_RULES_WORKBENCH_PVT.get_group_class(p_inventory_item_id,

2133: AND NVL(user_id, NVL(p_user_id, -9)) = NVL(p_user_id, -9)
2134: AND NVL(uom_code, NVL(p_uom_code, '#')) = NVL(p_uom_code, '#')
2135: AND NVL(uom_class, NVL(p_uom_class, '#')) = NVL(p_uom_class, '#')
2136: AND DECODE(abc_class_id, NULL, 'N', 'Y') = DECODE(abc_class_id, NULL,'N',
2137: WMS_RULES_WORKBENCH_PVT.get_group_class(p_inventory_item_id,
2138: assignment_group_id,
2139: abc_class_id))
2140: ORDER BY sequence_number;
2141:

Line 2208: END WMS_RULES_WORKBENCH_PVT;

2204:
2205: --*******************************************************************************
2206:
2207:
2208: END WMS_RULES_WORKBENCH_PVT;