1 PACKAGE ARP_PROCESS_APPLICATION2 AS
2 /* $Header: ARCEAP2S.pls 120.2 2003/02/28 20:48:51 jbeckett ship $ */
3
4 FUNCTION revision RETURN VARCHAR2;
5
6 PROCEDURE update_application(
7 p_ra_id IN NUMBER,
8 p_receipt_ps_id IN NUMBER,
9 p_invoice_ps_id IN NUMBER,
10 p_ussgl_transaction_code IN VARCHAR2,
11 p_application_ref_type IN
12 ar_receivable_applications.application_ref_type%TYPE,
13 p_application_ref_id IN
14 ar_receivable_applications.application_ref_id%TYPE,
15 p_application_ref_num IN
16 ar_receivable_applications.application_ref_num%TYPE,
17 p_secondary_application_ref_id IN
18 ar_receivable_applications.secondary_application_ref_id%TYPE DEFAULT NULL,
19 p_receivable_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
20 p_attribute_category IN VARCHAR2,
21 p_attribute1 IN VARCHAR2,
22 p_attribute2 IN VARCHAR2,
23 p_attribute3 IN VARCHAR2,
24 p_attribute4 IN VARCHAR2,
25 p_attribute5 IN VARCHAR2,
26 p_attribute6 IN VARCHAR2,
27 p_attribute7 IN VARCHAR2,
28 p_attribute8 IN VARCHAR2,
29 p_attribute9 IN VARCHAR2,
30 p_attribute10 IN VARCHAR2,
31 p_attribute11 IN VARCHAR2,
32 p_attribute12 IN VARCHAR2,
33 p_attribute13 IN VARCHAR2,
34 p_attribute14 IN VARCHAR2,
35 p_attribute15 IN VARCHAR2,
36 p_global_attribute_category IN VARCHAR2,
37 p_global_attribute1 IN VARCHAR2,
38 p_global_attribute2 IN VARCHAR2,
39 p_global_attribute3 IN VARCHAR2,
40 p_global_attribute4 IN VARCHAR2,
41 p_global_attribute5 IN VARCHAR2,
42 p_global_attribute6 IN VARCHAR2,
43 p_global_attribute7 IN VARCHAR2,
44 p_global_attribute8 IN VARCHAR2,
45 p_global_attribute9 IN VARCHAR2,
46 p_global_attribute10 IN VARCHAR2,
47 p_global_attribute11 IN VARCHAR2,
48 p_global_attribute12 IN VARCHAR2,
49 p_global_attribute13 IN VARCHAR2,
50 p_global_attribute14 IN VARCHAR2,
51 p_global_attribute15 IN VARCHAR2,
52 p_global_attribute16 IN VARCHAR2,
53 p_global_attribute17 IN VARCHAR2,
54 p_global_attribute18 IN VARCHAR2,
55 p_global_attribute19 IN VARCHAR2,
56 p_global_attribute20 IN VARCHAR2,
57 p_comments IN VARCHAR2, -- Added for bug 1839744
58 p_gl_date OUT NOCOPY DATE,
59 p_customer_trx_line_id IN NUMBER,
60 p_module_name IN VARCHAR2,
61 p_module_version IN VARCHAR2,
62 x_application_ref_id OUT NOCOPY
63 ar_receivable_applications.application_ref_id%TYPE,
64 x_application_ref_num OUT NOCOPY
65 ar_receivable_applications.application_ref_num%TYPE,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 p_acctd_amount_applied_to OUT NOCOPY NUMBER,
70 p_acctd_amount_applied_from OUT NOCOPY NUMBER,
71 p_amount_due_remaining IN ar_payment_schedules.amount_due_remaining%TYPE DEFAULT NULL,
72 p_application_ref_reason IN ar_receivable_applications.application_ref_reason%TYPE DEFAULT NULL,
73 p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
74 p_customer_reason IN ar_receivable_applications.customer_reason%TYPE DEFAULT NULL,
75 p_applied_rec_app_id IN ar_receivable_applications.applied_rec_app_id%TYPE,
76 x_claim_reason_name OUT NOCOPY VARCHAR2);
77
78 PROCEDURE delete_selected_transaction(
79 p_ra_id IN NUMBER
80 , p_app_ps_id IN NUMBER);
81
82 END arp_process_application2;