[Home] [Help]
PACKAGE: APPS.JG_ZZ_VAT_REP_UTILITY
Source
1 package jg_zz_vat_rep_utility as
2 /* $Header: jgzzvatreputil_s.pls 120.3 2006/12/29 07:06:57 rjreddy ship $*/
3
4 function get_last_processed_date
5 (
6 pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
7 pv_source in jg_zz_vat_rep_status.source%type,
8 pv_process_name in varchar2 /* possible values - SELECTION, ALLOCATION, FINAL REPORTING */
9 )
10 return date;
11
12 procedure validate_process_initiation
13 (
14 pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
15 pv_tax_calendar_period in gl_periods.period_name%type,
16 pv_source in jg_zz_vat_rep_status.source%type,
17 pv_process_name in varchar2, /* possible values - SELECTION, ALLOCATION, FINAL REPORTING */
18 pv_reallocate_flag in varchar2 default null, /* Valid for allocation only, Possible values Y or N or nul */
19 xn_reporting_status_id_ap out nocopy jg_zz_vat_rep_status.reporting_status_id%type,
20 xn_reporting_status_id_ar out nocopy jg_zz_vat_rep_status.reporting_status_id%type,
21 xn_reporting_status_id_gl out nocopy jg_zz_vat_rep_status.reporting_status_id%type,
22 xv_return_status out nocopy varchar2,
23 xv_return_message out nocopy varchar2
24 );
25
26
27 procedure post_process_update
28 (
29 pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
30 pv_tax_calendar_period in gl_periods.period_name%type,
31 pv_source in jg_zz_vat_rep_status.source%type,
32 pv_process_name in varchar2, /* possible values - SELECTION, ALLOCATION, FINAL REPORTING */
33 pn_process_id in jg_zz_vat_rep_status.selection_process_id%type, /* Process id for SELECTION, ALLOCATION, FINAL REPORTING */
34 pv_process_flag in jg_zz_vat_rep_status.selection_status_flag%type,
35 pv_enable_allocations_flag in jg_zz_vat_rep_entities.enable_allocations_flag%type default null, /* only for final reporting process */
36 xv_return_status out nocopy varchar2,
37 xv_return_message out nocopy varchar2
38 );
39
40
41 function get_period_status
42 (
43 pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
44 pv_tax_calendar_period in gl_periods.period_name%type,
45 pv_tax_calendar_year in number,
46 pv_source in jg_zz_vat_rep_status.source%type,
47 pv_report_name in varchar2,
48 pv_vat_register_id in jg_zz_vat_registers_b.vat_register_id%type DEFAULT NULL
49 ) return varchar2;
50
51
52 procedure validate_entity_attributes
53 (
54 pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
55 pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
56 pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
57 pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
58 xv_return_status out nocopy varchar2,
59 xv_return_message out nocopy varchar2
60 );
61
62 function get_accounting_entity
63 (
64 pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
65 pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
66 pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
67 pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null
68 ) return number;
69
70
71 procedure create_accounting_entity
72 (
73 pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
74 pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
75 pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type,
76 pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
77 xn_vat_reporting_entity_id out nocopy number,
78 xv_return_status out nocopy varchar2,
79 xv_return_message out nocopy varchar2
80 );
81
82 function get_reporting_identifier
83 (
84 pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
85 pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type default null,
86 pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
87 pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
88 pv_called_from in varchar2 /* possible values - PARAMETER_FORM or TABLE_HANDLER */
89 ) return varchar2;
90
91 procedure maintain_selection_entities
92 (
93 pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
94 pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
95 pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
96 pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
97 xn_vat_reporting_entity_id out nocopy number,
98 xv_return_status out nocopy varchar2,
99 xv_return_message out nocopy varchar2
100 );
101
102 end jg_zz_vat_rep_utility;