APPS.AR_UPGHARNESS_PKG dependencies on DBMS_SQL

Line 1029: tab_worker_number DBMS_SQL.NUMBER_TABLE;

1025: p_table_name IN VARCHAR2,
1026: p_workers_num IN NUMBER)
1027: IS
1028: i NUMBER;
1029: tab_worker_number DBMS_SQL.NUMBER_TABLE;
1030: tab_batch_id DBMS_SQL.NUMBER_TABLE;
1031: tab_script_name DBMS_SQL.VARCHAR2_TABLE;
1032: tab_status DBMS_SQL.VARCHAR2_TABLE;
1033: tab_order DBMS_SQL.NUMBER_TABLE;

Line 1030: tab_batch_id DBMS_SQL.NUMBER_TABLE;

1026: p_workers_num IN NUMBER)
1027: IS
1028: i NUMBER;
1029: tab_worker_number DBMS_SQL.NUMBER_TABLE;
1030: tab_batch_id DBMS_SQL.NUMBER_TABLE;
1031: tab_script_name DBMS_SQL.VARCHAR2_TABLE;
1032: tab_status DBMS_SQL.VARCHAR2_TABLE;
1033: tab_order DBMS_SQL.NUMBER_TABLE;
1034: tab_request_id DBMS_SQL.NUMBER_TABLE;

Line 1031: tab_script_name DBMS_SQL.VARCHAR2_TABLE;

1027: IS
1028: i NUMBER;
1029: tab_worker_number DBMS_SQL.NUMBER_TABLE;
1030: tab_batch_id DBMS_SQL.NUMBER_TABLE;
1031: tab_script_name DBMS_SQL.VARCHAR2_TABLE;
1032: tab_status DBMS_SQL.VARCHAR2_TABLE;
1033: tab_order DBMS_SQL.NUMBER_TABLE;
1034: tab_request_id DBMS_SQL.NUMBER_TABLE;
1035: tab_table_name DBMS_SQL.VARCHAR2_TABLE;

Line 1032: tab_status DBMS_SQL.VARCHAR2_TABLE;

1028: i NUMBER;
1029: tab_worker_number DBMS_SQL.NUMBER_TABLE;
1030: tab_batch_id DBMS_SQL.NUMBER_TABLE;
1031: tab_script_name DBMS_SQL.VARCHAR2_TABLE;
1032: tab_status DBMS_SQL.VARCHAR2_TABLE;
1033: tab_order DBMS_SQL.NUMBER_TABLE;
1034: tab_request_id DBMS_SQL.NUMBER_TABLE;
1035: tab_table_name DBMS_SQL.VARCHAR2_TABLE;
1036: BEGIN

Line 1033: tab_order DBMS_SQL.NUMBER_TABLE;

1029: tab_worker_number DBMS_SQL.NUMBER_TABLE;
1030: tab_batch_id DBMS_SQL.NUMBER_TABLE;
1031: tab_script_name DBMS_SQL.VARCHAR2_TABLE;
1032: tab_status DBMS_SQL.VARCHAR2_TABLE;
1033: tab_order DBMS_SQL.NUMBER_TABLE;
1034: tab_request_id DBMS_SQL.NUMBER_TABLE;
1035: tab_table_name DBMS_SQL.VARCHAR2_TABLE;
1036: BEGIN
1037: ins_120_ctl(p_script_name => p_script_name,

Line 1034: tab_request_id DBMS_SQL.NUMBER_TABLE;

1030: tab_batch_id DBMS_SQL.NUMBER_TABLE;
1031: tab_script_name DBMS_SQL.VARCHAR2_TABLE;
1032: tab_status DBMS_SQL.VARCHAR2_TABLE;
1033: tab_order DBMS_SQL.NUMBER_TABLE;
1034: tab_request_id DBMS_SQL.NUMBER_TABLE;
1035: tab_table_name DBMS_SQL.VARCHAR2_TABLE;
1036: BEGIN
1037: ins_120_ctl(p_script_name => p_script_name,
1038: p_batch_id => p_batch_id);

Line 1035: tab_table_name DBMS_SQL.VARCHAR2_TABLE;

1031: tab_script_name DBMS_SQL.VARCHAR2_TABLE;
1032: tab_status DBMS_SQL.VARCHAR2_TABLE;
1033: tab_order DBMS_SQL.NUMBER_TABLE;
1034: tab_request_id DBMS_SQL.NUMBER_TABLE;
1035: tab_table_name DBMS_SQL.VARCHAR2_TABLE;
1036: BEGIN
1037: ins_120_ctl(p_script_name => p_script_name,
1038: p_batch_id => p_batch_id);
1039: