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