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;
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 */
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 */
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:
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,
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,
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
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: );
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:
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;
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:
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:
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
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,
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,
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
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: );
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 */
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;
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:
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
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,
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,
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
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: );