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 1271: l_store_csr := DBMS_SQL.open_cursor;

1267: write_conc_log('###############l_store_insert_sql: '||l_store_insert_sql);
1268:
1269: IF l_store_insert_sql IS NOT NULL THEN
1270:
1271: l_store_csr := DBMS_SQL.open_cursor;
1272: DBMS_SQL.parse(l_store_csr, l_store_insert_sql, DBMS_SQL.native);
1273: DBMS_SQL.BIND_VARIABLE (l_store_csr, ':terr_id', p_terr_id);
1274:
1275: select length(l_store_final_sql) into len from dual;

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

1268:
1269: IF l_store_insert_sql IS NOT NULL THEN
1270:
1271: l_store_csr := DBMS_SQL.open_cursor;
1272: DBMS_SQL.parse(l_store_csr, l_store_insert_sql, DBMS_SQL.native);
1273: DBMS_SQL.BIND_VARIABLE (l_store_csr, ':terr_id', p_terr_id);
1274:
1275: select length(l_store_final_sql) into len from dual;
1276: Ozf_Utility_pvt.write_conc_log('############### Timestamp before for loop: '||to_char(sysdate,'DD-MM-YYYY HH24:MI:SS'));

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

1269: IF l_store_insert_sql IS NOT NULL THEN
1270:
1271: l_store_csr := DBMS_SQL.open_cursor;
1272: DBMS_SQL.parse(l_store_csr, l_store_insert_sql, DBMS_SQL.native);
1273: DBMS_SQL.BIND_VARIABLE (l_store_csr, ':terr_id', p_terr_id);
1274:
1275: select length(l_store_final_sql) into len from dual;
1276: Ozf_Utility_pvt.write_conc_log('############### Timestamp before for loop: '||to_char(sysdate,'DD-MM-YYYY HH24:MI:SS'));
1277: for n in 1..len

Line 1299: DBMS_SQL.BIND_VARIABLE (l_store_csr,

1295: IF l_final_bind_vars(lvar).bind_type = G_BIND_TYPE_CHAR
1296: THEN
1297: --
1298: write_conc_log('D: bind vars ' || lvar || ' char = ' || l_final_bind_vars(lvar).bind_char);
1299: DBMS_SQL.BIND_VARIABLE (l_store_csr,
1300: G_BIND_VAR_STRING || l_final_bind_vars(lvar).bind_index,
1301: l_final_bind_vars(lvar).bind_char);
1302: --
1303: ELSIF l_final_bind_vars(lvar).bind_type = G_BIND_TYPE_NUMBER

Line 1307: DBMS_SQL.BIND_VARIABLE (l_store_csr,

1303: ELSIF l_final_bind_vars(lvar).bind_type = G_BIND_TYPE_NUMBER
1304: THEN
1305: --
1306: write_conc_log('D: bind vars ' || lvar || ' number=' || l_final_bind_vars(lvar).bind_number);
1307: DBMS_SQL.BIND_VARIABLE (l_store_csr,
1308: G_BIND_VAR_STRING || l_final_bind_vars(lvar).bind_index,
1309: l_final_bind_vars(lvar).bind_number);
1310: --
1311: END IF;

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

1317: WHERE market_qualifier_type = 'TERRITORY'
1318: AND market_qualifier_reference = p_terr_id
1319: AND user_added = 'N';
1320:
1321: l_store_index := dbms_sql.execute(l_store_csr);
1322: dbms_sql.close_cursor(l_store_csr);
1323: END IF;
1324:
1325: write_conc_log('############### Stores inserted in ozf mapping: '||l_store_index);

Line 1322: dbms_sql.close_cursor(l_store_csr);

1318: AND market_qualifier_reference = p_terr_id
1319: AND user_added = 'N';
1320:
1321: l_store_index := dbms_sql.execute(l_store_csr);
1322: dbms_sql.close_cursor(l_store_csr);
1323: END IF;
1324:
1325: write_conc_log('############### Stores inserted in ozf mapping: '||l_store_index);
1326: --TRAY

Line 1431: l_denorm_csr := DBMS_SQL.open_cursor;

1427: l_party_select_sql ||
1428: substr(l_party_where_sql, 1, length(l_party_where_sql)-4) ||
1429: ')';
1430: write_conc_log('TRAY>>>>>>>>>>>>>>>>>>>>l_final_sql: '||l_final_sql);
1431: l_denorm_csr := DBMS_SQL.open_cursor;
1432: DBMS_SQL.parse(l_denorm_csr, l_final_sql, DBMS_SQL.native);
1433: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':org_id', l_client_info);
1434: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':terr_id', p_terr_id);
1435: FOR i IN NVL(l_final_bind_vars.FIRST, 1) .. NVL(l_final_bind_vars.LAST, 0)

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

1428: substr(l_party_where_sql, 1, length(l_party_where_sql)-4) ||
1429: ')';
1430: write_conc_log('TRAY>>>>>>>>>>>>>>>>>>>>l_final_sql: '||l_final_sql);
1431: l_denorm_csr := DBMS_SQL.open_cursor;
1432: DBMS_SQL.parse(l_denorm_csr, l_final_sql, DBMS_SQL.native);
1433: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':org_id', l_client_info);
1434: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':terr_id', p_terr_id);
1435: FOR i IN NVL(l_final_bind_vars.FIRST, 1) .. NVL(l_final_bind_vars.LAST, 0)
1436: LOOP

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

1429: ')';
1430: write_conc_log('TRAY>>>>>>>>>>>>>>>>>>>>l_final_sql: '||l_final_sql);
1431: l_denorm_csr := DBMS_SQL.open_cursor;
1432: DBMS_SQL.parse(l_denorm_csr, l_final_sql, DBMS_SQL.native);
1433: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':org_id', l_client_info);
1434: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':terr_id', p_terr_id);
1435: FOR i IN NVL(l_final_bind_vars.FIRST, 1) .. NVL(l_final_bind_vars.LAST, 0)
1436: LOOP
1437: --

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

1430: write_conc_log('TRAY>>>>>>>>>>>>>>>>>>>>l_final_sql: '||l_final_sql);
1431: l_denorm_csr := DBMS_SQL.open_cursor;
1432: DBMS_SQL.parse(l_denorm_csr, l_final_sql, DBMS_SQL.native);
1433: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':org_id', l_client_info);
1434: DBMS_SQL.BIND_VARIABLE (l_denorm_csr, ':terr_id', p_terr_id);
1435: FOR i IN NVL(l_final_bind_vars.FIRST, 1) .. NVL(l_final_bind_vars.LAST, 0)
1436: LOOP
1437: --
1438: write_conc_log('D: bind vars ' || i || ' index=' ||

Line 1446: DBMS_SQL.BIND_VARIABLE (l_denorm_csr,

1442: IF l_final_bind_vars(i).bind_type = G_BIND_TYPE_CHAR
1443: THEN
1444: --
1445: write_conc_log('D: bind vars ' || i || ' char = ' || l_final_bind_vars(i).bind_char);
1446: DBMS_SQL.BIND_VARIABLE (l_denorm_csr,
1447: G_BIND_VAR_STRING || l_final_bind_vars(i).bind_index,
1448: l_final_bind_vars(i).bind_char);
1449: --
1450: ELSIF l_final_bind_vars(i).bind_type = G_BIND_TYPE_NUMBER

Line 1454: DBMS_SQL.BIND_VARIABLE (l_denorm_csr,

1450: ELSIF l_final_bind_vars(i).bind_type = G_BIND_TYPE_NUMBER
1451: THEN
1452: --
1453: write_conc_log('D: bind vars ' || i || ' number=' || l_final_bind_vars(i).bind_number);
1454: DBMS_SQL.BIND_VARIABLE (l_denorm_csr,
1455: G_BIND_VAR_STRING || l_final_bind_vars(i).bind_index,
1456: l_final_bind_vars(i).bind_number);
1457: --
1458: END IF;

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

1457: --
1458: END IF;
1459: --
1460: END LOOP;
1461: l_index := dbms_sql.execute(l_denorm_csr);
1462: write_conc_log('D: After executing ');
1463: dbms_sql.close_cursor(l_denorm_csr);
1464:
1465: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Rows inserted in ams denorm table: '||l_index);

Line 1463: dbms_sql.close_cursor(l_denorm_csr);

1459: --
1460: END LOOP;
1461: l_index := dbms_sql.execute(l_denorm_csr);
1462: write_conc_log('D: After executing ');
1463: dbms_sql.close_cursor(l_denorm_csr);
1464:
1465: Ozf_Utility_pvt.write_conc_log(l_full_name || ': Rows inserted in ams denorm table: '||l_index);
1466:
1467: --TRAY