eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AR_CM_API_PUB

Source


1 PACKAGE AR_CM_API_PUB AUTHID CURRENT_USER AS
2 /* $Header: ARXPCMES.pls 120.0.12010000.2 2008/12/20 11:31:18 dgaurab ship $ */
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 ,
59         attribute14 ar_receivable_applications.attribute14%TYPE ,
56         attribute11 ar_receivable_applications.attribute11%TYPE ,
57         attribute12 ar_receivable_applications.attribute12%TYPE ,
58         attribute13 ar_receivable_applications.attribute13%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       p_org_id           IN   NUMBER  DEFAULT NULL);
108 
109 PROCEDURE unapply_on_account(
113       p_cm_unapp_rec     IN  cm_unapp_rec_type,
110       p_api_version      IN  NUMBER,
111       p_init_msg_list    IN  VARCHAR2 := FND_API.G_FALSE,
112       p_commit           IN  VARCHAR2 := FND_API.G_FALSE,
114       x_return_status    OUT NOCOPY VARCHAR2,
115       x_msg_count        OUT NOCOPY NUMBER,
116       x_msg_data         OUT NOCOPY VARCHAR2,
117       p_org_id           IN   NUMBER  DEFAULT NULL);
118 
119 END AR_CM_API_PUB;