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.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on DBMS_SQL

Line 1264: l_store_csr := DBMS_SQL.open_cursor;

1260: write_conc_log('###############l_store_insert_sql: '||l_store_insert_sql);
1261:
1262: IF l_store_insert_sql IS NOT NULL THEN
1263:
1264: l_store_csr := DBMS_SQL.open_cursor;
1265: DBMS_SQL.parse(l_store_csr, l_store_insert_sql, DBMS_SQL.native);
1266: DBMS_SQL.BIND_VARIABLE (l_store_csr, ':terr_id', p_terr_id);
1267:
1268: select length(l_store_final_sql) into len from dual;

Line 1265: DBMS_SQL.parse(l_store_csr, l_store_insert_sql, DBMS_SQL.native);

1261:
1262: IF l_store_insert_sql IS NOT NULL THEN
1263:
1264: l_store_csr := DBMS_SQL.open_cursor;
1265: DBMS_SQL.parse(l_store_csr, l_store_insert_sql, DBMS_SQL.native);
1266: DBMS_SQL.BIND_VARIABLE (l_store_csr, ':terr_id', p_terr_id);
1267:
1268: select length(l_store_final_sql) into len from dual;
1269:

Line 1266: DBMS_SQL.BIND_VARIABLE (l_store_csr, ':terr_id', p_terr_id);

1262: IF l_store_insert_sql IS NOT NULL THEN
1263:
1264: l_store_csr := DBMS_SQL.open_cursor;
1265: DBMS_SQL.parse(l_store_csr, l_store_insert_sql, DBMS_SQL.native);
1266: DBMS_SQL.BIND_VARIABLE (l_store_csr, ':terr_id', p_terr_id);
1267:
1268: select length(l_store_final_sql) into len from dual;
1269:
1270: for n in 1..len

Line 1286: DBMS_SQL.BIND_VARIABLE (l_store_csr,

1282: IF l_final_bind_vars(lvar).bind_type = G_BIND_TYPE_CHAR
1283: THEN
1284: --
1285: write_conc_log('D: bind vars ' || lvar || ' char = ' || l_final_bind_vars(lvar).bind_char);
1286: DBMS_SQL.BIND_VARIABLE (l_store_csr,
1287: G_BIND_VAR_STRING || l_final_bind_vars(lvar).bind_index,
1288: l_final_bind_vars(lvar).bind_char);
1289: --
1290: ELSIF l_final_bind_vars(lvar).bind_type = G_BIND_TYPE_NUMBER

Line 1294: DBMS_SQL.BIND_VARIABLE (l_store_csr,

1290: ELSIF l_final_bind_vars(lvar).bind_type = G_BIND_TYPE_NUMBER
1291: THEN
1292: --
1293: write_conc_log('D: bind vars ' || lvar || ' number=' || l_final_bind_vars(lvar).bind_number);
1294: DBMS_SQL.BIND_VARIABLE (l_store_csr,
1295: G_BIND_VAR_STRING || l_final_bind_vars(lvar).bind_index,
1296: l_final_bind_vars(lvar).bind_number);
1297: --
1298: END IF;

Line 1308: l_store_index := dbms_sql.execute(l_store_csr);

1304: WHERE market_qualifier_type = 'TERRITORY'
1305: AND market_qualifier_reference = p_terr_id
1306: AND user_added = 'N';
1307:
1308: l_store_index := dbms_sql.execute(l_store_csr);
1309: dbms_sql.close_cursor(l_store_csr);
1310: END IF;
1311:
1312: write_conc_log('############### Stores inserted in ozf mapping: '||l_store_index);

Line 1309: dbms_sql.close_cursor(l_store_csr);

1305: AND market_qualifier_reference = p_terr_id
1306: AND user_added = 'N';
1307:
1308: l_store_index := dbms_sql.execute(l_store_csr);
1309: dbms_sql.close_cursor(l_store_csr);
1310: END IF;
1311:
1312: write_conc_log('############### Stores inserted in ozf mapping: '||l_store_index);
1313: --TRAY

Line 1418: l_denorm_csr := DBMS_SQL.open_cursor;

1414: l_party_select_sql ||
1415: substr(l_party_where_sql, 1, length(l_party_where_sql)-4) ||
1416: ')';
1417: write_conc_log('TRAY>>>>>>>>>>>>>>>>>>>>l_final_sql: '||l_final_sql);
1418: l_denorm_csr := DBMS_SQL.open_cursor;
1419: DBMS_SQL.parse(l_denorm_csr, l_final_sql, DBMS_SQL.native);
1420: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':org_id', l_client_info);
1421: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':terr_id', p_terr_id);
1422: FOR i IN NVL(l_final_bind_vars.FIRST, 1) .. NVL(l_final_bind_vars.LAST, 0)

Line 1419: DBMS_SQL.parse(l_denorm_csr, l_final_sql, DBMS_SQL.native);

1415: substr(l_party_where_sql, 1, length(l_party_where_sql)-4) ||
1416: ')';
1417: write_conc_log('TRAY>>>>>>>>>>>>>>>>>>>>l_final_sql: '||l_final_sql);
1418: l_denorm_csr := DBMS_SQL.open_cursor;
1419: DBMS_SQL.parse(l_denorm_csr, l_final_sql, DBMS_SQL.native);
1420: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':org_id', l_client_info);
1421: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':terr_id', p_terr_id);
1422: FOR i IN NVL(l_final_bind_vars.FIRST, 1) .. NVL(l_final_bind_vars.LAST, 0)
1423: LOOP

Line 1420: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':org_id', l_client_info);

1416: ')';
1417: write_conc_log('TRAY>>>>>>>>>>>>>>>>>>>>l_final_sql: '||l_final_sql);
1418: l_denorm_csr := DBMS_SQL.open_cursor;
1419: DBMS_SQL.parse(l_denorm_csr, l_final_sql, DBMS_SQL.native);
1420: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':org_id', l_client_info);
1421: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':terr_id', p_terr_id);
1422: FOR i IN NVL(l_final_bind_vars.FIRST, 1) .. NVL(l_final_bind_vars.LAST, 0)
1423: LOOP
1424: --

Line 1421: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':terr_id', p_terr_id);

1417: write_conc_log('TRAY>>>>>>>>>>>>>>>>>>>>l_final_sql: '||l_final_sql);
1418: l_denorm_csr := DBMS_SQL.open_cursor;
1419: DBMS_SQL.parse(l_denorm_csr, l_final_sql, DBMS_SQL.native);
1420: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':org_id', l_client_info);
1421: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':terr_id', p_terr_id);
1422: FOR i IN NVL(l_final_bind_vars.FIRST, 1) .. NVL(l_final_bind_vars.LAST, 0)
1423: LOOP
1424: --
1425: write_conc_log('D: bind vars ' || i || ' index=' ||

Line 1433: DBMS_SQL.BIND_VARIABLE (l_denorm_csr,

1429: IF l_final_bind_vars(i).bind_type = G_BIND_TYPE_CHAR
1430: THEN
1431: --
1432: write_conc_log('D: bind vars ' || i || ' char = ' || l_final_bind_vars(i).bind_char);
1433: DBMS_SQL.BIND_VARIABLE (l_denorm_csr,
1434: G_BIND_VAR_STRING || l_final_bind_vars(i).bind_index,
1435: l_final_bind_vars(i).bind_char);
1436: --
1437: ELSIF l_final_bind_vars(i).bind_type = G_BIND_TYPE_NUMBER

Line 1441: DBMS_SQL.BIND_VARIABLE (l_denorm_csr,

1437: ELSIF l_final_bind_vars(i).bind_type = G_BIND_TYPE_NUMBER
1438: THEN
1439: --
1440: write_conc_log('D: bind vars ' || i || ' number=' || l_final_bind_vars(i).bind_number);
1441: DBMS_SQL.BIND_VARIABLE (l_denorm_csr,
1442: G_BIND_VAR_STRING || l_final_bind_vars(i).bind_index,
1443: l_final_bind_vars(i).bind_number);
1444: --
1445: END IF;

Line 1448: l_index := dbms_sql.execute(l_denorm_csr);

1444: --
1445: END IF;
1446: --
1447: END LOOP;
1448: l_index := dbms_sql.execute(l_denorm_csr);
1449: write_conc_log('D: After executing ');
1450: dbms_sql.close_cursor(l_denorm_csr);
1451:
1452: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Rows inserted in ams denorm table: '||l_index);

Line 1450: dbms_sql.close_cursor(l_denorm_csr);

1446: --
1447: END LOOP;
1448: l_index := dbms_sql.execute(l_denorm_csr);
1449: write_conc_log('D: After executing ');
1450: dbms_sql.close_cursor(l_denorm_csr);
1451:
1452: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Rows inserted in ams denorm table: '||l_index);
1453:
1454: --TRAY