APPS.OE_ITORD_UTIL dependencies on OE_ITEM_ORDERABILITY_RULES

Line 407: oe_item_orderability_rules rules

403: begin
404:
405: select 'Y' into l_exists
406: From oe_item_orderability hdr,
407: oe_item_orderability_rules rules
408: Where hdr.orderability_id = rules.orderability_id
409: and hdr.generally_available='Y'
410: and hdr.org_id = l_operating_unit_id
411: and hdr.enable_flag = 'Y'

Line 442: oe_item_orderability_rules rules

438: begin
439:
440: select 'Y' into l_exists
441: From oe_item_orderability hdr,
442: oe_item_orderability_rules rules
443: Where hdr.orderability_id = rules.orderability_id
444: and hdr.generally_available='N'
445: and hdr.org_id = l_operating_unit_id
446: and hdr.enable_flag = 'Y'

Line 542: oe_item_orderability_rules rules

538: begin
539:
540: select 'Y' into l_exists
541: From oe_item_orderability hdr,
542: oe_item_orderability_rules rules
543: Where hdr.orderability_id = rules.orderability_id
544: and hdr.generally_available='Y'
545: and hdr.org_id = p_org_id
546: and hdr.enable_flag = 'Y'

Line 577: oe_item_orderability_rules rules

573: begin
574:
575: select 'Y' into l_exists
576: From oe_item_orderability hdr,
577: oe_item_orderability_rules rules
578: Where hdr.orderability_id = rules.orderability_id
579: and hdr.generally_available='N'
580: and hdr.org_id = p_org_id
581: and hdr.enable_flag = 'Y'

Line 734: INSERT INTO OE_ITEM_ORDERABILITY_RULES

730: BEGIN
731:
732: x_return_status := FND_API.G_RET_STS_SUCCESS;
733:
734: INSERT INTO OE_ITEM_ORDERABILITY_RULES
735: (
736: ORDERABILITY_ID,
737: RULE_LEVEL,
738: CUSTOMER_ID,

Line 827: ,'Insert_Row - OE_ITEM_ORDERABILITY_RULES'

823:
824: OE_MSG_PUB.Add_Exc_Msg
825: (
826: G_PKG_NAME
827: ,'Insert_Row - OE_ITEM_ORDERABILITY_RULES'
828: );
829:
830: END;
831:

Line 842: UPDATE OE_ITEM_ORDERABILITY_RULES

838: BEGIN
839:
840: x_return_status := FND_API.G_RET_STS_SUCCESS;
841:
842: UPDATE OE_ITEM_ORDERABILITY_RULES
843: SET RULE_LEVEL = p_item_orderability_rules_rec.RULE_LEVEL,
844: CUSTOMER_ID = p_item_orderability_rules_rec.CUSTOMER_ID,
845: CUSTOMER_CLASS_ID = p_item_orderability_rules_rec.CUSTOMER_CLASS_ID,
846: CUSTOMER_CATEGORY_CODE = p_item_orderability_rules_rec.CUSTOMER_CATEGORY_CODE,

Line 893: ,'Update_Row - OE_ITEM_ORDERABILITY_RULES'

889:
890: OE_MSG_PUB.Add_Exc_Msg
891: (
892: G_PKG_NAME
893: ,'Update_Row - OE_ITEM_ORDERABILITY_RULES'
894: );
895:
896: END;
897: