APPS.OE_ITORD_UTIL dependencies on OE_ITEM_ORDERABILITY_RULES

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 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 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 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 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: