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 GL_PERIODS

Line 206: pv_period_set_name in gl_periods.period_set_name%type,

202:
203: procedure check_gap_in_process_period
204: (
205: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%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,

Line 207: pv_tax_calendar_period in gl_periods.period_name%type,

203: procedure check_gap_in_process_period
204: (
205: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%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 */

Line 208: pd_start_date in gl_periods.START_DATE%type,

204: (
205: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%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,

Line 209: pd_end_date in gl_periods.end_date%type,

205: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%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

Line 223: gl_periods

219: cursor c_get_first_period_start_date(pv_period_set_name varchar2, pv_tax_calendar_period varchar2) is
220: select
221: min(start_date)
222: from
223: gl_periods
224: where period_set_name = pv_period_set_name
225: and period_type =
226: (
227: select period_type

Line 228: from gl_periods

224: where period_set_name = pv_period_set_name
225: and period_type =
226: (
227: select period_type
228: from gl_periods
229: where period_set_name = pv_period_set_name
230: and period_name = pv_tax_calendar_period
231: );
232:

Line 287: pv_tax_calendar_period in gl_periods.period_name%type,

283: /* ================================== Start of pre_process_update INTERNAL procedure =============================== */
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

Line 366: pv_tax_calendar_period in gl_periods.period_name%type,

362: /* ================================== Start of validate_process_initiation EXTERNAL procedure=============================== */
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,

Line 423: cursor c_gl_periods (pv_tax_calendar_name varchar2, pv_tax_calendar_period varchar2) is

419: where
420: vat_reporting_entity_id = pn_vat_reporting_entity_id;
421:
422:
423: cursor c_gl_periods (pv_tax_calendar_name varchar2, pv_tax_calendar_period varchar2) is
424: select
425: start_date,
426: end_date,
427: period_year

Line 429: gl_periods

425: start_date,
426: end_date,
427: period_year
428: from
429: gl_periods
430: where
431: period_set_name = pv_tax_calendar_name
432: and period_name = pv_tax_calendar_period;
433:

Line 436: cur_rec_gl_periods c_gl_periods%rowtype;

432: and period_name = pv_tax_calendar_period;
433:
434: cur_rec_jg_zz_vat_rep_status c_jg_zz_vat_rep_status%rowtype;
435: cur_rec_jg_zz_vat_rep_entities c_jg_zz_vat_rep_entities%rowtype;
436: cur_rec_gl_periods c_gl_periods%rowtype;
437:
438: begin
439:
440: /* source = 'ALL' means all the three products need to be processed. In such a case the order for processing is AP>AR>GL */

Line 518: /* Get the details from gl_periods */

514: if ld_period_start_date is null then
515:
516: /* common information across all sources is not fetched at all, so need to fetch */
517:
518: /* Get the details from gl_periods */
519: open c_gl_periods (lv_tax_calendar_name, pv_tax_calendar_period);
520: fetch c_gl_periods into ld_period_start_date, ld_period_end_date, ln_tax_calendar_year;
521: close c_gl_periods;
522:

Line 519: open c_gl_periods (lv_tax_calendar_name, pv_tax_calendar_period);

515:
516: /* common information across all sources is not fetched at all, so need to fetch */
517:
518: /* Get the details from gl_periods */
519: open c_gl_periods (lv_tax_calendar_name, pv_tax_calendar_period);
520: fetch c_gl_periods into ld_period_start_date, ld_period_end_date, ln_tax_calendar_year;
521: close c_gl_periods;
522:
523: end if;

Line 520: fetch c_gl_periods into ld_period_start_date, ld_period_end_date, ln_tax_calendar_year;

516: /* common information across all sources is not fetched at all, so need to fetch */
517:
518: /* Get the details from gl_periods */
519: open c_gl_periods (lv_tax_calendar_name, pv_tax_calendar_period);
520: fetch c_gl_periods into ld_period_start_date, ld_period_end_date, ln_tax_calendar_year;
521: close c_gl_periods;
522:
523: end if;
524:

Line 521: close c_gl_periods;

517:
518: /* Get the details from gl_periods */
519: open c_gl_periods (lv_tax_calendar_name, pv_tax_calendar_period);
520: fetch c_gl_periods into ld_period_start_date, ld_period_end_date, ln_tax_calendar_year;
521: close c_gl_periods;
522:
523: end if;
524:
525: /* There should not be any gap in processing -

Line 795: pv_tax_calendar_period in gl_periods.period_name%type,

791: /* ================================== Start of post_process_update EXTERNAL procedure =============================== */
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,

Line 876: pv_tax_calendar_period in gl_periods.period_name%type,

872: /* ================================== Start of get_period_status EXTERNAL function ============= */
873: function get_period_status
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

Line 911: pv_tax_calendar_period gl_periods.period_name%type,

907:
908: cursor c_rep_status_id
909: (
910: pv_vat_reporting_entity_id number,
911: pv_tax_calendar_period gl_periods.period_name%type,
912: pv_tax_calendar_year number,
913: pv_source varchar2
914: ) is
915: select reporting_status_id

Line 933: gl_periods glp1

929: Cursor C_Current_Period Is
930: Select (glp1.period_year*100)+glp1.period_num current_period
931: from jg_zz_vat_rep_status rep,
932: jg_zz_vat_rep_entities jgvre,
933: gl_periods glp1
934: where rep.vat_reporting_entity_id = pn_vat_reporting_entity_id
935: and ( rep.TAX_CALENDAR_PERIOD = NVL(pv_tax_calendar_period,'-1'))
936: and jgvre.vat_reporting_entity_id = rep.vat_reporting_entity_id
937: and rep.tax_calendar_name = nvl(jgvre.tax_calendar_name, rep.tax_calendar_name)

Line 945: gl_periods glp1

941:
942: Cursor C_Report_Period Is
943: Select (glp1.period_year*100)+glp1.period_num report_period
944: from jg_zz_vat_rep_status rep,
945: gl_periods glp1
946: where rep.vat_reporting_entity_id = pn_vat_reporting_entity_id
947: and ( rep.TAX_CALENDAR_PERIOD = NVL(pv_tax_calendar_period,'-1'))
948: and glp1.PERIOD_SET_NAME = rep.tax_calendar_name
949: and glp1.period_name = rep.tax_calendar_period