APPS.JTF_TERR_JSP_LOV_RECS_PUB_W dependencies on JTF_TERR_JSP_LOV_RECS_PUB

Line 1: package body jtf_terr_jsp_lov_recs_pub_w as

1: package body jtf_terr_jsp_lov_recs_pub_w as
2: /* $Header: jtfwjlvb.pls 120.0 2005/06/02 18:23: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 22: procedure rosetta_table_copy_in_p2(t OUT NOCOPY jtf_terr_jsp_lov_recs_pub.lov_output_tbl_type, a0 JTF_VARCHAR2_TABLE_2000

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_p2(t OUT NOCOPY jtf_terr_jsp_lov_recs_pub.lov_output_tbl_type, a0 JTF_VARCHAR2_TABLE_2000
23: , a1 JTF_VARCHAR2_TABLE_2000
24: , a2 JTF_VARCHAR2_TABLE_2000
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_VARCHAR2_TABLE_2000

Line 79: procedure rosetta_table_copy_out_p2(t jtf_terr_jsp_lov_recs_pub.lov_output_tbl_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_2000

75: end loop;
76: end if;
77: end if;
78: end rosetta_table_copy_in_p2;
79: procedure rosetta_table_copy_out_p2(t jtf_terr_jsp_lov_recs_pub.lov_output_tbl_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
80: , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
81: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
82: , a3 OUT NOCOPY JTF_VARCHAR2_TABLE_2000
83: , a4 OUT NOCOPY JTF_VARCHAR2_TABLE_2000

Line 198: procedure rosetta_table_copy_in_p3(t OUT NOCOPY jtf_terr_jsp_lov_recs_pub.lov_disp_format_tbl_type, a0 JTF_NUMBER_TABLE

194: end if;
195: end if;
196: end rosetta_table_copy_out_p2;
197:
198: procedure rosetta_table_copy_in_p3(t OUT NOCOPY jtf_terr_jsp_lov_recs_pub.lov_disp_format_tbl_type, a0 JTF_NUMBER_TABLE
199: , a1 JTF_VARCHAR2_TABLE_100
200: , a2 JTF_VARCHAR2_TABLE_100
201: ) as
202: ddindx binary_integer; indx binary_integer;

Line 221: procedure rosetta_table_copy_out_p3(t jtf_terr_jsp_lov_recs_pub.lov_disp_format_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

217: end loop;
218: end if;
219: end if;
220: end rosetta_table_copy_in_p3;
221: procedure rosetta_table_copy_out_p3(t jtf_terr_jsp_lov_recs_pub.lov_disp_format_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
222: , a1 OUT NOCOPY JTF_VARCHAR2_TABLE_100
223: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
224: ) as
225: ddindx binary_integer; indx binary_integer;

Line 306: ddp_in_filter_lov_rec jtf_terr_jsp_lov_recs_pub.lov_inout_rec_type;

302: , p8_a1 OUT NOCOPY JTF_VARCHAR2_TABLE_100
303: , p8_a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
304: )
305: as
306: ddp_in_filter_lov_rec jtf_terr_jsp_lov_recs_pub.lov_inout_rec_type;
307: ddx_result_tbl jtf_terr_jsp_lov_recs_pub.lov_output_tbl_type;
308: ddx_disp_format_tbl jtf_terr_jsp_lov_recs_pub.lov_disp_format_tbl_type;
309: ddindx binary_integer; indx binary_integer;
310: begin

Line 307: ddx_result_tbl jtf_terr_jsp_lov_recs_pub.lov_output_tbl_type;

303: , p8_a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
304: )
305: as
306: ddp_in_filter_lov_rec jtf_terr_jsp_lov_recs_pub.lov_inout_rec_type;
307: ddx_result_tbl jtf_terr_jsp_lov_recs_pub.lov_output_tbl_type;
308: ddx_disp_format_tbl jtf_terr_jsp_lov_recs_pub.lov_disp_format_tbl_type;
309: ddindx binary_integer; indx binary_integer;
310: begin
311:

Line 308: ddx_disp_format_tbl jtf_terr_jsp_lov_recs_pub.lov_disp_format_tbl_type;

304: )
305: as
306: ddp_in_filter_lov_rec jtf_terr_jsp_lov_recs_pub.lov_inout_rec_type;
307: ddx_result_tbl jtf_terr_jsp_lov_recs_pub.lov_output_tbl_type;
308: ddx_disp_format_tbl jtf_terr_jsp_lov_recs_pub.lov_disp_format_tbl_type;
309: ddindx binary_integer; indx binary_integer;
310: begin
311:
312: -- copy data to the local IN or IN-OUT NOCOPY args, if any

Line 343: jtf_terr_jsp_lov_recs_pub.get_lov_records(p_range_low,

339:
340:
341:
342: -- here's the delegated call to the old PL/SQL routine
343: jtf_terr_jsp_lov_recs_pub.get_lov_records(p_range_low,
344: p_range_high,
345: p_record_group_name,
346: ddp_in_filter_lov_rec,
347: x_total_rows,

Line 361: jtf_terr_jsp_lov_recs_pub_w.rosetta_table_copy_out_p2(ddx_result_tbl, p7_a0

357:
358:
359:
360:
361: jtf_terr_jsp_lov_recs_pub_w.rosetta_table_copy_out_p2(ddx_result_tbl, p7_a0
362: , p7_a1
363: , p7_a2
364: , p7_a3
365: , p7_a4

Line 383: jtf_terr_jsp_lov_recs_pub_w.rosetta_table_copy_out_p3(ddx_disp_format_tbl, p8_a0

379: , p7_a18
380: , p7_a19
381: );
382:
383: jtf_terr_jsp_lov_recs_pub_w.rosetta_table_copy_out_p3(ddx_disp_format_tbl, p8_a0
384: , p8_a1
385: , p8_a2
386: );
387: end;

Line 389: end jtf_terr_jsp_lov_recs_pub_w;

385: , p8_a2
386: );
387: end;
388:
389: end jtf_terr_jsp_lov_recs_pub_w;