eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_RECIPE_DESIGNER_PKG dependencies on FND_PROFILE

Line 2026: -- FND_PROFILE.VALUE('USER_ID');

2022: x_return_code OUT NOCOPY VARCHAR2,
2023: x_error_msg OUT NOCOPY VARCHAR2) IS
2024:
2025: l_user_id NUMBER := fnd_global.user_id;
2026: -- FND_PROFILE.VALUE('USER_ID');
2027: l_login_id NUMBER := fnd_global.login_id;
2028: --FND_PROFILE.VALUE('LOGIN_ID');
2029:
2030: CURSOR Cur_recipe_id IS

Line 2028: --FND_PROFILE.VALUE('LOGIN_ID');

2024:
2025: l_user_id NUMBER := fnd_global.user_id;
2026: -- FND_PROFILE.VALUE('USER_ID');
2027: l_login_id NUMBER := fnd_global.login_id;
2028: --FND_PROFILE.VALUE('LOGIN_ID');
2029:
2030: CURSOR Cur_recipe_id IS
2031: SELECT gmd_recipe_id_s.NEXTVAL
2032: FROM FND_DUAL;

Line 2251: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');

2247: l_msg_cnt NUMBER;
2248: l_msg_dat VARCHAR2(30);
2249: l_message VARCHAR2(1000);
2250: l_dummy NUMBER;
2251: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');
2252: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
2253: CREATE_CUST_EXCEPTION EXCEPTION;
2254:
2255: BEGIN

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

2248: l_msg_dat VARCHAR2(30);
2249: l_message VARCHAR2(1000);
2250: l_dummy NUMBER;
2251: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');
2252: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
2253: CREATE_CUST_EXCEPTION EXCEPTION;
2254:
2255: BEGIN
2256:

Line 2421: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');

2417: l_msg_cnt NUMBER;
2418: l_msg_dat VARCHAR2(30);
2419: l_message VARCHAR2(1000);
2420: l_dummy NUMBER;
2421: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');
2422: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
2423: CREATE_LOSS_EXCEPTION EXCEPTION;
2424:
2425: BEGIN

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

2418: l_msg_dat VARCHAR2(30);
2419: l_message VARCHAR2(1000);
2420: l_dummy NUMBER;
2421: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');
2422: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
2423: CREATE_LOSS_EXCEPTION EXCEPTION;
2424:
2425: BEGIN
2426:

Line 2647: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');

2643: l_msg_cnt NUMBER;
2644: l_msg_dat VARCHAR2(30);
2645: l_message VARCHAR2(1000);
2646: l_dummy NUMBER;
2647: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');
2648: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
2649: UPDATE_LOSS_EXCEPTION EXCEPTION;
2650:
2651: BEGIN

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

2644: l_msg_dat VARCHAR2(30);
2645: l_message VARCHAR2(1000);
2646: l_dummy NUMBER;
2647: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');
2648: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
2649: UPDATE_LOSS_EXCEPTION EXCEPTION;
2650:
2651: BEGIN
2652:

Line 2758: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');

2754: l_msg_cnt NUMBER;
2755: l_msg_dat VARCHAR2(30);
2756: l_message VARCHAR2(1000);
2757: l_dummy NUMBER;
2758: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');
2759: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
2760: DELETE_RECIPE_EXCEPTION EXCEPTION;
2761:
2762: BEGIN

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

2755: l_msg_dat VARCHAR2(30);
2756: l_message VARCHAR2(1000);
2757: l_dummy NUMBER;
2758: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');
2759: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
2760: DELETE_RECIPE_EXCEPTION EXCEPTION;
2761:
2762: BEGIN
2763:

Line 2906: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');

2902: l_msg_cnt NUMBER;
2903: l_msg_dat VARCHAR2(30);
2904: l_message VARCHAR2(1000);
2905: l_dummy NUMBER;
2906: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');
2907: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
2908: DELETE_RECIPE_EXCEPTION EXCEPTION;
2909:
2910: BEGIN

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

2903: l_msg_dat VARCHAR2(30);
2904: l_message VARCHAR2(1000);
2905: l_dummy NUMBER;
2906: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');
2907: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
2908: DELETE_RECIPE_EXCEPTION EXCEPTION;
2909:
2910: BEGIN
2911:

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

3211: x_routing_id OUT NOCOPY NUMBER,
3212: x_return_code OUT NOCOPY VARCHAR2,
3213: x_error_msg OUT NOCOPY VARCHAR2) IS
3214:
3215: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
3216: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');
3217:
3218: CURSOR Cur_get_rcp_hdr IS
3219: SELECT *

Line 3216: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');

3212: x_return_code OUT NOCOPY VARCHAR2,
3213: x_error_msg OUT NOCOPY VARCHAR2) IS
3214:
3215: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
3216: l_login_id NUMBER := FND_PROFILE.VALUE('LOGIN_ID');
3217:
3218: CURSOR Cur_get_rcp_hdr IS
3219: SELECT *
3220: FROM gmd_recipes