APPS.CS_SR_PURGE_CP dependencies on DBMS_SQL

Line 5911: l_dbms_sql_cursor NUMBER;

5907: l_bind_var_ctr NUMBER;
5908:
5909: l_sql_statement VARCHAR2(10000);
5910: l_where_clause VARCHAR2(4000);
5911: l_dbms_sql_cursor NUMBER;
5912:
5913: l_row_count NUMBER;
5914:
5915: BEGIN

Line 6739: l_dbms_sql_cursor := DBMS_SQL.OPEN_CURSOR;

6735: END IF;
6736:
6737: -- Open a cursor to execute the Dynamic SQL
6738:
6739: l_dbms_sql_cursor := DBMS_SQL.OPEN_CURSOR;
6740:
6741: -- Parse the sql dynamic SQL statement
6742:
6743: DBMS_SQL.PARSE

Line 6743: DBMS_SQL.PARSE

6739: l_dbms_sql_cursor := DBMS_SQL.OPEN_CURSOR;
6740:
6741: -- Parse the sql dynamic SQL statement
6742:
6743: DBMS_SQL.PARSE
6744: (
6745: l_dbms_sql_cursor
6746: , l_sql_statement
6747: , DBMS_SQL.NATIVE

Line 6745: l_dbms_sql_cursor

6741: -- Parse the sql dynamic SQL statement
6742:
6743: DBMS_SQL.PARSE
6744: (
6745: l_dbms_sql_cursor
6746: , l_sql_statement
6747: , DBMS_SQL.NATIVE
6748: );
6749:

Line 6747: , DBMS_SQL.NATIVE

6743: DBMS_SQL.PARSE
6744: (
6745: l_dbms_sql_cursor
6746: , l_sql_statement
6747: , DBMS_SQL.NATIVE
6748: );
6749:
6750: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
6751: THEN

Line 6762: DBMS_SQL.BIND_VARIABLE

6758: END IF;
6759:
6760: -- Bind value of the variable p_request_id to the dynamic SQL
6761:
6762: DBMS_SQL.BIND_VARIABLE
6763: (
6764: l_dbms_sql_cursor
6765: , ':request_id'
6766: , p_request_id

Line 6764: l_dbms_sql_cursor

6760: -- Bind value of the variable p_request_id to the dynamic SQL
6761:
6762: DBMS_SQL.BIND_VARIABLE
6763: (
6764: l_dbms_sql_cursor
6765: , ':request_id'
6766: , p_request_id
6767: );
6768:

Line 6786: DBMS_SQL.BIND_VARIABLE

6782: -- Bind value of the variables the dynamic SQL
6783:
6784: IF l_bind_var_type_arr(j) = 'V'
6785: THEN
6786: DBMS_SQL.BIND_VARIABLE
6787: (
6788: l_dbms_sql_cursor
6789: , ':bind' || j
6790: , l_bind_var_val_arr(j)

Line 6788: l_dbms_sql_cursor

6784: IF l_bind_var_type_arr(j) = 'V'
6785: THEN
6786: DBMS_SQL.BIND_VARIABLE
6787: (
6788: l_dbms_sql_cursor
6789: , ':bind' || j
6790: , l_bind_var_val_arr(j)
6791: );
6792: ELSIF l_bind_var_type_arr(j) = 'N'

Line 6794: DBMS_SQL.BIND_VARIABLE

6790: , l_bind_var_val_arr(j)
6791: );
6792: ELSIF l_bind_var_type_arr(j) = 'N'
6793: THEN
6794: DBMS_SQL.BIND_VARIABLE
6795: (
6796: l_dbms_sql_cursor
6797: , ':bind' || j
6798: , TO_NUMBER(l_bind_var_val_arr(j))

Line 6796: l_dbms_sql_cursor

6792: ELSIF l_bind_var_type_arr(j) = 'N'
6793: THEN
6794: DBMS_SQL.BIND_VARIABLE
6795: (
6796: l_dbms_sql_cursor
6797: , ':bind' || j
6798: , TO_NUMBER(l_bind_var_val_arr(j))
6799: );
6800: ELSIF l_bind_var_type_arr(j) = 'D'

Line 6802: DBMS_SQL.BIND_VARIABLE

6798: , TO_NUMBER(l_bind_var_val_arr(j))
6799: );
6800: ELSIF l_bind_var_type_arr(j) = 'D'
6801: THEN
6802: DBMS_SQL.BIND_VARIABLE
6803: (
6804: l_dbms_sql_cursor
6805: , ':bind' || j
6806: , TO_DATE(l_bind_var_val_arr(j), 'DD-MM-RRRR HH24:MI:SS')

Line 6804: l_dbms_sql_cursor

6800: ELSIF l_bind_var_type_arr(j) = 'D'
6801: THEN
6802: DBMS_SQL.BIND_VARIABLE
6803: (
6804: l_dbms_sql_cursor
6805: , ':bind' || j
6806: , TO_DATE(l_bind_var_val_arr(j), 'DD-MM-RRRR HH24:MI:SS')
6807: );
6808: END IF;

Line 6835: DBMS_SQL.BIND_VARIABLE

6831: END IF;
6832:
6833: -- Bind value of the variable p_history_size to the dynamic SQL
6834:
6835: DBMS_SQL.BIND_VARIABLE
6836: (
6837: l_dbms_sql_cursor
6838: , ':histoy_size'
6839: , p_history_size

Line 6837: l_dbms_sql_cursor

6833: -- Bind value of the variable p_history_size to the dynamic SQL
6834:
6835: DBMS_SQL.BIND_VARIABLE
6836: (
6837: l_dbms_sql_cursor
6838: , ':histoy_size'
6839: , p_history_size
6840: );
6841: END IF;

Line 6845: p_row_count := DBMS_SQL.EXECUTE

6841: END IF;
6842:
6843: -- Execute the Query
6844:
6845: p_row_count := DBMS_SQL.EXECUTE
6846: (
6847: l_dbms_sql_cursor
6848: );
6849:

Line 6847: l_dbms_sql_cursor

6843: -- Execute the Query
6844:
6845: p_row_count := DBMS_SQL.EXECUTE
6846: (
6847: l_dbms_sql_cursor
6848: );
6849:
6850: -- Since the APPEND hint forces to commit
6851: -- after the transaction, committing here

Line 6855: DBMS_SQL.CLOSE_CURSOR

6851: -- after the transaction, committing here
6852:
6853: COMMIT;
6854:
6855: DBMS_SQL.CLOSE_CURSOR
6856: (
6857: l_dbms_sql_cursor
6858: );
6859:

Line 6857: l_dbms_sql_cursor

6853: COMMIT;
6854:
6855: DBMS_SQL.CLOSE_CURSOR
6856: (
6857: l_dbms_sql_cursor
6858: );
6859:
6860: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
6861: THEN