1 PACKAGE JERX_TO AUTHID CURRENT_USER AS
2 /* $Header: jegrtos.pls 120.2 2006/04/07 11:02:09 samalhot ship $ */
3
4 --
5 -- Main Core Report Specification for AR Turnover Extract Procedure.
6 --
7
8 PROCEDURE JE_AR_TURNOVER_EXTRACT(
9 errbuf OUT NOCOPY VARCHAR2,
10 retcode OUT NOCOPY NUMBER,
11 p_app_short_name in varchar2,
12 p_set_of_books_id in varchar2,
13 p_period_start_date in varchar2,
14 p_period_end_date in varchar2,
15 p_range_type in varchar2,
16 p_cs_name_from in varchar2,
17 p_cs_name_to in varchar2,
18 p_cs_number_from in varchar2,
19 p_cs_number_to in varchar2,
20 p_currency_code in varchar2,
21 p_rule_id in varchar2,
22 p_inv_amount_limit in varchar2,
23 p_balance_type in varchar2,
24 p_request_id in number,
25 p_legal_entity_id in number);
26
27 --
28 -- Main Core Report Specification for AP Turnover Extract Procedure.
29 --
30 PROCEDURE JE_AP_TURNOVER_EXTRACT(
31 errbuf OUT NOCOPY VARCHAR2,
32 retcode OUT NOCOPY NUMBER,
33 p_app_short_name in varchar2,
34 p_set_of_books_id in varchar2,
35 p_period_start_date in varchar2,
36 p_period_end_date in varchar2,
37 p_range_type in varchar2,
38 p_cs_name_from in varchar2,
39 p_cs_name_to in varchar2,
40 p_cs_number_from in varchar2,
41 p_cs_number_to in varchar2,
42 p_currency_code in varchar2,
43 p_rule_id in varchar2,
44 p_inv_amount_limit in varchar2,
45 p_balance_type in varchar2,
46 p_request_id in number,
47 p_legal_entity_id in number);
48
49 --
50 -- Main Core Report Specification for Generic Insert Into the Interface Table Procedure.
51 --
52 PROCEDURE GENERIC_INSERT_TO_ITF(
53 errbuf OUT NOCOPY VARCHAR2,
54 retcode OUT NOCOPY NUMBER,
55 p_request_id in number,
56 p_cust_sup_name in varchar2,
57 p_cust_sup_number in varchar2,
58 p_tax_payer_id in varchar2,
59 p_vat_registration_number in varchar2,
60 p_supplier_site_code in varchar2,
61 p_profession in varchar2,
62 p_address_line1 in varchar2,
63 p_address_line2 in varchar2,
64 p_address_line3 in varchar2,
65 p_city in varchar2,
66 p_state in varchar2,
67 p_zip in varchar2,
68 p_province in varchar2,
69 p_country in varchar2,
70 p_inv_trx_number in varchar2,
71 p_inv_trx_id in number,
72 p_inv_trx_date in date,
73 p_inv_trx_currency_code in varchar2,
74 p_inv_trx_amount in number,
75 p_inv_trx_type in varchar2,
76 p_acctd_inv_trx_amount in number,
77 p_cust_sup_type_code in varchar2,
78 p_created_by in number,
79 p_creation_date in date,
80 p_last_update_date in date,
81 p_last_updated_by in number,
82 p_last_update_login in number);
83
84 END JERX_TO;