DBA Data[Home] [Help]

APPS.JTF_PERZ_LF_PUB_W dependencies on JTF_PERZ_LF_PUB

Line 1: package body jtf_perz_lf_pub_w as

1: package body jtf_perz_lf_pub_w as
2: /* $Header: jtfzwlfb.pls 120.2 2005/11/02 23:01:03 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_lf_pub.attrib_rec_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_lf_pub.attrib_rec_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: ) as
26: ddindx binary_integer; indx binary_integer;

Line 45: procedure rosetta_table_copy_out_p1(t jtf_perz_lf_pub.attrib_rec_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

41: end loop;
42: end if;
43: end if;
44: end rosetta_table_copy_in_p1;
45: procedure rosetta_table_copy_out_p1(t jtf_perz_lf_pub.attrib_rec_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
46: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
47: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
48: ) as
49: ddindx binary_integer; indx binary_integer;

Line 79: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.attrib_value_tbl_type, a0 JTF_NUMBER_TABLE

75: end if;
76: end if;
77: end rosetta_table_copy_out_p1;
78:
79: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.attrib_value_tbl_type, a0 JTF_NUMBER_TABLE
80: , a1 JTF_VARCHAR2_TABLE_100
81: , a2 JTF_VARCHAR2_TABLE_100
82: , a3 JTF_VARCHAR2_TABLE_100
83: , a4 JTF_NUMBER_TABLE

Line 106: procedure rosetta_table_copy_out_p4(t jtf_perz_lf_pub.attrib_value_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

102: end loop;
103: end if;
104: end if;
105: end rosetta_table_copy_in_p4;
106: procedure rosetta_table_copy_out_p4(t jtf_perz_lf_pub.attrib_value_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
107: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
108: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
109: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
110: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 150: procedure rosetta_table_copy_in_p7(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.lf_object_out_tbl_type, a0 JTF_NUMBER_TABLE

146: end if;
147: end if;
148: end rosetta_table_copy_out_p4;
149:
150: procedure rosetta_table_copy_in_p7(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.lf_object_out_tbl_type, a0 JTF_NUMBER_TABLE
151: , a1 JTF_NUMBER_TABLE
152: , a2 JTF_NUMBER_TABLE
153: , a3 JTF_VARCHAR2_TABLE_100
154: , a4 JTF_VARCHAR2_TABLE_300

Line 193: procedure rosetta_table_copy_out_p7(t jtf_perz_lf_pub.lf_object_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

189: end loop;
190: end if;
191: end if;
192: end rosetta_table_copy_in_p7;
193: procedure rosetta_table_copy_out_p7(t jtf_perz_lf_pub.lf_object_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
194: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
195: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
196: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
197: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 308: ddp_attrib_value_tbl jtf_perz_lf_pub.attrib_value_tbl_type;

304: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
305: )
306: as
307: ddp_profile_attrib_tbl jtf_perz_profile_pub.profile_attrib_tbl_type;
308: ddp_attrib_value_tbl jtf_perz_lf_pub.attrib_value_tbl_type;
309: ddindx binary_integer; indx binary_integer;
310: begin
311:
312: -- copy data to the local IN or IN-OUT args, if any

Line 334: jtf_perz_lf_pub_w.rosetta_table_copy_in_p4(ddp_attrib_value_tbl, p15_a0

330:
331:
332:
333:
334: jtf_perz_lf_pub_w.rosetta_table_copy_in_p4(ddp_attrib_value_tbl, p15_a0
335: , p15_a1
336: , p15_a2
337: , p15_a3
338: , p15_a4

Line 346: jtf_perz_lf_pub.save_lf_object(p_api_version_number,

342:
343:
344:
345: -- here's the delegated call to the old PL/SQL routine
346: jtf_perz_lf_pub.save_lf_object(p_api_version_number,
347: p_init_msg_list,
348: p_commit,
349: p_profile_id,
350: p_profile_name,

Line 404: ddp_attrib_rec_tbl jtf_perz_lf_pub.attrib_rec_tbl_type;

400: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
401: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
402: )
403: as
404: ddp_attrib_rec_tbl jtf_perz_lf_pub.attrib_rec_tbl_type;
405: ddindx binary_integer; indx binary_integer;
406: begin
407:
408: -- copy data to the local IN or IN-OUT args, if any

Line 415: jtf_perz_lf_pub_w.rosetta_table_copy_in_p1(ddp_attrib_rec_tbl, p6_a0

411:
412:
413:
414:
415: jtf_perz_lf_pub_w.rosetta_table_copy_in_p1(ddp_attrib_rec_tbl, p6_a0
416: , p6_a1
417: , p6_a2
418: );
419:

Line 425: jtf_perz_lf_pub.save_lf_object_type(p_api_version_number,

421:
422:
423:
424: -- here's the delegated call to the old PL/SQL routine
425: jtf_perz_lf_pub.save_lf_object_type(p_api_version_number,
426: p_init_msg_list,
427: p_commit,
428: p_object_type_id,
429: p_object_type,

Line 472: ddp_attrib_value_tbl jtf_perz_lf_pub.attrib_value_tbl_type;

468: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
469: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
470: )
471: as
472: ddp_attrib_value_tbl jtf_perz_lf_pub.attrib_value_tbl_type;
473: ddindx binary_integer; indx binary_integer;
474: begin
475:
476: -- copy data to the local IN or IN-OUT args, if any

Line 488: jtf_perz_lf_pub_w.rosetta_table_copy_in_p4(ddp_attrib_value_tbl, p11_a0

484:
485:
486:
487:
488: jtf_perz_lf_pub_w.rosetta_table_copy_in_p4(ddp_attrib_value_tbl, p11_a0
489: , p11_a1
490: , p11_a2
491: , p11_a3
492: , p11_a4

Line 500: jtf_perz_lf_pub.create_lf_object(p_api_version_number,

496:
497:
498:
499: -- here's the delegated call to the old PL/SQL routine
500: jtf_perz_lf_pub.create_lf_object(p_api_version_number,
501: p_init_msg_list,
502: p_commit,
503: p_profile_id,
504: p_profile_name,

Line 549: ddx_attrib_rec_tbl jtf_perz_lf_pub.attrib_rec_tbl_type;

545: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
546: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
547: )
548: as
549: ddx_attrib_rec_tbl jtf_perz_lf_pub.attrib_rec_tbl_type;
550: ddindx binary_integer; indx binary_integer;
551: begin
552:
553: -- copy data to the local IN or IN-OUT args, if any

Line 565: jtf_perz_lf_pub.get_lf_object_type(p_api_version_number,

561:
562:
563:
564: -- here's the delegated call to the old PL/SQL routine
565: jtf_perz_lf_pub.get_lf_object_type(p_api_version_number,
566: p_init_msg_list,
567: p_object_type,
568: p_object_type_id,
569: x_object_type_id,

Line 583: jtf_perz_lf_pub_w.rosetta_table_copy_out_p1(ddx_attrib_rec_tbl, p6_a0

579:
580:
581:
582:
583: jtf_perz_lf_pub_w.rosetta_table_copy_out_p1(ddx_attrib_rec_tbl, p6_a0
584: , p6_a1
585: , p6_a2
586: );
587:

Line 620: ddx_object_tbl jtf_perz_lf_pub.lf_object_out_tbl_type;

616: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
617: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
618: )
619: as
620: ddx_object_tbl jtf_perz_lf_pub.lf_object_out_tbl_type;
621: ddindx binary_integer; indx binary_integer;
622: begin
623:
624: -- copy data to the local IN or IN-OUT args, if any

Line 640: jtf_perz_lf_pub.get_lf_object(p_api_version_number,

636:
637:
638:
639: -- here's the delegated call to the old PL/SQL routine
640: jtf_perz_lf_pub.get_lf_object(p_api_version_number,
641: p_init_msg_list,
642: p_application_id,
643: p_priority,
644: p_profile_id,

Line 666: jtf_perz_lf_pub_w.rosetta_table_copy_out_p7(ddx_object_tbl, p10_a0

662:
663:
664:
665:
666: jtf_perz_lf_pub_w.rosetta_table_copy_out_p7(ddx_object_tbl, p10_a0
667: , p10_a1
668: , p10_a2
669: , p10_a3
670: , p10_a4

Line 708: ddp_attrib_value_tbl jtf_perz_lf_pub.attrib_value_tbl_type;

704: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
705: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
706: )
707: as
708: ddp_attrib_value_tbl jtf_perz_lf_pub.attrib_value_tbl_type;
709: ddindx binary_integer; indx binary_integer;
710: begin
711:
712: -- copy data to the local IN or IN-OUT args, if any

Line 725: jtf_perz_lf_pub_w.rosetta_table_copy_in_p4(ddp_attrib_value_tbl, p12_a0

721:
722:
723:
724:
725: jtf_perz_lf_pub_w.rosetta_table_copy_in_p4(ddp_attrib_value_tbl, p12_a0
726: , p12_a1
727: , p12_a2
728: , p12_a3
729: , p12_a4

Line 737: jtf_perz_lf_pub.update_lf_object(p_api_version_number,

733:
734:
735:
736: -- here's the delegated call to the old PL/SQL routine
737: jtf_perz_lf_pub.update_lf_object(p_api_version_number,
738: p_init_msg_list,
739: p_commit,
740: p_profile_id,
741: p_profile_name,

Line 774: end jtf_perz_lf_pub_w;

770:
771:
772: end;
773:
774: end jtf_perz_lf_pub_w;