[Home] [Help]
PACKAGE: APPS.PV_TAP_ACCESS_TERRS_PVT_W
Source
1 package pv_tap_access_terrs_pvt_w AUTHID CURRENT_USER as
2 /* $Header: pvxwtras.pls 115.0 2003/10/15 04:22:56 rdsharma noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy pv_tap_access_terrs_pvt.tap_access_terrs_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_DATE_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_DATE_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_DATE_TABLE
15 );
16 procedure rosetta_table_copy_out_p2(t pv_tap_access_terrs_pvt.tap_access_terrs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
17 , a1 out nocopy JTF_NUMBER_TABLE
18 , a2 out nocopy JTF_DATE_TABLE
19 , a3 out nocopy JTF_NUMBER_TABLE
20 , a4 out nocopy JTF_DATE_TABLE
21 , a5 out nocopy JTF_NUMBER_TABLE
22 , a6 out nocopy JTF_NUMBER_TABLE
23 , a7 out nocopy JTF_NUMBER_TABLE
24 , a8 out nocopy JTF_NUMBER_TABLE
25 , a9 out nocopy JTF_NUMBER_TABLE
26 , a10 out nocopy JTF_NUMBER_TABLE
27 , a11 out nocopy JTF_DATE_TABLE
28 );
29
30 procedure create_tap_access_terrs(p_api_version_number NUMBER
31 , p_init_msg_list VARCHAR2
32 , p_commit VARCHAR2
33 , p_validation_level NUMBER
34 , x_return_status out nocopy VARCHAR2
35 , x_msg_count out nocopy NUMBER
36 , x_msg_data out nocopy VARCHAR2
37 , p7_a0 NUMBER
38 , p7_a1 NUMBER
39 , p7_a2 DATE
40 , p7_a3 NUMBER
41 , p7_a4 DATE
42 , p7_a5 NUMBER
43 , p7_a6 NUMBER
44 , p7_a7 NUMBER
45 , p7_a8 NUMBER
46 , p7_a9 NUMBER
47 , p7_a10 NUMBER
48 , p7_a11 DATE
49 );
50 procedure update_tap_access_terrs(p_api_version_number NUMBER
51 , p_init_msg_list VARCHAR2
52 , p_commit VARCHAR2
53 , p_validation_level NUMBER
54 , x_return_status out nocopy VARCHAR2
55 , x_msg_count out nocopy NUMBER
56 , x_msg_data out nocopy VARCHAR2
57 , p7_a0 NUMBER
58 , p7_a1 NUMBER
59 , p7_a2 DATE
60 , p7_a3 NUMBER
61 , p7_a4 DATE
62 , p7_a5 NUMBER
63 , p7_a6 NUMBER
64 , p7_a7 NUMBER
65 , p7_a8 NUMBER
66 , p7_a9 NUMBER
67 , p7_a10 NUMBER
68 , p7_a11 DATE
69 );
70 procedure validate_tap_access_terrs(p_api_version_number NUMBER
71 , p_init_msg_list VARCHAR2
72 , p_validation_level NUMBER
73 , p_validation_mode VARCHAR2
74 , p4_a0 NUMBER
75 , p4_a1 NUMBER
76 , p4_a2 DATE
77 , p4_a3 NUMBER
78 , p4_a4 DATE
79 , p4_a5 NUMBER
80 , p4_a6 NUMBER
81 , p4_a7 NUMBER
82 , p4_a8 NUMBER
83 , p4_a9 NUMBER
84 , p4_a10 NUMBER
85 , p4_a11 DATE
86 , x_return_status out nocopy VARCHAR2
87 , x_msg_count out nocopy NUMBER
88 , x_msg_data out nocopy VARCHAR2
89 );
90 procedure chk_tap_access_terrs_items(p0_a0 NUMBER
91 , p0_a1 NUMBER
92 , p0_a2 DATE
93 , p0_a3 NUMBER
94 , p0_a4 DATE
95 , p0_a5 NUMBER
96 , p0_a6 NUMBER
97 , p0_a7 NUMBER
98 , p0_a8 NUMBER
99 , p0_a9 NUMBER
100 , p0_a10 NUMBER
101 , p0_a11 DATE
102 , p_validation_mode VARCHAR2
103 , x_return_status out nocopy VARCHAR2
104 );
105 procedure validate_tap_access_terrs_rec(p_api_version_number NUMBER
106 , p_init_msg_list VARCHAR2
107 , x_return_status out nocopy VARCHAR2
108 , x_msg_count out nocopy NUMBER
109 , x_msg_data out nocopy VARCHAR2
110 , p5_a0 NUMBER
111 , p5_a1 NUMBER
112 , p5_a2 DATE
113 , p5_a3 NUMBER
114 , p5_a4 DATE
115 , p5_a5 NUMBER
116 , p5_a6 NUMBER
117 , p5_a7 NUMBER
118 , p5_a8 NUMBER
119 , p5_a9 NUMBER
120 , p5_a10 NUMBER
121 , p5_a11 DATE
122 );
123 end pv_tap_access_terrs_pvt_w;