DBA Data[Home] [Help]

APPS.IGS_EN_DASHBOARD_W dependencies on JTF_VARCHAR2_TABLE_100

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 66: a0 := JTF_VARCHAR2_TABLE_100();

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();
67: else
68: a0 := JTF_VARCHAR2_TABLE_100();
69: if t.count > 0 then
70: a0.extend(t.count);

Line 68: a0 := JTF_VARCHAR2_TABLE_100();

64: begin
65: if t is null or t.count = 0 then
66: a0 := JTF_VARCHAR2_TABLE_100();
67: else
68: a0 := JTF_VARCHAR2_TABLE_100();
69: if t.count > 0 then
70: a0.extend(t.count);
71: ddindx := t.first;
72: indx := 1;

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 148: a0 := JTF_VARCHAR2_TABLE_100();

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();
149: else
150: a0 := JTF_VARCHAR2_TABLE_100();
151: if t.count > 0 then
152: a0.extend(t.count);

Line 150: a0 := JTF_VARCHAR2_TABLE_100();

146: begin
147: if t is null or t.count = 0 then
148: a0 := JTF_VARCHAR2_TABLE_100();
149: else
150: a0 := JTF_VARCHAR2_TABLE_100();
151: if t.count > 0 then
152: a0.extend(t.count);
153: ddindx := t.first;
154: indx := 1;

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 189: a0 := JTF_VARCHAR2_TABLE_100();

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();
190: else
191: a0 := JTF_VARCHAR2_TABLE_100();
192: if t.count > 0 then
193: a0.extend(t.count);

Line 191: a0 := JTF_VARCHAR2_TABLE_100();

187: begin
188: if t is null or t.count = 0 then
189: a0 := JTF_VARCHAR2_TABLE_100();
190: else
191: a0 := JTF_VARCHAR2_TABLE_100();
192: if t.count > 0 then
193: a0.extend(t.count);
194: ddindx := t.first;
195: indx := 1;

Line 211: , p_cal_tbl out nocopy JTF_VARCHAR2_TABLE_100

207:
208: procedure student_api(p_n_person_id NUMBER
209: , p_c_person_type VARCHAR2
210: , p_text_tbl out nocopy JTF_VARCHAR2_TABLE_200
211: , p_cal_tbl out nocopy JTF_VARCHAR2_TABLE_100
212: , p_seq_tbl out nocopy JTF_NUMBER_TABLE
213: , p_car_tbl out nocopy JTF_VARCHAR2_TABLE_100
214: , p_typ_tbl out nocopy JTF_VARCHAR2_TABLE_100
215: , p_sch_allow out nocopy VARCHAR2

Line 213: , p_car_tbl out nocopy JTF_VARCHAR2_TABLE_100

209: , p_c_person_type VARCHAR2
210: , p_text_tbl out nocopy JTF_VARCHAR2_TABLE_200
211: , p_cal_tbl out nocopy JTF_VARCHAR2_TABLE_100
212: , p_seq_tbl out nocopy JTF_NUMBER_TABLE
213: , p_car_tbl out nocopy JTF_VARCHAR2_TABLE_100
214: , p_typ_tbl out nocopy JTF_VARCHAR2_TABLE_100
215: , p_sch_allow out nocopy VARCHAR2
216: )
217:

Line 214: , p_typ_tbl out nocopy JTF_VARCHAR2_TABLE_100

210: , p_text_tbl out nocopy JTF_VARCHAR2_TABLE_200
211: , p_cal_tbl out nocopy JTF_VARCHAR2_TABLE_100
212: , p_seq_tbl out nocopy JTF_NUMBER_TABLE
213: , p_car_tbl out nocopy JTF_VARCHAR2_TABLE_100
214: , p_typ_tbl out nocopy JTF_VARCHAR2_TABLE_100
215: , p_sch_allow out nocopy VARCHAR2
216: )
217:
218: as