APPS.OE_UPG_PC dependencies on FND_API

Line 257: AND NVL(action_id,FND_API.G_MISS_NUM) = NVL(p_action_id,FND_API.G_MISS_NUM)

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)
259: AND rownum = 1;
260:
261: IF l_vtmplt_id IS NOT NULL THEN

Line 258: AND NVL(result_id,FND_API.G_MISS_NUM) = NVL(p_result_id,FND_API.G_MISS_NUM)

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)
259: AND rownum = 1;
260:
261: IF l_vtmplt_id IS NOT NULL THEN
262: updated := TRUE;

Line 274: AND NVL(action_id,FND_API.G_MISS_NUM)

270: ,p_entity_id)
271: , vtmplt_id = p_condn_table(I).validation_tmplt_id
272: , group_number = p_group_number
273: WHERE old_object_id = p_old_object_id
274: AND NVL(action_id,FND_API.G_MISS_NUM)
275: = NVL(p_action_id,FND_API.G_MISS_NUM)
276: AND NVL(result_id,FND_API.G_MISS_NUM)
277: = NVL(p_result_id,FND_API.G_MISS_NUM)
278: AND condition_code = p_condition_code;

Line 275: = NVL(p_action_id,FND_API.G_MISS_NUM)

271: , vtmplt_id = p_condn_table(I).validation_tmplt_id
272: , group_number = p_group_number
273: WHERE old_object_id = p_old_object_id
274: AND NVL(action_id,FND_API.G_MISS_NUM)
275: = NVL(p_action_id,FND_API.G_MISS_NUM)
276: AND NVL(result_id,FND_API.G_MISS_NUM)
277: = NVL(p_result_id,FND_API.G_MISS_NUM)
278: AND condition_code = p_condition_code;
279: updated := TRUE;

Line 276: AND NVL(result_id,FND_API.G_MISS_NUM)

272: , group_number = p_group_number
273: WHERE old_object_id = p_old_object_id
274: AND NVL(action_id,FND_API.G_MISS_NUM)
275: = NVL(p_action_id,FND_API.G_MISS_NUM)
276: AND NVL(result_id,FND_API.G_MISS_NUM)
277: = NVL(p_result_id,FND_API.G_MISS_NUM)
278: AND condition_code = p_condition_code;
279: updated := TRUE;
280: ELSE

Line 277: = NVL(p_result_id,FND_API.G_MISS_NUM)

273: WHERE old_object_id = p_old_object_id
274: AND NVL(action_id,FND_API.G_MISS_NUM)
275: = NVL(p_action_id,FND_API.G_MISS_NUM)
276: AND NVL(result_id,FND_API.G_MISS_NUM)
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