eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_SUM_TRANS dependencies on T_NUM_15_TYPE

Line 5668: t_person_table t_num_15_type;

5664: l_supercede_reqid_str varchar2(9000); --Bug 6037692
5665: l_run_id integer;
5666: i integer;
5667: j integer;
5668: t_person_table t_num_15_type;
5669: t_efforts_table t_num_15_type;
5670: t_sum_line_id t_num_15_type;
5671: t_tolerance_per t_num_15_type;
5672: t_tolerance_req t_num_15_type;

Line 5669: t_efforts_table t_num_15_type;

5665: l_run_id integer;
5666: i integer;
5667: j integer;
5668: t_person_table t_num_15_type;
5669: t_efforts_table t_num_15_type;
5670: t_sum_line_id t_num_15_type;
5671: t_tolerance_per t_num_15_type;
5672: t_tolerance_req t_num_15_type;
5673: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;

Line 5670: t_sum_line_id t_num_15_type;

5666: i integer;
5667: j integer;
5668: t_person_table t_num_15_type;
5669: t_efforts_table t_num_15_type;
5670: t_sum_line_id t_num_15_type;
5671: t_tolerance_per t_num_15_type;
5672: t_tolerance_req t_num_15_type;
5673: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5674: t_tolerance_sline t_num_15_type_ind;

Line 5671: t_tolerance_per t_num_15_type;

5667: j integer;
5668: t_person_table t_num_15_type;
5669: t_efforts_table t_num_15_type;
5670: t_sum_line_id t_num_15_type;
5671: t_tolerance_per t_num_15_type;
5672: t_tolerance_req t_num_15_type;
5673: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5674: t_tolerance_sline t_num_15_type_ind;
5675: t_request_id t_num_15_type_ind;

Line 5672: t_tolerance_req t_num_15_type;

5668: t_person_table t_num_15_type;
5669: t_efforts_table t_num_15_type;
5670: t_sum_line_id t_num_15_type;
5671: t_tolerance_per t_num_15_type;
5672: t_tolerance_req t_num_15_type;
5673: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5674: t_tolerance_sline t_num_15_type_ind;
5675: t_request_id t_num_15_type_ind;
5676: t_template_id t_num_15_type_ind;

Line 5673: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;

5669: t_efforts_table t_num_15_type;
5670: t_sum_line_id t_num_15_type;
5671: t_tolerance_per t_num_15_type;
5672: t_tolerance_req t_num_15_type;
5673: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5674: t_tolerance_sline t_num_15_type_ind;
5675: t_request_id t_num_15_type_ind;
5676: t_template_id t_num_15_type_ind;
5677: t_tolerance_erid t_num_15_type_ind;

Line 5674: t_tolerance_sline t_num_15_type_ind;

5670: t_sum_line_id t_num_15_type;
5671: t_tolerance_per t_num_15_type;
5672: t_tolerance_req t_num_15_type;
5673: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5674: t_tolerance_sline t_num_15_type_ind;
5675: t_request_id t_num_15_type_ind;
5676: t_template_id t_num_15_type_ind;
5677: t_tolerance_erid t_num_15_type_ind;
5678: l_S_and_T_reqid integer;

Line 5675: t_request_id t_num_15_type_ind;

5671: t_tolerance_per t_num_15_type;
5672: t_tolerance_req t_num_15_type;
5673: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5674: t_tolerance_sline t_num_15_type_ind;
5675: t_request_id t_num_15_type_ind;
5676: t_template_id t_num_15_type_ind;
5677: t_tolerance_erid t_num_15_type_ind;
5678: l_S_and_T_reqid integer;
5679: l_sql_string varchar2(12000); --Bug 6037692

Line 5676: t_template_id t_num_15_type_ind;

5672: t_tolerance_req t_num_15_type;
5673: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5674: t_tolerance_sline t_num_15_type_ind;
5675: t_request_id t_num_15_type_ind;
5676: t_template_id t_num_15_type_ind;
5677: t_tolerance_erid t_num_15_type_ind;
5678: l_S_and_T_reqid integer;
5679: l_sql_string varchar2(12000); --Bug 6037692
5680: l_tolerance_amt number;

Line 5677: t_tolerance_erid t_num_15_type_ind;

5673: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5674: t_tolerance_sline t_num_15_type_ind;
5675: t_request_id t_num_15_type_ind;
5676: t_template_id t_num_15_type_ind;
5677: t_tolerance_erid t_num_15_type_ind;
5678: l_S_and_T_reqid integer;
5679: l_sql_string varchar2(12000); --Bug 6037692
5680: l_tolerance_amt number;
5681: l_tolerance_percent number;

Line 6153: t_person_id t_num_15_type;

6149: l_employee_notify boolean;
6150: l_init_notify boolean;
6151: l_frp_notify boolean;
6152: t_wf_roles t_varchar2_400_type;
6153: t_person_id t_num_15_type;
6154: l_template_name varchar2(240);
6155: l_distribution_source varchar2(260);
6156: l_time_period_name varchar2(100);
6157:

Line 6866: t_person_table := t_num_15_type(null);

6862: end if;
6863: end if; -- new template
6864: end loop;
6865: delete psp_supercede_persons_gt;
6866: t_person_table := t_num_15_type(null);
6867: t_efforts_table := t_num_15_type(null);
6868: t_sum_line_id := t_num_15_type(null);
6869: t_person_table.delete;
6870: t_efforts_table.delete;

Line 6867: t_efforts_table := t_num_15_type(null);

6863: end if; -- new template
6864: end loop;
6865: delete psp_supercede_persons_gt;
6866: t_person_table := t_num_15_type(null);
6867: t_efforts_table := t_num_15_type(null);
6868: t_sum_line_id := t_num_15_type(null);
6869: t_person_table.delete;
6870: t_efforts_table.delete;
6871: t_sum_line_id.delete ;

Line 6868: t_sum_line_id := t_num_15_type(null);

6864: end loop;
6865: delete psp_supercede_persons_gt;
6866: t_person_table := t_num_15_type(null);
6867: t_efforts_table := t_num_15_type(null);
6868: t_sum_line_id := t_num_15_type(null);
6869: t_person_table.delete;
6870: t_efforts_table.delete;
6871: t_sum_line_id.delete ;
6872: t_tolerance_erid.delete;