DBA Data[Home] [Help]

APPS.AS_FORECAST_ACTUAL_PKG dependencies on FND_GLOBAL

Line 7: g_next_line VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(10);/*for chr='\n'*/

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_FORECAST_ACTUAL_PKG';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxtfab.pls';
6: g_line_error NUMBER := 0;
7: g_next_line VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(10);/*for chr='\n'*/
8: g_temp_blob BLOB;
9:
10: PROCEDURE Insert_Row(
11: p_SALESFORCE_ID in NUMBER,

Line 469: l_token VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(44);

465: APP_EXCEPTION.RAISE_EXCEPTION;
466: END Upload_Data;
467:
468: FUNCTION Get_LogDir(p_data_file IN VARCHAR2) RETURN VARCHAR2 IS
469: l_token VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(44);
470: l_slash VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(47);
471: l_logdir VARCHAR2(2000) := '';
472: l_pos number := 0;
473: BEGIN

Line 470: l_slash VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(47);

466: END Upload_Data;
467:
468: FUNCTION Get_LogDir(p_data_file IN VARCHAR2) RETURN VARCHAR2 IS
469: l_token VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(44);
470: l_slash VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(47);
471: l_logdir VARCHAR2(2000) := '';
472: l_pos number := 0;
473: BEGIN
474: -- use first entry of utl_file_dir as the DIR

Line 497: l_decimal VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(46);

493: FUNCTION Get_LogFileName (p_data_file IN VARCHAR2)
494: RETURN VARCHAR2
495: IS
496: l_log_date VARCHAR2(10);
497: l_decimal VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(46);
498: l_underscore VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(95);
499: l_filename VARCHAR2(100):= '';
500: BEGIN
501: -- Form the log filename using data filename and current date/time.

Line 498: l_underscore VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(95);

494: RETURN VARCHAR2
495: IS
496: l_log_date VARCHAR2(10);
497: l_decimal VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(46);
498: l_underscore VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(95);
499: l_filename VARCHAR2(100):= '';
500: BEGIN
501: -- Form the log filename using data filename and current date/time.
502: l_log_date := TO_CHAR(SYSDATE,'MMDDYY');

Line 750: l_decimal VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(46);/*for chr='.'*/

746: lv_budget_amt VARCHAR2(25) := '';
747: lv_revenue_amt VARCHAR2(25) := '';
748: l_currency_code VARCHAR2(25) := '';
749: l_line_data VARCHAR2(100) := '';
750: l_decimal VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(46);/*for chr='.'*/
751: l_token VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(34);/*for chr='"'*/
752: l_comma VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(44); /*for chr=','*/
753: l_period_set_name VARCHAR2(50) := FND_PROFILE.VALUE('AS_FORECAST_CALENDAR');
754: lv_amount_var NUMBER := 0;

Line 751: l_token VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(34);/*for chr='"'*/

747: lv_revenue_amt VARCHAR2(25) := '';
748: l_currency_code VARCHAR2(25) := '';
749: l_line_data VARCHAR2(100) := '';
750: l_decimal VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(46);/*for chr='.'*/
751: l_token VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(34);/*for chr='"'*/
752: l_comma VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(44); /*for chr=','*/
753: l_period_set_name VARCHAR2(50) := FND_PROFILE.VALUE('AS_FORECAST_CALENDAR');
754: lv_amount_var NUMBER := 0;
755: l_temp_string VARCHAR2(100) := '';

Line 752: l_comma VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(44); /*for chr=','*/

748: l_currency_code VARCHAR2(25) := '';
749: l_line_data VARCHAR2(100) := '';
750: l_decimal VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(46);/*for chr='.'*/
751: l_token VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(34);/*for chr='"'*/
752: l_comma VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(44); /*for chr=','*/
753: l_period_set_name VARCHAR2(50) := FND_PROFILE.VALUE('AS_FORECAST_CALENDAR');
754: lv_amount_var NUMBER := 0;
755: l_temp_string VARCHAR2(100) := '';
756: l_header VARCHAR2(100):='';