eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JG_ZZ_VAT_REP_UTILITY dependencies on JG_ZZ_VAT_REP_STATUS_S

Line 49: pv_source in jg_zz_vat_rep_status.source%type,

45: pv_tax_registration_number in jg_zz_vat_rep_status.tax_registration_number%type,
46: pv_tax_calendar_name in jg_zz_vat_rep_status.tax_calendar_name%type,
47: pn_tax_calendar_year in jg_zz_vat_rep_status.tax_calendar_year%type,
48: pv_tax_calendar_period in jg_zz_vat_rep_status.tax_calendar_period%type,
49: pv_source in jg_zz_vat_rep_status.source%type,
50: pd_period_start_date in jg_zz_vat_rep_status.period_start_date%type,
51: pd_period_end_date in jg_zz_vat_rep_status.period_end_date%type,
52: pn_mapping_vat_rep_entity_id in jg_zz_vat_rep_status.mapping_vat_rep_entity_id%type
53: )

Line 83: jg_zz_vat_rep_status_s.nextval ,

79: mapping_vat_rep_entity_id /* Revised Approach Change */
80: )
81: values
82: (
83: jg_zz_vat_rep_status_s.nextval ,
84: pn_vat_reporting_entity_id ,
85: pv_tax_registration_number ,
86: pv_tax_calendar_name ,
87: pn_tax_calendar_year ,

Line 113: pv_source in jg_zz_vat_rep_status.source%type,

109: /* =========================== Start of get_last_processed_date ======================= */
110: function get_last_processed_date
111: (
112: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
113: pv_source in jg_zz_vat_rep_status.source%type,
114: pv_process_name in varchar2 /* possible values - SELECTION, ALLOCATION, FINAL REPORTING */
115: )
116: return date is
117:

Line 118: lv_source jg_zz_vat_rep_status.source%type;

114: pv_process_name in varchar2 /* possible values - SELECTION, ALLOCATION, FINAL REPORTING */
115: )
116: return date is
117:
118: lv_source jg_zz_vat_rep_status.source%type;
119: ld_last_processed_date date;
120: ld_last_processed_date_source date;
121:
122: cursor c_get_last_processed_date_src ( pn_vat_reporting_entity_id number, pv_source varchar2, pv_process_name varchar2 ) is

Line 210: pv_source in jg_zz_vat_rep_status.source%type,

206: pv_period_set_name in gl_periods.period_set_name%type,
207: pv_tax_calendar_period in gl_periods.period_name%type,
208: pd_start_date in gl_periods.START_DATE%type,
209: pd_end_date in gl_periods.end_date%type,
210: pv_source in jg_zz_vat_rep_status.source%type,
211: pv_process_name in varchar2, /* possible values - SELECTION, ALLOCATION, FINAL REPORTING */
212: xv_return_status out nocopy varchar2,
213: xv_return_message out nocopy varchar2
214: )

Line 288: pv_source in jg_zz_vat_rep_status.source%type,

284: procedure pre_process_update
285: (
286: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
287: pv_tax_calendar_period in gl_periods.period_name%type,
288: pv_source in jg_zz_vat_rep_status.source%type,
289: pv_process_name in varchar2, /* possible values - SELECTION, ALLOCATION, FINAL REPORTING */
290: xv_return_status out nocopy varchar2, /* Possible Values : E - Error, S - Successful */
291: xv_return_message out nocopy varchar2
292: )

Line 367: pv_source in jg_zz_vat_rep_status.source%type,

363: procedure validate_process_initiation
364: (
365: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
366: pv_tax_calendar_period in gl_periods.period_name%type,
367: pv_source in jg_zz_vat_rep_status.source%type,
368: pv_process_name in varchar2, /* possible values - SELECTION, ALLOCATION, FINAL REPORTING */
369: pv_reallocate_flag in varchar2 default null, /* Valid for allocation only, Possible values Y or N or nul */
370: xn_reporting_status_id_ap out nocopy jg_zz_vat_rep_status.reporting_status_id%type,
371: xn_reporting_status_id_ar out nocopy jg_zz_vat_rep_status.reporting_status_id%type,

Line 378: lv_source jg_zz_vat_rep_status.source%type;

374: xv_return_message out nocopy varchar2
375: )
376: is
377:
378: lv_source jg_zz_vat_rep_status.source%type;
379: ln_reporting_status_id jg_zz_vat_rep_status.reporting_status_id%type;
380: lv_selection_status_flag jg_zz_vat_rep_status.selection_status_flag%type;
381: lv_allocation_status_flag jg_zz_vat_rep_status.allocation_status_flag%type;
382: lv_final_reporting_status_flag jg_zz_vat_rep_status.final_reporting_status_flag%type;

Line 380: lv_selection_status_flag jg_zz_vat_rep_status.selection_status_flag%type;

376: is
377:
378: lv_source jg_zz_vat_rep_status.source%type;
379: ln_reporting_status_id jg_zz_vat_rep_status.reporting_status_id%type;
380: lv_selection_status_flag jg_zz_vat_rep_status.selection_status_flag%type;
381: lv_allocation_status_flag jg_zz_vat_rep_status.allocation_status_flag%type;
382: lv_final_reporting_status_flag jg_zz_vat_rep_status.final_reporting_status_flag%type;
383: ld_period_start_date jg_zz_vat_rep_status.period_start_date%type;
384: ld_period_end_date jg_zz_vat_rep_status.period_end_date%type;

Line 624: if cur_rec_jg_zz_vat_rep_status.selection_status_flag <> fnd_api.g_ret_sts_success then

620:
621: elsif pv_process_name = 'ALLOCATION' then
622:
623: /* Check if selection has already happened successfully */
624: if cur_rec_jg_zz_vat_rep_status.selection_status_flag <> fnd_api.g_ret_sts_success then
625: fnd_message.set_name('JG', 'JG_ZZ_VAT_ERROR_SELECTION');
626: fnd_message.set_token('SOURCE', lv_source);
627: fnd_message.set_token('PROCESS_NAME', pv_process_name);
628: xv_return_message := fnd_message.get;

Line 675: if cur_rec_jg_zz_vat_rep_status.selection_status_flag <> fnd_api.g_ret_sts_success then

671:
672: elsif pv_process_name = 'FINAL REPORTING' then
673:
674: /* Check if selection has already happened successfully */
675: if cur_rec_jg_zz_vat_rep_status.selection_status_flag <> fnd_api.g_ret_sts_success then
676: fnd_message.set_name('JG', 'JG_ZZ_VAT_ERROR_SELECTION');
677: fnd_message.set_token('SOURCE', lv_source);
678: fnd_message.set_token('PROCESS_NAME', pv_process_name);
679: xv_return_message := fnd_message.get;

Line 796: pv_source in jg_zz_vat_rep_status.source%type,

792: procedure post_process_update
793: (
794: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
795: pv_tax_calendar_period in gl_periods.period_name%type,
796: pv_source in jg_zz_vat_rep_status.source%type,
797: pv_process_name in varchar2, /* possible values - SELECTION, ALLOCATION, FINAL REPORTING */
798: pn_process_id in jg_zz_vat_rep_status.selection_process_id%type, /* Process id for SELECTION, ALLOCATION, FINAL REPORTING */
799: pv_process_flag in jg_zz_vat_rep_status.selection_status_flag%type,
800: pv_enable_allocations_flag in jg_zz_vat_rep_entities.enable_allocations_flag%type default null, /* only for final reporting process */

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

794: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
795: pv_tax_calendar_period in gl_periods.period_name%type,
796: pv_source in jg_zz_vat_rep_status.source%type,
797: pv_process_name in varchar2, /* possible values - SELECTION, ALLOCATION, FINAL REPORTING */
798: pn_process_id in jg_zz_vat_rep_status.selection_process_id%type, /* Process id for SELECTION, ALLOCATION, FINAL REPORTING */
799: pv_process_flag in jg_zz_vat_rep_status.selection_status_flag%type,
800: pv_enable_allocations_flag in jg_zz_vat_rep_entities.enable_allocations_flag%type default null, /* only for final reporting process */
801: xv_return_status out nocopy varchar2, /* Possible Values : E - Error, S - Successful */
802: xv_return_message out nocopy varchar2

Line 799: pv_process_flag in jg_zz_vat_rep_status.selection_status_flag%type,

795: pv_tax_calendar_period in gl_periods.period_name%type,
796: pv_source in jg_zz_vat_rep_status.source%type,
797: pv_process_name in varchar2, /* possible values - SELECTION, ALLOCATION, FINAL REPORTING */
798: pn_process_id in jg_zz_vat_rep_status.selection_process_id%type, /* Process id for SELECTION, ALLOCATION, FINAL REPORTING */
799: pv_process_flag in jg_zz_vat_rep_status.selection_status_flag%type,
800: pv_enable_allocations_flag in jg_zz_vat_rep_entities.enable_allocations_flag%type default null, /* only for final reporting process */
801: xv_return_status out nocopy varchar2, /* Possible Values : E - Error, S - Successful */
802: xv_return_message out nocopy varchar2
803: )

Line 878: pv_source in jg_zz_vat_rep_status.source%type,

874: (
875: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
876: pv_tax_calendar_period in gl_periods.period_name%type,
877: pv_tax_calendar_year in number,
878: pv_source in jg_zz_vat_rep_status.source%type,
879: pv_report_name in varchar2,
880: pv_vat_register_id in jg_zz_vat_registers_b.vat_register_id%type DEFAULT NULL
881: ) return varchar2
882: is