[Home] [Help]
PACKAGE: APPS.AHL_PRD_SERN_CHANGE_PVT_W
Source
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
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
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
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
34 , p_commit VARCHAR2
35 , p_validation_level NUMBER
36 , p4_a0 NUMBER
37 , p4_a1 VARCHAR2
38 , p4_a2 VARCHAR2
39 , p4_a3 VARCHAR2
40 , p4_a4 VARCHAR2
41 , p4_a5 VARCHAR2
42 , p4_a6 NUMBER
43 , p4_a7 NUMBER
44 , p4_a8 VARCHAR2
45 , p4_a9 VARCHAR2
46 , p4_a10 VARCHAR2
47 , p4_a11 VARCHAR2
48 , p4_a12 VARCHAR2
49 , x_return_status out nocopy VARCHAR2
50 , x_msg_count out nocopy NUMBER
51 , x_msg_data out nocopy VARCHAR2
52 , x_warning_msg_tbl out nocopy JTF_VARCHAR2_TABLE_2000
53 );
54 end ahl_prd_sern_change_pvt_w;