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.OE_ITORD_UTIL dependencies on OE_ITORD_UTIL

Line 1: PACKAGE BODY OE_ITORD_UTIL AS

1: PACKAGE BODY OE_ITORD_UTIL AS
2: /* $Header: OEITORDB.pls 120.6.12010000.4 2008/09/22 06:46:15 smanian ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_ITORD_UTIL';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_ITORD_UTIL';

1: PACKAGE BODY OE_ITORD_UTIL AS
2: /* $Header: OEITORDB.pls 120.6.12010000.4 2008/09/22 06:46:15 smanian ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_ITORD_UTIL';
6:
7: --------------------------------------------------------------------------------------
8: --Function get_item_category_id will return the item category_id for the passed inventory_item_id
9: --------------------------------------------------------------------------------------

Line 92: l_location_id := OE_ITORD_UTIL.Get_Shipto_Location_Id(p_ship_to_org_id);

88: IF p_ship_to_org_id IS NULL then
89: RETURN NULL;
90: END IF;
91:
92: l_location_id := OE_ITORD_UTIL.Get_Shipto_Location_Id(p_ship_to_org_id);
93:
94: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches
95: ( p_location_id => l_location_id,
96: p_use_cache => TRUE,

Line 194: where category_id = OE_ITORD_UTIL.get_item_category_id (p_inventory_item_id);

190: begin
191: select concatenated_segments
192: into l_category
193: from mtl_categories_kfv
194: where category_id = OE_ITORD_UTIL.get_item_category_id (p_inventory_item_id);
195:
196: return l_category;
197: Exception
198: when others then

Line 381: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_line_rec.inventory_item_id);

377:
378: begin
379:
380: l_operating_unit_id := p_line_rec.org_id;
381: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_line_rec.inventory_item_id);
382: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_line_rec.sold_to_org_id);
383: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_line_rec.ship_to_org_id);
384: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_line_rec.sold_to_org_id);
385: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id (p_line_rec.header_id);

Line 382: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_line_rec.sold_to_org_id);

378: begin
379:
380: l_operating_unit_id := p_line_rec.org_id;
381: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_line_rec.inventory_item_id);
382: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_line_rec.sold_to_org_id);
383: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_line_rec.ship_to_org_id);
384: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_line_rec.sold_to_org_id);
385: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id (p_line_rec.header_id);
386: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_line_rec.header_id);

Line 383: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_line_rec.ship_to_org_id);

379:
380: l_operating_unit_id := p_line_rec.org_id;
381: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_line_rec.inventory_item_id);
382: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_line_rec.sold_to_org_id);
383: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_line_rec.ship_to_org_id);
384: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_line_rec.sold_to_org_id);
385: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id (p_line_rec.header_id);
386: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_line_rec.header_id);
387:

Line 384: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_line_rec.sold_to_org_id);

380: l_operating_unit_id := p_line_rec.org_id;
381: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_line_rec.inventory_item_id);
382: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_line_rec.sold_to_org_id);
383: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_line_rec.ship_to_org_id);
384: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_line_rec.sold_to_org_id);
385: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id (p_line_rec.header_id);
386: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_line_rec.header_id);
387:
388: IF l_debug_level >0 then

Line 385: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id (p_line_rec.header_id);

381: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_line_rec.inventory_item_id);
382: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_line_rec.sold_to_org_id);
383: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_line_rec.ship_to_org_id);
384: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_line_rec.sold_to_org_id);
385: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id (p_line_rec.header_id);
386: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_line_rec.header_id);
387:
388: IF l_debug_level >0 then
389: oe_debug_pub.add('Entering OE_ITORD_UTIL.Validate_item_orderability',1);

Line 386: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_line_rec.header_id);

382: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_line_rec.sold_to_org_id);
383: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_line_rec.ship_to_org_id);
384: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_line_rec.sold_to_org_id);
385: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id (p_line_rec.header_id);
386: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_line_rec.header_id);
387:
388: IF l_debug_level >0 then
389: oe_debug_pub.add('Entering OE_ITORD_UTIL.Validate_item_orderability',1);
390: oe_debug_pub.add('Inventory_item_id :'||p_line_rec.inventory_item_id);

Line 389: oe_debug_pub.add('Entering OE_ITORD_UTIL.Validate_item_orderability',1);

385: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id (p_line_rec.header_id);
386: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_line_rec.header_id);
387:
388: IF l_debug_level >0 then
389: oe_debug_pub.add('Entering OE_ITORD_UTIL.Validate_item_orderability',1);
390: oe_debug_pub.add('Inventory_item_id :'||p_line_rec.inventory_item_id);
391: oe_debug_pub.add('Item Category Id :'||l_x_item_category_id);
392: oe_debug_pub.add('Customer ID :'|| p_line_rec.sold_to_org_id);
393: oe_debug_pub.add('Customer Class ID :'||l_x_customer_class_id);

Line 488: oe_debug_pub.add('Exiting OE_ITORD_UTIL.Validate_item_orderability',1);

484:
485: END IF;
486:
487:
488: oe_debug_pub.add('Exiting OE_ITORD_UTIL.Validate_item_orderability',1);
489:
490: Exception
491: when others then
492: OE_MSG_PUB.Add_Exc_Msg

Line 528: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_inventory_item_id);

524:
525: begin
526:
527:
528: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_inventory_item_id);
529: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_sold_to_org_id);
530: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_ship_to_org_id);
531: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_sold_to_org_id);
532: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id(p_header_id);

Line 529: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_sold_to_org_id);

525: begin
526:
527:
528: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_inventory_item_id);
529: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_sold_to_org_id);
530: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_ship_to_org_id);
531: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_sold_to_org_id);
532: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id(p_header_id);
533: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_header_id);

Line 530: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_ship_to_org_id);

526:
527:
528: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_inventory_item_id);
529: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_sold_to_org_id);
530: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_ship_to_org_id);
531: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_sold_to_org_id);
532: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id(p_header_id);
533: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_header_id);
534:

Line 531: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_sold_to_org_id);

527:
528: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_inventory_item_id);
529: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_sold_to_org_id);
530: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_ship_to_org_id);
531: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_sold_to_org_id);
532: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id(p_header_id);
533: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_header_id);
534:
535:

Line 532: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id(p_header_id);

528: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_inventory_item_id);
529: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_sold_to_org_id);
530: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_ship_to_org_id);
531: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_sold_to_org_id);
532: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id(p_header_id);
533: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_header_id);
534:
535:
536: --Validation for Exclusion Rules

Line 533: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_header_id);

529: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_sold_to_org_id);
530: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_ship_to_org_id);
531: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_sold_to_org_id);
532: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id(p_header_id);
533: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_header_id);
534:
535:
536: --Validation for Exclusion Rules
537:

Line 636: ( p_item_orderability_rec IN OE_ITORD_UTIL.Item_Orderability_Rec

632: End Validate_item_orderability;
633:
634:
635: PROCEDURE Insert_Row
636: ( p_item_orderability_rec IN OE_ITORD_UTIL.Item_Orderability_Rec
637: , x_return_status OUT NOCOPY VARCHAR2
638: )
639: IS
640: BEGIN

Line 688: ( p_item_orderability_rec IN OE_ITORD_UTIL.Item_Orderability_Rec

684:
685: END;
686:
687: PROCEDURE Update_Row
688: ( p_item_orderability_rec IN OE_ITORD_UTIL.Item_Orderability_Rec
689: , x_return_status OUT NOCOPY VARCHAR2
690: )
691: IS
692: BEGIN

Line 725: ( p_item_orderability_rules_rec IN OE_ITORD_UTIL.Item_Orderability_Rules_Rec

721: END;
722:
723:
724: PROCEDURE Insert_Row
725: ( p_item_orderability_rules_rec IN OE_ITORD_UTIL.Item_Orderability_Rules_Rec
726: , x_return_status OUT NOCOPY VARCHAR2
727: , x_rowid OUT NOCOPY ROWID
728: )
729: IS

Line 833: ( p_item_orderability_rules_rec IN OE_ITORD_UTIL.Item_Orderability_Rules_Rec

829:
830: END;
831:
832: PROCEDURE Update_Row
833: ( p_item_orderability_rules_rec IN OE_ITORD_UTIL.Item_Orderability_Rules_Rec
834: , p_row_id IN ROWID
835: , x_return_status OUT NOCOPY VARCHAR2
836: )
837: IS

Line 1128: END OE_ITORD_UTIL;

1124: End get_sales_channel_code;
1125:
1126:
1127:
1128: END OE_ITORD_UTIL;