APPS.OE_ITORD_UTIL dependencies on OE_ITEM_ORDERABILITY

Line 437: From oe_item_orderability hdr,

433:
434: begin
435:
436: select 'Y' into l_exists
437: From oe_item_orderability hdr,
438: oe_item_orderability_rules rules
439: Where hdr.orderability_id = rules.orderability_id
440: and hdr.generally_available='Y'
441: and hdr.org_id = l_operating_unit_id

Line 438: oe_item_orderability_rules rules

434: begin
435:
436: select 'Y' into l_exists
437: From oe_item_orderability hdr,
438: oe_item_orderability_rules rules
439: Where hdr.orderability_id = rules.orderability_id
440: and hdr.generally_available='Y'
441: and hdr.org_id = l_operating_unit_id
442: and hdr.enable_flag = 'Y'

Line 472: From oe_item_orderability hdr,

468:
469: begin
470:
471: select 'Y' into l_exists
472: From oe_item_orderability hdr,
473: oe_item_orderability_rules rules
474: Where hdr.orderability_id = rules.orderability_id
475: and hdr.generally_available='N'
476: and hdr.org_id = l_operating_unit_id

Line 473: oe_item_orderability_rules rules

469: begin
470:
471: select 'Y' into l_exists
472: From oe_item_orderability hdr,
473: oe_item_orderability_rules rules
474: Where hdr.orderability_id = rules.orderability_id
475: and hdr.generally_available='N'
476: and hdr.org_id = l_operating_unit_id
477: and hdr.enable_flag = 'Y'

Line 502: From oe_item_orderability hdr

498: --This is to handle the inclusion rule case where only item orderablility header is defined but no rules are defined
499: --Item is generally not available in all cases(since no rule is defeined in detail block)
500:
501: select 'Y' into l_exists
502: From oe_item_orderability hdr
503: where hdr.generally_available='N'
504: and hdr.org_id = l_operating_unit_id
505: and hdr.enable_flag = 'Y'
506: and (hdr.inventory_item_id = p_line_rec.inventory_item_id or hdr.item_category_id = l_x_item_category_id )

Line 572: From oe_item_orderability hdr,

568:
569: begin
570:
571: select 'Y' into l_exists
572: From oe_item_orderability hdr,
573: oe_item_orderability_rules rules
574: Where hdr.orderability_id = rules.orderability_id
575: and hdr.generally_available='Y'
576: and hdr.org_id = p_org_id

Line 573: oe_item_orderability_rules rules

569: begin
570:
571: select 'Y' into l_exists
572: From oe_item_orderability hdr,
573: oe_item_orderability_rules rules
574: Where hdr.orderability_id = rules.orderability_id
575: and hdr.generally_available='Y'
576: and hdr.org_id = p_org_id
577: and hdr.enable_flag = 'Y'

Line 607: From oe_item_orderability hdr,

603:
604: begin
605:
606: select 'Y' into l_exists
607: From oe_item_orderability hdr,
608: oe_item_orderability_rules rules
609: Where hdr.orderability_id = rules.orderability_id
610: and hdr.generally_available='N'
611: and hdr.org_id = p_org_id

Line 608: oe_item_orderability_rules rules

604: begin
605:
606: select 'Y' into l_exists
607: From oe_item_orderability hdr,
608: oe_item_orderability_rules rules
609: Where hdr.orderability_id = rules.orderability_id
610: and hdr.generally_available='N'
611: and hdr.org_id = p_org_id
612: and hdr.enable_flag = 'Y'

Line 634: From oe_item_orderability hdr

630: Exception
631: when no_data_found then
632: begin
633: select 'Y' into l_exists
634: From oe_item_orderability hdr
635: where hdr.generally_available='N'
636: and hdr.org_id = p_org_id
637: and hdr.enable_flag = 'Y'
638: and (hdr.inventory_item_id = p_inventory_item_id or hdr.item_category_id = l_x_item_category_id )

Line 675: INSERT INTO OE_ITEM_ORDERABILITY

671: BEGIN
672:
673: x_return_status := FND_API.G_RET_STS_SUCCESS;
674:
675: INSERT INTO OE_ITEM_ORDERABILITY
676: (
677: orderability_id,
678: org_id,
679: item_level,

Line 713: ,'Insert_Row - OE_ITEM_ORDERABILITY'

709:
710: OE_MSG_PUB.Add_Exc_Msg
711: (
712: G_PKG_NAME
713: ,'Insert_Row - OE_ITEM_ORDERABILITY'
714: );
715:
716: END;
717:

Line 727: UPDATE OE_ITEM_ORDERABILITY

723: BEGIN
724:
725: x_return_status := FND_API.G_RET_STS_SUCCESS;
726:
727: UPDATE OE_ITEM_ORDERABILITY
728: SET item_level = p_item_orderability_rec.item_level,
729: item_category_id = p_item_orderability_rec.item_category_id,
730: inventory_item_id = p_item_orderability_rec.inventory_item_id,
731: generally_available = p_item_orderability_rec.generally_available,

Line 749: ,'Update_Row - OE_ITEM_ORDERABILITY'

745:
746: OE_MSG_PUB.Add_Exc_Msg
747: (
748: G_PKG_NAME
749: ,'Update_Row - OE_ITEM_ORDERABILITY'
750: );
751:
752: END;
753:

Line 765: INSERT INTO OE_ITEM_ORDERABILITY_RULES

761: BEGIN
762:
763: x_return_status := FND_API.G_RET_STS_SUCCESS;
764:
765: INSERT INTO OE_ITEM_ORDERABILITY_RULES
766: (
767: ORDERABILITY_ID,
768: RULE_LEVEL,
769: CUSTOMER_ID,

Line 858: ,'Insert_Row - OE_ITEM_ORDERABILITY_RULES'

854:
855: OE_MSG_PUB.Add_Exc_Msg
856: (
857: G_PKG_NAME
858: ,'Insert_Row - OE_ITEM_ORDERABILITY_RULES'
859: );
860:
861: END;
862:

Line 873: UPDATE OE_ITEM_ORDERABILITY_RULES

869: BEGIN
870:
871: x_return_status := FND_API.G_RET_STS_SUCCESS;
872:
873: UPDATE OE_ITEM_ORDERABILITY_RULES
874: SET RULE_LEVEL = p_item_orderability_rules_rec.RULE_LEVEL,
875: CUSTOMER_ID = p_item_orderability_rules_rec.CUSTOMER_ID,
876: CUSTOMER_CLASS_ID = p_item_orderability_rules_rec.CUSTOMER_CLASS_ID,
877: CUSTOMER_CATEGORY_CODE = p_item_orderability_rules_rec.CUSTOMER_CATEGORY_CODE,

Line 924: ,'Update_Row - OE_ITEM_ORDERABILITY_RULES'

920:
921: OE_MSG_PUB.Add_Exc_Msg
922: (
923: G_PKG_NAME
924: ,'Update_Row - OE_ITEM_ORDERABILITY_RULES'
925: );
926:
927: END;
928: