APPS.GMDRTVAL_PUB dependencies on FND_PROFILE

Line 508: l_user_id := FND_PROFILE.VALUE('USER_ID');

504: /* ================ */
505: missing_details EXCEPTION;
506: insert_failure EXCEPTION;
507: BEGIN
508: l_user_id := FND_PROFILE.VALUE('USER_ID');
509: DELETE FROM fm_rout_dep
510: WHERE routing_id = prouting_id;
511: OPEN Cur_get_routing_steps;
512: FETCH Cur_get_routing_steps INTO X_rout_step_rec;

Line 627: l_user_id := FND_PROFILE.VALUE('USER_ID');

623: /* ================ */
624: missing_details EXCEPTION;
625: insert_failure EXCEPTION;
626: BEGIN
627: l_user_id := FND_PROFILE.VALUE('USER_ID');
628: DELETE FROM fm_rout_dep
629: WHERE routing_id = prouting_id;
630: OPEN Cur_get_routing_steps;
631: FETCH Cur_get_routing_steps INTO X_rout_step_rec;