DBA Data[Home] [Help]

APPS.JTF_RS_JSP_LOV_RECS_PUB_W dependencies on JTF_RS_JSP_LOV_RECS_PUB

Line 1: package body jtf_rs_jsp_lov_recs_pub_w as

1: package body jtf_rs_jsp_lov_recs_pub_w as
2: /* $Header: jtfrsjwb.pls 120.0 2005/05/11 08:20:26 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_rs_jsp_lov_recs_pub.lov_output_tbl_type, a0 JTF_VARCHAR2_TABLE_2000

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type, a0 JTF_VARCHAR2_TABLE_2000
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_2000
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_VARCHAR2_TABLE_2000

Line 59: procedure rosetta_table_copy_out_p2(t jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_2000

55: end loop;
56: end if;
57: end if;
58: end rosetta_table_copy_in_p2;
59: procedure rosetta_table_copy_out_p2(t jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_2000
60: , a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
62: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
63: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 155: ddp_in_filter_lov_rec jtf_rs_jsp_lov_recs_pub.lov_input_rec_type;

151: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
152: )
153:
154: as
155: ddp_in_filter_lov_rec jtf_rs_jsp_lov_recs_pub.lov_input_rec_type;
156: ddx_result_tbl jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type;
157: ddindx binary_integer; indx binary_integer;
158: begin
159:

Line 156: ddx_result_tbl jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type;

152: )
153:
154: as
155: ddp_in_filter_lov_rec jtf_rs_jsp_lov_recs_pub.lov_input_rec_type;
156: ddx_result_tbl jtf_rs_jsp_lov_recs_pub.lov_output_tbl_type;
157: ddindx binary_integer; indx binary_integer;
158: begin
159:
160: -- copy data to the local IN or IN-OUT args, if any

Line 178: jtf_rs_jsp_lov_recs_pub.get_lov_records(p_range_low,

174:
175:
176:
177: -- here's the delegated call to the old PL/SQL routine
178: jtf_rs_jsp_lov_recs_pub.get_lov_records(p_range_low,
179: p_range_high,
180: p_record_group_name,
181: ddp_in_filter_lov_rec,
182: p_in_filter1,

Line 200: jtf_rs_jsp_lov_recs_pub_w.rosetta_table_copy_out_p2(ddx_result_tbl, p9_a0

196:
197:
198:
199:
200: jtf_rs_jsp_lov_recs_pub_w.rosetta_table_copy_out_p2(ddx_result_tbl, p9_a0
201: , p9_a1
202: , p9_a2
203: , p9_a3
204: , p9_a4

Line 214: end jtf_rs_jsp_lov_recs_pub_w;

210: );
211:
212: end;
213:
214: end jtf_rs_jsp_lov_recs_pub_w;