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 5245: t_person_table t_num_15_type;

5241: l_supercede_reqid_str varchar2(9000); --Bug 6037692
5242: l_run_id integer;
5243: i integer;
5244: j integer;
5245: t_person_table t_num_15_type;
5246: t_efforts_table t_num_15_type;
5247: t_sum_line_id t_num_15_type;
5248: t_tolerance_per t_num_15_type;
5249: t_tolerance_req t_num_15_type;

Line 5246: t_efforts_table t_num_15_type;

5242: l_run_id integer;
5243: i integer;
5244: j integer;
5245: t_person_table t_num_15_type;
5246: t_efforts_table t_num_15_type;
5247: t_sum_line_id t_num_15_type;
5248: t_tolerance_per t_num_15_type;
5249: t_tolerance_req t_num_15_type;
5250: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;

Line 5247: t_sum_line_id t_num_15_type;

5243: i integer;
5244: j integer;
5245: t_person_table t_num_15_type;
5246: t_efforts_table t_num_15_type;
5247: t_sum_line_id t_num_15_type;
5248: t_tolerance_per t_num_15_type;
5249: t_tolerance_req t_num_15_type;
5250: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5251: t_tolerance_sline t_num_15_type_ind;

Line 5248: t_tolerance_per t_num_15_type;

5244: j integer;
5245: t_person_table t_num_15_type;
5246: t_efforts_table t_num_15_type;
5247: t_sum_line_id t_num_15_type;
5248: t_tolerance_per t_num_15_type;
5249: t_tolerance_req t_num_15_type;
5250: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5251: t_tolerance_sline t_num_15_type_ind;
5252: t_request_id t_num_15_type_ind;

Line 5249: t_tolerance_req t_num_15_type;

5245: t_person_table t_num_15_type;
5246: t_efforts_table t_num_15_type;
5247: t_sum_line_id t_num_15_type;
5248: t_tolerance_per t_num_15_type;
5249: t_tolerance_req t_num_15_type;
5250: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5251: t_tolerance_sline t_num_15_type_ind;
5252: t_request_id t_num_15_type_ind;
5253: t_template_id t_num_15_type_ind;

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

5246: t_efforts_table t_num_15_type;
5247: t_sum_line_id t_num_15_type;
5248: t_tolerance_per t_num_15_type;
5249: t_tolerance_req t_num_15_type;
5250: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5251: t_tolerance_sline t_num_15_type_ind;
5252: t_request_id t_num_15_type_ind;
5253: t_template_id t_num_15_type_ind;
5254: t_tolerance_erid t_num_15_type_ind;

Line 5251: t_tolerance_sline t_num_15_type_ind;

5247: t_sum_line_id t_num_15_type;
5248: t_tolerance_per t_num_15_type;
5249: t_tolerance_req t_num_15_type;
5250: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5251: t_tolerance_sline t_num_15_type_ind;
5252: t_request_id t_num_15_type_ind;
5253: t_template_id t_num_15_type_ind;
5254: t_tolerance_erid t_num_15_type_ind;
5255: l_S_and_T_reqid integer;

Line 5252: t_request_id t_num_15_type_ind;

5248: t_tolerance_per t_num_15_type;
5249: t_tolerance_req t_num_15_type;
5250: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5251: t_tolerance_sline t_num_15_type_ind;
5252: t_request_id t_num_15_type_ind;
5253: t_template_id t_num_15_type_ind;
5254: t_tolerance_erid t_num_15_type_ind;
5255: l_S_and_T_reqid integer;
5256: l_sql_string varchar2(12000); --Bug 6037692

Line 5253: t_template_id t_num_15_type_ind;

5249: t_tolerance_req t_num_15_type;
5250: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5251: t_tolerance_sline t_num_15_type_ind;
5252: t_request_id t_num_15_type_ind;
5253: t_template_id t_num_15_type_ind;
5254: t_tolerance_erid t_num_15_type_ind;
5255: l_S_and_T_reqid integer;
5256: l_sql_string varchar2(12000); --Bug 6037692
5257: l_tolerance_amt number;

Line 5254: t_tolerance_erid t_num_15_type_ind;

5250: TYPE t_num_15_type_ind IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5251: t_tolerance_sline t_num_15_type_ind;
5252: t_request_id t_num_15_type_ind;
5253: t_template_id t_num_15_type_ind;
5254: t_tolerance_erid t_num_15_type_ind;
5255: l_S_and_T_reqid integer;
5256: l_sql_string varchar2(12000); --Bug 6037692
5257: l_tolerance_amt number;
5258: l_tolerance_percent number;

Line 5730: t_person_id t_num_15_type;

5726: l_employee_notify boolean;
5727: l_init_notify boolean;
5728: l_frp_notify boolean;
5729: t_wf_roles t_varchar2_400_type;
5730: t_person_id t_num_15_type;
5731: l_template_name varchar2(240);
5732: l_distribution_source varchar2(260);
5733: l_time_period_name varchar2(100);
5734:

Line 6439: t_person_table := t_num_15_type(null);

6435: end if;
6436: end if; -- new template
6437: end loop;
6438: delete psp_supercede_persons_gt;
6439: t_person_table := t_num_15_type(null);
6440: t_efforts_table := t_num_15_type(null);
6441: t_sum_line_id := t_num_15_type(null);
6442: t_person_table.delete;
6443: t_efforts_table.delete;

Line 6440: t_efforts_table := t_num_15_type(null);

6436: end if; -- new template
6437: end loop;
6438: delete psp_supercede_persons_gt;
6439: t_person_table := t_num_15_type(null);
6440: t_efforts_table := t_num_15_type(null);
6441: t_sum_line_id := t_num_15_type(null);
6442: t_person_table.delete;
6443: t_efforts_table.delete;
6444: t_sum_line_id.delete ;

Line 6441: t_sum_line_id := t_num_15_type(null);

6437: end loop;
6438: delete psp_supercede_persons_gt;
6439: t_person_table := t_num_15_type(null);
6440: t_efforts_table := t_num_15_type(null);
6441: t_sum_line_id := t_num_15_type(null);
6442: t_person_table.delete;
6443: t_efforts_table.delete;
6444: t_sum_line_id.delete ;
6445: t_tolerance_erid.delete;