APPS.AR_UPGHARNESS_PKG dependencies on DBMS_SQL

Line 987: tab_worker_number DBMS_SQL.NUMBER_TABLE;

983: p_table_name IN VARCHAR2,
984: p_workers_num IN NUMBER)
985: IS
986: i NUMBER;
987: tab_worker_number DBMS_SQL.NUMBER_TABLE;
988: tab_batch_id DBMS_SQL.NUMBER_TABLE;
989: tab_script_name DBMS_SQL.VARCHAR2_TABLE;
990: tab_status DBMS_SQL.VARCHAR2_TABLE;
991: tab_order DBMS_SQL.NUMBER_TABLE;

Line 988: tab_batch_id DBMS_SQL.NUMBER_TABLE;

984: p_workers_num IN NUMBER)
985: IS
986: i NUMBER;
987: tab_worker_number DBMS_SQL.NUMBER_TABLE;
988: tab_batch_id DBMS_SQL.NUMBER_TABLE;
989: tab_script_name DBMS_SQL.VARCHAR2_TABLE;
990: tab_status DBMS_SQL.VARCHAR2_TABLE;
991: tab_order DBMS_SQL.NUMBER_TABLE;
992: tab_request_id DBMS_SQL.NUMBER_TABLE;

Line 989: tab_script_name DBMS_SQL.VARCHAR2_TABLE;

985: IS
986: i NUMBER;
987: tab_worker_number DBMS_SQL.NUMBER_TABLE;
988: tab_batch_id DBMS_SQL.NUMBER_TABLE;
989: tab_script_name DBMS_SQL.VARCHAR2_TABLE;
990: tab_status DBMS_SQL.VARCHAR2_TABLE;
991: tab_order DBMS_SQL.NUMBER_TABLE;
992: tab_request_id DBMS_SQL.NUMBER_TABLE;
993: tab_table_name DBMS_SQL.VARCHAR2_TABLE;

Line 990: tab_status DBMS_SQL.VARCHAR2_TABLE;

986: i NUMBER;
987: tab_worker_number DBMS_SQL.NUMBER_TABLE;
988: tab_batch_id DBMS_SQL.NUMBER_TABLE;
989: tab_script_name DBMS_SQL.VARCHAR2_TABLE;
990: tab_status DBMS_SQL.VARCHAR2_TABLE;
991: tab_order DBMS_SQL.NUMBER_TABLE;
992: tab_request_id DBMS_SQL.NUMBER_TABLE;
993: tab_table_name DBMS_SQL.VARCHAR2_TABLE;
994: BEGIN

Line 991: tab_order DBMS_SQL.NUMBER_TABLE;

987: tab_worker_number DBMS_SQL.NUMBER_TABLE;
988: tab_batch_id DBMS_SQL.NUMBER_TABLE;
989: tab_script_name DBMS_SQL.VARCHAR2_TABLE;
990: tab_status DBMS_SQL.VARCHAR2_TABLE;
991: tab_order DBMS_SQL.NUMBER_TABLE;
992: tab_request_id DBMS_SQL.NUMBER_TABLE;
993: tab_table_name DBMS_SQL.VARCHAR2_TABLE;
994: BEGIN
995: ins_120_ctl(p_script_name => p_script_name,

Line 992: tab_request_id DBMS_SQL.NUMBER_TABLE;

988: tab_batch_id DBMS_SQL.NUMBER_TABLE;
989: tab_script_name DBMS_SQL.VARCHAR2_TABLE;
990: tab_status DBMS_SQL.VARCHAR2_TABLE;
991: tab_order DBMS_SQL.NUMBER_TABLE;
992: tab_request_id DBMS_SQL.NUMBER_TABLE;
993: tab_table_name DBMS_SQL.VARCHAR2_TABLE;
994: BEGIN
995: ins_120_ctl(p_script_name => p_script_name,
996: p_batch_id => p_batch_id);

Line 993: tab_table_name DBMS_SQL.VARCHAR2_TABLE;

989: tab_script_name DBMS_SQL.VARCHAR2_TABLE;
990: tab_status DBMS_SQL.VARCHAR2_TABLE;
991: tab_order DBMS_SQL.NUMBER_TABLE;
992: tab_request_id DBMS_SQL.NUMBER_TABLE;
993: tab_table_name DBMS_SQL.VARCHAR2_TABLE;
994: BEGIN
995: ins_120_ctl(p_script_name => p_script_name,
996: p_batch_id => p_batch_id);
997: