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.IGS_EN_DASHBOARD_W dependencies on IGS_EN_DASHBOARD

Line 1: package body igs_en_dashboard_w as

1: package body igs_en_dashboard_w as
2: /* $Header: IGSENB3B.pls 120.0 2005/09/13 10:03:21 appldev noship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy igs_en_dashboard.link_text_type, a0 JTF_VARCHAR2_TABLE_200) as
4: ddindx binary_integer; indx binary_integer;
5: begin

Line 3: procedure rosetta_table_copy_in_p0(t out nocopy igs_en_dashboard.link_text_type, a0 JTF_VARCHAR2_TABLE_200) as

1: package body igs_en_dashboard_w as
2: /* $Header: IGSENB3B.pls 120.0 2005/09/13 10:03:21 appldev noship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy igs_en_dashboard.link_text_type, a0 JTF_VARCHAR2_TABLE_200) as
4: ddindx binary_integer; indx binary_integer;
5: begin
6: if a0 is not null and a0.count > 0 then
7: if a0.count > 0 then

Line 21: procedure rosetta_table_copy_out_p0(t igs_en_dashboard.link_text_type, a0 out nocopy JTF_VARCHAR2_TABLE_200) as

17: end loop;
18: end if;
19: end if;
20: end rosetta_table_copy_in_p0;
21: procedure rosetta_table_copy_out_p0(t igs_en_dashboard.link_text_type, a0 out nocopy JTF_VARCHAR2_TABLE_200) as
22: ddindx binary_integer; indx binary_integer;
23: begin
24: if t is null or t.count = 0 then
25: a0 := JTF_VARCHAR2_TABLE_200();

Line 44: procedure rosetta_table_copy_in_p1(t out nocopy igs_en_dashboard.cal_type, a0 JTF_VARCHAR2_TABLE_100) as

40: end if;
41: end if;
42: end rosetta_table_copy_out_p0;
43:
44: procedure rosetta_table_copy_in_p1(t out nocopy igs_en_dashboard.cal_type, a0 JTF_VARCHAR2_TABLE_100) as
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if a0 is not null and a0.count > 0 then
48: if a0.count > 0 then

Line 62: procedure rosetta_table_copy_out_p1(t igs_en_dashboard.cal_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

58: end loop;
59: end if;
60: end if;
61: end rosetta_table_copy_in_p1;
62: procedure rosetta_table_copy_out_p1(t igs_en_dashboard.cal_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
63: ddindx binary_integer; indx binary_integer;
64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_VARCHAR2_TABLE_100();

Line 85: procedure rosetta_table_copy_in_p2(t out nocopy igs_en_dashboard.seq_num_type, a0 JTF_NUMBER_TABLE) as

81: end if;
82: end if;
83: end rosetta_table_copy_out_p1;
84:
85: procedure rosetta_table_copy_in_p2(t out nocopy igs_en_dashboard.seq_num_type, a0 JTF_NUMBER_TABLE) as
86: ddindx binary_integer; indx binary_integer;
87: begin
88: if a0 is not null and a0.count > 0 then
89: if a0.count > 0 then

Line 103: procedure rosetta_table_copy_out_p2(t igs_en_dashboard.seq_num_type, a0 out nocopy JTF_NUMBER_TABLE) as

99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p2;
103: procedure rosetta_table_copy_out_p2(t igs_en_dashboard.seq_num_type, a0 out nocopy JTF_NUMBER_TABLE) as
104: ddindx binary_integer; indx binary_integer;
105: begin
106: if t is null or t.count = 0 then
107: a0 := JTF_NUMBER_TABLE();

Line 126: procedure rosetta_table_copy_in_p3(t out nocopy igs_en_dashboard.prg_car_type, a0 JTF_VARCHAR2_TABLE_100) as

122: end if;
123: end if;
124: end rosetta_table_copy_out_p2;
125:
126: procedure rosetta_table_copy_in_p3(t out nocopy igs_en_dashboard.prg_car_type, a0 JTF_VARCHAR2_TABLE_100) as
127: ddindx binary_integer; indx binary_integer;
128: begin
129: if a0 is not null and a0.count > 0 then
130: if a0.count > 0 then

Line 144: procedure rosetta_table_copy_out_p3(t igs_en_dashboard.prg_car_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

140: end loop;
141: end if;
142: end if;
143: end rosetta_table_copy_in_p3;
144: procedure rosetta_table_copy_out_p3(t igs_en_dashboard.prg_car_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
145: ddindx binary_integer; indx binary_integer;
146: begin
147: if t is null or t.count = 0 then
148: a0 := JTF_VARCHAR2_TABLE_100();

Line 167: procedure rosetta_table_copy_in_p4(t out nocopy igs_en_dashboard.plan_sched_type, a0 JTF_VARCHAR2_TABLE_100) as

163: end if;
164: end if;
165: end rosetta_table_copy_out_p3;
166:
167: procedure rosetta_table_copy_in_p4(t out nocopy igs_en_dashboard.plan_sched_type, a0 JTF_VARCHAR2_TABLE_100) as
168: ddindx binary_integer; indx binary_integer;
169: begin
170: if a0 is not null and a0.count > 0 then
171: if a0.count > 0 then

Line 185: procedure rosetta_table_copy_out_p4(t igs_en_dashboard.plan_sched_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

181: end loop;
182: end if;
183: end if;
184: end rosetta_table_copy_in_p4;
185: procedure rosetta_table_copy_out_p4(t igs_en_dashboard.plan_sched_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
186: ddindx binary_integer; indx binary_integer;
187: begin
188: if t is null or t.count = 0 then
189: a0 := JTF_VARCHAR2_TABLE_100();

Line 219: ddp_text_tbl igs_en_dashboard.link_text_type;

215: , p_sch_allow out nocopy VARCHAR2
216: )
217:
218: as
219: ddp_text_tbl igs_en_dashboard.link_text_type;
220: ddp_cal_tbl igs_en_dashboard.cal_type;
221: ddp_seq_tbl igs_en_dashboard.seq_num_type;
222: ddp_car_tbl igs_en_dashboard.prg_car_type;
223: ddp_typ_tbl igs_en_dashboard.plan_sched_type;

Line 220: ddp_cal_tbl igs_en_dashboard.cal_type;

216: )
217:
218: as
219: ddp_text_tbl igs_en_dashboard.link_text_type;
220: ddp_cal_tbl igs_en_dashboard.cal_type;
221: ddp_seq_tbl igs_en_dashboard.seq_num_type;
222: ddp_car_tbl igs_en_dashboard.prg_car_type;
223: ddp_typ_tbl igs_en_dashboard.plan_sched_type;
224: ddindx binary_integer; indx binary_integer;

Line 221: ddp_seq_tbl igs_en_dashboard.seq_num_type;

217:
218: as
219: ddp_text_tbl igs_en_dashboard.link_text_type;
220: ddp_cal_tbl igs_en_dashboard.cal_type;
221: ddp_seq_tbl igs_en_dashboard.seq_num_type;
222: ddp_car_tbl igs_en_dashboard.prg_car_type;
223: ddp_typ_tbl igs_en_dashboard.plan_sched_type;
224: ddindx binary_integer; indx binary_integer;
225: begin

Line 222: ddp_car_tbl igs_en_dashboard.prg_car_type;

218: as
219: ddp_text_tbl igs_en_dashboard.link_text_type;
220: ddp_cal_tbl igs_en_dashboard.cal_type;
221: ddp_seq_tbl igs_en_dashboard.seq_num_type;
222: ddp_car_tbl igs_en_dashboard.prg_car_type;
223: ddp_typ_tbl igs_en_dashboard.plan_sched_type;
224: ddindx binary_integer; indx binary_integer;
225: begin
226:

Line 223: ddp_typ_tbl igs_en_dashboard.plan_sched_type;

219: ddp_text_tbl igs_en_dashboard.link_text_type;
220: ddp_cal_tbl igs_en_dashboard.cal_type;
221: ddp_seq_tbl igs_en_dashboard.seq_num_type;
222: ddp_car_tbl igs_en_dashboard.prg_car_type;
223: ddp_typ_tbl igs_en_dashboard.plan_sched_type;
224: ddindx binary_integer; indx binary_integer;
225: begin
226:
227: -- copy data to the local IN or IN-OUT args, if any

Line 237: igs_en_dashboard.student_api(p_n_person_id,

233:
234:
235:
236: -- here's the delegated call to the old PL/SQL routine
237: igs_en_dashboard.student_api(p_n_person_id,
238: p_c_person_type,
239: ddp_text_tbl,
240: ddp_cal_tbl,
241: ddp_seq_tbl,

Line 249: igs_en_dashboard_w.rosetta_table_copy_out_p0(ddp_text_tbl, p_text_tbl);

245:
246: -- copy data back from the local variables to OUT or IN-OUT args, if any
247:
248:
249: igs_en_dashboard_w.rosetta_table_copy_out_p0(ddp_text_tbl, p_text_tbl);
250:
251: igs_en_dashboard_w.rosetta_table_copy_out_p1(ddp_cal_tbl, p_cal_tbl);
252:
253: igs_en_dashboard_w.rosetta_table_copy_out_p2(ddp_seq_tbl, p_seq_tbl);

Line 251: igs_en_dashboard_w.rosetta_table_copy_out_p1(ddp_cal_tbl, p_cal_tbl);

247:
248:
249: igs_en_dashboard_w.rosetta_table_copy_out_p0(ddp_text_tbl, p_text_tbl);
250:
251: igs_en_dashboard_w.rosetta_table_copy_out_p1(ddp_cal_tbl, p_cal_tbl);
252:
253: igs_en_dashboard_w.rosetta_table_copy_out_p2(ddp_seq_tbl, p_seq_tbl);
254:
255: igs_en_dashboard_w.rosetta_table_copy_out_p3(ddp_car_tbl, p_car_tbl);

Line 253: igs_en_dashboard_w.rosetta_table_copy_out_p2(ddp_seq_tbl, p_seq_tbl);

249: igs_en_dashboard_w.rosetta_table_copy_out_p0(ddp_text_tbl, p_text_tbl);
250:
251: igs_en_dashboard_w.rosetta_table_copy_out_p1(ddp_cal_tbl, p_cal_tbl);
252:
253: igs_en_dashboard_w.rosetta_table_copy_out_p2(ddp_seq_tbl, p_seq_tbl);
254:
255: igs_en_dashboard_w.rosetta_table_copy_out_p3(ddp_car_tbl, p_car_tbl);
256:
257: igs_en_dashboard_w.rosetta_table_copy_out_p4(ddp_typ_tbl, p_typ_tbl);

Line 255: igs_en_dashboard_w.rosetta_table_copy_out_p3(ddp_car_tbl, p_car_tbl);

251: igs_en_dashboard_w.rosetta_table_copy_out_p1(ddp_cal_tbl, p_cal_tbl);
252:
253: igs_en_dashboard_w.rosetta_table_copy_out_p2(ddp_seq_tbl, p_seq_tbl);
254:
255: igs_en_dashboard_w.rosetta_table_copy_out_p3(ddp_car_tbl, p_car_tbl);
256:
257: igs_en_dashboard_w.rosetta_table_copy_out_p4(ddp_typ_tbl, p_typ_tbl);
258:
259: end;

Line 257: igs_en_dashboard_w.rosetta_table_copy_out_p4(ddp_typ_tbl, p_typ_tbl);

253: igs_en_dashboard_w.rosetta_table_copy_out_p2(ddp_seq_tbl, p_seq_tbl);
254:
255: igs_en_dashboard_w.rosetta_table_copy_out_p3(ddp_car_tbl, p_car_tbl);
256:
257: igs_en_dashboard_w.rosetta_table_copy_out_p4(ddp_typ_tbl, p_typ_tbl);
258:
259: end;
260:
261: end igs_en_dashboard_w;

Line 261: end igs_en_dashboard_w;

257: igs_en_dashboard_w.rosetta_table_copy_out_p4(ddp_typ_tbl, p_typ_tbl);
258:
259: end;
260:
261: end igs_en_dashboard_w;