1: package iby_disburse_ui_api_pub_pkg_w as
2: /* $Header: ibydapiws.pls 120.4 2006/08/29 22:03:48 rameshsh noship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy iby_disburse_ui_api_pub_pkg.docpayidtab, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p0(t iby_disburse_ui_api_pub_pkg.docpayidtab, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy iby_disburse_ui_api_pub_pkg.docpaystatustab, a0 JTF_VARCHAR2_TABLE_100);
7: procedure rosetta_table_copy_out_p1(t iby_disburse_ui_api_pub_pkg.docpaystatustab, a0 out nocopy JTF_VARCHAR2_TABLE_100);
1: package iby_disburse_ui_api_pub_pkg_w as
2: /* $Header: ibydapiws.pls 120.4 2006/08/29 22:03:48 rameshsh noship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy iby_disburse_ui_api_pub_pkg.docpayidtab, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p0(t iby_disburse_ui_api_pub_pkg.docpayidtab, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy iby_disburse_ui_api_pub_pkg.docpaystatustab, a0 JTF_VARCHAR2_TABLE_100);
7: procedure rosetta_table_copy_out_p1(t iby_disburse_ui_api_pub_pkg.docpaystatustab, a0 out nocopy JTF_VARCHAR2_TABLE_100);
8:
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy iby_disburse_ui_api_pub_pkg.docpaystatustab, a0 JTF_VARCHAR2_TABLE_100);
7: procedure rosetta_table_copy_out_p1(t iby_disburse_ui_api_pub_pkg.docpaystatustab, a0 out nocopy JTF_VARCHAR2_TABLE_100);
8:
9: procedure rosetta_table_copy_in_p2(t out nocopy iby_disburse_ui_api_pub_pkg.pmtidtab, a0 JTF_NUMBER_TABLE);
10: procedure rosetta_table_copy_out_p2(t iby_disburse_ui_api_pub_pkg.pmtidtab, a0 out nocopy JTF_NUMBER_TABLE);
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy iby_disburse_ui_api_pub_pkg.pmtstatustab, a0 JTF_VARCHAR2_TABLE_100);
13: procedure rosetta_table_copy_out_p3(t iby_disburse_ui_api_pub_pkg.pmtstatustab, a0 out nocopy JTF_VARCHAR2_TABLE_100);
6: procedure rosetta_table_copy_in_p1(t out nocopy iby_disburse_ui_api_pub_pkg.docpaystatustab, a0 JTF_VARCHAR2_TABLE_100);
7: procedure rosetta_table_copy_out_p1(t iby_disburse_ui_api_pub_pkg.docpaystatustab, a0 out nocopy JTF_VARCHAR2_TABLE_100);
8:
9: procedure rosetta_table_copy_in_p2(t out nocopy iby_disburse_ui_api_pub_pkg.pmtidtab, a0 JTF_NUMBER_TABLE);
10: procedure rosetta_table_copy_out_p2(t iby_disburse_ui_api_pub_pkg.pmtidtab, a0 out nocopy JTF_NUMBER_TABLE);
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy iby_disburse_ui_api_pub_pkg.pmtstatustab, a0 JTF_VARCHAR2_TABLE_100);
13: procedure rosetta_table_copy_out_p3(t iby_disburse_ui_api_pub_pkg.pmtstatustab, a0 out nocopy JTF_VARCHAR2_TABLE_100);
14:
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy iby_disburse_ui_api_pub_pkg.pmtstatustab, a0 JTF_VARCHAR2_TABLE_100);
13: procedure rosetta_table_copy_out_p3(t iby_disburse_ui_api_pub_pkg.pmtstatustab, a0 out nocopy JTF_VARCHAR2_TABLE_100);
14:
15: procedure rosetta_table_copy_in_p4(t out nocopy iby_disburse_ui_api_pub_pkg.pmtdocstab, a0 JTF_NUMBER_TABLE);
16: procedure rosetta_table_copy_out_p4(t iby_disburse_ui_api_pub_pkg.pmtdocstab, a0 out nocopy JTF_NUMBER_TABLE);
17:
18: procedure rosetta_table_copy_in_p5(t out nocopy iby_disburse_ui_api_pub_pkg.paperdocnumtab, a0 JTF_NUMBER_TABLE);
19: procedure rosetta_table_copy_out_p5(t iby_disburse_ui_api_pub_pkg.paperdocnumtab, a0 out nocopy JTF_NUMBER_TABLE);
12: procedure rosetta_table_copy_in_p3(t out nocopy iby_disburse_ui_api_pub_pkg.pmtstatustab, a0 JTF_VARCHAR2_TABLE_100);
13: procedure rosetta_table_copy_out_p3(t iby_disburse_ui_api_pub_pkg.pmtstatustab, a0 out nocopy JTF_VARCHAR2_TABLE_100);
14:
15: procedure rosetta_table_copy_in_p4(t out nocopy iby_disburse_ui_api_pub_pkg.pmtdocstab, a0 JTF_NUMBER_TABLE);
16: procedure rosetta_table_copy_out_p4(t iby_disburse_ui_api_pub_pkg.pmtdocstab, a0 out nocopy JTF_NUMBER_TABLE);
17:
18: procedure rosetta_table_copy_in_p5(t out nocopy iby_disburse_ui_api_pub_pkg.paperdocnumtab, a0 JTF_NUMBER_TABLE);
19: procedure rosetta_table_copy_out_p5(t iby_disburse_ui_api_pub_pkg.paperdocnumtab, a0 out nocopy JTF_NUMBER_TABLE);
20:
14:
15: procedure rosetta_table_copy_in_p4(t out nocopy iby_disburse_ui_api_pub_pkg.pmtdocstab, a0 JTF_NUMBER_TABLE);
16: procedure rosetta_table_copy_out_p4(t iby_disburse_ui_api_pub_pkg.pmtdocstab, a0 out nocopy JTF_NUMBER_TABLE);
17:
18: procedure rosetta_table_copy_in_p5(t out nocopy iby_disburse_ui_api_pub_pkg.paperdocnumtab, a0 JTF_NUMBER_TABLE);
19: procedure rosetta_table_copy_out_p5(t iby_disburse_ui_api_pub_pkg.paperdocnumtab, a0 out nocopy JTF_NUMBER_TABLE);
20:
21: procedure rosetta_table_copy_in_p6(t out nocopy iby_disburse_ui_api_pub_pkg.paperdocusereasontab, a0 JTF_VARCHAR2_TABLE_100);
22: procedure rosetta_table_copy_out_p6(t iby_disburse_ui_api_pub_pkg.paperdocusereasontab, a0 out nocopy JTF_VARCHAR2_TABLE_100);
15: procedure rosetta_table_copy_in_p4(t out nocopy iby_disburse_ui_api_pub_pkg.pmtdocstab, a0 JTF_NUMBER_TABLE);
16: procedure rosetta_table_copy_out_p4(t iby_disburse_ui_api_pub_pkg.pmtdocstab, a0 out nocopy JTF_NUMBER_TABLE);
17:
18: procedure rosetta_table_copy_in_p5(t out nocopy iby_disburse_ui_api_pub_pkg.paperdocnumtab, a0 JTF_NUMBER_TABLE);
19: procedure rosetta_table_copy_out_p5(t iby_disburse_ui_api_pub_pkg.paperdocnumtab, a0 out nocopy JTF_NUMBER_TABLE);
20:
21: procedure rosetta_table_copy_in_p6(t out nocopy iby_disburse_ui_api_pub_pkg.paperdocusereasontab, a0 JTF_VARCHAR2_TABLE_100);
22: procedure rosetta_table_copy_out_p6(t iby_disburse_ui_api_pub_pkg.paperdocusereasontab, a0 out nocopy JTF_VARCHAR2_TABLE_100);
23:
23:
24: procedure rosetta_table_copy_in_p7(t out nocopy iby_disburse_ui_api_pub_pkg.appnamestab, a0 JTF_VARCHAR2_TABLE_100);
25: procedure rosetta_table_copy_out_p7(t iby_disburse_ui_api_pub_pkg.appnamestab, a0 out nocopy JTF_VARCHAR2_TABLE_100);
26:
27: procedure rosetta_table_copy_in_p8(t out nocopy iby_disburse_ui_api_pub_pkg.appidstab, a0 JTF_NUMBER_TABLE);
28: procedure rosetta_table_copy_out_p8(t iby_disburse_ui_api_pub_pkg.appidstab, a0 out nocopy JTF_NUMBER_TABLE);
29:
30: procedure remove_documents_payable(p_doc_list JTF_NUMBER_TABLE
31: , p_doc_status_list JTF_VARCHAR2_TABLE_100
24: procedure rosetta_table_copy_in_p7(t out nocopy iby_disburse_ui_api_pub_pkg.appnamestab, a0 JTF_VARCHAR2_TABLE_100);
25: procedure rosetta_table_copy_out_p7(t iby_disburse_ui_api_pub_pkg.appnamestab, a0 out nocopy JTF_VARCHAR2_TABLE_100);
26:
27: procedure rosetta_table_copy_in_p8(t out nocopy iby_disburse_ui_api_pub_pkg.appidstab, a0 JTF_NUMBER_TABLE);
28: procedure rosetta_table_copy_out_p8(t iby_disburse_ui_api_pub_pkg.appidstab, a0 out nocopy JTF_NUMBER_TABLE);
29:
30: procedure remove_documents_payable(p_doc_list JTF_NUMBER_TABLE
31: , p_doc_status_list JTF_VARCHAR2_TABLE_100
32: , x_return_status out nocopy VARCHAR2
26:
27: procedure rosetta_table_copy_in_p8(t out nocopy iby_disburse_ui_api_pub_pkg.appidstab, a0 JTF_NUMBER_TABLE);
28: procedure rosetta_table_copy_out_p8(t iby_disburse_ui_api_pub_pkg.appidstab, a0 out nocopy JTF_NUMBER_TABLE);
29:
30: procedure remove_documents_payable(p_doc_list JTF_NUMBER_TABLE
31: , p_doc_status_list JTF_VARCHAR2_TABLE_100
32: , x_return_status out nocopy VARCHAR2
33: );
34: procedure remove_payments(p_pmt_list JTF_NUMBER_TABLE
30: procedure remove_documents_payable(p_doc_list JTF_NUMBER_TABLE
31: , p_doc_status_list JTF_VARCHAR2_TABLE_100
32: , x_return_status out nocopy VARCHAR2
33: );
34: procedure remove_payments(p_pmt_list JTF_NUMBER_TABLE
35: , p_pmt_status_list JTF_VARCHAR2_TABLE_100
36: , x_return_status out nocopy VARCHAR2
37: );
38: procedure stop_payments(p_pmt_list JTF_NUMBER_TABLE
34: procedure remove_payments(p_pmt_list JTF_NUMBER_TABLE
35: , p_pmt_status_list JTF_VARCHAR2_TABLE_100
36: , x_return_status out nocopy VARCHAR2
37: );
38: procedure stop_payments(p_pmt_list JTF_NUMBER_TABLE
39: , p_pmt_status_list JTF_VARCHAR2_TABLE_100
40: , x_return_status out nocopy VARCHAR2
41: );
42: procedure reprint_prenum_pmt_documents(p_instr_id NUMBER
40: , x_return_status out nocopy VARCHAR2
41: );
42: procedure reprint_prenum_pmt_documents(p_instr_id NUMBER
43: , p_pmt_doc_id NUMBER
44: , p_pmt_list JTF_NUMBER_TABLE
45: , p_new_ppr_docs_list JTF_NUMBER_TABLE
46: , p_old_ppr_docs_list JTF_NUMBER_TABLE
47: , p_printer_name VARCHAR2
48: , x_return_status out nocopy VARCHAR2
41: );
42: procedure reprint_prenum_pmt_documents(p_instr_id NUMBER
43: , p_pmt_doc_id NUMBER
44: , p_pmt_list JTF_NUMBER_TABLE
45: , p_new_ppr_docs_list JTF_NUMBER_TABLE
46: , p_old_ppr_docs_list JTF_NUMBER_TABLE
47: , p_printer_name VARCHAR2
48: , x_return_status out nocopy VARCHAR2
49: );
42: procedure reprint_prenum_pmt_documents(p_instr_id NUMBER
43: , p_pmt_doc_id NUMBER
44: , p_pmt_list JTF_NUMBER_TABLE
45: , p_new_ppr_docs_list JTF_NUMBER_TABLE
46: , p_old_ppr_docs_list JTF_NUMBER_TABLE
47: , p_printer_name VARCHAR2
48: , x_return_status out nocopy VARCHAR2
49: );
50: procedure reprint_blank_pmt_documents(p_instr_id NUMBER
47: , p_printer_name VARCHAR2
48: , x_return_status out nocopy VARCHAR2
49: );
50: procedure reprint_blank_pmt_documents(p_instr_id NUMBER
51: , p_pmt_list JTF_NUMBER_TABLE
52: , p_printer_name VARCHAR2
53: , x_return_status out nocopy VARCHAR2
54: );
55: procedure finalize_print_status(p_instr_id NUMBER
53: , x_return_status out nocopy VARCHAR2
54: );
55: procedure finalize_print_status(p_instr_id NUMBER
56: , p_pmt_doc_id NUMBER
57: , p_used_docs_list JTF_NUMBER_TABLE
58: , x_return_status out nocopy VARCHAR2
59: );
60: procedure finalize_print_status(p_instr_id NUMBER
61: , p_pmt_doc_id NUMBER
58: , x_return_status out nocopy VARCHAR2
59: );
60: procedure finalize_print_status(p_instr_id NUMBER
61: , p_pmt_doc_id NUMBER
62: , p_used_docs_list JTF_NUMBER_TABLE
63: , p_submit_postive_pay number
64: , x_return_status out nocopy VARCHAR2
65: );
66: procedure finalize_instr_print_status(p_instr_id NUMBER