APPS.CN_SF_PARAMS_PVT_W dependencies on CN_SF_PARAMS_PVT

Line 1: package body cn_sf_params_pvt_w as

1: package body cn_sf_params_pvt_w as
2: /* $Header: cnwprmsb.pls 115.4 2002/12/04 05:05:17 fmburu 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 13: procedure rosetta_table_copy_in_p1(t out nocopy cn_sf_params_pvt.sf_repositories_tbl_type, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_sf_params_pvt.sf_repositories_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_2000
16: , a3 JTF_VARCHAR2_TABLE_1000
17: , a4 JTF_VARCHAR2_TABLE_100

Line 52: procedure rosetta_table_copy_out_p1(t cn_sf_params_pvt.sf_repositories_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

48: end loop;
49: end if;
50: end if;
51: end rosetta_table_copy_in_p1;
52: procedure rosetta_table_copy_out_p1(t cn_sf_params_pvt.sf_repositories_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_VARCHAR2_TABLE_100
54: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
55: , a3 out nocopy JTF_VARCHAR2_TABLE_1000
56: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 147: ddp_sf_param_rec cn_sf_params_pvt.cn_sf_repositories_rec_type;

143: , x_msg_data out nocopy VARCHAR2
144: )
145:
146: as
147: ddp_sf_param_rec cn_sf_params_pvt.cn_sf_repositories_rec_type;
148: ddindx binary_integer; indx binary_integer;
149: begin
150:
151: -- copy data to the local IN or IN-OUT args, if any

Line 161: cn_sf_params_pvt.get_sf_parameters(p_api_version,

157:
158:
159:
160: -- here's the delegated call to the old PL/SQL routine
161: cn_sf_params_pvt.get_sf_parameters(p_api_version,
162: p_init_msg_list,
163: p_commit,
164: p_validation_level,
165: ddp_sf_param_rec,

Line 212: ddp_sf_repositories_rec cn_sf_params_pvt.cn_sf_repositories_rec_type;

208: , x_msg_data out nocopy VARCHAR2
209: )
210:
211: as
212: ddp_sf_repositories_rec cn_sf_params_pvt.cn_sf_repositories_rec_type;
213: ddindx binary_integer; indx binary_integer;
214: begin
215:
216: -- copy data to the local IN or IN-OUT args, if any

Line 237: cn_sf_params_pvt.update_sf_parameters(p_api_version,

233:
234:
235:
236: -- here's the delegated call to the old PL/SQL routine
237: cn_sf_params_pvt.update_sf_parameters(p_api_version,
238: p_init_msg_list,
239: p_commit,
240: p_validation_level,
241: ddp_sf_repositories_rec,

Line 277: ddp_sf_repositories_rec cn_sf_params_pvt.cn_sf_repositories_rec_type;

273: , x_msg_data out nocopy VARCHAR2
274: )
275:
276: as
277: ddp_sf_repositories_rec cn_sf_params_pvt.cn_sf_repositories_rec_type;
278: ddindx binary_integer; indx binary_integer;
279: begin
280:
281: -- copy data to the local IN or IN-OUT args, if any

Line 302: cn_sf_params_pvt.insert_sf_parameters(p_api_version,

298:
299:
300:
301: -- here's the delegated call to the old PL/SQL routine
302: cn_sf_params_pvt.insert_sf_parameters(p_api_version,
303: p_init_msg_list,
304: p_commit,
305: p_validation_level,
306: ddp_sf_repositories_rec,

Line 321: end cn_sf_params_pvt_w;

317:
318:
319: end;
320:
321: end cn_sf_params_pvt_w;