APPS.CSZ_INTERACTION_PVT dependencies on JTF_IH_WRAP_UPS_VL

Line 178: select outcome_id, result_id, reason_id into l_outcome_id, l_result_id, l_reason_id from jtf_ih_wrap_ups_vl where wrap_id = l_wrap_id;

174: end;
175:
176: -- Retreive default values for populating the result, reason, outcome fields in JTF_IH_ACTIVITIES table
177: begin
178: select outcome_id, result_id, reason_id into l_outcome_id, l_result_id, l_reason_id from jtf_ih_wrap_ups_vl where wrap_id = l_wrap_id;
179: exception
180: when NO_DATA_FOUND then
181: x_return_status := Fnd_Api.G_RET_STS_ERROR;
182: Fnd_Message.SET_NAME('CS','Outcome, result, reason codes could not be found');

Line 471: select outcome_id, result_id, reason_id into l_outcome_id, l_result_id, l_reason_id from jtf_ih_wrap_ups_vl where wrap_id = l_wrap_id;

467:
468: -- dbms_output.put_line ('Got Profile Id=CSC_CC_WRAPUP_INTERACTION_DEFAULTS'|| ' Status=' || x_return_status);
469: -- Retreive default values for populating the result, reason, outcome fields in JTF_IH_ACTIVITIES table
470: begin
471: select outcome_id, result_id, reason_id into l_outcome_id, l_result_id, l_reason_id from jtf_ih_wrap_ups_vl where wrap_id = l_wrap_id;
472: exception
473: when NO_DATA_FOUND then
474: rollback to end_interaction_sp;
475: x_return_status := Fnd_Api.G_RET_STS_ERROR;