APPS.GMP_BOM_ROUTING_PKG dependencies on FND_PROFILE

Line 482: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('GMP_DEBUG_ENABLED'),'N'); -- BUG: 8420747

478:
479: /* Global Scalar values follow
480: =========================== */
481:
482: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('GMP_DEBUG_ENABLED'),'N'); -- BUG: 8420747
483:
484:
485: s PLS_INTEGER := 1;
486: sd_index INTEGER := 0 ; -- B4918786 (RDP) SDS

Line 1166: -- l_gmp_um_code := fnd_profile.VALUE('BOM:HOUR_UOM_CODE');

1162:
1163: /* bug: 6710684 Vpedarla making changes to take the profile value from source server
1164: and also made changes to use procedure get_profile_value */
1165: -- commented the below code line
1166: -- l_gmp_um_code := fnd_profile.VALUE('BOM:HOUR_UOM_CODE');
1167: l_gmp_um_code := get_profile_value('BOM:HOUR_UOM_CODE', at_apps_link );
1168: /* bug: 6710684 end of changes */
1169:
1170: IF l_gmp_um_code IS NOT NULL THEN

Line 7378: -- l_profile := FND_PROFILE.VALUE('BOM:HOUR_UOM_CODE');

7374: time_stamp;
7375: /* bug: 6710684 Vpedarla making changes to take the profile value from source server
7376: and also made changes to use procedure get_profile_value */
7377: -- commented the below code line
7378: -- l_profile := FND_PROFILE.VALUE('BOM:HOUR_UOM_CODE');
7379: l_profile := get_profile_value('BOM:HOUR_UOM_CODE' , at_apps_link);
7380:
7381: -- ZERO Transitions (Alternate Resources are considered)
7382: stmt_no := 910 ;

Line 8154: uom_code_dblink := 'select fnd_profile.VALUE'||pdblink||'('''||profile_name||''')'||' from dual ';

8150: l_gmp_um_code VARCHAR2(32767);
8151: BEGIN
8152: LOG_MESSAGE(' GMP_BOM_ROUTING_PKG.get_profile_value called for profile '||profile_name||' with dblink '||pdblink);
8153:
8154: uom_code_dblink := 'select fnd_profile.VALUE'||pdblink||'('''||profile_name||''')'||' from dual ';
8155:
8156: OPEN uom_code_ref for uom_code_dblink ;
8157: FETCH uom_code_ref INTO l_gmp_um_code;
8158: CLOSE uom_code_ref;