1 PACKAGE AR_CM_VAL_PVT AUTHID CURRENT_USER AS
2 /* $Header: ARXVCMES.pls 120.0.12000000.1 2007/02/27 12:07:13 mpsingh noship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_CM_VAL_PVT';
5
6 PROCEDURE default_app_ids(
7 p_cm_customer_trx_id IN OUT NOCOPY NUMBER,
8 p_cm_trx_number IN VARCHAR2,
9 p_inv_customer_trx_id IN OUT NOCOPY NUMBER,
10 p_inv_trx_number IN VARCHAR2,
11 p_inv_customer_trx_line_id IN OUT NOCOPY NUMBER,
12 p_inv_line_number IN NUMBER,
13 p_installment IN OUT NOCOPY NUMBER,
14 p_applied_payment_schedule_id IN NUMBER,
15 p_return_status OUT NOCOPY VARCHAR2 );
16
17
18 PROCEDURE default_app_info(
19 p_cm_customer_trx_id IN NUMBER,
20 p_inv_customer_trx_id IN NUMBER,
21 p_inv_customer_trx_line_id IN NUMBER,
22 p_show_closed_invoices IN VARCHAR2,
23 p_installment IN OUT NOCOPY NUMBER,
24 p_apply_date IN OUT NOCOPY DATE,
25 p_apply_gl_date IN OUT NOCOPY DATE,
26 p_amount_applied IN OUT NOCOPY NUMBER,
27 p_applied_payment_schedule_id IN OUT NOCOPY NUMBER,
28 p_cm_gl_date OUT NOCOPY DATE,
29 p_cm_trx_date OUT NOCOPY DATE,
30 p_cm_amount_rem OUT NOCOPY NUMBER,
31 p_cm_currency_code OUT NOCOPY VARCHAR2,
32 p_inv_due_date OUT NOCOPY DATE,
33 p_inv_currency_code OUT NOCOPY VARCHAR2,
34 p_inv_amount_rem OUT NOCOPY NUMBER,
35 p_inv_trx_date OUT NOCOPY DATE,
36 p_inv_gl_date OUT NOCOPY DATE,
37 p_allow_overappln_flag OUT NOCOPY VARCHAR2,
38 p_natural_appln_only_flag OUT NOCOPY VARCHAR2,
39 p_creation_sign OUT NOCOPY VARCHAR2,
40 p_cm_payment_schedule_id OUT NOCOPY NUMBER,
41 p_inv_line_amount OUT NOCOPY NUMBER,
42 p_return_status OUT NOCOPY VARCHAR2
43 );
44
45 PROCEDURE validate_app_info(
46 p_apply_date IN DATE,
47 p_cm_trx_date IN DATE,
48 p_inv_trx_date IN DATE,
49 p_apply_gl_date IN DATE,
50 p_cm_gl_date IN DATE,
51 p_inv_gl_date IN DATE,
52 p_amount_applied IN NUMBER,
53 p_applied_payment_schedule_id IN NUMBER,
54 p_customer_trx_line_id IN NUMBER,
55 p_inv_line_amount IN NUMBER,
56 p_creation_sign IN VARCHAR2,
57 p_allow_overappln_flag IN VARCHAR2,
58 p_natural_appln_only_flag IN VARCHAR2,
59 p_cm_amount_rem IN NUMBER,
60 p_inv_amount_rem IN NUMBER,
61 p_cm_currency_code IN VARCHAR2,
62 p_inv_currency_code IN VARCHAR2,
63 p_return_status OUT NOCOPY VARCHAR2
64 ) ;
65
66 PROCEDURE Default_unapp_ids(
67 p_cm_trx_number IN VARCHAR2,
68 p_cm_customer_trx_id IN OUT NOCOPY NUMBER,
69 p_inv_trx_number IN VARCHAR2,
70 p_inv_customer_trx_id IN OUT NOCOPY NUMBER,
71 p_receivable_application_id IN OUT NOCOPY NUMBER,
72 p_installment IN NUMBER,
73 p_applied_payment_schedule_id IN OUT NOCOPY NUMBER,
74 p_apply_gl_date OUT NOCOPY DATE,
75 p_return_status OUT NOCOPY VARCHAR2
76 );
77
78 PROCEDURE Default_unapp_info(
79 p_receivable_application_id IN NUMBER,
80 p_apply_gl_date IN DATE,
81 p_cm_customer_trx_id IN NUMBER,
82 p_reversal_gl_date IN OUT NOCOPY DATE,
83 p_cm_gl_date OUT NOCOPY DATE
84 );
85
86 PROCEDURE Validate_unapp_info(
87 p_cm_gl_date IN DATE,
88 p_receivable_application_id IN NUMBER,
89 p_reversal_gl_date IN DATE,
90 p_apply_gl_date IN DATE,
91 p_return_status OUT NOCOPY VARCHAR2
92 );
93
94
95 END AR_CM_VAL_PVT;