[Home] [Help]
PACKAGE: APPS.AR_CM_API_PUB
Source
1 PACKAGE AR_CM_API_PUB AS
2 /* $Header: ARXPCMES.pls 120.0.12000000.1 2007/02/27 12:05:41 mpsingh noship $ */
3 /*#
4 * Credit Memo APIs allow users to apply on account credit memo
5 * against a debit memo or invoice using simple calls to PL/SQL functions.
6 */
7
8 TYPE G_cm_app_rec_type IS RECORD(
9 cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE ,
10 cm_trx_number ra_customer_trx.trx_number%TYPE ,
11 inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE ,
12 inv_trx_number ra_customer_trx.trx_number%TYPE ,
13 installment ar_payment_schedules.terms_sequence_number%TYPE ,
14 applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE ,
15 amount_applied ar_receivable_applications.amount_applied%TYPE ,
16 inv_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE ,
17 inv_line_number ra_customer_trx_lines.line_number%TYPE );
18
19 TYPE G_cm_unapp_rec_type IS RECORD
20 (cm_trx_number ra_customer_trx.trx_number%TYPE,
21 cm_customer_trx_id ar_receivable_applications.customer_trx_id%TYPE,
22 inv_trx_number ra_customer_trx.trx_number%TYPE,
23 inv_customer_trx_id ar_receivable_applications.customer_trx_id%TYPE,
24 applied_ps_id ar_receivable_applications.applied_payment_schedule_id%TYPE,
25 receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
26
27
28 original_cm_app_info G_cm_app_rec_type;
29 original_cm_unapp_info G_cm_unapp_rec_type;
30
31 TYPE cm_app_rec_type IS RECORD (
32 cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
33 cm_trx_number ra_customer_trx.trx_number%TYPE,
34 inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
35 inv_trx_number ra_customer_trx.trx_number%TYPE,
36 installment NUMBER(15),
37 applied_payment_schedule_id NUMBER(15),
38 amount_applied ar_receivable_applications.amount_applied%TYPE,
39 apply_date ar_receivable_applications.apply_date%TYPE,
40 gl_date ar_receivable_applications.gl_date%TYPE,
41 inv_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE ,
42 inv_line_number ra_customer_trx_lines.line_number%TYPE ,
43 show_closed_invoices VARCHAR2(1),
44 ussgl_transaction_code ar_receivable_applications.ussgl_transaction_code%TYPE ,
45 attribute_category ar_receivable_applications.attribute_category%TYPE ,
46 attribute1 ar_receivable_applications.attribute1%TYPE ,
47 attribute2 ar_receivable_applications.attribute2%TYPE ,
48 attribute3 ar_receivable_applications.attribute3%TYPE ,
49 attribute4 ar_receivable_applications.attribute4%TYPE ,
50 attribute5 ar_receivable_applications.attribute5%TYPE ,
51 attribute6 ar_receivable_applications.attribute6%TYPE ,
52 attribute7 ar_receivable_applications.attribute7%TYPE ,
53 attribute8 ar_receivable_applications.attribute8%TYPE ,
54 attribute9 ar_receivable_applications.attribute9%TYPE ,
55 attribute10 ar_receivable_applications.attribute10%TYPE ,
56 attribute11 ar_receivable_applications.attribute11%TYPE ,
57 attribute12 ar_receivable_applications.attribute12%TYPE ,
58 attribute13 ar_receivable_applications.attribute13%TYPE ,
59 attribute14 ar_receivable_applications.attribute14%TYPE ,
60 attribute15 ar_receivable_applications.attribute15%TYPE ,
61 global_attribute_category ar_receivable_applications.global_attribute_category%TYPE ,
62 global_attribute1 ar_receivable_applications.global_attribute1%TYPE ,
63 global_attribute2 ar_receivable_applications.global_attribute2%TYPE ,
64 global_attribute3 ar_receivable_applications.global_attribute3%TYPE ,
65 global_attribute4 ar_receivable_applications.global_attribute4%TYPE ,
66 global_attribute5 ar_receivable_applications.global_attribute5%TYPE ,
67 global_attribute6 ar_receivable_applications.global_attribute6%TYPE ,
68 global_attribute7 ar_receivable_applications.global_attribute7%TYPE ,
69 global_attribute8 ar_receivable_applications.global_attribute8%TYPE ,
70 global_attribute9 ar_receivable_applications.global_attribute9%TYPE ,
71 global_attribute10 ar_receivable_applications.global_attribute10%TYPE ,
72 global_attribute11 ar_receivable_applications.global_attribute11%TYPE ,
73 global_attribute12 ar_receivable_applications.global_attribute12%TYPE ,
74 global_attribute13 ar_receivable_applications.global_attribute13%TYPE ,
75 global_attribute14 ar_receivable_applications.global_attribute14%TYPE ,
76 global_attribute15 ar_receivable_applications.global_attribute15%TYPE ,
77 global_attribute16 ar_receivable_applications.global_attribute16%TYPE ,
78 global_attribute17 ar_receivable_applications.global_attribute17%TYPE ,
79 global_attribute18 ar_receivable_applications.global_attribute18%TYPE ,
80 global_attribute19 ar_receivable_applications.global_attribute19%TYPE ,
81 global_attribute20 ar_receivable_applications.global_attribute20%TYPE ,
82 comments ar_receivable_applications.comments%TYPE,
83 called_from VARCHAR2(20) );
84
85 TYPE cm_unapp_rec_type IS RECORD (
86 cm_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
87 cm_trx_number ra_customer_trx.trx_number%TYPE,
88 inv_customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
89 inv_trx_number ra_customer_trx.trx_number%TYPE,
90 installment NUMBER(15),
91 applied_payment_schedule_id NUMBER(15),
92 receivable_application_id NUMBER(15),
93 reversal_gl_date DATE,
94 called_from VARCHAR2(20));
95
96 PROCEDURE apply_on_account(
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
99 p_commit IN VARCHAR2 := FND_API.G_FALSE,
100 p_cm_app_rec IN cm_app_rec_type,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 x_out_rec_application_id OUT NOCOPY NUMBER,
105 x_acctd_amount_applied_from OUT NOCOPY ar_receivable_applications.acctd_amount_applied_from%TYPE,
106 x_acctd_amount_applied_to OUT NOCOPY ar_receivable_applications.acctd_amount_applied_to%TYPE);
107
108 PROCEDURE unapply_on_account(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111 p_commit IN VARCHAR2 := FND_API.G_FALSE,
112 p_cm_unapp_rec IN cm_unapp_rec_type,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2);
116
117 END AR_CM_API_PUB;