[Home] [Help]
PACKAGE: APPS.ARP_CTLS_PKG
Source
1 PACKAGE ARP_CTLS_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARTITLSS.pls 120.6.12010000.1 2008/07/24 16:57:04 appldev ship $ */
3
4 PROCEDURE select_summary(p_customer_trx_id IN number,
5 p_customer_trx_line_id IN number,
6 p_mode IN varchar2,
7 p_amount_total IN OUT NOCOPY number,
8 p_amount_total_rtot_db IN OUT NOCOPY number,
9 p_percent_total IN OUT NOCOPY number,
10 p_percent_total_rtot_db IN OUT NOCOPY number );
11
12 PROCEDURE display_salescredit( p_cust_trx_line_salesrep_id IN
13 ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
14
15 PROCEDURE display_salescredit_rec( p_srep_rec IN
16 ra_cust_trx_line_salesreps%rowtype);
17
18 PROCEDURE display_salescredit_f_ctl_id( p_customer_trx_line_id IN
19 ra_customer_trx_lines.customer_trx_line_id%type);
20
21 PROCEDURE set_to_dummy( p_srep_rec OUT NOCOPY ra_cust_trx_line_salesreps%rowtype);
22
23 FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN number;
24
25 PROCEDURE lock_p( p_cust_trx_line_salesrep_id
26 IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
27
28 PROCEDURE lock_f_ct_id( p_customer_trx_id
29 IN ra_customer_trx.customer_trx_id%type );
30
31 PROCEDURE lock_f_ctl_id( p_customer_trx_line_id
32 IN ra_customer_trx_lines.customer_trx_line_id%type);
33
34 PROCEDURE lock_fetch_p( p_srep_rec IN OUT NOCOPY ra_cust_trx_line_salesreps%rowtype,
35 p_cust_trx_line_salesrep_id IN
36 ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
37
38 PROCEDURE lock_compare_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
39 p_cust_trx_line_salesrep_id IN
40 ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
41 p_ignore_who_flag BOOLEAN DEFAULT FALSE);
42
43 PROCEDURE fetch_p( p_srep_rec OUT NOCOPY ra_cust_trx_line_salesreps%rowtype,
44 p_cust_trx_line_salesrep_id IN
45 ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
46
47 procedure delete_p( p_cust_trx_line_salesrep_id
48 IN ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
49 p_customer_trx_line_id
50 IN ra_customer_trx_lines.customer_trx_line_id%type );
51
52 procedure delete_f_ct_id( p_customer_trx_id
53 IN ra_customer_trx.customer_trx_id%type,
54 p_delete_default_recs_flag IN boolean DEFAULT TRUE);
55
56 procedure delete_f_ctl_id( p_customer_trx_line_id
57 IN ra_customer_trx_lines.customer_trx_line_id%type);
58
59 PROCEDURE update_p( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
60 p_cust_trx_line_salesrep_id IN
61 ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type);
62
63 PROCEDURE update_f_ct_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
64 p_customer_trx_id IN ra_customer_trx.customer_trx_id%type);
65
66 PROCEDURE update_f_ctl_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
67 p_customer_trx_line_id IN
68 ra_customer_trx_lines.customer_trx_line_id%type);
69
70 PROCEDURE update_f_psr_id( p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
71 p_prev_cust_trx_line_srep_id
72 ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type);
73
74 PROCEDURE update_amounts_f_ctl_id(
75 p_customer_trx_line_id IN
76 ra_customer_trx_lines.customer_trx_line_id%type,
77 p_line_amount IN
78 ra_customer_trx_lines.extended_amount%type,
79 p_foreign_currency_code IN
80 fnd_currencies.currency_code%type);
81
82 PROCEDURE insert_p(
83 p_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
84 p_cust_trx_line_salesrep_id
85 OUT NOCOPY ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type
86 );
87
88 PROCEDURE insert_f_ct_ctl_id(
89 p_customer_trx_id IN
90 ra_customer_trx_lines.customer_trx_id%type,
91 p_customer_trx_line_id IN
92 ra_customer_trx_lines.customer_trx_line_id%type
93 );
94
95 PROCEDURE insert_f_cm_ct_ctl_id(
96 p_customer_trx_id IN
97 ra_customer_trx.customer_trx_id%type,
98 p_customer_trx_line_id IN
99 ra_customer_trx_lines.customer_trx_line_id%type,
100 p_currency_code IN fnd_currencies.currency_code%type
101 );
102 PROCEDURE insert_f_cmn_ct_ctl_id(
103 p_customer_trx_id IN
104 ra_customer_trx.customer_trx_id%type,
105 p_customer_trx_line_id IN
106 ra_customer_trx_lines.customer_trx_line_id%type
107 );
108 PROCEDURE merge_srep_recs(
109 p_old_srep_rec IN ra_cust_trx_line_salesreps%rowtype,
110 p_new_srep_rec IN
111 ra_cust_trx_line_salesreps%rowtype,
112 p_out_srep_rec IN OUT NOCOPY
113 ra_cust_trx_line_salesreps%rowtype);
114
115 PROCEDURE erase_foreign_key_references( p_cust_trx_line_salesrep_id IN
116 ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
117 p_customer_trx_id IN
118 ra_customer_trx.customer_trx_id%type,
119 p_customer_trx_line_id IN
120 ra_customer_trx_lines.customer_trx_line_id%type);
121
122 PROCEDURE lock_compare_cover(
123 p_cust_trx_line_salesrep_id IN
124 ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type,
125 p_customer_trx_id IN
126 ra_cust_trx_line_salesreps.customer_trx_id%type,
127 p_customer_trx_line_id IN
128 ra_cust_trx_line_salesreps.customer_trx_line_id%type,
129 p_salesrep_id IN
130 ra_cust_trx_line_salesreps.salesrep_id%type,
131 p_revenue_amount_split IN
132 ra_cust_trx_line_salesreps.revenue_amount_split%type,
133 p_non_revenue_amount_split IN
134 ra_cust_trx_line_salesreps.non_revenue_amount_split%type,
135 p_non_revenue_percent_split IN
136 ra_cust_trx_line_salesreps.non_revenue_percent_split%type,
137 p_revenue_percent_split IN
138 ra_cust_trx_line_salesreps.revenue_percent_split%type,
139 p_prev_cust_trx_line_srep_id IN
140 ra_cust_trx_line_salesreps.prev_cust_trx_line_salesrep_id%type,
141 p_attribute_category IN
142 ra_cust_trx_line_salesreps.attribute_category%type,
143 p_attribute1 IN
144 ra_cust_trx_line_salesreps.attribute1%type,
145 p_attribute2 IN
146 ra_cust_trx_line_salesreps.attribute2%type,
147 p_attribute3 IN
148 ra_cust_trx_line_salesreps.attribute3%type,
149 p_attribute4 IN
150 ra_cust_trx_line_salesreps.attribute4%type,
151 p_attribute5 IN
152 ra_cust_trx_line_salesreps.attribute5%type,
153 p_attribute6 IN
154 ra_cust_trx_line_salesreps.attribute6%type,
155 p_attribute7 IN
156 ra_cust_trx_line_salesreps.attribute7%type,
157 p_attribute8 IN
158 ra_cust_trx_line_salesreps.attribute8%type,
159 p_attribute9 IN
160 ra_cust_trx_line_salesreps.attribute9%type,
161 p_attribute10 IN
162 ra_cust_trx_line_salesreps.attribute10%type,
163 p_attribute11 IN
164 ra_cust_trx_line_salesreps.attribute11%type,
165 p_attribute12 IN
166 ra_cust_trx_line_salesreps.attribute12%type,
167 p_attribute13 IN
168 ra_cust_trx_line_salesreps.attribute13%type,
169 p_attribute14 IN
170 ra_cust_trx_line_salesreps.attribute14%type,
171 p_attribute15 IN
172 ra_cust_trx_line_salesreps.attribute15%type,
173 p_revenue_salesgroup_id IN
174 ra_cust_trx_line_salesreps.revenue_salesgroup_id%type DEFAULT null,
175 p_non_revenue_salesgroup_id IN
176 ra_cust_trx_line_salesreps.non_revenue_salesgroup_id%type DEFAULT null);
177
178 PROCEDURE init;
179
180 END ARP_CTLS_PKG;