[Home] [Help]
PACKAGE: APPS.AR_CM_APPLICATION_PUB
Source
1 Package AR_CM_APPLICATION_PUB AS
2 /* $Header: ARXPCMAS.pls 120.4 2005/12/24 13:19:32 jbeckett 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
85 PROCEDURE Activity_application(
86 -- Standard API parameters.
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 -- Credit Memo application parameters.
95 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE, --this has no default
96 p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
97 p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
98 p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
99 p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
100 p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
101 p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
102 p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
103 -- ******* Global Flexfield parameters *******
104 p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
105 p_comments IN ar_receivable_applications.comments%TYPE DEFAULT NULL,
106 p_chk_approval_limit_flag IN VARCHAR2 DEFAULT 'Y',
107 p_application_ref_type IN OUT NOCOPY
108 ar_receivable_applications.application_ref_type%TYPE,
109 p_application_ref_id IN OUT NOCOPY
110 ar_receivable_applications.application_ref_id%TYPE,
111 p_application_ref_num IN OUT NOCOPY
112 ar_receivable_applications.application_ref_num%TYPE,
113 p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
114 p_called_from IN VARCHAR2 DEFAULT NULL
115 ,p_org_id IN NUMBER DEFAULT NULL
116 ,p_pay_group_lookup_code IN FND_LOOKUPS.lookup_code%TYPE DEFAULT NULL
117 ,p_pay_alone_flag IN VARCHAR2 DEFAULT NULL
118 ,p_payment_method_code IN ap_invoices.payment_method_code%TYPE DEFAULT NULL
119 ,p_payment_reason_code IN ap_invoices.payment_reason_code%TYPE DEFAULT NULL
120 ,p_payment_reason_comments IN ap_invoices.payment_reason_comments%TYPE DEFAULT NULL
121 ,p_delivery_channel_code IN ap_invoices.delivery_channel_code%TYPE DEFAULT NULL
122 ,p_remittance_message1 IN ap_invoices.remittance_message1%TYPE DEFAULT NULL
123 ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE DEFAULT NULL
124 ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE DEFAULT NULL
125 ,p_party_id IN hz_parties.party_id%TYPE DEFAULT NULL
126 ,p_party_site_id IN hz_party_sites.party_site_id%TYPE DEFAULT NULL
127 ,p_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL
128 );
129
130 PROCEDURE Activity_unapplication(
131 -- Standard API parameters.
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
134 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
135 p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
136 x_return_status OUT NOCOPY VARCHAR2 ,
137 x_msg_count OUT NOCOPY NUMBER ,
138 x_msg_data OUT NOCOPY VARCHAR2 ,
139 -- *** Credit Memo Info. parameters *****
140 p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
141 p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
142 p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
143 p_called_from IN VARCHAR2 DEFAULT NULL,
144 p_org_id IN NUMBER DEFAULT NULL
145 );
146
147 END AR_CM_APPLICATION_PUB;