DBA Data[Home] [Help]

APPS.OE_ITORD_PUB dependencies on OE_ITORD_UTIL

Line 936: IF NOT OE_ITORD_UTIL.Check_Duplicate_Rules(sql_stmt)

932: END IF;
933:
934:
935:
936: IF NOT OE_ITORD_UTIL.Check_Duplicate_Rules(sql_stmt)
937: THEN
938: fnd_message.set_name('ONT','OE_ITORD_DUP_RULE_EXISTS');
939: fnd_message.set_token('RULE_LEVEL',l_rule_level_coulmn);
940: fnd_message.set_token('RULE_LEVEL_VALUE',l_rule_level_value);

Line 1001: IF NOT OE_ITORD_UTIL.Check_Duplicate_Rules(sql_stmt)

997: END IF;
998:
999:
1000:
1001: IF NOT OE_ITORD_UTIL.Check_Duplicate_Rules(sql_stmt)
1002: THEN
1003: fnd_message.set_name('ONT','OE_ITORD_DUP_RULE_EXISTS');
1004: fnd_message.set_token('RULE_LEVEL',l_rule_level_coulmn);
1005: fnd_message.set_token('RULE_LEVEL_VALUE',l_rule_level_value);

Line 1093: l_item_orderability_rec OE_ITORD_UTIL.Item_Orderability_Rec;

1089: End;
1090:
1091: Procedure insert_rules( p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec ) IS
1092:
1093: l_item_orderability_rec OE_ITORD_UTIL.Item_Orderability_Rec;
1094: l_item_orderability_rules_rec OE_ITORD_UTIL.Item_Orderability_Rules_Rec;
1095: l_orderability_id NUMBER;
1096: l_status VARCHAR2(1);
1097: l_rowid rowid := NULL;

Line 1094: l_item_orderability_rules_rec OE_ITORD_UTIL.Item_Orderability_Rules_Rec;

1090:
1091: Procedure insert_rules( p_Item_Orderability_Import_Rec IN OUT NOCOPY OE_ITORD_PUB.Item_Orderability_Import_Rec ) IS
1092:
1093: l_item_orderability_rec OE_ITORD_UTIL.Item_Orderability_Rec;
1094: l_item_orderability_rules_rec OE_ITORD_UTIL.Item_Orderability_Rules_Rec;
1095: l_orderability_id NUMBER;
1096: l_status VARCHAR2(1);
1097: l_rowid rowid := NULL;
1098:

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

1142: l_item_orderability_rec.last_updated_by := p_Item_Orderability_Import_Rec.last_updated_by;
1143: l_item_orderability_rec.last_update_date := p_Item_Orderability_Import_Rec.last_update_date;
1144:
1145:
1146: OE_ITORD_UTIL.INSERT_ROW (l_item_orderability_rec,l_status);
1147: END IF;
1148:
1149:
1150: l_item_orderability_rules_rec.ORDERABILITY_ID := l_orderability_id;

Line 1190: OE_ITORD_UTIL.Insert_Row( l_item_orderability_rules_rec

1186: l_item_orderability_rules_rec.ATTRIBUTE18 := p_Item_Orderability_Import_Rec.ATTRIBUTE18;
1187: l_item_orderability_rules_rec.ATTRIBUTE19 := p_Item_Orderability_Import_Rec.ATTRIBUTE19;
1188: l_item_orderability_rules_rec.ATTRIBUTE20 := p_Item_Orderability_Import_Rec.ATTRIBUTE20;
1189:
1190: OE_ITORD_UTIL.Insert_Row( l_item_orderability_rules_rec
1191: , l_status
1192: , l_rowid
1193: );
1194: