APPS.JTF_PERZ_PROFILE_PUB_W dependencies on JTF_PERZ_PROFILE_PUB

Line 1: package body jtf_perz_profile_pub_w as

1: package body jtf_perz_profile_pub_w as
2: /* $Header: jtfzwpfb.pls 120.2 2005/11/02 23:48:35 skothe ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_attrib_tbl_type, a0 JTF_NUMBER_TABLE

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_attrib_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100

Line 49: procedure rosetta_table_copy_out_p1(t jtf_perz_profile_pub.profile_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

45: end loop;
46: end if;
47: end if;
48: end rosetta_table_copy_in_p1;
49: procedure rosetta_table_copy_out_p1(t jtf_perz_profile_pub.profile_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
50: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
51: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
52: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
53: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 93: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_out_tbl_type, a0 JTF_NUMBER_TABLE

89: end if;
90: end if;
91: end rosetta_table_copy_out_p1;
92:
93: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_out_tbl_type, a0 JTF_NUMBER_TABLE
94: , a1 JTF_VARCHAR2_TABLE_100
95: , a2 JTF_VARCHAR2_TABLE_100
96: , a3 JTF_VARCHAR2_TABLE_300
97: , a4 JTF_VARCHAR2_TABLE_100

Line 126: procedure rosetta_table_copy_out_p4(t jtf_perz_profile_pub.profile_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

122: end loop;
123: end if;
124: end if;
125: end rosetta_table_copy_in_p4;
126: procedure rosetta_table_copy_out_p4(t jtf_perz_profile_pub.profile_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
127: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
128: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
129: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
130: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 205: ddp_profile_attrib_tbl jtf_perz_profile_pub.profile_attrib_tbl_type;

201: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
202: )
203:
204: as
205: ddp_profile_attrib_tbl jtf_perz_profile_pub.profile_attrib_tbl_type;
206: ddindx binary_integer; indx binary_integer;
207: begin
208:
209: -- copy data to the local IN or IN-OUT args, if any

Line 217: jtf_perz_profile_pub_w.rosetta_table_copy_in_p1(ddp_profile_attrib_tbl, p7_a0

213:
214:
215:
216:
217: jtf_perz_profile_pub_w.rosetta_table_copy_in_p1(ddp_profile_attrib_tbl, p7_a0
218: , p7_a1
219: , p7_a2
220: , p7_a3
221: , p7_a4

Line 230: jtf_perz_profile_pub.create_profile(p_api_version_number,

226:
227:
228:
229: -- here's the delegated call to the old PL/SQL routine
230: jtf_perz_profile_pub.create_profile(p_api_version_number,
231: p_init_msg_list,
232: p_commit,
233: p_profile_id,
234: p_profile_name,

Line 283: ddp_profile_attrib_tbl jtf_perz_profile_pub.profile_attrib_tbl_type;

279: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
280: )
281:
282: as
283: ddp_profile_attrib_tbl jtf_perz_profile_pub.profile_attrib_tbl_type;
284: ddx_profile_tbl jtf_perz_profile_pub.profile_out_tbl_type;
285: ddindx binary_integer; indx binary_integer;
286: begin
287:

Line 284: ddx_profile_tbl jtf_perz_profile_pub.profile_out_tbl_type;

280: )
281:
282: as
283: ddp_profile_attrib_tbl jtf_perz_profile_pub.profile_attrib_tbl_type;
284: ddx_profile_tbl jtf_perz_profile_pub.profile_out_tbl_type;
285: ddindx binary_integer; indx binary_integer;
286: begin
287:
288: -- copy data to the local IN or IN-OUT args, if any

Line 294: jtf_perz_profile_pub_w.rosetta_table_copy_in_p1(ddp_profile_attrib_tbl, p5_a0

290:
291:
292:
293:
294: jtf_perz_profile_pub_w.rosetta_table_copy_in_p1(ddp_profile_attrib_tbl, p5_a0
295: , p5_a1
296: , p5_a2
297: , p5_a3
298: , p5_a4

Line 306: jtf_perz_profile_pub.get_profile(p_api_version_number,

302:
303:
304:
305: -- here's the delegated call to the old PL/SQL routine
306: jtf_perz_profile_pub.get_profile(p_api_version_number,
307: p_init_msg_list,
308: p_profile_id,
309: p_profile_name,
310: p_profile_type,

Line 324: jtf_perz_profile_pub_w.rosetta_table_copy_out_p4(ddx_profile_tbl, p6_a0

320:
321:
322:
323:
324: jtf_perz_profile_pub_w.rosetta_table_copy_out_p4(ddx_profile_tbl, p6_a0
325: , p6_a1
326: , p6_a2
327: , p6_a3
328: , p6_a4

Line 358: ddp_profile_attrib_tbl jtf_perz_profile_pub.profile_attrib_tbl_type;

354: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
355: )
356:
357: as
358: ddp_profile_attrib_tbl jtf_perz_profile_pub.profile_attrib_tbl_type;
359: ddindx binary_integer; indx binary_integer;
360: begin
361:
362: -- copy data to the local IN or IN-OUT args, if any

Line 371: jtf_perz_profile_pub_w.rosetta_table_copy_in_p1(ddp_profile_attrib_tbl, p8_a0

367:
368:
369:
370:
371: jtf_perz_profile_pub_w.rosetta_table_copy_in_p1(ddp_profile_attrib_tbl, p8_a0
372: , p8_a1
373: , p8_a2
374: , p8_a3
375: , p8_a4

Line 383: jtf_perz_profile_pub.update_profile(p_api_version_number,

379:
380:
381:
382: -- here's the delegated call to the old PL/SQL routine
383: jtf_perz_profile_pub.update_profile(p_api_version_number,
384: p_init_msg_list,
385: p_commit,
386: p_profile_id,
387: p_profile_name,

Line 412: end jtf_perz_profile_pub_w;

408:
409:
410: end;
411:
412: end jtf_perz_profile_pub_w;