APPS.AHL_PRD_SERN_CHANGE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package ahl_prd_sern_change_pvt_w as
2: /* $Header: AHLWSNCS.pls 120.3 2008/03/06 00:19:27 adivenka ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package ahl_prd_sern_change_pvt_w as
2: /* $Header: AHLWSNCS.pls 120.3 2008/03/06 00:19:27 adivenka ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: AHLWSNCS.pls 120.3 2008/03/06 00:19:27 adivenka ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100

Line 12: , a9 JTF_VARCHAR2_TABLE_100

8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: );

Line 13: , a10 JTF_VARCHAR2_TABLE_100

9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: );
17: procedure rosetta_table_copy_out_p1(t ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 14: , a11 JTF_VARCHAR2_TABLE_100

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: );
17: procedure rosetta_table_copy_out_p1(t ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 15: , a12 JTF_VARCHAR2_TABLE_100

11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: );
17: procedure rosetta_table_copy_out_p1(t ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_VARCHAR2_TABLE_100
19: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 18: , a1 out nocopy JTF_VARCHAR2_TABLE_100

14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: );
17: procedure rosetta_table_copy_out_p1(t ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_VARCHAR2_TABLE_100
19: , a2 out nocopy JTF_VARCHAR2_TABLE_100
20: , a3 out nocopy JTF_VARCHAR2_TABLE_100
21: , a4 out nocopy JTF_VARCHAR2_TABLE_100
22: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 19: , a2 out nocopy JTF_VARCHAR2_TABLE_100

15: , a12 JTF_VARCHAR2_TABLE_100
16: );
17: procedure rosetta_table_copy_out_p1(t ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_VARCHAR2_TABLE_100
19: , a2 out nocopy JTF_VARCHAR2_TABLE_100
20: , a3 out nocopy JTF_VARCHAR2_TABLE_100
21: , a4 out nocopy JTF_VARCHAR2_TABLE_100
22: , a5 out nocopy JTF_VARCHAR2_TABLE_100
23: , a6 out nocopy JTF_NUMBER_TABLE

Line 20: , a3 out nocopy JTF_VARCHAR2_TABLE_100

16: );
17: procedure rosetta_table_copy_out_p1(t ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_VARCHAR2_TABLE_100
19: , a2 out nocopy JTF_VARCHAR2_TABLE_100
20: , a3 out nocopy JTF_VARCHAR2_TABLE_100
21: , a4 out nocopy JTF_VARCHAR2_TABLE_100
22: , a5 out nocopy JTF_VARCHAR2_TABLE_100
23: , a6 out nocopy JTF_NUMBER_TABLE
24: , a7 out nocopy JTF_NUMBER_TABLE

Line 21: , a4 out nocopy JTF_VARCHAR2_TABLE_100

17: procedure rosetta_table_copy_out_p1(t ahl_prd_sern_change_pvt.sernum_change_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_VARCHAR2_TABLE_100
19: , a2 out nocopy JTF_VARCHAR2_TABLE_100
20: , a3 out nocopy JTF_VARCHAR2_TABLE_100
21: , a4 out nocopy JTF_VARCHAR2_TABLE_100
22: , a5 out nocopy JTF_VARCHAR2_TABLE_100
23: , a6 out nocopy JTF_NUMBER_TABLE
24: , a7 out nocopy JTF_NUMBER_TABLE
25: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 22: , a5 out nocopy JTF_VARCHAR2_TABLE_100

18: , a1 out nocopy JTF_VARCHAR2_TABLE_100
19: , a2 out nocopy JTF_VARCHAR2_TABLE_100
20: , a3 out nocopy JTF_VARCHAR2_TABLE_100
21: , a4 out nocopy JTF_VARCHAR2_TABLE_100
22: , a5 out nocopy JTF_VARCHAR2_TABLE_100
23: , a6 out nocopy JTF_NUMBER_TABLE
24: , a7 out nocopy JTF_NUMBER_TABLE
25: , a8 out nocopy JTF_VARCHAR2_TABLE_100
26: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 25: , a8 out nocopy JTF_VARCHAR2_TABLE_100

21: , a4 out nocopy JTF_VARCHAR2_TABLE_100
22: , a5 out nocopy JTF_VARCHAR2_TABLE_100
23: , a6 out nocopy JTF_NUMBER_TABLE
24: , a7 out nocopy JTF_NUMBER_TABLE
25: , a8 out nocopy JTF_VARCHAR2_TABLE_100
26: , a9 out nocopy JTF_VARCHAR2_TABLE_100
27: , a10 out nocopy JTF_VARCHAR2_TABLE_100
28: , a11 out nocopy JTF_VARCHAR2_TABLE_100
29: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 26: , a9 out nocopy JTF_VARCHAR2_TABLE_100

22: , a5 out nocopy JTF_VARCHAR2_TABLE_100
23: , a6 out nocopy JTF_NUMBER_TABLE
24: , a7 out nocopy JTF_NUMBER_TABLE
25: , a8 out nocopy JTF_VARCHAR2_TABLE_100
26: , a9 out nocopy JTF_VARCHAR2_TABLE_100
27: , a10 out nocopy JTF_VARCHAR2_TABLE_100
28: , a11 out nocopy JTF_VARCHAR2_TABLE_100
29: , a12 out nocopy JTF_VARCHAR2_TABLE_100
30: );

Line 27: , a10 out nocopy JTF_VARCHAR2_TABLE_100

23: , a6 out nocopy JTF_NUMBER_TABLE
24: , a7 out nocopy JTF_NUMBER_TABLE
25: , a8 out nocopy JTF_VARCHAR2_TABLE_100
26: , a9 out nocopy JTF_VARCHAR2_TABLE_100
27: , a10 out nocopy JTF_VARCHAR2_TABLE_100
28: , a11 out nocopy JTF_VARCHAR2_TABLE_100
29: , a12 out nocopy JTF_VARCHAR2_TABLE_100
30: );
31:

Line 28: , a11 out nocopy JTF_VARCHAR2_TABLE_100

24: , a7 out nocopy JTF_NUMBER_TABLE
25: , a8 out nocopy JTF_VARCHAR2_TABLE_100
26: , a9 out nocopy JTF_VARCHAR2_TABLE_100
27: , a10 out nocopy JTF_VARCHAR2_TABLE_100
28: , a11 out nocopy JTF_VARCHAR2_TABLE_100
29: , a12 out nocopy JTF_VARCHAR2_TABLE_100
30: );
31:
32: procedure process_serialnum_change(p_api_version NUMBER

Line 29: , a12 out nocopy JTF_VARCHAR2_TABLE_100

25: , a8 out nocopy JTF_VARCHAR2_TABLE_100
26: , a9 out nocopy JTF_VARCHAR2_TABLE_100
27: , a10 out nocopy JTF_VARCHAR2_TABLE_100
28: , a11 out nocopy JTF_VARCHAR2_TABLE_100
29: , a12 out nocopy JTF_VARCHAR2_TABLE_100
30: );
31:
32: procedure process_serialnum_change(p_api_version NUMBER
33: , p_init_msg_list VARCHAR2