APPS.MTH_UTIL_PKG dependencies on FND_PROFILE

Line 1013: select fnd_profile.value(p_profile_name) into v_profile_value from dual;

1009: --Initialize the session for default values -1.
1010: /* fnd_global.apps_initialize(v_uid, v_rid, v_applid); */
1011:
1012: --select the value of the profile into the local variable.
1013: select fnd_profile.value(p_profile_name) into v_profile_value from dual;
1014:
1015: --Return the value.
1016: RETURN(v_profile_value);
1017:

Line 1143: v_profile := FND_PROFILE.VALUE('MTH_UDA_EQUIPMENT_PROFILE');

1139:
1140: BEGIN
1141:
1142: -- Get the profile value, it will be of form h_id:level_no
1143: v_profile := FND_PROFILE.VALUE('MTH_UDA_EQUIPMENT_PROFILE');
1144:
1145: -- based on the position of :, retrieve h_id
1146: v_pos := INSTR(v_profile,':');
1147: v_hId := SUBSTR(v_profile,1,v_pos-1);

Line 1177: v_profile := FND_PROFILE.VALUE('MTH_UDA_EQUIPMENT_PROFILE');

1173:
1174: BEGIN
1175:
1176: -- Get the profile value, it will be of form h_id:level_no
1177: v_profile := FND_PROFILE.VALUE('MTH_UDA_EQUIPMENT_PROFILE');
1178:
1179: -- based on the position of :, retrieve h_id
1180: v_pos := INSTR(v_profile,':');
1181: v_length := LENGTH(v_profile);

Line 3275: null,null,FND_PROFILE.VALUE('MTH_CATCH_ALL_NAME'),null, l_system_fk_key,

3271: creation_date,last_update_date,creation_system_id,
3272: last_update_system_id)
3273: VALUES(mth_workdays_shifts_s.nextval,TO_CHAR(l_start_date,'yyyymmdd-hh24:mi:ss')||'-'||l_plant_pk|| "MTH_UTIL_PKG"."MTH_UA_GET_VAL"(),l_start_date ,TO_NUMBER(TO_CHAR( l_start_date ,'J')),
3274: l_plant_fk_key,'BOTH',null,null,
3275: null,null,FND_PROFILE.VALUE('MTH_CATCH_ALL_NAME'),null, l_system_fk_key,
3276: l_sysdate, l_sysdate,l_creation_system_id,l_last_update_system_id);
3277: l_start_date := l_start_date+1;
3278:
3279:

Line 3745: l_source_location VARCHAR2(100) := fnd_profile.value('MTH_OWB_SOURCE_LOCATION');

3741: v_count NUMBER;
3742: v_schema_name VARCHAR2(100);
3743: v_status VARCHAR2(30) ;
3744: v_industry VARCHAR2(30) ;
3745: l_source_location VARCHAR2(100) := fnd_profile.value('MTH_OWB_SOURCE_LOCATION');
3746: l_source_service VARCHAR2(100) := fnd_profile.value('MTH_SOURCE_DB_SERVICE_NAME');
3747: l_dblink VARCHAR2(400);
3748: l_sql_stmt VARCHAR2(1000);
3749: l_installed VARCHAR2(1);

Line 3746: l_source_service VARCHAR2(100) := fnd_profile.value('MTH_SOURCE_DB_SERVICE_NAME');

3742: v_schema_name VARCHAR2(100);
3743: v_status VARCHAR2(30) ;
3744: v_industry VARCHAR2(30) ;
3745: l_source_location VARCHAR2(100) := fnd_profile.value('MTH_OWB_SOURCE_LOCATION');
3746: l_source_service VARCHAR2(100) := fnd_profile.value('MTH_SOURCE_DB_SERVICE_NAME');
3747: l_dblink VARCHAR2(400);
3748: l_sql_stmt VARCHAR2(1000);
3749: l_installed VARCHAR2(1);
3750:

Line 3905: mth_util_pkg.g_mth_debug := nvl(fnd_profile.value('MTH_DEBUG_LEVEL'),0);

3901: p_execution_id IN OUT NOCOPY NUMBER
3902: ) IS
3903: BEGIN
3904:
3905: mth_util_pkg.g_mth_debug := nvl(fnd_profile.value('MTH_DEBUG_LEVEL'),0);
3906: mth_util_pkg.g_debug_indent_level := 0;
3907: if FND_GLOBAL.CONC_REQUEST_ID <> -1 then
3908: mth_util_pkg.g_execution_id := -1;
3909: else