DBA Data[Home] [Help]

APPS.OE_ITORD_PUB dependencies on OE_ITORD_UTIL

Line 893: IF NOT OE_ITORD_UTIL.Check_Duplicate_Rules(sql_stmt)

889: END IF;
890:
891:
892:
893: IF NOT OE_ITORD_UTIL.Check_Duplicate_Rules(sql_stmt)
894: THEN
895: fnd_message.set_name('ONT','OE_ITORD_DUP_RULE_EXISTS');
896: fnd_message.set_token('RULE_LEVEL',l_rule_level_coulmn);
897: fnd_message.set_token('RULE_LEVEL_VALUE',l_rule_level_value);

Line 956: IF NOT OE_ITORD_UTIL.Check_Duplicate_Rules(sql_stmt)

952: END IF;
953:
954:
955:
956: IF NOT OE_ITORD_UTIL.Check_Duplicate_Rules(sql_stmt)
957: THEN
958: fnd_message.set_name('ONT','OE_ITORD_DUP_RULE_EXISTS');
959: fnd_message.set_token('RULE_LEVEL',l_rule_level_coulmn);
960: fnd_message.set_token('RULE_LEVEL_VALUE',l_rule_level_value);

Line 1044: l_item_orderability_rec OE_ITORD_UTIL.Item_Orderability_Rec;

1040: End;
1041:
1042: Procedure insert_rules( p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec ) IS
1043:
1044: l_item_orderability_rec OE_ITORD_UTIL.Item_Orderability_Rec;
1045: l_item_orderability_rules_rec OE_ITORD_UTIL.Item_Orderability_Rules_Rec;
1046: l_orderability_id NUMBER;
1047: l_status VARCHAR2(1);
1048: l_rowid rowid := NULL;

Line 1045: l_item_orderability_rules_rec OE_ITORD_UTIL.Item_Orderability_Rules_Rec;

1041:
1042: Procedure insert_rules( p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec ) IS
1043:
1044: l_item_orderability_rec OE_ITORD_UTIL.Item_Orderability_Rec;
1045: l_item_orderability_rules_rec OE_ITORD_UTIL.Item_Orderability_Rules_Rec;
1046: l_orderability_id NUMBER;
1047: l_status VARCHAR2(1);
1048: l_rowid rowid := NULL;
1049:

Line 1096: OE_ITORD_UTIL.INSERT_ROW (l_item_orderability_rec,l_status);

1092: l_item_orderability_rec.last_updated_by := p_Item_Orderability_Import_Rec.last_updated_by;
1093: l_item_orderability_rec.last_update_date := p_Item_Orderability_Import_Rec.last_update_date;
1094:
1095:
1096: OE_ITORD_UTIL.INSERT_ROW (l_item_orderability_rec,l_status);
1097: END IF;
1098:
1099:
1100: l_item_orderability_rules_rec.ORDERABILITY_ID := l_orderability_id;

Line 1140: OE_ITORD_UTIL.Insert_Row( l_item_orderability_rules_rec

1136: l_item_orderability_rules_rec.ATTRIBUTE18 := p_Item_Orderability_Import_Rec.ATTRIBUTE18;
1137: l_item_orderability_rules_rec.ATTRIBUTE19 := p_Item_Orderability_Import_Rec.ATTRIBUTE19;
1138: l_item_orderability_rules_rec.ATTRIBUTE20 := p_Item_Orderability_Import_Rec.ATTRIBUTE20;
1139:
1140: OE_ITORD_UTIL.Insert_Row( l_item_orderability_rules_rec
1141: , l_status
1142: , l_rowid
1143: );
1144: