APPS.OE_UPG_PC dependencies on OE_UPGRADE_PC_CONDNS

Line 254: FROM oe_upgrade_pc_condns

250: BEGIN
251:
252: SELECT vtmplt_id
253: INTO l_vtmplt_id
254: FROM oe_upgrade_pc_condns
255: WHERE condition_code = p_condition_code
256: AND old_object_id = p_old_object_id
257: AND NVL(action_id,FND_API.G_MISS_NUM) = NVL(p_action_id,FND_API.G_MISS_NUM)
258: AND NVL(result_id,FND_API.G_MISS_NUM) = NVL(p_result_id,FND_API.G_MISS_NUM)

Line 267: UPDATE oe_upgrade_pc_condns

263: END IF;
264:
265: FOR I IN 1..p_condn_table.COUNT LOOP
266: IF NOT updated THEN
267: UPDATE oe_upgrade_pc_condns
268: SET new_entity_id = p_entity_id
269: , validation_entity_id = nvl(p_condn_table(I).validation_entity_id
270: ,p_entity_id)
271: , vtmplt_id = p_condn_table(I).validation_tmplt_id

Line 281: INSERT INTO oe_upgrade_pc_condns

277: = NVL(p_result_id,FND_API.G_MISS_NUM)
278: AND condition_code = p_condition_code;
279: updated := TRUE;
280: ELSE
281: INSERT INTO oe_upgrade_pc_condns
282: (condition_code
283: ,vtmplt_id
284: ,OLD_OBJECT_ID
285: ,ACTION_ID

Line 310: FROM oe_upgrade_pc_condns

306:
307: PROCEDURE Upgrade_insert_condns IS
308: CURSOR old_condns IS
309: SELECT distinct OLD_OBJECT_ID, CONDITION_CODE, ACTION_ID, RESULT_ID
310: FROM oe_upgrade_pc_condns
311: ORDER BY OLD_OBJECT_ID, CONDITION_CODE, ACTION_ID, RESULT_ID;
312: l_condn_table condn_table;
313: l_entity_condn_table condn_table;
314: l_entity_id NUMBER;

Line 321: update oe_upgrade_pc_condns

317: --
318: BEGIN
319:
320: -- set all the columns in R11i to null
321: update oe_upgrade_pc_condns
322: set vtmplt_id = null
323: , new_entity_id = null
324: , validation_entity_id = null
325: , group_number = null;

Line 332: delete from oe_upgrade_pc_condns

328: -- columns in R11 that need to be upgraded. This will delete
329: -- duplicate rows for the old conditions that may have been
330: -- created when this data was populated previously using
331: -- this script
332: delete from oe_upgrade_pc_condns
333: where rowid not in (
334: select min(rowid) from oe_upgrade_pc_condns
335: group by old_object_id, condition_code, action_id, result_id
336: ) ;

Line 334: select min(rowid) from oe_upgrade_pc_condns

330: -- created when this data was populated previously using
331: -- this script
332: delete from oe_upgrade_pc_condns
333: where rowid not in (
334: select min(rowid) from oe_upgrade_pc_condns
335: group by old_object_id, condition_code, action_id, result_id
336: ) ;
337:
338: