1: package body ari_process_validate_w as
2: /* $Header: ARI_PROCESS_VALIDATE_PUBJ_B.pls 120.0 2011/07/29 06:51:50 mbolli noship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy ari_process_validate.payment_schedule_tbl, a0 JTF_NUMBER_TABLE) as
4: ddindx binary_integer; indx binary_integer;
5: begin
6: if a0 is not null and a0.count > 0 then
7: if a0.count > 0 then
17: end loop;
18: end if;
19: end if;
20: end rosetta_table_copy_in_p0;
21: procedure rosetta_table_copy_out_p0(t ari_process_validate.payment_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
22: ddindx binary_integer; indx binary_integer;
23: begin
24: if t is null or t.count = 0 then
25: a0 := JTF_NUMBER_TABLE();
21: procedure rosetta_table_copy_out_p0(t ari_process_validate.payment_schedule_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
22: ddindx binary_integer; indx binary_integer;
23: begin
24: if t is null or t.count = 0 then
25: a0 := JTF_NUMBER_TABLE();
26: else
27: a0 := JTF_NUMBER_TABLE();
28: if t.count > 0 then
29: a0.extend(t.count);
23: begin
24: if t is null or t.count = 0 then
25: a0 := JTF_NUMBER_TABLE();
26: else
27: a0 := JTF_NUMBER_TABLE();
28: if t.count > 0 then
29: a0.extend(t.count);
30: ddindx := t.first;
31: indx := 1;
84:
85: procedure validate_dispute(p_cust_account_id NUMBER
86: , p_cust_site_use_id NUMBER
87: , p_session_id NUMBER
88: , p_payment_schedule_tbl JTF_NUMBER_TABLE
89: , p_trx_number_tbl JTF_VARCHAR2_TABLE_200
90: , x_fail_payment_schedule_tbl out nocopy JTF_NUMBER_TABLE
91: , x_return_status out nocopy VARCHAR2
92: , x_msg_count out nocopy NUMBER
86: , p_cust_site_use_id NUMBER
87: , p_session_id NUMBER
88: , p_payment_schedule_tbl JTF_NUMBER_TABLE
89: , p_trx_number_tbl JTF_VARCHAR2_TABLE_200
90: , x_fail_payment_schedule_tbl out nocopy JTF_NUMBER_TABLE
91: , x_return_status out nocopy VARCHAR2
92: , x_msg_count out nocopy NUMBER
93: , x_msg_data out nocopy VARCHAR2
94: )
137:
138: procedure validate_payment(p_cust_account_id NUMBER
139: , p_cust_site_use_id NUMBER
140: , p_session_id NUMBER
141: , p_payment_schedule_tbl JTF_NUMBER_TABLE
142: , p_trx_number_tbl JTF_VARCHAR2_TABLE_200
143: , x_fail_payment_schedule_tbl out nocopy JTF_NUMBER_TABLE
144: , x_return_status out nocopy VARCHAR2
145: , x_msg_count out nocopy NUMBER
139: , p_cust_site_use_id NUMBER
140: , p_session_id NUMBER
141: , p_payment_schedule_tbl JTF_NUMBER_TABLE
142: , p_trx_number_tbl JTF_VARCHAR2_TABLE_200
143: , x_fail_payment_schedule_tbl out nocopy JTF_NUMBER_TABLE
144: , x_return_status out nocopy VARCHAR2
145: , x_msg_count out nocopy NUMBER
146: , x_msg_data out nocopy VARCHAR2
147: )
190:
191: procedure validate_print(p_cust_account_id NUMBER
192: , p_cust_site_use_id NUMBER
193: , p_session_id NUMBER
194: , p_payment_schedule_tbl JTF_NUMBER_TABLE
195: , p_trx_number_tbl JTF_VARCHAR2_TABLE_200
196: , x_fail_payment_schedule_tbl out nocopy JTF_NUMBER_TABLE
197: , x_return_status out nocopy VARCHAR2
198: , x_msg_count out nocopy NUMBER
192: , p_cust_site_use_id NUMBER
193: , p_session_id NUMBER
194: , p_payment_schedule_tbl JTF_NUMBER_TABLE
195: , p_trx_number_tbl JTF_VARCHAR2_TABLE_200
196: , x_fail_payment_schedule_tbl out nocopy JTF_NUMBER_TABLE
197: , x_return_status out nocopy VARCHAR2
198: , x_msg_count out nocopy NUMBER
199: , x_msg_data out nocopy VARCHAR2
200: )