eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_RECONVERSION_PKG dependencies on DBMS_SQL

Line 1028: l_processSQL DBMS_SQL.VARCHAR2S;

1024: , p_log_filename IN VARCHAR2
1025: , p_output_filename IN VARCHAR2
1026: ) IS
1027: l_use_id_columns BOOLEAN := FALSE;
1028: l_processSQL DBMS_SQL.VARCHAR2S;
1029: i NUMBER := 0;
1030: l_cursorID INTEGER;
1031: l_message VARCHAR2(255);
1032: l_processed_rows NUMBER := 0;

Line 1062: l_cursorID := DBMS_SQL.OPEN_CURSOR;

1058: l_processSQL(1) := 'SELECT company_id, cost_center_id, fin_category_id';
1059: l_processSQL(2) := 'FROM FII_GL_JE_SUMMARY_B WHERE rownum = 1';
1060:
1061: -- Open cursor
1062: l_cursorID := DBMS_SQL.OPEN_CURSOR;
1063: -- Parse the SQL
1064: DBMS_SQL.PARSE(l_cursorID, l_processSQL, 1, 2, TRUE, dbms_sql.native);
1065: -- Execute the SQL
1066: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);

Line 1064: DBMS_SQL.PARSE(l_cursorID, l_processSQL, 1, 2, TRUE, dbms_sql.native);

1060:
1061: -- Open cursor
1062: l_cursorID := DBMS_SQL.OPEN_CURSOR;
1063: -- Parse the SQL
1064: DBMS_SQL.PARSE(l_cursorID, l_processSQL, 1, 2, TRUE, dbms_sql.native);
1065: -- Execute the SQL
1066: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1067: -- Close cursor
1068: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

Line 1066: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);

1062: l_cursorID := DBMS_SQL.OPEN_CURSOR;
1063: -- Parse the SQL
1064: DBMS_SQL.PARSE(l_cursorID, l_processSQL, 1, 2, TRUE, dbms_sql.native);
1065: -- Execute the SQL
1066: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1067: -- Close cursor
1068: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
1069:
1070: -- Modify the above SQL to check FII_RECONV_GL_ROLLUP_GT

Line 1068: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

1064: DBMS_SQL.PARSE(l_cursorID, l_processSQL, 1, 2, TRUE, dbms_sql.native);
1065: -- Execute the SQL
1066: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1067: -- Close cursor
1068: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
1069:
1070: -- Modify the above SQL to check FII_RECONV_GL_ROLLUP_GT
1071: l_processSQL(2) := 'FROM FII_RECONV_GL_ROLLUP_GT WHERE rownum =1';
1072:

Line 1074: l_cursorID := DBMS_SQL.OPEN_CURSOR;

1070: -- Modify the above SQL to check FII_RECONV_GL_ROLLUP_GT
1071: l_processSQL(2) := 'FROM FII_RECONV_GL_ROLLUP_GT WHERE rownum =1';
1072:
1073: -- Open cursor
1074: l_cursorID := DBMS_SQL.OPEN_CURSOR;
1075: -- Parse the SQL
1076: DBMS_SQL.PARSE(l_cursorID, l_processSQL, 1, 2, TRUE, dbms_sql.native);
1077: -- Execute the SQL
1078: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);

Line 1076: DBMS_SQL.PARSE(l_cursorID, l_processSQL, 1, 2, TRUE, dbms_sql.native);

1072:
1073: -- Open cursor
1074: l_cursorID := DBMS_SQL.OPEN_CURSOR;
1075: -- Parse the SQL
1076: DBMS_SQL.PARSE(l_cursorID, l_processSQL, 1, 2, TRUE, dbms_sql.native);
1077: -- Execute the SQL
1078: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1079: -- Close cursor
1080: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

Line 1078: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);

1074: l_cursorID := DBMS_SQL.OPEN_CURSOR;
1075: -- Parse the SQL
1076: DBMS_SQL.PARSE(l_cursorID, l_processSQL, 1, 2, TRUE, dbms_sql.native);
1077: -- Execute the SQL
1078: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1079: -- Close cursor
1080: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
1081:
1082: -- It can select the ID columns from FII_GL_JE_SUMMARY_B and

Line 1080: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

1076: DBMS_SQL.PARSE(l_cursorID, l_processSQL, 1, 2, TRUE, dbms_sql.native);
1077: -- Execute the SQL
1078: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1079: -- Close cursor
1080: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
1081:
1082: -- It can select the ID columns from FII_GL_JE_SUMMARY_B and
1083: -- FII_RECONV_GL_ROLLUP_GT, so set l_use_id_columns to TRUE
1084: l_use_id_columns := TRUE;

Line 1255: l_cursorID := DBMS_SQL.OPEN_CURSOR;

1251: 'Insert daily differences SQL:', l_processSQL, i);
1252:
1253: -- Open cursor
1254: l_process_step := 'OPEN_DAILY_SQL';
1255: l_cursorID := DBMS_SQL.OPEN_CURSOR;
1256:
1257: -- Parse the SQL
1258: l_process_step := 'PARSE_DAILY_SQL';
1259: DBMS_SQL.PARSE(l_cursorID, l_processSQL, 1, i, TRUE, dbms_sql.native);

Line 1259: DBMS_SQL.PARSE(l_cursorID, l_processSQL, 1, i, TRUE, dbms_sql.native);

1255: l_cursorID := DBMS_SQL.OPEN_CURSOR;
1256:
1257: -- Parse the SQL
1258: l_process_step := 'PARSE_DAILY_SQL';
1259: DBMS_SQL.PARSE(l_cursorID, l_processSQL, 1, i, TRUE, dbms_sql.native);
1260:
1261: -- Bind variables
1262: l_process_step := 'BIND_DAILY_SQL';
1263: IF (p_primary_currency IS NOT NULL)

Line 1265: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau1', p_primary_mau);

1261: -- Bind variables
1262: l_process_step := 'BIND_DAILY_SQL';
1263: IF (p_primary_currency IS NOT NULL)
1264: THEN
1265: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau1', p_primary_mau);
1266: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau2', p_primary_mau);
1267: -- Bug fix 4637659: START
1268: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau3', p_primary_mau);
1269: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau4', p_primary_mau);

Line 1266: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau2', p_primary_mau);

1262: l_process_step := 'BIND_DAILY_SQL';
1263: IF (p_primary_currency IS NOT NULL)
1264: THEN
1265: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau1', p_primary_mau);
1266: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau2', p_primary_mau);
1267: -- Bug fix 4637659: START
1268: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau3', p_primary_mau);
1269: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau4', p_primary_mau);
1270: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau5', p_primary_mau);

Line 1268: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau3', p_primary_mau);

1264: THEN
1265: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau1', p_primary_mau);
1266: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau2', p_primary_mau);
1267: -- Bug fix 4637659: START
1268: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau3', p_primary_mau);
1269: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau4', p_primary_mau);
1270: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau5', p_primary_mau);
1271: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau6', p_primary_mau);
1272: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau7', p_primary_mau);

Line 1269: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau4', p_primary_mau);

1265: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau1', p_primary_mau);
1266: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau2', p_primary_mau);
1267: -- Bug fix 4637659: START
1268: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau3', p_primary_mau);
1269: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau4', p_primary_mau);
1270: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau5', p_primary_mau);
1271: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau6', p_primary_mau);
1272: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau7', p_primary_mau);
1273: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau8', p_primary_mau);

Line 1270: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau5', p_primary_mau);

1266: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau2', p_primary_mau);
1267: -- Bug fix 4637659: START
1268: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau3', p_primary_mau);
1269: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau4', p_primary_mau);
1270: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau5', p_primary_mau);
1271: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau6', p_primary_mau);
1272: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau7', p_primary_mau);
1273: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau8', p_primary_mau);
1274: -- Bug fix 4637659: END

Line 1271: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau6', p_primary_mau);

1267: -- Bug fix 4637659: START
1268: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau3', p_primary_mau);
1269: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau4', p_primary_mau);
1270: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau5', p_primary_mau);
1271: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau6', p_primary_mau);
1272: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau7', p_primary_mau);
1273: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau8', p_primary_mau);
1274: -- Bug fix 4637659: END
1275: END IF; -- IF (p_primary_currency IS NOT NULL)

Line 1272: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau7', p_primary_mau);

1268: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau3', p_primary_mau);
1269: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau4', p_primary_mau);
1270: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau5', p_primary_mau);
1271: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau6', p_primary_mau);
1272: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau7', p_primary_mau);
1273: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau8', p_primary_mau);
1274: -- Bug fix 4637659: END
1275: END IF; -- IF (p_primary_currency IS NOT NULL)
1276:

Line 1273: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau8', p_primary_mau);

1269: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau4', p_primary_mau);
1270: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau5', p_primary_mau);
1271: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau6', p_primary_mau);
1272: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau7', p_primary_mau);
1273: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau8', p_primary_mau);
1274: -- Bug fix 4637659: END
1275: END IF; -- IF (p_primary_currency IS NOT NULL)
1276:
1277: IF (p_secondary_currency IS NOT NULL)

Line 1279: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sec_mau1', p_secondary_mau);

1275: END IF; -- IF (p_primary_currency IS NOT NULL)
1276:
1277: IF (p_secondary_currency IS NOT NULL)
1278: THEN
1279: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sec_mau1', p_secondary_mau);
1280: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sec_mau2', p_secondary_mau);
1281: END IF; -- IF (p_secondary_currency IS NOT NULL)
1282:
1283: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':req_id', p_request_id);

Line 1280: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sec_mau2', p_secondary_mau);

1276:
1277: IF (p_secondary_currency IS NOT NULL)
1278: THEN
1279: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sec_mau1', p_secondary_mau);
1280: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sec_mau2', p_secondary_mau);
1281: END IF; -- IF (p_secondary_currency IS NOT NULL)
1282:
1283: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':req_id', p_request_id);
1284: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':from_date_id', p_from_date_id);

Line 1283: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':req_id', p_request_id);

1279: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sec_mau1', p_secondary_mau);
1280: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sec_mau2', p_secondary_mau);
1281: END IF; -- IF (p_secondary_currency IS NOT NULL)
1282:
1283: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':req_id', p_request_id);
1284: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':from_date_id', p_from_date_id);
1285: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':to_date_id', p_to_date_id);
1286:
1287: IF (p_primary_currency IS NOT NULL)

Line 1284: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':from_date_id', p_from_date_id);

1280: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sec_mau2', p_secondary_mau);
1281: END IF; -- IF (p_secondary_currency IS NOT NULL)
1282:
1283: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':req_id', p_request_id);
1284: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':from_date_id', p_from_date_id);
1285: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':to_date_id', p_to_date_id);
1286:
1287: IF (p_primary_currency IS NOT NULL)
1288: THEN

Line 1285: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':to_date_id', p_to_date_id);

1281: END IF; -- IF (p_secondary_currency IS NOT NULL)
1282:
1283: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':req_id', p_request_id);
1284: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':from_date_id', p_from_date_id);
1285: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':to_date_id', p_to_date_id);
1286:
1287: IF (p_primary_currency IS NOT NULL)
1288: THEN
1289: -- Bug fix 4637659: START

Line 1290: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau9', p_primary_mau);

1286:
1287: IF (p_primary_currency IS NOT NULL)
1288: THEN
1289: -- Bug fix 4637659: START
1290: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau9', p_primary_mau);
1291: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau10', p_primary_mau);
1292: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau11', p_primary_mau);
1293: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau12', p_primary_mau);
1294: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau13', p_primary_mau);

Line 1291: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau10', p_primary_mau);

1287: IF (p_primary_currency IS NOT NULL)
1288: THEN
1289: -- Bug fix 4637659: START
1290: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau9', p_primary_mau);
1291: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau10', p_primary_mau);
1292: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau11', p_primary_mau);
1293: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau12', p_primary_mau);
1294: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau13', p_primary_mau);
1295: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau14', p_primary_mau);

Line 1292: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau11', p_primary_mau);

1288: THEN
1289: -- Bug fix 4637659: START
1290: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau9', p_primary_mau);
1291: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau10', p_primary_mau);
1292: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau11', p_primary_mau);
1293: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau12', p_primary_mau);
1294: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau13', p_primary_mau);
1295: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau14', p_primary_mau);
1296: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau15', p_primary_mau);

Line 1293: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau12', p_primary_mau);

1289: -- Bug fix 4637659: START
1290: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau9', p_primary_mau);
1291: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau10', p_primary_mau);
1292: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau11', p_primary_mau);
1293: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau12', p_primary_mau);
1294: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau13', p_primary_mau);
1295: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau14', p_primary_mau);
1296: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau15', p_primary_mau);
1297: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau16', p_primary_mau);

Line 1294: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau13', p_primary_mau);

1290: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau9', p_primary_mau);
1291: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau10', p_primary_mau);
1292: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau11', p_primary_mau);
1293: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau12', p_primary_mau);
1294: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau13', p_primary_mau);
1295: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau14', p_primary_mau);
1296: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau15', p_primary_mau);
1297: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau16', p_primary_mau);
1298: -- Bug fix 4637659: END

Line 1295: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau14', p_primary_mau);

1291: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau10', p_primary_mau);
1292: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau11', p_primary_mau);
1293: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau12', p_primary_mau);
1294: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau13', p_primary_mau);
1295: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau14', p_primary_mau);
1296: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau15', p_primary_mau);
1297: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau16', p_primary_mau);
1298: -- Bug fix 4637659: END
1299: END IF; -- IF (p_primary_currency IS NOT NULL)

Line 1296: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau15', p_primary_mau);

1292: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau11', p_primary_mau);
1293: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau12', p_primary_mau);
1294: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau13', p_primary_mau);
1295: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau14', p_primary_mau);
1296: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau15', p_primary_mau);
1297: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau16', p_primary_mau);
1298: -- Bug fix 4637659: END
1299: END IF; -- IF (p_primary_currency IS NOT NULL)
1300:

Line 1297: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau16', p_primary_mau);

1293: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau12', p_primary_mau);
1294: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau13', p_primary_mau);
1295: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau14', p_primary_mau);
1296: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau15', p_primary_mau);
1297: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':pri_mau16', p_primary_mau);
1298: -- Bug fix 4637659: END
1299: END IF; -- IF (p_primary_currency IS NOT NULL)
1300:
1301: IF (p_secondary_currency IS NOT NULL)

Line 1303: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sec_mau3', p_secondary_mau);

1299: END IF; -- IF (p_primary_currency IS NOT NULL)
1300:
1301: IF (p_secondary_currency IS NOT NULL)
1302: THEN
1303: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sec_mau3', p_secondary_mau);
1304: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sec_mau4', p_secondary_mau);
1305: END IF; -- IF (p_secondary_currency IS NOT NULL)
1306:
1307: -- Execute the SQL

Line 1304: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sec_mau4', p_secondary_mau);

1300:
1301: IF (p_secondary_currency IS NOT NULL)
1302: THEN
1303: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sec_mau3', p_secondary_mau);
1304: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':sec_mau4', p_secondary_mau);
1305: END IF; -- IF (p_secondary_currency IS NOT NULL)
1306:
1307: -- Execute the SQL
1308: l_process_step := 'RUN_DAILY_SQL';

Line 1309: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);

1305: END IF; -- IF (p_secondary_currency IS NOT NULL)
1306:
1307: -- Execute the SQL
1308: l_process_step := 'RUN_DAILY_SQL';
1309: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1310: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1311: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1312: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1313:

Line 1316: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

1312: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1313:
1314: -- Close cursor
1315: l_process_step := 'CLOSE_DAILY_SQL';
1316: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
1317:
1318: -- Check if any daily differences are inserted
1319: IF (l_processed_rows > 0)
1320: THEN

Line 1437: l_cursorID := DBMS_SQL.OPEN_CURSOR;

1433: 'Rollup weekly differences SQL:', l_processSQL, i);
1434:
1435: -- Open cursor
1436: l_process_step := 'OPEN_WEEKLY_SQL';
1437: l_cursorID := DBMS_SQL.OPEN_CURSOR;
1438:
1439: -- Parse the SQL
1440: l_process_step := 'PARSE_WEEKLY_SQL';
1441: DBMS_SQL.PARSE(l_cursorID,l_processSQL,1,i,TRUE,dbms_sql.native);

Line 1441: DBMS_SQL.PARSE(l_cursorID,l_processSQL,1,i,TRUE,dbms_sql.native);

1437: l_cursorID := DBMS_SQL.OPEN_CURSOR;
1438:
1439: -- Parse the SQL
1440: l_process_step := 'PARSE_WEEKLY_SQL';
1441: DBMS_SQL.PARSE(l_cursorID,l_processSQL,1,i,TRUE,dbms_sql.native);
1442:
1443: -- Execute the SQL
1444: l_process_step := 'RUN_WEEKLY_SQL';
1445: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);

Line 1445: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);

1441: DBMS_SQL.PARSE(l_cursorID,l_processSQL,1,i,TRUE,dbms_sql.native);
1442:
1443: -- Execute the SQL
1444: l_process_step := 'RUN_WEEKLY_SQL';
1445: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1446: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1447: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1448: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1449:

Line 1452: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

1448: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1449:
1450: -- Close cursor
1451: l_process_step := 'CLOSE_WEEKLY_SQL';
1452: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
1453:
1454: --
1455: -- 3.4 Roll up to periodly, quarterly, and yearly differences
1456: --

Line 1579: l_cursorID := DBMS_SQL.OPEN_CURSOR;

1575: 'Rollup other differences SQL:', l_processSQL, i);
1576:
1577: -- Open cursor
1578: l_process_step := 'OPEN_OTHER_SQL';
1579: l_cursorID := DBMS_SQL.OPEN_CURSOR;
1580:
1581: -- Parse the SQL
1582: l_process_step := 'PARSE_OTHER_SQL';
1583: DBMS_SQL.PARSE(l_cursorID, l_processSQL, 1, i, TRUE, dbms_sql.native);

Line 1583: DBMS_SQL.PARSE(l_cursorID, l_processSQL, 1, i, TRUE, dbms_sql.native);

1579: l_cursorID := DBMS_SQL.OPEN_CURSOR;
1580:
1581: -- Parse the SQL
1582: l_process_step := 'PARSE_OTHER_SQL';
1583: DBMS_SQL.PARSE(l_cursorID, l_processSQL, 1, i, TRUE, dbms_sql.native);
1584:
1585: -- Execute the SQL
1586: l_process_step := 'RUN_OTHER_SQL';
1587: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);

Line 1587: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);

1583: DBMS_SQL.PARSE(l_cursorID, l_processSQL, 1, i, TRUE, dbms_sql.native);
1584:
1585: -- Execute the SQL
1586: l_process_step := 'RUN_OTHER_SQL';
1587: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1588: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1589: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1590: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1591:

Line 1594: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

1590: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1591:
1592: -- Close cursor
1593: l_process_step := 'CLOSE_OTHER_SQL';
1594: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
1595:
1596: --
1597: -- 3.5 Updated FII_GL_JE_SUMMARY_B with the global amount differences,
1598: --

Line 1764: l_cursorID := DBMS_SQL.OPEN_CURSOR;

1760: 'Update GL differences SQL:', l_processSQL, i);
1761:
1762: -- Open cursor
1763: l_process_step := 'OPEN_UPDATE_SQL';
1764: l_cursorID := DBMS_SQL.OPEN_CURSOR;
1765:
1766: -- Parse the SQL
1767: l_process_step := 'PARSE_UPDATE_SQL';
1768: DBMS_SQL.PARSE(l_cursorID,l_processSQL,1,i,TRUE,dbms_sql.native);

Line 1768: DBMS_SQL.PARSE(l_cursorID,l_processSQL,1,i,TRUE,dbms_sql.native);

1764: l_cursorID := DBMS_SQL.OPEN_CURSOR;
1765:
1766: -- Parse the SQL
1767: l_process_step := 'PARSE_UPDATE_SQL';
1768: DBMS_SQL.PARSE(l_cursorID,l_processSQL,1,i,TRUE,dbms_sql.native);
1769:
1770: -- Bind variables
1771: l_process_step := 'BIND_UPDATE_SQL';
1772: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':user_id1', p_user_id);

Line 1772: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':user_id1', p_user_id);

1768: DBMS_SQL.PARSE(l_cursorID,l_processSQL,1,i,TRUE,dbms_sql.native);
1769:
1770: -- Bind variables
1771: l_process_step := 'BIND_UPDATE_SQL';
1772: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':user_id1', p_user_id);
1773: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':user_id2', p_user_id);
1774:
1775: -- Execute the SQL
1776: l_process_step := 'RUN_UPDATE_SQL';

Line 1773: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':user_id2', p_user_id);

1769:
1770: -- Bind variables
1771: l_process_step := 'BIND_UPDATE_SQL';
1772: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':user_id1', p_user_id);
1773: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':user_id2', p_user_id);
1774:
1775: -- Execute the SQL
1776: l_process_step := 'RUN_UPDATE_SQL';
1777: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);

Line 1777: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);

1773: DBMS_SQL.BIND_VARIABLE(l_cursorID, ':user_id2', p_user_id);
1774:
1775: -- Execute the SQL
1776: l_process_step := 'RUN_UPDATE_SQL';
1777: l_processed_rows := DBMS_SQL.EXECUTE(l_cursorID);
1778: COMMIT;
1779: FND_MESSAGE.set_name('FND', 'GENERIC_ROWS_PROCESSED');
1780: FND_MESSAGE.set_token('ROWS', l_processed_rows);
1781: FII_UTIL.put_timestamp(FND_MESSAGE.get);

Line 1785: DBMS_SQL.CLOSE_CURSOR(l_cursorID);

1781: FII_UTIL.put_timestamp(FND_MESSAGE.get);
1782:
1783: -- Close cursor
1784: l_process_step := 'CLOSE_UPDATE_SQL';
1785: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
1786:
1787: END IF; -- IF (l_processed_rows > 0)
1788: -- LOG: Print out the number of updated rows for GL
1789: FII_UTIL.put_line(' ');

Line 2469: , p_sql_stmt IN DBMS_SQL.VARCHAR2S

2465: --
2466: -- DESCRIPTION:
2467: -- It will print the passed SQL statement to log file.
2468: PROCEDURE print_sql( p_sql_desc IN VARCHAR2
2469: , p_sql_stmt IN DBMS_SQL.VARCHAR2S
2470: , p_num_of_lines IN NUMBER) IS
2471: i NUMBER;
2472:
2473: l_process_step VARCHAR2(50) := 'PRINT_BUILT_SQL';