[Home] [Help]
PACKAGE: APPS.AMV_PERSPECTIVE_PVT_W
Source
1 package amv_perspective_pvt_w as
2 /* $Header: amvwpsps.pls 120.2 2005/06/30 08:30 appldev ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy amv_perspective_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
4 procedure rosetta_table_copy_out_p1(t amv_perspective_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
5
6 procedure rosetta_table_copy_in_p5(t out nocopy amv_perspective_pvt.amv_perspective_obj_varray, a0 JTF_NUMBER_TABLE
7 , a1 JTF_NUMBER_TABLE
8 , a2 JTF_VARCHAR2_TABLE_100
9 , a3 JTF_VARCHAR2_TABLE_2000
10 , a4 JTF_VARCHAR2_TABLE_100
11 , a5 JTF_VARCHAR2_TABLE_100
12 , a6 JTF_DATE_TABLE
13 , a7 JTF_NUMBER_TABLE
14 , a8 JTF_DATE_TABLE
15 , a9 JTF_NUMBER_TABLE
16 , a10 JTF_NUMBER_TABLE
17 );
18 procedure rosetta_table_copy_out_p5(t amv_perspective_pvt.amv_perspective_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
19 , a1 out nocopy JTF_NUMBER_TABLE
20 , a2 out nocopy JTF_VARCHAR2_TABLE_100
21 , a3 out nocopy JTF_VARCHAR2_TABLE_2000
22 , a4 out nocopy JTF_VARCHAR2_TABLE_100
23 , a5 out nocopy JTF_VARCHAR2_TABLE_100
24 , a6 out nocopy JTF_DATE_TABLE
25 , a7 out nocopy JTF_NUMBER_TABLE
26 , a8 out nocopy JTF_DATE_TABLE
27 , a9 out nocopy JTF_NUMBER_TABLE
28 , a10 out nocopy JTF_NUMBER_TABLE
29 );
30
31 procedure get_perspective(p_api_version NUMBER
32 , p_init_msg_list 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 , p_check_login_user VARCHAR2
38 , p_perspective_id NUMBER
39 , p_perspective_name VARCHAR2
40 , p9_a0 out nocopy NUMBER
41 , p9_a1 out nocopy NUMBER
42 , p9_a2 out nocopy VARCHAR2
43 , p9_a3 out nocopy VARCHAR2
44 , p9_a4 out nocopy VARCHAR2
45 , p9_a5 out nocopy VARCHAR2
46 , p9_a6 out nocopy DATE
47 , p9_a7 out nocopy NUMBER
48 , p9_a8 out nocopy DATE
49 , p9_a9 out nocopy NUMBER
50 , p9_a10 out nocopy NUMBER
51 );
52 procedure find_perspective(p_api_version NUMBER
53 , p_init_msg_list VARCHAR2
54 , p_validation_level NUMBER
55 , x_return_status out nocopy VARCHAR2
56 , x_msg_count out nocopy NUMBER
57 , x_msg_data out nocopy VARCHAR2
58 , p_check_login_user VARCHAR2
59 , p_perspective_name VARCHAR2
60 , p_persp_description VARCHAR2
61 , p10_a0 out nocopy NUMBER
62 , p10_a1 out nocopy NUMBER
63 , p10_a2 out nocopy NUMBER
64 , p11_a0 out nocopy JTF_NUMBER_TABLE
65 , p11_a1 out nocopy JTF_NUMBER_TABLE
66 , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
67 , p11_a3 out nocopy JTF_VARCHAR2_TABLE_2000
68 , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
69 , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
70 , p11_a6 out nocopy JTF_DATE_TABLE
71 , p11_a7 out nocopy JTF_NUMBER_TABLE
72 , p11_a8 out nocopy JTF_DATE_TABLE
73 , p11_a9 out nocopy JTF_NUMBER_TABLE
74 , p11_a10 out nocopy JTF_NUMBER_TABLE
75 , p9_a0 NUMBER := 0-1962.0724
76 , p9_a1 NUMBER := 0-1962.0724
77 , p9_a2 VARCHAR2 := fnd_api.g_miss_char
78 );
79 procedure add_itempersps(p_api_version NUMBER
80 , p_init_msg_list VARCHAR2
81 , p_commit VARCHAR2
82 , p_validation_level NUMBER
83 , x_return_status out nocopy VARCHAR2
84 , x_msg_count out nocopy NUMBER
85 , x_msg_data out nocopy VARCHAR2
86 , p_check_login_user VARCHAR2
87 , p_item_id NUMBER
88 , p_perspective_array JTF_NUMBER_TABLE
89 );
90 procedure delete_itempersps(p_api_version NUMBER
91 , p_init_msg_list VARCHAR2
92 , p_commit VARCHAR2
93 , p_validation_level NUMBER
94 , x_return_status out nocopy VARCHAR2
95 , x_msg_count out nocopy NUMBER
96 , x_msg_data out nocopy VARCHAR2
97 , p_check_login_user VARCHAR2
98 , p_item_id NUMBER
99 , p_perspective_array JTF_NUMBER_TABLE
100 );
101 procedure update_itempersps(p_api_version NUMBER
102 , p_init_msg_list VARCHAR2
103 , p_commit VARCHAR2
104 , p_validation_level NUMBER
105 , x_return_status out nocopy VARCHAR2
106 , x_msg_count out nocopy NUMBER
107 , x_msg_data out nocopy VARCHAR2
108 , p_check_login_user VARCHAR2
109 , p_item_id NUMBER
110 , p_perspective_array JTF_NUMBER_TABLE
111 );
112 procedure get_itempersps(p_api_version NUMBER
113 , p_init_msg_list VARCHAR2
114 , p_validation_level NUMBER
115 , x_return_status out nocopy VARCHAR2
116 , x_msg_count out nocopy NUMBER
117 , x_msg_data out nocopy VARCHAR2
118 , p_check_login_user VARCHAR2
119 , p_item_id NUMBER
120 , p8_a0 out nocopy JTF_NUMBER_TABLE
121 , p8_a1 out nocopy JTF_NUMBER_TABLE
122 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
123 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_2000
124 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
125 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
126 , p8_a6 out nocopy JTF_DATE_TABLE
127 , p8_a7 out nocopy JTF_NUMBER_TABLE
128 , p8_a8 out nocopy JTF_DATE_TABLE
129 , p8_a9 out nocopy JTF_NUMBER_TABLE
130 , p8_a10 out nocopy JTF_NUMBER_TABLE
131 );
132 end amv_perspective_pvt_w;