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.IEC_REPORTS_PVT dependencies on NUMBER_TBL_TYPE

Line 39: , p_subset_id_col IN SYSTEM.number_tbl_type

35:
36: PROCEDURE Calculate_SubsetCounts
37: ( p_schedule_id IN NUMBER
38: , p_list_id IN NUMBER
39: , p_subset_id_col IN SYSTEM.number_tbl_type
40: , x_subset_record_loaded_col IN OUT NOCOPY SYSTEM.number_tbl_type
41: , x_subset_record_called_col IN OUT NOCOPY SYSTEM.number_tbl_type)
42: IS
43: BEGIN

Line 40: , x_subset_record_loaded_col IN OUT NOCOPY SYSTEM.number_tbl_type

36: PROCEDURE Calculate_SubsetCounts
37: ( p_schedule_id IN NUMBER
38: , p_list_id IN NUMBER
39: , p_subset_id_col IN SYSTEM.number_tbl_type
40: , x_subset_record_loaded_col IN OUT NOCOPY SYSTEM.number_tbl_type
41: , x_subset_record_called_col IN OUT NOCOPY SYSTEM.number_tbl_type)
42: IS
43: BEGIN
44:

Line 41: , x_subset_record_called_col IN OUT NOCOPY SYSTEM.number_tbl_type)

37: ( p_schedule_id IN NUMBER
38: , p_list_id IN NUMBER
39: , p_subset_id_col IN SYSTEM.number_tbl_type
40: , x_subset_record_loaded_col IN OUT NOCOPY SYSTEM.number_tbl_type
41: , x_subset_record_called_col IN OUT NOCOPY SYSTEM.number_tbl_type)
42: IS
43: BEGIN
44:
45: x_subset_record_loaded_col := SYSTEM.number_tbl_type();

Line 45: x_subset_record_loaded_col := SYSTEM.number_tbl_type();

41: , x_subset_record_called_col IN OUT NOCOPY SYSTEM.number_tbl_type)
42: IS
43: BEGIN
44:
45: x_subset_record_loaded_col := SYSTEM.number_tbl_type();
46: x_subset_record_called_col := SYSTEM.number_tbl_type();
47:
48: IF p_subset_id_col IS NOT NULL AND p_subset_id_col.COUNT > 0 THEN
49:

Line 46: x_subset_record_called_col := SYSTEM.number_tbl_type();

42: IS
43: BEGIN
44:
45: x_subset_record_loaded_col := SYSTEM.number_tbl_type();
46: x_subset_record_called_col := SYSTEM.number_tbl_type();
47:
48: IF p_subset_id_col IS NOT NULL AND p_subset_id_col.COUNT > 0 THEN
49:
50: FOR i IN 1..p_subset_id_col.LAST LOOP

Line 118: , p_subset_id_col IN SYSTEM.number_tbl_type

114:
115: PROCEDURE Update_SubsetCounts
116: ( p_schedule_id IN NUMBER
117: , p_list_id IN NUMBER
118: , p_subset_id_col IN SYSTEM.number_tbl_type
119: , p_subset_record_loaded_col IN SYSTEM.number_tbl_type
120: , p_subset_record_called_col IN SYSTEM.number_tbl_type)
121:
122: IS

Line 119: , p_subset_record_loaded_col IN SYSTEM.number_tbl_type

115: PROCEDURE Update_SubsetCounts
116: ( p_schedule_id IN NUMBER
117: , p_list_id IN NUMBER
118: , p_subset_id_col IN SYSTEM.number_tbl_type
119: , p_subset_record_loaded_col IN SYSTEM.number_tbl_type
120: , p_subset_record_called_col IN SYSTEM.number_tbl_type)
121:
122: IS
123: BEGIN

Line 120: , p_subset_record_called_col IN SYSTEM.number_tbl_type)

116: ( p_schedule_id IN NUMBER
117: , p_list_id IN NUMBER
118: , p_subset_id_col IN SYSTEM.number_tbl_type
119: , p_subset_record_loaded_col IN SYSTEM.number_tbl_type
120: , p_subset_record_called_col IN SYSTEM.number_tbl_type)
121:
122: IS
123: BEGIN
124:

Line 188: l_subset_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

184: , p_source_id IN NUMBER
185: , x_return_code IN OUT NOCOPY VARCHAR2)
186: IS
187:
188: l_subset_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
189: l_subset_record_loaded_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
190: l_subset_record_called_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
191:
192: l_cc_tz_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

Line 189: l_subset_record_loaded_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

185: , x_return_code IN OUT NOCOPY VARCHAR2)
186: IS
187:
188: l_subset_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
189: l_subset_record_loaded_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
190: l_subset_record_called_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
191:
192: l_cc_tz_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
193: l_cc_tz_count_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

Line 190: l_subset_record_called_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

186: IS
187:
188: l_subset_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
189: l_subset_record_loaded_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
190: l_subset_record_called_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
191:
192: l_cc_tz_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
193: l_cc_tz_count_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
194:

Line 192: l_cc_tz_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

188: l_subset_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
189: l_subset_record_loaded_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
190: l_subset_record_called_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
191:
192: l_cc_tz_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
193: l_cc_tz_count_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
194:
195: BEGIN
196:

Line 193: l_cc_tz_count_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

189: l_subset_record_loaded_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
190: l_subset_record_called_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
191:
192: l_cc_tz_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
193: l_cc_tz_count_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
194:
195: BEGIN
196:
197: x_return_code := 'S';

Line 307: l_list_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

303: , p_source_id IN NUMBER
304: , x_return_code IN OUT NOCOPY VARCHAR2)
305: IS
306:
307: l_list_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
308: l_return_code VARCHAR2(1);
309:
310: BEGIN
311:

Line 383: l_schedule_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

379: ( p_source_id IN NUMBER
380: , x_return_code IN OUT NOCOPY VARCHAR2)
381: IS
382:
383: l_schedule_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
384: l_return_code VARCHAR2(1);
385:
386: BEGIN
387: