DBA Data[Home] [Help]

APPS.CN_PAY_GROUP_DTLS_PVT_W dependencies on CN_PAY_GROUP_DTLS_PVT

Line 1: package body cn_pay_group_dtls_pvt_w as

1: package body cn_pay_group_dtls_pvt_w as
2: /* $Header: cnwpgdtb.pls 115.5 2002/11/27 12:20:46 pramadas 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_p3(t out nocopy cn_pay_group_dtls_pvt.pay_group_dtls_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_p3(t out nocopy cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100

Line 48: procedure rosetta_table_copy_out_p3(t cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

44: end loop;
45: end if;
46: end if;
47: end rosetta_table_copy_in_p3;
48: procedure rosetta_table_copy_out_p3(t cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 112: procedure rosetta_table_copy_in_p4(t out nocopy cn_pay_group_dtls_pvt.pay_group_sales_tbl_type, a0 JTF_NUMBER_TABLE

108: end if;
109: end if;
110: end rosetta_table_copy_out_p3;
111:
112: procedure rosetta_table_copy_in_p4(t out nocopy cn_pay_group_dtls_pvt.pay_group_sales_tbl_type, a0 JTF_NUMBER_TABLE
113: , a1 JTF_VARCHAR2_TABLE_100
114: , a2 JTF_VARCHAR2_TABLE_100
115: , a3 JTF_VARCHAR2_TABLE_100
116: , a4 JTF_VARCHAR2_TABLE_400

Line 145: procedure rosetta_table_copy_out_p4(t cn_pay_group_dtls_pvt.pay_group_sales_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

141: end loop;
142: end if;
143: end if;
144: end rosetta_table_copy_in_p4;
145: procedure rosetta_table_copy_out_p4(t cn_pay_group_dtls_pvt.pay_group_sales_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
146: , a1 out nocopy JTF_VARCHAR2_TABLE_100
147: , a2 out nocopy JTF_VARCHAR2_TABLE_100
148: , a3 out nocopy JTF_VARCHAR2_TABLE_100
149: , a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 204: procedure rosetta_table_copy_in_p5(t out nocopy cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 JTF_NUMBER_TABLE

200: end if;
201: end if;
202: end rosetta_table_copy_out_p4;
203:
204: procedure rosetta_table_copy_in_p5(t out nocopy cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 JTF_NUMBER_TABLE
205: , a1 JTF_VARCHAR2_TABLE_100
206: , a2 JTF_VARCHAR2_TABLE_100
207: , a3 JTF_VARCHAR2_TABLE_100
208: , a4 JTF_VARCHAR2_TABLE_100

Line 237: procedure rosetta_table_copy_out_p5(t cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

233: end loop;
234: end if;
235: end if;
236: end rosetta_table_copy_in_p5;
237: procedure rosetta_table_copy_out_p5(t cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
238: , a1 out nocopy JTF_VARCHAR2_TABLE_100
239: , a2 out nocopy JTF_VARCHAR2_TABLE_100
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 319: ddx_pay_group_dtls cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type;

315: , x_msg_data out nocopy VARCHAR2
316: )
317:
318: as
319: ddx_pay_group_dtls cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type;
320: ddindx binary_integer; indx binary_integer;
321: begin
322:
323: -- copy data to the local IN or IN-OUT args, if any

Line 337: cn_pay_group_dtls_pvt.get_pay_group_dtls(p_api_version,

333:
334:
335:
336: -- here's the delegated call to the old PL/SQL routine
337: cn_pay_group_dtls_pvt.get_pay_group_dtls(p_api_version,
338: p_init_msg_list,
339: p_commit,
340: p_validation_level,
341: p_start_record,

Line 358: cn_pay_group_dtls_pvt_w.rosetta_table_copy_out_p3(ddx_pay_group_dtls, p7_a0

354:
355:
356:
357:
358: cn_pay_group_dtls_pvt_w.rosetta_table_copy_out_p3(ddx_pay_group_dtls, p7_a0
359: , p7_a1
360: , p7_a2
361: , p7_a3
362: , p7_a4

Line 396: ddx_pay_group_sales cn_pay_group_dtls_pvt.pay_group_sales_tbl_type;

392: , x_msg_data out nocopy VARCHAR2
393: )
394:
395: as
396: ddx_pay_group_sales cn_pay_group_dtls_pvt.pay_group_sales_tbl_type;
397: ddindx binary_integer; indx binary_integer;
398: begin
399:
400: -- copy data to the local IN or IN-OUT args, if any

Line 414: cn_pay_group_dtls_pvt.get_pay_group_sales(p_api_version,

410:
411:
412:
413: -- here's the delegated call to the old PL/SQL routine
414: cn_pay_group_dtls_pvt.get_pay_group_sales(p_api_version,
415: p_init_msg_list,
416: p_commit,
417: p_validation_level,
418: p_start_record,

Line 435: cn_pay_group_dtls_pvt_w.rosetta_table_copy_out_p4(ddx_pay_group_sales, p7_a0

431:
432:
433:
434:
435: cn_pay_group_dtls_pvt_w.rosetta_table_copy_out_p4(ddx_pay_group_sales, p7_a0
436: , p7_a1
437: , p7_a2
438: , p7_a3
439: , p7_a4

Line 472: ddx_pay_group_roles cn_pay_group_dtls_pvt.pay_group_roles_tbl_type;

468: , x_msg_data out nocopy VARCHAR2
469: )
470:
471: as
472: ddx_pay_group_roles cn_pay_group_dtls_pvt.pay_group_roles_tbl_type;
473: ddindx binary_integer; indx binary_integer;
474: begin
475:
476: -- copy data to the local IN or IN-OUT args, if any

Line 490: cn_pay_group_dtls_pvt.get_pay_group_roles(p_api_version,

486:
487:
488:
489: -- here's the delegated call to the old PL/SQL routine
490: cn_pay_group_dtls_pvt.get_pay_group_roles(p_api_version,
491: p_init_msg_list,
492: p_commit,
493: p_validation_level,
494: p_start_record,

Line 511: cn_pay_group_dtls_pvt_w.rosetta_table_copy_out_p5(ddx_pay_group_roles, p7_a0

507:
508:
509:
510:
511: cn_pay_group_dtls_pvt_w.rosetta_table_copy_out_p5(ddx_pay_group_roles, p7_a0
512: , p7_a1
513: , p7_a2
514: , p7_a3
515: , p7_a4

Line 526: end cn_pay_group_dtls_pvt_w;

522:
523:
524: end;
525:
526: end cn_pay_group_dtls_pvt_w;