DBA Data[Home] [Help]

APPS.ASG_DOWNLOAD dependencies on NUMBER_TABLE

Line 300: l_accessList dbms_sql.Number_table;

296: l_base_owner asg_pub_item.base_owner%TYPE;
297: l_base_object asg_pub_item.base_object_name%TYPE;
298: l_access_owner asg_pub_item.access_owner%TYPE;
299: l_access_name asg_pub_item.access_name%TYPE;
300: l_accessList dbms_sql.Number_table;
301: l_qidList dbms_sql.Number_table;
302: l_cur_id NUMBER;
303: l_cur_rc NUMBER;
304:

Line 301: l_qidList dbms_sql.Number_table;

297: l_base_object asg_pub_item.base_object_name%TYPE;
298: l_access_owner asg_pub_item.access_owner%TYPE;
299: l_access_name asg_pub_item.access_name%TYPE;
300: l_accessList dbms_sql.Number_table;
301: l_qidList dbms_sql.Number_table;
302: l_cur_id NUMBER;
303: l_cur_rc NUMBER;
304:
305: BEGIN

Line 1236: l_qid_tmp_list DBMS_SQL.NUMBER_TABLE;

1232: l_c_access_id asg_system_dirty_queue.access_id%TYPE;
1233: l_c_dml_type asg_system_dirty_queue.dml_type%TYPE;
1234: l_cur_rc NUMBER;
1235: l_rc NUMBER;
1236: l_qid_tmp_list DBMS_SQL.NUMBER_TABLE;
1237: l_tmpqry VARCHAR2(32767);
1238: l_qid_list NUMBER_TABLE;
1239: l_cur NUMBER;
1240: l_qid NUMBER;

Line 1238: l_qid_list NUMBER_TABLE;

1234: l_cur_rc NUMBER;
1235: l_rc NUMBER;
1236: l_qid_tmp_list DBMS_SQL.NUMBER_TABLE;
1237: l_tmpqry VARCHAR2(32767);
1238: l_qid_list NUMBER_TABLE;
1239: l_cur NUMBER;
1240: l_qid NUMBER;
1241: l_curid NUMBER;
1242: l_counter NUMBER;