DBA Data[Home] [Help]

APPS.CN_WKSHT_GET_PUB_W dependencies on CN_WKSHT_GET_PUB

Line 1: package body cn_wksht_get_pub_w as

1: package body cn_wksht_get_pub_w as
2: /* $Header: cnwwkgtb.pls 115.16 2003/06/27 20:36:01 achung 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_wksht_get_pub.wksht_tbl, 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_wksht_get_pub.wksht_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100

Line 74: procedure rosetta_table_copy_out_p1(t cn_wksht_get_pub.wksht_tbl, a0 out nocopy JTF_NUMBER_TABLE

70: end loop;
71: end if;
72: end if;
73: end rosetta_table_copy_in_p1;
74: procedure rosetta_table_copy_out_p1(t cn_wksht_get_pub.wksht_tbl, a0 out nocopy JTF_NUMBER_TABLE
75: , a1 out nocopy JTF_NUMBER_TABLE
76: , a2 out nocopy JTF_VARCHAR2_TABLE_300
77: , a3 out nocopy JTF_NUMBER_TABLE
78: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 254: ddx_wksht_tbl cn_wksht_get_pub.wksht_tbl;

250: , x_total_records out nocopy NUMBER
251: )
252:
253: as
254: ddx_wksht_tbl cn_wksht_get_pub.wksht_tbl;
255: ddindx binary_integer; indx binary_integer;
256: begin
257:
258: -- copy data to the local IN or IN-OUT args, if any

Line 287: cn_wksht_get_pub.get_srp_wksht(p_api_version,

283:
284:
285:
286: -- here's the delegated call to the old PL/SQL routine
287: cn_wksht_get_pub.get_srp_wksht(p_api_version,
288: p_init_msg_list,
289: p_commit,
290: p_validation_level,
291: x_return_status,

Line 334: cn_wksht_get_pub_w.rosetta_table_copy_out_p1(ddx_wksht_tbl, p18_a0

330:
331:
332:
333:
334: cn_wksht_get_pub_w.rosetta_table_copy_out_p1(ddx_wksht_tbl, p18_a0
335: , p18_a1
336: , p18_a2
337: , p18_a3
338: , p18_a4

Line 367: end cn_wksht_get_pub_w;

363:
364:
365: end;
366:
367: end cn_wksht_get_pub_w;