771: l_pend_matl NUMBER;
772: l_pend_ship NUMBER;
773: l_uncost_matl NUMBER;
774:
775: l_user_id fnd_user.user_id%TYPE;
776: l_user fnd_user.user_name%TYPE;
777: l_login_id NUMBER;
778: l_prog_appl_id NUMBER;
779: l_program_id NUMBER;
772: l_pend_ship NUMBER;
773: l_uncost_matl NUMBER;
774:
775: l_user_id fnd_user.user_id%TYPE;
776: l_user fnd_user.user_name%TYPE;
777: l_login_id NUMBER;
778: l_prog_appl_id NUMBER;
779: l_program_id NUMBER;
780: l_request_id NUMBER;
844:
845: l_user_id := FND_PROFILE.VALUE('USER_ID');
846:
847: SELECT user_name INTO l_user
848: FROM fnd_user
849: WHERE user_id = l_user_id;
850:
851: l_login_id := FND_GLOBAL.LOGIN_ID;
852: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;