1 PACKAGE ar_late_charge_pkg AUTHID CURRENT_USER AS
2 /* $Header: ARLCDOCS.pls 120.5 2011/05/25 09:26:13 naneja ship $ */
3 TYPE t_ar_lookups_desc_table IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
4
5 pg_ar_lookups_desc_rec t_ar_lookups_desc_table;
6
7 g_invoice_api_called_from_lc varchar2(1) := 'N';
8
9 FUNCTION get_lookup_desc (p_lookup_type IN VARCHAR2,
10 p_lookup_code IN VARCHAR2)
11 RETURN VARCHAR2;
12
13
14 FUNCTION phrase
15 (p_type IN VARCHAR2,
16 p_class IN VARCHAR2,
17 p_trx_number IN VARCHAR2,
18 p_receipt_number IN VARCHAR2,
19 p_due_date IN DATE,
20 p_outstanding_amt IN NUMBER,
21 p_payment_date IN DATE,
22 p_days_overdue_late IN NUMBER,
23 p_last_charge_date IN DATE,
24 p_interest_rate IN NUMBER,
25 p_calculate_interest_to_date IN DATE)
26 RETURN VARCHAR2;
27
28
29 PROCEDURE empty_var_iv;
30
31 PROCEDURE inv_to_inv_api_interface
32 (p_gl_date IN DATE,
33 p_cal_int_date IN DATE,
34 p_batch_id IN NUMBER);
35
36 PROCEDURE call_invoice_api
37 ( x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2);
40
41 PROCEDURE create_charge_inv_dm
42 ( p_batch_source_id IN NUMBER,
43 p_batch_id IN NUMBER,
44 p_worker_num IN NUMBER DEFAULT NULL,
45 p_gl_date IN DATE DEFAULT NULL,
46 p_cal_int_date IN DATE DEFAULT NULL,
47 p_api_bulk_size IN NUMBER DEFAULT NULL,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2);
51
52
53 PROCEDURE create_charge_adj
54 ( p_batch_id IN NUMBER,
55 p_worker_num IN NUMBER DEFAULT NULL,
56 p_gl_date IN DATE DEFAULT NULL,
57 p_cal_int_date IN DATE DEFAULT NULL,
58 p_api_bulk_size IN NUMBER DEFAULT NULL,
59 x_num_adj_created OUT NOCOPY NUMBER,
60 x_num_adj_error OUT NOCOPY NUMBER,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2);
64
65
66
67 PROCEDURE create_late_charge_child
68 (errbuf OUT NOCOPY VARCHAR2,
69 retcode OUT NOCOPY VARCHAR2,
70 p_batch_source_id IN NUMBER,
71 p_batch_id IN NUMBER,
72 p_gl_date IN DATE,
73 p_cal_int_date IN DATE,
74 p_api_bulk_size IN NUMBER);
75
76
77 PROCEDURE submit_late_charge_child
78 (p_batch_id IN NUMBER,
79 p_batch_source_id IN NUMBER,
80 p_gl_date IN DATE,
81 p_cal_int_date IN DATE,
82 p_api_bulk_size IN NUMBER,
83 x_out_request_id OUT NOCOPY NUMBER);
84
85
86 PROCEDURE wait_for_end_subreq(
87 p_interval IN NUMBER DEFAULT 60
88 ,p_max_wait IN NUMBER DEFAULT 180
89 ,p_sub_name IN VARCHAR2);
90
91
92 PROCEDURE get_status_for_sub_process
93 (p_sub_name IN VARCHAR2,
94 x_status OUT NOCOPY VARCHAR2);
95
96
97 PROCEDURE create_late_charge
98 (errbuf OUT NOCOPY VARCHAR2,
99 retcode OUT NOCOPY VARCHAR2,
100 p_max_workers IN NUMBER DEFAULT 4,
101 p_interval IN NUMBER DEFAULT 60,
102 p_max_wait IN NUMBER DEFAULT 180,
103 p_api_bulk_size IN NUMBER DEFAULT 1000,
104 p_batch_source_id IN NUMBER,
105 p_batch_id IN NUMBER );
106
107 --Late Charge per worker
108 PROCEDURE create_late_charge_per_worker
109 ( errbuf OUT NOCOPY VARCHAR2,
110 retcode OUT NOCOPY VARCHAR2,
111 p_batch_source_id IN NUMBER,
112 p_batch_id IN NUMBER,
113 p_worker_num IN NUMBER,
114 p_gl_date IN DATE,
115 p_cal_int_date IN DATE,
116 p_api_bulk_size IN NUMBER);
117
118
119 PROCEDURE ordonancer_per_worker
120 ( p_worker_num IN NUMBER,
121 p_request_id IN NUMBER);
122
123 PROCEDURE create_late_charge_by_worker
124 (errbuf OUT NOCOPY VARCHAR2,
125 retcode OUT NOCOPY VARCHAR2,
126 p_max_workers IN NUMBER DEFAULT 4,
127 p_interval IN NUMBER DEFAULT 60,
128 p_max_wait IN NUMBER DEFAULT 180,
129 p_api_bulk_size IN NUMBER DEFAULT 9000,
130 p_batch_source_id IN NUMBER,
131 p_batch_id IN NUMBER );
132
133 PROCEDURE submit_late_charge_worker
134 (p_batch_id IN NUMBER,
135 p_batch_source_id IN NUMBER,
136 p_gl_date IN DATE,
137 p_cal_int_date IN DATE,
138 p_api_bulk_size IN NUMBER,
139 p_worker_num IN NUMBER,
140 x_out_request_id OUT NOCOPY NUMBER);
141
142 END;