APPS.IBE_PROD_RELATION_RULE_PVT dependencies on IBE_CT_RELATION_RULES

Line 56: INSERT INTO IBE_CT_RELATION_RULES(

52: FND_MSG_PUB.Add;
53: RAISE FND_API.G_EXC_ERROR;
54: END IF;
55:
56: INSERT INTO IBE_CT_RELATION_RULES(
57: relation_rule_id, object_version_number, created_by,
58: creation_date, last_updated_by, last_update_date,
59: relation_type_code, origin_object_type,
60: dest_object_type, sql_statement

Line 63: IBE_CT_RELATION_RULES_S1.NEXTVAL, 1, L_USER_ID,

59: relation_type_code, origin_object_type,
60: dest_object_type, sql_statement
61: )
62: VALUES(
63: IBE_CT_RELATION_RULES_S1.NEXTVAL, 1, L_USER_ID,
64: SYSDATE, L_USER_ID, SYSDATE,
65: p_rel_type_code, 'N',
66: 'N', p_sql_statement
67: );

Line 177: INSERT INTO IBE_CT_RELATION_RULES(

173: IBE_UTIL.debug('Inserting the mapping rules from the Preview page.');
174: END IF;
175: FOR i IN 1..p_origin_object_type_tbl.COUNT LOOP
176: BEGIN
177: INSERT INTO IBE_CT_RELATION_RULES(
178: relation_rule_id, object_version_number, created_by,
179: creation_date, last_updated_by, last_update_date,
180: relation_type_code, origin_object_type,
181: dest_object_type, origin_object_id, dest_object_id

Line 184: ibe_ct_relation_rules_s1.nextval, 1, L_USER_ID,

180: relation_type_code, origin_object_type,
181: dest_object_type, origin_object_id, dest_object_id
182: )
183: VALUES(
184: ibe_ct_relation_rules_s1.nextval, 1, L_USER_ID,
185: SYSDATE, L_USER_ID, SYSDATE,
186: p_rel_type_code, p_origin_object_type_tbl(i),
187: p_dest_object_type_tbl(i), p_origin_object_id_tbl(i), p_dest_object_id_tbl(i)
188: )

Line 218: INSERT INTO IBE_CT_RELATION_RULES(

214: END IF;
215: FOR i IN 1..p_origin_object_type_tbl.COUNT LOOP
216: FOR j IN 1..p_dest_object_type_tbl.COUNT LOOP
217: BEGIN
218: INSERT INTO IBE_CT_RELATION_RULES(
219: relation_rule_id, object_version_number, created_by,
220: creation_date, last_updated_by, last_update_date,
221: relation_type_code, origin_object_type,
222: dest_object_type, origin_object_id, dest_object_id

Line 225: ibe_ct_relation_rules_s1.nextval, 1, L_USER_ID,

221: relation_type_code, origin_object_type,
222: dest_object_type, origin_object_id, dest_object_id
223: )
224: VALUES(
225: ibe_ct_relation_rules_s1.nextval, 1, L_USER_ID,
226: SYSDATE, L_USER_ID, SYSDATE,
227: p_rel_type_code, p_origin_object_type_tbl(i),
228: p_dest_object_type_tbl(j), p_origin_object_id_tbl(i), p_dest_object_id_tbl(j)
229: )

Line 352: UPDATE IBE_CT_RELATION_RULES

348: FND_MSG_PUB.Add;
349: RAISE FND_API.G_EXC_ERROR;
350: END IF;
351:
352: UPDATE IBE_CT_RELATION_RULES
353: SET object_version_number = object_version_number + 1,
354: sql_statement = p_sql_statement
355: WHERE relation_rule_id = p_rel_rule_id
356: AND object_version_number = p_obj_ver_num;

Line 453: IBE_UTIL.debug('Deleting rows in IBE_CT_RELATION_RULES.');

449: IBE_UTIL.debug('IBE_Prod_Relation_Rule_PVT.Delete_Rule(+)');
450: END IF;
451: -- API body
452: IF (l_debug = 'Y') THEN
453: IBE_UTIL.debug('Deleting rows in IBE_CT_RELATION_RULES.');
454: END IF;
455: FORALL i IN p_rel_rule_id_tbl.FIRST..p_rel_rule_id_tbl.LAST
456: DELETE
457: FROM ibe_ct_relation_rules

Line 457: FROM ibe_ct_relation_rules

453: IBE_UTIL.debug('Deleting rows in IBE_CT_RELATION_RULES.');
454: END IF;
455: FORALL i IN p_rel_rule_id_tbl.FIRST..p_rel_rule_id_tbl.LAST
456: DELETE
457: FROM ibe_ct_relation_rules
458: WHERE relation_rule_id = p_rel_rule_id_tbl(i)
459: AND object_version_number = p_obj_ver_num_tbl(i);
460:
461: IF SQL%NOTFOUND THEN

Line 463: IBE_UTIL.debug('Failed delete statement for IBE_CT_RELATION_RULES.');

459: AND object_version_number = p_obj_ver_num_tbl(i);
460:
461: IF SQL%NOTFOUND THEN
462: IF (l_debug = 'Y') THEN
463: IBE_UTIL.debug('Failed delete statement for IBE_CT_RELATION_RULES.');
464: END IF;
465: FND_MESSAGE.Set_Name('IBE', 'IBE_CT_REL_RULE_NOT_DELETED');
466: FND_MSG_PUB.Add;
467: RAISE FND_API.G_EXC_ERROR;