APPS.FTE_BULK_DTT_PKG dependencies on FND_GLOBAL

Line 53: g_user_id CONSTANT NUMBER := FND_GLOBAL.USER_ID;

49: -- ------------------------ --
50: -- --
51: -- -------------------------------------------------------------------------- --
52: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_BULK_DTT_PKG';
53: g_user_id CONSTANT NUMBER := FND_GLOBAL.USER_ID;
54:
55: g_bulk_insert_limit CONSTANT NUMBER := 250;
56: g_total_numcharts NUMBER;
57: g_chart_count_temp NUMBER := 0;

Line 157: WSH_DEBUG_SV.logmsg(l_module_name,'Calling fnd_global.apps_initialize with p_user_id,p_resp_id,p_resp_appl_id');

153: END IF;
154:
155:
156: IF l_debug_on THEN
157: WSH_DEBUG_SV.logmsg(l_module_name,'Calling fnd_global.apps_initialize with p_user_id,p_resp_id,p_resp_appl_id');
158: END IF;
159:
160: fnd_global.apps_initialize(user_id => p_user_id,
161: resp_id => p_resp_id,

Line 160: fnd_global.apps_initialize(user_id => p_user_id,

156: IF l_debug_on THEN
157: WSH_DEBUG_SV.logmsg(l_module_name,'Calling fnd_global.apps_initialize with p_user_id,p_resp_id,p_resp_appl_id');
158: END IF;
159:
160: fnd_global.apps_initialize(user_id => p_user_id,
161: resp_id => p_resp_id,
162: resp_appl_id => p_resp_appl_id);
163:
164:

Line 1317: l_line_length := NVL(LENGTH(RTRIM(LTRIM(REPLACE(substr(l_line,1, l_line_length),FND_GLOBAL.local_chr(9),' '),' '),' ')),0);

1313: --
1314: -- Line length is greater than 0, lets get rid of all spaces and see if
1315: -- there is any length left
1316: --
1317: l_line_length := NVL(LENGTH(RTRIM(LTRIM(REPLACE(substr(l_line,1, l_line_length),FND_GLOBAL.local_chr(9),' '),' '),' ')),0);
1318: IF (l_line_length <= 0) THEN
1319: RAISE FTE_DIST_INV_LINE_LENGTH;
1320: --
1321: IF l_debug_on THEN

Line 1354: l_ret_dist_val := RTRIM(LTRIM(REPLACE(substr(l_line,l_ret_dist_start_pos, l_ret_dist_length),FND_GLOBAL.local_chr(9),' '),' '),' ');

1350: -- [AAB][12/16/03][BUG# 3325486]
1351: -- Added Replace to the extraction to replace all occurances of TAB in the string with a space,
1352: -- The spaces are then trimmed off the left and right end
1353: --
1354: l_ret_dist_val := RTRIM(LTRIM(REPLACE(substr(l_line,l_ret_dist_start_pos, l_ret_dist_length),FND_GLOBAL.local_chr(9),' '),' '),' ');
1355:
1356: IF l_debug_on THEN
1357: WSH_DEBUG_SV.logmsg(l_module_name,'Converting distance value to a number');
1358: END IF;

Line 1387: l_ret_time_val := RTRIM(LTRIM(REPLACE(substr(l_line,l_ret_time_start_pos, l_ret_time_length),FND_GLOBAL.local_chr(9),' '),' '),' ');

1383: -- [AAB][12/16/03][BUG# 3325486]
1384: -- Added Replace to the extraction to replace all occurances of TAB in the string with a space,
1385: -- The spaces are then trimmed off the left and right end
1386: --
1387: l_ret_time_val := RTRIM(LTRIM(REPLACE(substr(l_line,l_ret_time_start_pos, l_ret_time_length),FND_GLOBAL.local_chr(9),' '),' '),' ');
1388:
1389:
1390: l_colon_check := 0;
1391: