[Home] [Help]
PACKAGE: APPS.CN_WKSHT_CT_UP_PUB_W
Source
1 package cn_wksht_ct_up_pub_w AUTHID CURRENT_USER as
2 /* $Header: cnwwkcds.pls 120.0 2005/09/26 15:09:14 fmburu noship $ */
3 procedure apply_payment_plan_upd(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , x_return_status out nocopy VARCHAR2
8 , x_msg_count out nocopy NUMBER
9 , x_msg_data out nocopy VARCHAR2
10 , p_salesrep_id NUMBER
11 , p_srp_pmt_asgn_id NUMBER
12 , p_payrun_id NUMBER
13 , p10_a0 VARCHAR2
14 , p10_a1 VARCHAR2
15 , p10_a2 VARCHAR2
16 , p10_a3 DATE
17 , p10_a4 DATE
18 , p10_a5 NUMBER
19 , p10_a6 NUMBER
20 , p10_a7 NUMBER
21 , p10_a8 VARCHAR2
22 , p10_a9 VARCHAR2
23 , p10_a10 VARCHAR2
24 , p10_a11 VARCHAR2
25 , p10_a12 VARCHAR2
26 , p10_a13 VARCHAR2
27 , p10_a14 VARCHAR2
28 , p10_a15 VARCHAR2
29 , p10_a16 VARCHAR2
30 , p10_a17 VARCHAR2
31 , p10_a18 VARCHAR2
32 , p10_a19 VARCHAR2
33 , p10_a20 VARCHAR2
34 , p10_a21 VARCHAR2
35 , p10_a22 VARCHAR2
36 , p10_a23 VARCHAR2
37 , p11_a0 VARCHAR2
38 , p11_a1 VARCHAR2
39 , p11_a2 VARCHAR2
40 , p11_a3 DATE
41 , p11_a4 DATE
42 , p11_a5 NUMBER
43 , p11_a6 NUMBER
44 , p11_a7 NUMBER
45 , p11_a8 VARCHAR2
46 , p11_a9 VARCHAR2
47 , p11_a10 VARCHAR2
48 , p11_a11 VARCHAR2
49 , p11_a12 VARCHAR2
50 , p11_a13 VARCHAR2
51 , p11_a14 VARCHAR2
52 , p11_a15 VARCHAR2
53 , p11_a16 VARCHAR2
54 , p11_a17 VARCHAR2
55 , p11_a18 VARCHAR2
56 , p11_a19 VARCHAR2
57 , p11_a20 VARCHAR2
58 , p11_a21 VARCHAR2
59 , p11_a22 VARCHAR2
60 , p11_a23 VARCHAR2
61 , x_status out nocopy VARCHAR2
62 , x_loading_status out nocopy VARCHAR2
63 );
64 procedure apply_payment_plan_cre(p_api_version NUMBER
65 , p_init_msg_list VARCHAR2
66 , p_commit VARCHAR2
67 , p_validation_level NUMBER
68 , x_return_status out nocopy VARCHAR2
69 , x_msg_count out nocopy NUMBER
70 , x_msg_data out nocopy VARCHAR2
71 , p_salesrep_id NUMBER
72 , p_srp_pmt_asgn_id NUMBER
73 , p_payrun_id NUMBER
74 , p10_a0 VARCHAR2
75 , p10_a1 VARCHAR2
76 , p10_a2 VARCHAR2
77 , p10_a3 DATE
78 , p10_a4 DATE
79 , p10_a5 NUMBER
80 , p10_a6 NUMBER
81 , p10_a7 NUMBER
82 , p10_a8 VARCHAR2
83 , p10_a9 VARCHAR2
84 , p10_a10 VARCHAR2
85 , p10_a11 VARCHAR2
86 , p10_a12 VARCHAR2
87 , p10_a13 VARCHAR2
88 , p10_a14 VARCHAR2
89 , p10_a15 VARCHAR2
90 , p10_a16 VARCHAR2
91 , p10_a17 VARCHAR2
92 , p10_a18 VARCHAR2
93 , p10_a19 VARCHAR2
94 , p10_a20 VARCHAR2
95 , p10_a21 VARCHAR2
96 , p10_a22 VARCHAR2
97 , p10_a23 VARCHAR2
98 , x_status out nocopy VARCHAR2
99 , x_loading_status out nocopy VARCHAR2
100 );
101 procedure apply_payment_plan_del(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_salesrep_id NUMBER
109 , p_srp_pmt_asgn_id NUMBER
110 , p_payrun_id NUMBER
111 , p10_a0 VARCHAR2
112 , p10_a1 VARCHAR2
113 , p10_a2 VARCHAR2
114 , p10_a3 DATE
115 , p10_a4 DATE
116 , p10_a5 NUMBER
117 , p10_a6 NUMBER
118 , p10_a7 NUMBER
119 , p10_a8 VARCHAR2
120 , p10_a9 VARCHAR2
121 , p10_a10 VARCHAR2
122 , p10_a11 VARCHAR2
123 , p10_a12 VARCHAR2
124 , p10_a13 VARCHAR2
125 , p10_a14 VARCHAR2
126 , p10_a15 VARCHAR2
127 , p10_a16 VARCHAR2
128 , p10_a17 VARCHAR2
129 , p10_a18 VARCHAR2
130 , p10_a19 VARCHAR2
131 , p10_a20 VARCHAR2
132 , p10_a21 VARCHAR2
133 , p10_a22 VARCHAR2
134 , p10_a23 VARCHAR2
135 , x_status out nocopy VARCHAR2
136 , x_loading_status out nocopy VARCHAR2
137 );
138 end cn_wksht_ct_up_pub_w;