1 PACKAGE JG_AR_RECEIVABLE_APPLICATIONS as
2 /* $Header: jgzzrras.pls 120.7 2005/08/25 23:36:00 cleyvaol ship $ */
3
4 /*----------------------------------------------------------------------------*
5 | PUBLIC FUNCTIONS/PROCEDURES |
6 *----------------------------------------------------------------------------*/
7
8 Type gdf_rec is Record (
9 global_attribute1 VARCHAR2(150),
10 global_attribute2 VARCHAR2(150),
11 global_attribute3 VARCHAR2(150),
12 global_attribute4 VARCHAR2(150),
13 global_attribute5 VARCHAR2(150),
14 global_attribute6 VARCHAR2(150),
15 global_attribute7 VARCHAR2(150),
16 global_attribute8 VARCHAR2(150),
17 global_attribute9 VARCHAR2(150),
18 global_attribute10 VARCHAR2(150),
19 global_attribute11 VARCHAR2(150),
20 global_attribute12 VARCHAR2(150),
21 global_attribute13 VARCHAR2(150),
22 global_attribute14 VARCHAR2(150),
23 global_attribute15 VARCHAR2(150),
24 global_attribute16 VARCHAR2(150),
25 global_attribute17 VARCHAR2(150),
26 global_attribute18 VARCHAR2(150),
27 global_attribute19 VARCHAR2(150),
28 global_attribute20 VARCHAR2(150),
29 global_attribute_category VARCHAR2(150)
30 );
31
32 PROCEDURE Apply(p_apply_before_after IN VARCHAR2 ,
33 p_global_attribute_category IN OUT NOCOPY VARCHAR2 ,
34 p_set_of_books_id IN NUMBER ,
35 p_cash_receipt_id IN VARCHAR2 ,
36 p_receipt_date IN DATE ,
37 p_applied_payment_schedule_id IN NUMBER ,
38 p_amount_applied IN NUMBER ,
39 p_unapplied_amount IN NUMBER ,
40 p_due_date IN DATE ,
41 p_receipt_method_id IN NUMBER ,
42 p_remittance_bank_account_id IN NUMBER ,
43 p_global_attribute1 IN OUT NOCOPY VARCHAR2 ,
44 p_global_attribute2 IN OUT NOCOPY VARCHAR2 ,
45 p_global_attribute3 IN OUT NOCOPY VARCHAR2 ,
46 p_global_attribute4 IN OUT NOCOPY VARCHAR2 ,
47 p_global_attribute5 IN OUT NOCOPY VARCHAR2 ,
48 p_global_attribute6 IN OUT NOCOPY VARCHAR2 ,
49 p_global_attribute7 IN OUT NOCOPY VARCHAR2 ,
50 p_global_attribute8 IN OUT NOCOPY VARCHAR2 ,
51 p_global_attribute9 IN OUT NOCOPY VARCHAR2 ,
52 p_global_attribute10 IN OUT NOCOPY VARCHAR2 ,
53 p_global_attribute11 IN OUT NOCOPY VARCHAR2 ,
54 p_global_attribute12 IN OUT NOCOPY VARCHAR2 ,
55 p_global_attribute13 IN OUT NOCOPY VARCHAR2 ,
56 p_global_attribute14 IN OUT NOCOPY VARCHAR2 ,
57 p_global_attribute15 IN OUT NOCOPY VARCHAR2 ,
58 p_global_attribute16 IN OUT NOCOPY VARCHAR2 ,
59 p_global_attribute17 IN OUT NOCOPY VARCHAR2 ,
60 p_global_attribute18 IN OUT NOCOPY VARCHAR2 ,
61 p_global_attribute19 IN OUT NOCOPY VARCHAR2 ,
62 p_global_attribute20 IN OUT NOCOPY VARCHAR2 ,
63 p_return_status OUT NOCOPY VARCHAR2);
64
65 PROCEDURE Unapply(
66 p_cash_receipt_id IN VARCHAR2 ,
67 p_applied_payment_schedule_id IN NUMBER ,
68 p_return_status OUT NOCOPY VARCHAR2);
69
70
71 PROCEDURE create_interest_adjustment(
72 p_post_quickcash_req_id IN NUMBER,
73 x_return_status OUT NOCOPY VARCHAR2);
74
75 PROCEDURE delete_interest_adjustment(
76 p_cash_receipt_id IN NUMBER,
77 x_return_status OUT NOCOPY VARCHAR2);
78
79 END JG_AR_RECEIVABLE_APPLICATIONS;