APPS.AST_CAMP_OUTCOME_PVT dependencies on JTF_IH_WRAP_UPS

Line 421: Select object_type from JTF_IH_WRAP_UPS where object_id = p_Camp_id;

417: l_object_type VARCHAR2(50);
418: d_object_type VARCHAR2(50);
419:
420: Cursor WrapUp_Camp(p_Camp_id number) IS
421: Select object_type from JTF_IH_WRAP_UPS where object_id = p_Camp_id;
422:
423: BEGIN
424: -- Standard Start of API savepoint
425: SAVEPOINT Save_Change_PVT;

Line 470: update JTF_IH_WRAP_UPS

466: Fetch Wrapup_Camp into d_object_type;
467: if Wrapup_Camp%FOUND then
468:
469: if (l_object_type = 'DEFAULT') then
470: update JTF_IH_WRAP_UPS
471: set object_type = ''
472: where object_id <> p_object_id;
473: end if;
474:

Line 475: update JTF_IH_WRAP_UPS set

471: set object_type = ''
472: where object_id <> p_object_id;
473: end if;
474:
475: update JTF_IH_WRAP_UPS set
476: outcome_id = p_outcome_id,
477: result_id = p_result_id,
478: reason_id = p_reason_id,
479: action_activity_id = p_action_id,

Line 486: select JTF_IH_WRAP_UPS_S1.nextval into l_wrapId from dual;

482: object_type = l_object_type
483: where object_id = p_object_id;
484: else
485:
486: select JTF_IH_WRAP_UPS_S1.nextval into l_wrapId from dual;
487:
488: insert into JTF_IH_WRAP_UPS (WRAP_ID, OBJECT_ID, OUTCOME_ID,
489: RESULT_ID, REASON_ID, ACTION_ACTIVITY_ID, SOURCE_CODE_ID,
490: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, last_update_date,

Line 488: insert into JTF_IH_WRAP_UPS (WRAP_ID, OBJECT_ID, OUTCOME_ID,

484: else
485:
486: select JTF_IH_WRAP_UPS_S1.nextval into l_wrapId from dual;
487:
488: insert into JTF_IH_WRAP_UPS (WRAP_ID, OBJECT_ID, OUTCOME_ID,
489: RESULT_ID, REASON_ID, ACTION_ACTIVITY_ID, SOURCE_CODE_ID,
490: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, last_update_date,
491: SOURCE_CODE, object_type)
492: VALUES (l_wrapid, p_object_id, p_outcome_id, p_result_id,

Line 497: update JTF_IH_WRAP_UPS set OBJECT_TYPE = ''

493: p_reason_id, p_action_id, p_action_item_id, G_USER_ID, SYSDATE,
494: -1, SYSDATE, 'DEFAULT', l_object_type);
495:
496: if (l_object_type = 'DEFAULT') then
497: update JTF_IH_WRAP_UPS set OBJECT_TYPE = ''
498: where OBJECT_ID <> p_object_id;
499: end if;
500:
501: end if;