APPS.PQH_GENERIC_PURGE dependencies on DBMS_SQL

Line 176: l_all_txn_rows_array dbms_sql.varchar2_table;

172: l_select_stmt VARCHAR2(8000);
173: l_from_clause_txn pqh_table_route.from_clause%TYPE;
174: l_where_clause_in_txn pqh_table_route.where_clause%TYPE;
175: l_where_clause_out_txn pqh_table_route.where_clause%TYPE;
176: l_all_txn_rows_array dbms_sql.varchar2_table;
177: l_tot_txn_rows NUMBER;
178: l_parent_pk_value NUMBER;
179: i NUMBER default 1 ;
180: l_select varchar2(2000);

Line 397: l_all_child_rows_array dbms_sql.varchar2_table;

393: c_pk_col_name pqh_attributes.column_name%TYPE;
394: l_select_stmt varchar2(8000) DEFAULT null;
395: l_parent_pk_value number;
396: --
397: l_all_child_rows_array dbms_sql.varchar2_table;
398: l_child_alias pqh_table_route.table_alias%TYPE;
399: l_from_clause_txn pqh_table_route.from_clause%type;
400: l_where_clause_in_txn pqh_table_route.where_clause%type;
401: l_where_clause_out_txn pqh_table_route.where_clause%type;

Line 530: -- l_ovn_value dbms_sql.varchar2_table;

526: l_proc varchar2(72) := g_package||'call_delete_api';
527: l_dummy_in varchar2(4000);
528: l_dummy_out varchar2(4000);
529: l_select_stmt varchar2(8000);
530: -- l_ovn_value dbms_sql.varchar2_table;
531: -- l_plog_value dbms_sql.varchar2_table;
532: l_from_clause_txn pqh_table_route.from_clause%type;
533: l_where_clause_in_txn pqh_table_route.where_clause%type;
534: l_where_clause_out_txn pqh_table_route.where_clause%type;

Line 531: -- l_plog_value dbms_sql.varchar2_table;

527: l_dummy_in varchar2(4000);
528: l_dummy_out varchar2(4000);
529: l_select_stmt varchar2(8000);
530: -- l_ovn_value dbms_sql.varchar2_table;
531: -- l_plog_value dbms_sql.varchar2_table;
532: l_from_clause_txn pqh_table_route.from_clause%type;
533: l_where_clause_in_txn pqh_table_route.where_clause%type;
534: l_where_clause_out_txn pqh_table_route.where_clause%type;
535: l_ovn_rows number;

Line 652: L_txn_value DBMS_SQL.VARCHAR2_TABLE;

648: and tca.txn_category_attribute_id = sat.txn_category_attribute_id
649: and sat.attribute_type_cd = 'ERROR_KEY';
650: lcol varchar2(50);
651: l_select varchar2(8000);
652: L_txn_value DBMS_SQL.VARCHAR2_TABLE;
653: l_where_clause varchar2(8000);
654: l_tot_columns number :=0;
655: l_tot_rows number;
656: L_from_clause varchar2(4000);