DBA Data[Home] [Help]

APPS.CSZ_INTERACTION_PVT dependencies on FND_PROFILE

Line 167: select FND_PROFILE.Value('CSC_CC_WRAPUP_INTERACTION_DEFAULTS') into l_wrap_id from dual;

163: raise NO_DATA_FOUND;
164: end;
165: -- Profile Values from wrap up
166: begin
167: select FND_PROFILE.Value('CSC_CC_WRAPUP_INTERACTION_DEFAULTS') into l_wrap_id from dual;
168: exception
169: when NO_DATA_FOUND then
170: x_return_status := Fnd_Api.G_RET_STS_ERROR;
171: Fnd_Message.SET_NAME('CS','Profile "CSC_CC_WRAPUP_INTERACTION_DEFAULTS" could not be found');

Line 458: select FND_PROFILE.Value('CSC_CC_WRAPUP_INTERACTION_DEFAULTS') into l_wrap_id from dual;

454: -- dbms_output.put_line ('Got Resource Id=' || l_interaction_rec.resource_id|| ' Status=' || x_return_status);
455:
456: -- Profile Values from wrap up
457: begin
458: select FND_PROFILE.Value('CSC_CC_WRAPUP_INTERACTION_DEFAULTS') into l_wrap_id from dual;
459: exception
460: when NO_DATA_FOUND then
461: rollback to end_interaction_sp;
462: x_return_status := Fnd_Api.G_RET_STS_ERROR;