[Home] [Help]
PACKAGE: APPS.AR_CM_APPLICATION_PUB
Source
1 Package AR_CM_APPLICATION_PUB AUTHID CURRENT_USER AS
2 /* $Header: ARXPCMAS.pls 120.5.12020000.2 2012/10/07 05:40:32 aghoraka ship $ */
3
4 --Start of comments
5 --API name : Credit Memo Application API
6 --Type : Public.
7 --Function : Apply and unapply credit memos
8 --Pre-reqs :
9 --
10 -- Notes :
11 --
12 -- Modification History
13 -- Date Name Description
14 -- 26-JAN-2005 J Beckett Created.
15 -- End of comments
16
17 TYPE attribute_rec_type IS RECORD(
18 attribute_category VARCHAR2(30) DEFAULT NULL,
19 attribute1 VARCHAR2(150) DEFAULT NULL,
20 attribute2 VARCHAR2(150) DEFAULT NULL,
21 attribute3 VARCHAR2(150) DEFAULT NULL,
22 attribute4 VARCHAR2(150) DEFAULT NULL,
23 attribute5 VARCHAR2(150) DEFAULT NULL,
24 attribute6 VARCHAR2(150) DEFAULT NULL,
25 attribute7 VARCHAR2(150) DEFAULT NULL,
26 attribute8 VARCHAR2(150) DEFAULT NULL,
27 attribute9 VARCHAR2(150) DEFAULT NULL,
28 attribute10 VARCHAR2(150) DEFAULT NULL,
29 attribute11 VARCHAR2(150) DEFAULT NULL,
30 attribute12 VARCHAR2(150) DEFAULT NULL,
31 attribute13 VARCHAR2(150) DEFAULT NULL,
32 attribute14 VARCHAR2(150) DEFAULT NULL,
33 attribute15 VARCHAR2(150) DEFAULT NULL);
34
35 TYPE global_attribute_rec_type IS RECORD(
36 global_attribute_category VARCHAR2(30) default null,
37 global_attribute1 VARCHAR2(150) default NULL,
38 global_attribute2 VARCHAR2(150) DEFAULT NULL,
39 global_attribute3 VARCHAR2(150) DEFAULT NULL,
40 global_attribute4 VARCHAR2(150) DEFAULT NULL,
41 global_attribute5 VARCHAR2(150) DEFAULT NULL,
42 global_attribute6 VARCHAR2(150) DEFAULT NULL,
43 global_attribute7 VARCHAR2(150) DEFAULT NULL,
44 global_attribute8 VARCHAR2(150) DEFAULT NULL,
45 global_attribute9 VARCHAR2(150) DEFAULT NULL,
46 global_attribute10 VARCHAR2(150) DEFAULT NULL,
47 global_attribute11 VARCHAR2(150) DEFAULT NULL,
48 global_attribute12 VARCHAR2(150) DEFAULT NULL,
49 global_attribute13 VARCHAR2(150) DEFAULT NULL,
50 global_attribute14 VARCHAR2(150) DEFAULT NULL,
51 global_attribute15 VARCHAR2(150) DEFAULT NULL,
52 global_attribute16 VARCHAR2(150) DEFAULT NULL,
53 global_attribute17 VARCHAR2(150) DEFAULT NULL,
54 global_attribute18 VARCHAR2(150) DEFAULT NULL,
55 global_attribute19 VARCHAR2(150) DEFAULT NULL,
56 global_attribute20 VARCHAR2(150) DEFAULT NULL);
57
58 TYPE global_attribute_rec_type_upd IS RECORD(
59 global_attribute_category VARCHAR2(30) default FND_API.G_MISS_CHAR,
60 global_attribute1 VARCHAR2(150) default FND_API.G_MISS_CHAR,
61 global_attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62 global_attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63 global_attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64 global_attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65 global_attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66 global_attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67 global_attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68 global_attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69 global_attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70 global_attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71 global_attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72 global_attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73 global_attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74 global_attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75 global_attribute16 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76 global_attribute17 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77 global_attribute18 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
78 global_attribute19 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
79 global_attribute20 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR);
80
81 attribute_rec_const attribute_rec_type;
82 global_attribute_rec_const global_attribute_rec_type;
83
84 PROCEDURE Activity_application(
85 -- Standard API parameters.
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
88 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2,
93 -- Credit Memo application parameters.
94 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE, --this has no default
95 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
96 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
97 p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
98 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
99 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
100 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
101 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
102 -- ******* Global Flexfield parameters *******
103 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
104 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
105 p_chk_approval_limit_flag IN VARCHAR2 DEFAULT 'Y',
106 p_application_ref_type IN OUT NOCOPY
107 ar_receivable_applications.application_ref_type%TYPE,
108 p_application_ref_id IN OUT NOCOPY
109 ar_receivable_applications.application_ref_id%TYPE,
110 p_application_ref_num IN OUT NOCOPY
111 ar_receivable_applications.application_ref_num%TYPE,
112 p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
113 p_called_from IN VARCHAR2 DEFAULT NULL
114 ,p_org_id IN NUMBER DEFAULT NULL
115 ,p_pay_group_lookup_code IN FND_LOOKUPS.lookup_code%TYPE DEFAULT NULL
116 ,p_pay_alone_flag IN VARCHAR2 DEFAULT NULL
117 ,p_payment_method_code IN ap_invoices.payment_method_code%TYPE DEFAULT NULL
118 ,p_payment_reason_code IN ap_invoices.payment_reason_code%TYPE DEFAULT NULL
119 ,p_payment_reason_comments IN ap_invoices.payment_reason_comments%TYPE DEFAULT NULL
120 ,p_delivery_channel_code IN ap_invoices.delivery_channel_code%TYPE DEFAULT NULL
121 ,p_remittance_message1 IN ap_invoices.remittance_message1%TYPE DEFAULT NULL
122 ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE DEFAULT NULL
123 ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE DEFAULT NULL
124 ,p_party_id IN hz_parties.party_id%TYPE DEFAULT NULL
125 ,p_party_site_id IN hz_party_sites.party_site_id%TYPE DEFAULT NULL
126 ,p_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL
127 ,p_payment_priority IN ap_invoices_interface.PAYMENT_PRIORITY%TYPE DEFAULT NULL --Bug8290172
128 ,p_terms_id IN ap_invoices_interface.TERMS_ID%TYPE DEFAULT NULL --Bug8290172
129 );
130
131 PROCEDURE Activity_unapplication(
132 -- Standard API parameters.
133 p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
135 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
136 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
137 x_return_status OUT NOCOPY VARCHAR2 ,
138 x_msg_count OUT NOCOPY NUMBER ,
139 x_msg_data OUT NOCOPY VARCHAR2 ,
140 -- *** Credit Memo Info. parameters *****
141 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
142 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
143 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
144 p_called_from IN VARCHAR2 DEFAULT NULL,
145 p_org_id IN NUMBER DEFAULT NULL
146 );
147
148 PROCEDURE unapply_regular_cm(
149 -- Standard API parameters.
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152 p_commit IN VARCHAR2 := FND_API.G_FALSE,
153 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154 x_return_status OUT NOCOPY VARCHAR2 ,
155 x_msg_count OUT NOCOPY NUMBER ,
156 x_msg_data OUT NOCOPY VARCHAR2 ,
157 -- *** Credit Memo Info. parameters *****
158 p_cm_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
159 p_cm_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
160 p_app_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
161 p_app_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
162 p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
163 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
164 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
165 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
166 p_called_from IN VARCHAR2 DEFAULT NULL,
167 p_org_id IN NUMBER DEFAULT NULL
168 );
169
170 END AR_CM_APPLICATION_PUB;