[Home] [Help]
PACKAGE: APPS.CN_PSUM_PVT_W
Source
1 package cn_psum_pvt_w AUTHID CURRENT_USER as
2 /* $Header: cnwpsums.pls 115.5 2002/11/25 22:26:08 nkodkani ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy cn_psum_pvt.psum_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_400
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_NUMBER_TABLE
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 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_DATE_TABLE
18 , a15 JTF_DATE_TABLE
19 , a16 JTF_NUMBER_TABLE
20 );
21 procedure rosetta_table_copy_out_p1(t cn_psum_pvt.psum_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
22 , a1 out nocopy JTF_VARCHAR2_TABLE_400
23 , a2 out nocopy JTF_NUMBER_TABLE
24 , a3 out nocopy JTF_NUMBER_TABLE
25 , a4 out nocopy JTF_VARCHAR2_TABLE_100
26 , a5 out nocopy JTF_VARCHAR2_TABLE_100
27 , a6 out nocopy JTF_NUMBER_TABLE
28 , a7 out nocopy JTF_VARCHAR2_TABLE_100
29 , a8 out nocopy JTF_NUMBER_TABLE
30 , a9 out nocopy JTF_VARCHAR2_TABLE_100
31 , a10 out nocopy JTF_VARCHAR2_TABLE_100
32 , a11 out nocopy JTF_VARCHAR2_TABLE_100
33 , a12 out nocopy JTF_VARCHAR2_TABLE_100
34 , a13 out nocopy JTF_VARCHAR2_TABLE_100
35 , a14 out nocopy JTF_DATE_TABLE
36 , a15 out nocopy JTF_DATE_TABLE
37 , a16 out nocopy JTF_NUMBER_TABLE
38 );
39
40 procedure get_psum_data(p_api_version NUMBER
41 , p_init_msg_list VARCHAR2
42 , p_commit VARCHAR2
43 , p_validation_level NUMBER
44 , x_return_status out nocopy VARCHAR2
45 , x_msg_count out nocopy NUMBER
46 , x_msg_data out nocopy VARCHAR2
47 , p_mgr_id NUMBER
48 , p_comp_group_id NUMBER
49 , p_mgr_dtl_flag VARCHAR2
50 , p_effective_date date
51 , p11_a0 out nocopy JTF_NUMBER_TABLE
52 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_400
53 , p11_a2 out nocopy JTF_NUMBER_TABLE
54 , p11_a3 out nocopy JTF_NUMBER_TABLE
55 , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
56 , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
57 , p11_a6 out nocopy JTF_NUMBER_TABLE
58 , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
59 , p11_a8 out nocopy JTF_NUMBER_TABLE
60 , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
61 , p11_a10 out nocopy JTF_VARCHAR2_TABLE_100
62 , p11_a11 out nocopy JTF_VARCHAR2_TABLE_100
63 , p11_a12 out nocopy JTF_VARCHAR2_TABLE_100
64 , p11_a13 out nocopy JTF_VARCHAR2_TABLE_100
65 , p11_a14 out nocopy JTF_DATE_TABLE
66 , p11_a15 out nocopy JTF_DATE_TABLE
67 , p11_a16 out nocopy JTF_NUMBER_TABLE
68 , x_total_rows out nocopy NUMBER
69 );
70 procedure get_mo_psum_data(p_api_version NUMBER
71 , p_init_msg_list VARCHAR2
72 , p_commit VARCHAR2
73 , p_validation_level NUMBER
74 , x_return_status out nocopy VARCHAR2
75 , x_msg_count out nocopy NUMBER
76 , x_msg_data out nocopy VARCHAR2
77 , p_mgr_id NUMBER
78 , p_comp_group_id NUMBER
79 , p_mgr_dtl_flag VARCHAR2
80 , p_effective_date date
81 , p_is_multiorg VARCHAR2
82 , p12_a0 out nocopy JTF_NUMBER_TABLE
83 , p12_a1 out nocopy JTF_VARCHAR2_TABLE_400
84 , p12_a2 out nocopy JTF_NUMBER_TABLE
85 , p12_a3 out nocopy JTF_NUMBER_TABLE
86 , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
87 , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
88 , p12_a6 out nocopy JTF_NUMBER_TABLE
89 , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
90 , p12_a8 out nocopy JTF_NUMBER_TABLE
91 , p12_a9 out nocopy JTF_VARCHAR2_TABLE_100
92 , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
93 , p12_a11 out nocopy JTF_VARCHAR2_TABLE_100
94 , p12_a12 out nocopy JTF_VARCHAR2_TABLE_100
95 , p12_a13 out nocopy JTF_VARCHAR2_TABLE_100
96 , p12_a14 out nocopy JTF_DATE_TABLE
97 , p12_a15 out nocopy JTF_DATE_TABLE
98 , p12_a16 out nocopy JTF_NUMBER_TABLE
99 , x_total_rows out nocopy NUMBER
100 );
101 end cn_psum_pvt_w;