DBA Data[Home] [Help]

APPS.GMD_API_GRP dependencies on FND_PROFILE

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

2: /* $Header: GMDGAPIB.pls 120.35.12020000.3 2012/09/29 09:19:46 yanpewan ship $ */
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: /*bug 14108934, change nvl value to -1 instead of 0, 0 is the userid of seeded login SYSADMIN*/
84: IF NVL (gmd_api_grp.user_id, -1) = -1 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: /*bug 14108934, change nvl value to -1 instead of 0, 0 is the userid of seeded login SYSADMIN*/
84: IF NVL (gmd_api_grp.user_id, -1) = -1 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: /*bug 14108934, change nvl value to -1 instead of 0, 0 is the userid of seeded login SYSADMIN*/
84: IF NVL (gmd_api_grp.user_id, -1) = -1 THEN
85: log_message (
86: 'GMD_API_INVALID_USER_ID'

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

1138: /* Local Variables */
1139:
1140: l_vpd_flag VARCHAR2(1) := 'N';
1141: l_access_type_ind VARCHAR2(1);
1142: l_default_user_id VARCHAR2(240) := fnd_profile.value('GMD_DEFAULT_USER');
1143: l_exists PLS_INTEGER;
1144: BEGIN
1145: /* First check if the VPD flag is set */
1146: OPEN get_vpd_flag;

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

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

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

1523:
1524: OPEN c_get_recipe_info(l_orgn_id);
1525: FETCH c_get_recipe_info INTO LocalInfoRecord;
1526: IF c_get_recipe_info%FOUND THEN
1527: l_user_id := FND_PROFILE.VALUE('USER_ID');
1528: l_login_id := FND_PROFILE.VALUE ('LOGIN_ID');
1529:
1530: IF LocalInfoRecord.start_date_type = 0 THEN
1531: OPEN c_get_formula;

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

1524: OPEN c_get_recipe_info(l_orgn_id);
1525: FETCH c_get_recipe_info INTO LocalInfoRecord;
1526: IF c_get_recipe_info%FOUND THEN
1527: l_user_id := FND_PROFILE.VALUE('USER_ID');
1528: l_login_id := FND_PROFILE.VALUE ('LOGIN_ID');
1529:
1530: IF LocalInfoRecord.start_date_type = 0 THEN
1531: OPEN c_get_formula;
1532: FETCH c_get_formula INTO LocalDateRecord;

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

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

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

1757: OPEN c_get_recipe_info(l_orgn_id);
1758: FETCH c_get_recipe_info INTO LocalInfoRecord;
1759: IF c_get_recipe_info%FOUND THEN
1760: l_recipe_name := LocalInfoRecord.recipe_naming_convention;
1761: l_user_id := FND_PROFILE.VALUE('USER_ID');
1762: l_login_id := FND_PROFILE.VALUE ('LOGIN_ID');
1763: END IF;
1764: CLOSE c_get_recipe_info;
1765:

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

1758: FETCH c_get_recipe_info INTO LocalInfoRecord;
1759: IF c_get_recipe_info%FOUND THEN
1760: l_recipe_name := LocalInfoRecord.recipe_naming_convention;
1761: l_user_id := FND_PROFILE.VALUE('USER_ID');
1762: l_login_id := FND_PROFILE.VALUE ('LOGIN_ID');
1763: END IF;
1764: CLOSE c_get_recipe_info;
1765:
1766: IF l_recipe_name = 0 THEN