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_API_GRP dependencies on FND_PROFILE

Line 6: l_resp_id NUMBER := FND_PROFILE.VALUE('RESP_ID');

2: /* $Header: GMDGAPIB.pls 120.32 2008/01/29 19:55:26 rnalla noship $ */
3:
4:
5: l_package_name CONSTANT VARCHAR2 (30) := 'GMD_API_GRP';
6: l_resp_id NUMBER := FND_PROFILE.VALUE('RESP_ID');
7: --Bug 3222090, NSRIVAST 20-FEB-2004, BEGIN
8: --Forward declaration.
9: FUNCTION set_debug_flag RETURN VARCHAR2;
10: l_debug VARCHAR2(1) := set_debug_flag;

Line 80: gmd_api_grp.login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));

76: FUNCTION setup
77: RETURN BOOLEAN IS
78: missing_profile_option EXCEPTION;
79: BEGIN
80: gmd_api_grp.login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
81: gmd_api_grp.user_id := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
82: gmd_api_grp.resp_id := TO_NUMBER (fnd_profile.VALUE ('RESP_ID'));
83:
84: IF NVL (gmd_api_grp.user_id, 0) = 0 THEN

Line 81: gmd_api_grp.user_id := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

77: RETURN BOOLEAN IS
78: missing_profile_option EXCEPTION;
79: BEGIN
80: gmd_api_grp.login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
81: gmd_api_grp.user_id := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
82: gmd_api_grp.resp_id := TO_NUMBER (fnd_profile.VALUE ('RESP_ID'));
83:
84: IF NVL (gmd_api_grp.user_id, 0) = 0 THEN
85: log_message (

Line 82: gmd_api_grp.resp_id := TO_NUMBER (fnd_profile.VALUE ('RESP_ID'));

78: missing_profile_option EXCEPTION;
79: BEGIN
80: gmd_api_grp.login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
81: gmd_api_grp.user_id := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
82: gmd_api_grp.resp_id := TO_NUMBER (fnd_profile.VALUE ('RESP_ID'));
83:
84: IF NVL (gmd_api_grp.user_id, 0) = 0 THEN
85: log_message (
86: 'GMD_API_INVALID_USER_ID'

Line 1136: l_default_user_id VARCHAR2(240) := fnd_profile.value('GMD_DEFAULT_USER');

1132: /* Local Variables */
1133:
1134: l_vpd_flag VARCHAR2(1) := 'N';
1135: l_access_type_ind VARCHAR2(1);
1136: l_default_user_id VARCHAR2(240) := fnd_profile.value('GMD_DEFAULT_USER');
1137: l_exists PLS_INTEGER;
1138: BEGIN
1139: /* First check if the VPD flag is set */
1140: OPEN get_vpd_flag;

Line 1434: ** 25-May-2004 B3653935 GK Changed variables login_id, user_id to be assigned to FND_PROFILE.VALUE

1430: ** 24-May-2004 B3643405 GK Added the statement orgn IS NULL to cursor c_get_recipe_info
1431: ** 25-May-2004 B3645706 GK Removed the statement orgn IS NULL to cursor c_get_recipe_info
1432: ** and created a new cursor c_get_global_info to accomodate for global and
1433: ** so that the orgn code will pick up the correct configuration information
1434: ** 25-May-2004 B3653935 GK Changed variables login_id, user_id to be assigned to FND_PROFILE.VALUE
1435: ** 25-May-2004 B GK In the global records the start date and end date still referenced the local so changed this
1436: ** 01-dec-2004 kkillams orgn_code is replaced with organization_id/owner_organization_id w.r.t. 4004501
1437: ** 10-Feb-2005 4004501 Krishna Added Revision column, in the retrival information.
1438: ** 18-APR-2006 kmotupal Added check for default status while retrieving recipe VR details

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

1517:
1518: OPEN c_get_recipe_info(l_orgn_id);
1519: FETCH c_get_recipe_info INTO LocalInfoRecord;
1520: IF c_get_recipe_info%FOUND THEN
1521: l_user_id := FND_PROFILE.VALUE('USER_ID');
1522: l_login_id := FND_PROFILE.VALUE ('LOGIN_ID');
1523:
1524: IF LocalInfoRecord.start_date_type = 0 THEN
1525: OPEN c_get_formula;

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

1518: OPEN c_get_recipe_info(l_orgn_id);
1519: FETCH c_get_recipe_info INTO LocalInfoRecord;
1520: IF c_get_recipe_info%FOUND THEN
1521: l_user_id := FND_PROFILE.VALUE('USER_ID');
1522: l_login_id := FND_PROFILE.VALUE ('LOGIN_ID');
1523:
1524: IF LocalInfoRecord.start_date_type = 0 THEN
1525: OPEN c_get_formula;
1526: FETCH c_get_formula INTO LocalDateRecord;

Line 1646: ** 25-May-2004 B3653935 GK Changed variables login_id, user_id to be assigned to FND_PROFILE.VALUE

1642: ** 24-May-2004 B3643405 GK Added the statement orgn IS NULL to cursor c_get_recipe_info
1643: ** 25-May-2004 B3645706 GK Removed the statement orgn IS NULL to cursor c_get_recipe_info
1644: ** and created a new cursor c_get_global_info to accomodate for global and
1645: ** so that the orgn code will pick up the correct configuration information
1646: ** 25-May-2004 B3653935 GK Changed variables login_id, user_id to be assigned to FND_PROFILE.VALUE
1647: ** 01-dec-2004 kkillams orgn_code is replaced with organization_id/owner_organization_id w.r.t. 4004501
1648: ** 18-APR-2006 kmotupal Added check for default status while retrieving recipe details
1649: ** 30-MAY-2006 Kalyani Bug 5218106 Added code to default recipe_type from orgn parameters.
1650: ** 03-Jan-07 Kapil M LCF-GMO ME : Bug#5458666. Added routing_id to retrieve_recipe

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

1743: OPEN c_get_recipe_info(l_orgn_id);
1744: FETCH c_get_recipe_info INTO LocalInfoRecord;
1745: IF c_get_recipe_info%FOUND THEN
1746: l_recipe_name := LocalInfoRecord.recipe_naming_convention;
1747: l_user_id := FND_PROFILE.VALUE('USER_ID');
1748: l_login_id := FND_PROFILE.VALUE ('LOGIN_ID');
1749: END IF;
1750: CLOSE c_get_recipe_info;
1751:

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

1744: FETCH c_get_recipe_info INTO LocalInfoRecord;
1745: IF c_get_recipe_info%FOUND THEN
1746: l_recipe_name := LocalInfoRecord.recipe_naming_convention;
1747: l_user_id := FND_PROFILE.VALUE('USER_ID');
1748: l_login_id := FND_PROFILE.VALUE ('LOGIN_ID');
1749: END IF;
1750: CLOSE c_get_recipe_info;
1751:
1752: IF l_recipe_name = 0 THEN