APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on DBMS_SQL

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

1400: -- SOLIN, end
1401:
1402: cur BINARY_INTEGER;
1403: l_exec BINARY_INTEGER;
1404: l_count number; --DBMS_SQL.NUMBER_TABLE;
1405: idx varchar2(6);
1406:
1407: begin
1408: delete from ams_act_logs where ARC_ACT_LOG_USED_BY =

Line 1446: cur := DBMS_SQL.OPEN_CURSOR;

1442: p_log_used_by_id => p_template_id,
1443: p_msg_data => 'l_total_param := '||l_total_param||' l_i:'||l_i,
1444: p_msg_type => 'DEBUG');
1445:
1446: cur := DBMS_SQL.OPEN_CURSOR;
1447:
1448: AMS_Utility_PVT.Create_Log (
1449: x_return_status => l_return_status,
1450: p_arc_log_used_by => 'RECL',

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

1451: p_log_used_by_id => p_template_id,
1452: p_msg_data => substr('SQL_QUERY:= '||p_sql_string(l_i),1,255),
1453: p_msg_type => 'DEBUG');
1454:
1455: DBMS_SQL.PARSE (cur, p_sql_string(l_i), DBMS_SQL.NATIVE);
1456: DBMS_SQL.DEFINE_COLUMN (cur, 1, l_count);
1457:
1458: FOR i IN 1..l_total_param
1459: LOOP

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

1452: p_msg_data => substr('SQL_QUERY:= '||p_sql_string(l_i),1,255),
1453: p_msg_type => 'DEBUG');
1454:
1455: DBMS_SQL.PARSE (cur, p_sql_string(l_i), DBMS_SQL.NATIVE);
1456: DBMS_SQL.DEFINE_COLUMN (cur, 1, l_count);
1457:
1458: FOR i IN 1..l_total_param
1459: LOOP
1460: --bind variables

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

1457:
1458: FOR i IN 1..l_total_param
1459: LOOP
1460: --bind variables
1461: DBMS_SQL.BIND_VARIABLE (cur, ''||i||'', p_string_parameters(l_param_start));
1462: l_param_start:=l_param_start+1;
1463: END LOOP;
1464:
1465: l_exec := DBMS_SQL.EXECUTE(cur);

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

1461: DBMS_SQL.BIND_VARIABLE (cur, ''||i||'', p_string_parameters(l_param_start));
1462: l_param_start:=l_param_start+1;
1463: END LOOP;
1464:
1465: l_exec := DBMS_SQL.EXECUTE(cur);
1466:
1467: IF DBMS_SQL.FETCH_ROWS (cur) > 0 THEN
1468: DBMS_SQL.COLUMN_VALUE (cur, 1, l_count);
1469: ELSE

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

1463: END LOOP;
1464:
1465: l_exec := DBMS_SQL.EXECUTE(cur);
1466:
1467: IF DBMS_SQL.FETCH_ROWS (cur) > 0 THEN
1468: DBMS_SQL.COLUMN_VALUE (cur, 1, l_count);
1469: ELSE
1470: l_count := 0;
1471: END IF;

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

1464:
1465: l_exec := DBMS_SQL.EXECUTE(cur);
1466:
1467: IF DBMS_SQL.FETCH_ROWS (cur) > 0 THEN
1468: DBMS_SQL.COLUMN_VALUE (cur, 1, l_count);
1469: ELSE
1470: l_count := 0;
1471: END IF;
1472:

Line 1473: DBMS_SQL.CLOSE_CURSOR (cur);

1469: ELSE
1470: l_count := 0;
1471: END IF;
1472:
1473: DBMS_SQL.CLOSE_CURSOR (cur);
1474:
1475: -- dbms_output.put_line('Total from query -- l_total = '|| to_char(l_total));
1476: AMS_Utility_PVT.Create_Log (
1477: x_return_status => l_return_status,