[Home] [Help]
PACKAGE: APPS.JE_IT_INVOICES_ABOVE_THRESHOLD
Source
1 PACKAGE JE_IT_INVOICES_ABOVE_THRESHOLD AUTHID CURRENT_USER AS
2 /* $Header: jeitiats.pls 120.1.12020000.2 2012/07/17 09:51:49 rshergil noship $ */
3
4 --Global variable required for report. To store parameters
5 g_vat_reporting_entity_id NUMBER(15);
6 g_set_of_books_id NUMBER(15);
7 g_org_id NUMBER(15);
8 g_legal_entity_id NUMBER(15);
9 g_year NUMBER(10);
10 g_type_of_upload NUMBER(1);
11 g_transmission_code NUMBER(15);
12 g_protocol_num NUMBER(6);
13 g_province_code VARCHAR2(3);
14 g_decl_inc_company NUMBER;
15 g_inv_acctg_status VARCHAR2(20);
16 g_end_date_for_cm_dm DATE;
17 g_b2b_threshold NUMBER(15);
18 g_b2c_threshold NUMBER(15);
19 g_b2c_trx_start_date DATE;
20 g_max_no_of_records NUMBER(5);
21 g_gen_eft_report VARCHAR2(1);
22 g_start_date DATE;
23 g_end_date DATE;
24 g_currency_code VARCHAR2(5);
25 g_default_prod_clas VARCHAR2(20);
26 g_default_payment_mode VARCHAR2(2);
27 -- g_prev_year_name VARCHAR2(20);
28
29 g_conc_request_id NUMBER(15);
30 g_created_by NUMBER(15);
31 g_creation_date DATE;
32 g_last_updated_by NUMBER(15);
33 g_last_update_date DATE;
34 g_last_update_login NUMBER(15);
35
36 -- Globals for log
37
38 g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
39 g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40 g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
41 g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
42 g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
43 g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
44 g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
45 g_error_buffer VARCHAR2(100);
46 g_debug_flag VARCHAR2(1);
47 g_pkg_name CONSTANT VARCHAR2(30) := 'JE_IT_INVOICES_ABOVE_THRESHOLD';
48 g_module_name CONSTANT VARCHAR2(30) := 'JE_IT_INVOICES_ABOVE_THRESHOLD';
49 g_errbuf VARCHAR2(2000);
50 g_retcode NUMBER;
51
52 -- parameters of EFT.
53
54 p_year_of_declaration VARCHAR2(10);
55 p_vat_reporting_entity_id NUMBER(15);
56 p_type_of_upload VARCHAR2(10);
57 p_report_mode VARCHAR2(10);
58 p_conc_request_id NUMBER(15); -- bug 14063111
59 p_progression_num NUMBER(3);
60 g_table_schema VARCHAR2(10);
61 Procedure Extract_Data (
62 errbuf Out Nocopy Varchar2,
63 retcode Out Nocopy Number,
64 p_vat_reporting_entity_id IN NUMBER,
65 p_year IN NUMBER,
66 p_type_of_upload IN VARCHAR2,
67 p_type_of_upload_dummy IN VARCHAR2,
68 p_transmission_code IN NUMBER,
69 p_protocol_num IN NUMBER,
70 p_province_code IN VARCHAR2,
71 p_decl_inc_company IN VARCHAR2,
72 p_inv_acctg_status IN VARCHAR2,
73 p_end_date_for_cm_dm IN VARCHAR2,
74 p_b2c_threshold IN NUMBER,
75 p_b2b_threshold IN NUMBER,
76 p_b2c_trx_start_date IN VARCHAR2,
77 p_max_no_of_records IN NUMBER,
78 p_gen_eft_report IN VARCHAR2);
79
80
81 FUNCTION generate_next_eft (p_year VARCHAR2,
82 p_vat_reporting_entity_id NUMBER,
83 p_type_of_upload NUMBER,
84 p_concurrent_request_id NUMBER,
85 p_report_mode VARCHAR2,
86 p_progression_number NUMBER) RETURN BOOLEAN;
87
88 FUNCTION is_cm_dm_line_consistent( p_application_id NUMBER,
89 p_parent_trx_id VARCHAR2,
90 p_line_type VARCHAR2,
91 p_below_threshold VARCHAR2,
92 p_report_exclusion VARCHAR2,
93 p_contract_ident VARCHAR2,
94 p_payment_mode VARCHAR2) RETURN VARCHAR2;
95
96 FUNCTION get_orig_trx_id( p_cust_trx_id NUMBER,
97 p_parent_trx_id NUMBER) RETURN NUMBER;
98
99 END JE_IT_INVOICES_ABOVE_THRESHOLD;