DBA Data[Home] [Help]

APPS.JG_ZZ_VAT_REP_UTILITY dependencies on JG_ZZ_VAT_REP_STATUS

Line 7: pv_source in jg_zz_vat_rep_status.source%type,

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:

Line 16: pv_source in jg_zz_vat_rep_status.source%type,

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,

Line 19: xn_reporting_status_id_ap out nocopy jg_zz_vat_rep_status.reporting_status_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

Line 20: xn_reporting_status_id_ar out nocopy jg_zz_vat_rep_status.reporting_status_id%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: );

Line 21: xn_reporting_status_id_gl out nocopy jg_zz_vat_rep_status.reporting_status_id%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:

Line 31: pv_source in jg_zz_vat_rep_status.source%type,

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

Line 33: pn_process_id in jg_zz_vat_rep_status.selection_process_id%type, /* Process id for SELECTION, ALLOCATION, FINAL REPORTING */

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

Line 34: pv_process_flag in jg_zz_vat_rep_status.selection_status_flag%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: );

Line 46: pv_source in jg_zz_vat_rep_status.source%type,

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: