DBA Data[Home] [Help]

APPS.JG_ZZ_VAT_REP_UTILITY dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 6: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

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;

Line 14: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

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 */

Line 29: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

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 */

Line 35: pv_enable_allocations_flag in jg_zz_vat_rep_entities.enable_allocations_flag%type default null, /* only for final reporting process */

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:

Line 43: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

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,

Line 54: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,

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,

Line 55: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

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

Line 56: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,

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: );

Line 57: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,

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:

Line 64: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,

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;

Line 65: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

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:

Line 66: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,

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:

Line 67: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null

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

Line 73: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,

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,

Line 74: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

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,

Line 75: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type,

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

Line 76: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,

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: );

Line 84: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

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 */

Line 85: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type default null,

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;

Line 86: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,

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:

Line 87: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,

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

Line 93: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,

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,

Line 94: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

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,

Line 95: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,

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

Line 96: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,

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: );