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.9.12020000.2 2012/12/04 04:30:22 kadiraju 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.9.12020000.2 2012/12/04 04:30:22 kadiraju 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 95: l_location_id := OE_ITORD_UTIL.Get_Shipto_Location_Id(p_ship_to_org_id);

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

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

221: begin
222: select concatenated_segments
223: into l_category
224: from mtl_categories_kfv
225: where category_id = OE_ITORD_UTIL.get_item_category_id (p_inventory_item_id);
226:
227: return l_category;
228: Exception
229: when others then

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

408:
409: begin
410:
411: l_operating_unit_id := p_line_rec.org_id;
412: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_line_rec.inventory_item_id);
413: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_line_rec.sold_to_org_id);
414: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_line_rec.ship_to_org_id);
415: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_line_rec.sold_to_org_id);
416: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id (p_line_rec.header_id);

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

409: begin
410:
411: l_operating_unit_id := p_line_rec.org_id;
412: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_line_rec.inventory_item_id);
413: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_line_rec.sold_to_org_id);
414: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_line_rec.ship_to_org_id);
415: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_line_rec.sold_to_org_id);
416: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id (p_line_rec.header_id);
417: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_line_rec.header_id);

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

410:
411: l_operating_unit_id := p_line_rec.org_id;
412: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_line_rec.inventory_item_id);
413: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_line_rec.sold_to_org_id);
414: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_line_rec.ship_to_org_id);
415: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_line_rec.sold_to_org_id);
416: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id (p_line_rec.header_id);
417: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_line_rec.header_id);
418:

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

411: l_operating_unit_id := p_line_rec.org_id;
412: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_line_rec.inventory_item_id);
413: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_line_rec.sold_to_org_id);
414: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_line_rec.ship_to_org_id);
415: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_line_rec.sold_to_org_id);
416: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id (p_line_rec.header_id);
417: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_line_rec.header_id);
418:
419: IF l_debug_level >0 then

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

412: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_line_rec.inventory_item_id);
413: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_line_rec.sold_to_org_id);
414: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_line_rec.ship_to_org_id);
415: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_line_rec.sold_to_org_id);
416: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id (p_line_rec.header_id);
417: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_line_rec.header_id);
418:
419: IF l_debug_level >0 then
420: oe_debug_pub.add('Entering OE_ITORD_UTIL.Validate_item_orderability',1);

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

413: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_line_rec.sold_to_org_id);
414: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_line_rec.ship_to_org_id);
415: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_line_rec.sold_to_org_id);
416: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id (p_line_rec.header_id);
417: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_line_rec.header_id);
418:
419: IF l_debug_level >0 then
420: oe_debug_pub.add('Entering OE_ITORD_UTIL.Validate_item_orderability',1);
421: oe_debug_pub.add('Inventory_item_id :'||p_line_rec.inventory_item_id);

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

416: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id (p_line_rec.header_id);
417: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_line_rec.header_id);
418:
419: IF l_debug_level >0 then
420: oe_debug_pub.add('Entering OE_ITORD_UTIL.Validate_item_orderability',1);
421: oe_debug_pub.add('Inventory_item_id :'||p_line_rec.inventory_item_id);
422: oe_debug_pub.add('Item Category Id :'||l_x_item_category_id);
423: oe_debug_pub.add('Customer ID :'|| p_line_rec.sold_to_org_id);
424: oe_debug_pub.add('Customer Class ID :'||l_x_customer_class_id);

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

515:
516: END IF;
517:
518:
519: oe_debug_pub.add('Exiting OE_ITORD_UTIL.Validate_item_orderability',1);
520:
521: Exception
522: when others then
523: OE_MSG_PUB.Add_Exc_Msg

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

555:
556: begin
557:
558:
559: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_inventory_item_id);
560: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_sold_to_org_id);
561: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_ship_to_org_id);
562: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_sold_to_org_id);
563: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id(p_header_id);

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

556: begin
557:
558:
559: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_inventory_item_id);
560: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_sold_to_org_id);
561: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_ship_to_org_id);
562: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_sold_to_org_id);
563: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id(p_header_id);
564: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_header_id);

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

557:
558:
559: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_inventory_item_id);
560: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_sold_to_org_id);
561: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_ship_to_org_id);
562: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_sold_to_org_id);
563: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id(p_header_id);
564: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_header_id);
565:

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

558:
559: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_inventory_item_id);
560: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_sold_to_org_id);
561: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_ship_to_org_id);
562: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_sold_to_org_id);
563: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id(p_header_id);
564: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_header_id);
565:
566:

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

559: l_x_item_category_id := OE_ITORD_UTIL.get_item_category_id (p_inventory_item_id);
560: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_sold_to_org_id);
561: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_ship_to_org_id);
562: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_sold_to_org_id);
563: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id(p_header_id);
564: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_header_id);
565:
566:
567: --Validation for Exclusion Rules

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

560: l_x_customer_class_id := OE_ITORD_UTIL.get_customer_class_id(p_sold_to_org_id);
561: l_x_region_id_list := OE_ITORD_UTIL.get_region_ids(p_ship_to_org_id);
562: l_x_customer_category_code := OE_ITORD_UTIL.get_customer_category_code (p_sold_to_org_id);
563: l_x_order_type_id := OE_ITORD_UTIL.get_order_type_id(p_header_id);
564: l_x_sales_channel_code := OE_ITORD_UTIL.get_sales_channel_code(p_header_id);
565:
566:
567: --Validation for Exclusion Rules
568:

Line 667: ( p_item_orderability_rec IN OE_ITORD_UTIL.Item_Orderability_Rec

663: End Validate_item_orderability;
664:
665:
666: PROCEDURE Insert_Row
667: ( p_item_orderability_rec IN OE_ITORD_UTIL.Item_Orderability_Rec
668: , x_return_status OUT NOCOPY VARCHAR2
669: )
670: IS
671: BEGIN

Line 719: ( p_item_orderability_rec IN OE_ITORD_UTIL.Item_Orderability_Rec

715:
716: END;
717:
718: PROCEDURE Update_Row
719: ( p_item_orderability_rec IN OE_ITORD_UTIL.Item_Orderability_Rec
720: , x_return_status OUT NOCOPY VARCHAR2
721: )
722: IS
723: BEGIN

Line 756: ( p_item_orderability_rules_rec IN OE_ITORD_UTIL.Item_Orderability_Rules_Rec

752: END;
753:
754:
755: PROCEDURE Insert_Row
756: ( p_item_orderability_rules_rec IN OE_ITORD_UTIL.Item_Orderability_Rules_Rec
757: , x_return_status OUT NOCOPY VARCHAR2
758: , x_rowid OUT NOCOPY ROWID
759: )
760: IS

Line 864: ( p_item_orderability_rules_rec IN OE_ITORD_UTIL.Item_Orderability_Rules_Rec

860:
861: END;
862:
863: PROCEDURE Update_Row
864: ( p_item_orderability_rules_rec IN OE_ITORD_UTIL.Item_Orderability_Rules_Rec
865: , p_row_id IN ROWID
866: , x_return_status OUT NOCOPY VARCHAR2
867: )
868: IS

Line 1159: END OE_ITORD_UTIL;

1155: End get_sales_channel_code;
1156:
1157:
1158:
1159: END OE_ITORD_UTIL;