APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on DBMS_SQL

Line 1338: l_count number; --DBMS_SQL.NUMBER_TABLE;

1334: -- SOLIN, end
1335:
1336: cur BINARY_INTEGER;
1337: l_exec BINARY_INTEGER;
1338: l_count number; --DBMS_SQL.NUMBER_TABLE;
1339: idx varchar2(6);
1340:
1341: begin
1342: delete from ams_act_logs where ARC_ACT_LOG_USED_BY =

Line 1380: cur := DBMS_SQL.OPEN_CURSOR;

1376: p_log_used_by_id => p_template_id,
1377: p_msg_data => 'l_total_param := '||l_total_param||' l_i:'||l_i,
1378: p_msg_type => 'DEBUG');
1379:
1380: cur := DBMS_SQL.OPEN_CURSOR;
1381:
1382: AMS_Utility_PVT.Create_Log (
1383: x_return_status => l_return_status,
1384: p_arc_log_used_by => 'RECL',

Line 1389: DBMS_SQL.PARSE (cur, p_sql_string(l_i), DBMS_SQL.NATIVE);

1385: p_log_used_by_id => p_template_id,
1386: p_msg_data => substr('SQL_QUERY:= '||p_sql_string(l_i),1,255),
1387: p_msg_type => 'DEBUG');
1388:
1389: DBMS_SQL.PARSE (cur, p_sql_string(l_i), DBMS_SQL.NATIVE);
1390: DBMS_SQL.DEFINE_COLUMN (cur, 1, l_count);
1391:
1392: FOR i IN 1..l_total_param
1393: LOOP

Line 1390: DBMS_SQL.DEFINE_COLUMN (cur, 1, l_count);

1386: p_msg_data => substr('SQL_QUERY:= '||p_sql_string(l_i),1,255),
1387: p_msg_type => 'DEBUG');
1388:
1389: DBMS_SQL.PARSE (cur, p_sql_string(l_i), DBMS_SQL.NATIVE);
1390: DBMS_SQL.DEFINE_COLUMN (cur, 1, l_count);
1391:
1392: FOR i IN 1..l_total_param
1393: LOOP
1394: --bind variables

Line 1395: DBMS_SQL.BIND_VARIABLE (cur, ''||i||'', p_string_parameters(l_param_start));

1391:
1392: FOR i IN 1..l_total_param
1393: LOOP
1394: --bind variables
1395: DBMS_SQL.BIND_VARIABLE (cur, ''||i||'', p_string_parameters(l_param_start));
1396: l_param_start:=l_param_start+1;
1397: END LOOP;
1398:
1399: l_exec := DBMS_SQL.EXECUTE(cur);

Line 1399: l_exec := DBMS_SQL.EXECUTE(cur);

1395: DBMS_SQL.BIND_VARIABLE (cur, ''||i||'', p_string_parameters(l_param_start));
1396: l_param_start:=l_param_start+1;
1397: END LOOP;
1398:
1399: l_exec := DBMS_SQL.EXECUTE(cur);
1400:
1401: IF DBMS_SQL.FETCH_ROWS (cur) > 0 THEN
1402: DBMS_SQL.COLUMN_VALUE (cur, 1, l_count);
1403: ELSE

Line 1401: IF DBMS_SQL.FETCH_ROWS (cur) > 0 THEN

1397: END LOOP;
1398:
1399: l_exec := DBMS_SQL.EXECUTE(cur);
1400:
1401: IF DBMS_SQL.FETCH_ROWS (cur) > 0 THEN
1402: DBMS_SQL.COLUMN_VALUE (cur, 1, l_count);
1403: ELSE
1404: l_count := 0;
1405: END IF;

Line 1402: DBMS_SQL.COLUMN_VALUE (cur, 1, l_count);

1398:
1399: l_exec := DBMS_SQL.EXECUTE(cur);
1400:
1401: IF DBMS_SQL.FETCH_ROWS (cur) > 0 THEN
1402: DBMS_SQL.COLUMN_VALUE (cur, 1, l_count);
1403: ELSE
1404: l_count := 0;
1405: END IF;
1406:

Line 1407: DBMS_SQL.CLOSE_CURSOR (cur);

1403: ELSE
1404: l_count := 0;
1405: END IF;
1406:
1407: DBMS_SQL.CLOSE_CURSOR (cur);
1408:
1409: -- dbms_output.put_line('Total from query -- l_total = '|| to_char(l_total));
1410: AMS_Utility_PVT.Create_Log (
1411: x_return_status => l_return_status,