DBA Data[Home] [Help]

APPS.JTF_TERR_LOOKUP_PUB_W dependencies on JTF_TERR_LOOKUP_PUB_W

Line 1: package body jtf_terr_lookup_pub_w as

1: package body jtf_terr_lookup_pub_w as
2: /* $Header: jtftlkwb.pls 120.0 2005/06/02 18:21:17 appldev 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 226: procedure rosetta_table_copy_in_p5(t OUT NOCOPY jtf_terr_lookup_pub.win_rsc_tbl_type, a0 JTF_NUMBER_TABLE

222: end if;
223: end if;
224: end rosetta_table_copy_out_p3;
225:
226: procedure rosetta_table_copy_in_p5(t OUT NOCOPY jtf_terr_lookup_pub.win_rsc_tbl_type, a0 JTF_NUMBER_TABLE
227: , a1 JTF_NUMBER_TABLE
228: , a2 JTF_VARCHAR2_TABLE_200
229: , a3 JTF_VARCHAR2_TABLE_200
230: , a4 JTF_VARCHAR2_TABLE_200

Line 269: procedure rosetta_table_copy_out_p5(t jtf_terr_lookup_pub.win_rsc_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

265: end loop;
266: end if;
267: end if;
268: end rosetta_table_copy_in_p5;
269: procedure rosetta_table_copy_out_p5(t jtf_terr_lookup_pub.win_rsc_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
270: , a1 OUT NOCOPY JTF_NUMBER_TABLE
271: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_200
272: , a3 OUT NOCOPY JTF_VARCHAR2_TABLE_200
273: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_200

Line 353: procedure rosetta_table_copy_in_p7(t OUT NOCOPY jtf_terr_lookup_pub.winners_tbl_type, a0 JTF_VARCHAR2_TABLE_100

349: end if;
350: end if;
351: end rosetta_table_copy_out_p5;
352:
353: procedure rosetta_table_copy_in_p7(t OUT NOCOPY jtf_terr_lookup_pub.winners_tbl_type, a0 JTF_VARCHAR2_TABLE_100
354: , a1 JTF_NUMBER_TABLE
355: , a2 JTF_NUMBER_TABLE
356: , a3 JTF_NUMBER_TABLE
357: , a4 JTF_NUMBER_TABLE

Line 446: procedure rosetta_table_copy_out_p7(t jtf_terr_lookup_pub.winners_tbl_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100

442: end loop;
443: end if;
444: end if;
445: end rosetta_table_copy_in_p7;
446: procedure rosetta_table_copy_out_p7(t jtf_terr_lookup_pub.winners_tbl_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100
447: , a1 OUT NOCOPY JTF_NUMBER_TABLE
448: , a2 OUT NOCOPY JTF_NUMBER_TABLE
449: , a3 OUT NOCOPY JTF_NUMBER_TABLE
450: , a4 OUT NOCOPY JTF_NUMBER_TABLE

Line 779: jtf_terr_lookup_pub_w.rosetta_table_copy_out_p3(ddx_result_tbl, p22_a0

775:
776:
777:
778:
779: jtf_terr_lookup_pub_w.rosetta_table_copy_out_p3(ddx_result_tbl, p22_a0
780: , p22_a1
781: , p22_a2
782: , p22_a3
783: , p22_a4

Line 961: ddx_winners_tbl jtf_terr_lookup_pub.winners_tbl_type;

957: , p10_a37 OUT NOCOPY JTF_VARCHAR2_TABLE_400
958: )
959: as
960: ddp_trans_rec jtf_terr_lookup_pub.trans_rec_type;
961: ddx_winners_tbl jtf_terr_lookup_pub.winners_tbl_type;
962: ddindx binary_integer; indx binary_integer;
963: begin
964:
965: -- copy data to the local IN or IN-OUT NOCOPY args, if any

Line 1106: jtf_terr_lookup_pub_w.rosetta_table_copy_out_p7(ddx_winners_tbl, p10_a0

1102:
1103:
1104:
1105:
1106: jtf_terr_lookup_pub_w.rosetta_table_copy_out_p7(ddx_winners_tbl, p10_a0
1107: , p10_a1
1108: , p10_a2
1109: , p10_a3
1110: , p10_a4

Line 1147: end jtf_terr_lookup_pub_w;

1143: , p10_a37
1144: );
1145: end;
1146:
1147: end jtf_terr_lookup_pub_w;
1148: