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_ENTITIES

Line 25: Added third argument lx_row_id in call to jg_zz_vat_rep_entities_pkg.insert_row API,

21: Added code to hanlde ALL for pv_source
22: in get_last_processed_date procedure.
23:
24: 2. 23-Jun-2006 Bhavik. Version 120.5 xBuild-7
25: Added third argument lx_row_id in call to jg_zz_vat_rep_entities_pkg.insert_row API,
26: as the signature of this API has been changed. Please refer bug# 5166688 for details
27: regarding change in signature of table handler APIs.
28:
29: 3. 10-jul-2006 Aparajita. Version#120.6. UT bug fix.

Line 112: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

108:
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

Line 205: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

201: /* ======================= start of check_gap_in_process_period INTERNAL procedure ============== */
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,

Line 286: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

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

Line 365: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

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

Line 389: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;

385: ln_tax_calendar_year jg_zz_vat_rep_status.tax_calendar_year%type;
386: lv_return_status varchar2(1);
387: lv_return_message varchar2(254);
388:
389: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
390: lv_tax_calendar_name jg_zz_vat_rep_entities.tax_calendar_name%type;
391: lv_enable_allocations_flag jg_zz_vat_rep_entities.enable_allocations_flag%type;
392: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;
393:

Line 390: lv_tax_calendar_name jg_zz_vat_rep_entities.tax_calendar_name%type;

386: lv_return_status varchar2(1);
387: lv_return_message varchar2(254);
388:
389: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
390: lv_tax_calendar_name jg_zz_vat_rep_entities.tax_calendar_name%type;
391: lv_enable_allocations_flag jg_zz_vat_rep_entities.enable_allocations_flag%type;
392: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;
393:
394:

Line 391: lv_enable_allocations_flag jg_zz_vat_rep_entities.enable_allocations_flag%type;

387: lv_return_message varchar2(254);
388:
389: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
390: lv_tax_calendar_name jg_zz_vat_rep_entities.tax_calendar_name%type;
391: lv_enable_allocations_flag jg_zz_vat_rep_entities.enable_allocations_flag%type;
392: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;
393:
394:
395: cursor c_jg_zz_vat_rep_status(pn_vat_reporting_entity_id number, pv_tax_calendar_period varchar2, pv_source varchar2) is

Line 392: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;

388:
389: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
390: lv_tax_calendar_name jg_zz_vat_rep_entities.tax_calendar_name%type;
391: lv_enable_allocations_flag jg_zz_vat_rep_entities.enable_allocations_flag%type;
392: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;
393:
394:
395: cursor c_jg_zz_vat_rep_status(pn_vat_reporting_entity_id number, pv_tax_calendar_period varchar2, pv_source varchar2) is
396: select

Line 411: cursor c_jg_zz_vat_rep_entities (pn_vat_reporting_entity_id number) is

407: vat_reporting_entity_id = pn_vat_reporting_entity_id
408: and tax_calendar_period = pv_tax_calendar_period
409: and source = pv_source;
410:
411: cursor c_jg_zz_vat_rep_entities (pn_vat_reporting_entity_id number) is
412: select
413: tax_registration_number,
414: tax_calendar_name,
415: enable_allocations_flag,

Line 418: jg_zz_vat_rep_entities

414: tax_calendar_name,
415: enable_allocations_flag,
416: mapping_vat_rep_entity_id /* Revised Approach change */
417: from
418: jg_zz_vat_rep_entities
419: where
420: vat_reporting_entity_id = pn_vat_reporting_entity_id;
421:
422:

Line 435: cur_rec_jg_zz_vat_rep_entities c_jg_zz_vat_rep_entities%rowtype;

431: period_set_name = pv_tax_calendar_name
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:

Line 452: /* Get the details from jg_zz_vat_rep_entities */

448: elsif pv_source = 'GL' then
449: lv_source := 'GL';
450: end if;
451:
452: /* Get the details from jg_zz_vat_rep_entities */
453: cur_rec_jg_zz_vat_rep_entities := null;
454: open c_jg_zz_vat_rep_entities (pn_vat_reporting_entity_id);
455: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;
456: close c_jg_zz_vat_rep_entities;

Line 453: cur_rec_jg_zz_vat_rep_entities := null;

449: lv_source := 'GL';
450: end if;
451:
452: /* Get the details from jg_zz_vat_rep_entities */
453: cur_rec_jg_zz_vat_rep_entities := null;
454: open c_jg_zz_vat_rep_entities (pn_vat_reporting_entity_id);
455: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;
456: close c_jg_zz_vat_rep_entities;
457:

Line 454: open c_jg_zz_vat_rep_entities (pn_vat_reporting_entity_id);

450: end if;
451:
452: /* Get the details from jg_zz_vat_rep_entities */
453: cur_rec_jg_zz_vat_rep_entities := null;
454: open c_jg_zz_vat_rep_entities (pn_vat_reporting_entity_id);
455: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;
456: close c_jg_zz_vat_rep_entities;
457:
458: /* Revised approach changes for mapping entities */

Line 455: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;

451:
452: /* Get the details from jg_zz_vat_rep_entities */
453: cur_rec_jg_zz_vat_rep_entities := null;
454: open c_jg_zz_vat_rep_entities (pn_vat_reporting_entity_id);
455: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;
456: close c_jg_zz_vat_rep_entities;
457:
458: /* Revised approach changes for mapping entities */
459:

Line 456: close c_jg_zz_vat_rep_entities;

452: /* Get the details from jg_zz_vat_rep_entities */
453: cur_rec_jg_zz_vat_rep_entities := null;
454: open c_jg_zz_vat_rep_entities (pn_vat_reporting_entity_id);
455: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;
456: close c_jg_zz_vat_rep_entities;
457:
458: /* Revised approach changes for mapping entities */
459:
460: if cur_rec_jg_zz_vat_rep_entities.mapping_vat_rep_entity_id is null then

Line 460: if cur_rec_jg_zz_vat_rep_entities.mapping_vat_rep_entity_id is null then

456: close c_jg_zz_vat_rep_entities;
457:
458: /* Revised approach changes for mapping entities */
459:
460: if cur_rec_jg_zz_vat_rep_entities.mapping_vat_rep_entity_id is null then
461:
462: /* Entity is a legal entity, other values to be taken directly from the entity */
463: lv_tax_registration_number := cur_rec_jg_zz_vat_rep_entities.tax_registration_number;
464: lv_tax_calendar_name := cur_rec_jg_zz_vat_rep_entities.tax_calendar_name;

Line 463: lv_tax_registration_number := cur_rec_jg_zz_vat_rep_entities.tax_registration_number;

459:
460: if cur_rec_jg_zz_vat_rep_entities.mapping_vat_rep_entity_id is null then
461:
462: /* Entity is a legal entity, other values to be taken directly from the entity */
463: lv_tax_registration_number := cur_rec_jg_zz_vat_rep_entities.tax_registration_number;
464: lv_tax_calendar_name := cur_rec_jg_zz_vat_rep_entities.tax_calendar_name;
465: lv_enable_allocations_flag := cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag;
466: ln_mapping_vat_rep_entity_id:= pn_vat_reporting_entity_id;
467:

Line 464: lv_tax_calendar_name := cur_rec_jg_zz_vat_rep_entities.tax_calendar_name;

460: if cur_rec_jg_zz_vat_rep_entities.mapping_vat_rep_entity_id is null then
461:
462: /* Entity is a legal entity, other values to be taken directly from the entity */
463: lv_tax_registration_number := cur_rec_jg_zz_vat_rep_entities.tax_registration_number;
464: lv_tax_calendar_name := cur_rec_jg_zz_vat_rep_entities.tax_calendar_name;
465: lv_enable_allocations_flag := cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag;
466: ln_mapping_vat_rep_entity_id:= pn_vat_reporting_entity_id;
467:
468: /* For legal entities mapping entity is being populated same as that of the entity id for

Line 465: lv_enable_allocations_flag := cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag;

461:
462: /* Entity is a legal entity, other values to be taken directly from the entity */
463: lv_tax_registration_number := cur_rec_jg_zz_vat_rep_entities.tax_registration_number;
464: lv_tax_calendar_name := cur_rec_jg_zz_vat_rep_entities.tax_calendar_name;
465: lv_enable_allocations_flag := cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag;
466: ln_mapping_vat_rep_entity_id:= pn_vat_reporting_entity_id;
467:
468: /* For legal entities mapping entity is being populated same as that of the entity id for
469: simplicity of implementation. */

Line 474: ln_mapping_vat_rep_entity_id:= cur_rec_jg_zz_vat_rep_entities.mapping_vat_rep_entity_id;

470:
471: else
472:
473: /* Entity is an accounting entity, need to fetch details from the mapping legal entity */
474: ln_mapping_vat_rep_entity_id:= cur_rec_jg_zz_vat_rep_entities.mapping_vat_rep_entity_id;
475:
476: cur_rec_jg_zz_vat_rep_entities := null;
477: open c_jg_zz_vat_rep_entities (ln_mapping_vat_rep_entity_id);
478: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;

Line 476: cur_rec_jg_zz_vat_rep_entities := null;

472:
473: /* Entity is an accounting entity, need to fetch details from the mapping legal entity */
474: ln_mapping_vat_rep_entity_id:= cur_rec_jg_zz_vat_rep_entities.mapping_vat_rep_entity_id;
475:
476: cur_rec_jg_zz_vat_rep_entities := null;
477: open c_jg_zz_vat_rep_entities (ln_mapping_vat_rep_entity_id);
478: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;
479: close c_jg_zz_vat_rep_entities;
480:

Line 477: open c_jg_zz_vat_rep_entities (ln_mapping_vat_rep_entity_id);

473: /* Entity is an accounting entity, need to fetch details from the mapping legal entity */
474: ln_mapping_vat_rep_entity_id:= cur_rec_jg_zz_vat_rep_entities.mapping_vat_rep_entity_id;
475:
476: cur_rec_jg_zz_vat_rep_entities := null;
477: open c_jg_zz_vat_rep_entities (ln_mapping_vat_rep_entity_id);
478: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;
479: close c_jg_zz_vat_rep_entities;
480:
481: lv_tax_registration_number := cur_rec_jg_zz_vat_rep_entities.tax_registration_number;

Line 478: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;

474: ln_mapping_vat_rep_entity_id:= cur_rec_jg_zz_vat_rep_entities.mapping_vat_rep_entity_id;
475:
476: cur_rec_jg_zz_vat_rep_entities := null;
477: open c_jg_zz_vat_rep_entities (ln_mapping_vat_rep_entity_id);
478: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;
479: close c_jg_zz_vat_rep_entities;
480:
481: lv_tax_registration_number := cur_rec_jg_zz_vat_rep_entities.tax_registration_number;
482: lv_tax_calendar_name := cur_rec_jg_zz_vat_rep_entities.tax_calendar_name;

Line 479: close c_jg_zz_vat_rep_entities;

475:
476: cur_rec_jg_zz_vat_rep_entities := null;
477: open c_jg_zz_vat_rep_entities (ln_mapping_vat_rep_entity_id);
478: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;
479: close c_jg_zz_vat_rep_entities;
480:
481: lv_tax_registration_number := cur_rec_jg_zz_vat_rep_entities.tax_registration_number;
482: lv_tax_calendar_name := cur_rec_jg_zz_vat_rep_entities.tax_calendar_name;
483: lv_enable_allocations_flag := cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag;

Line 481: lv_tax_registration_number := cur_rec_jg_zz_vat_rep_entities.tax_registration_number;

477: open c_jg_zz_vat_rep_entities (ln_mapping_vat_rep_entity_id);
478: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;
479: close c_jg_zz_vat_rep_entities;
480:
481: lv_tax_registration_number := cur_rec_jg_zz_vat_rep_entities.tax_registration_number;
482: lv_tax_calendar_name := cur_rec_jg_zz_vat_rep_entities.tax_calendar_name;
483: lv_enable_allocations_flag := cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag;
484:
485: end if;

Line 482: lv_tax_calendar_name := cur_rec_jg_zz_vat_rep_entities.tax_calendar_name;

478: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;
479: close c_jg_zz_vat_rep_entities;
480:
481: lv_tax_registration_number := cur_rec_jg_zz_vat_rep_entities.tax_registration_number;
482: lv_tax_calendar_name := cur_rec_jg_zz_vat_rep_entities.tax_calendar_name;
483: lv_enable_allocations_flag := cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag;
484:
485: end if;
486:

Line 483: lv_enable_allocations_flag := cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag;

479: close c_jg_zz_vat_rep_entities;
480:
481: lv_tax_registration_number := cur_rec_jg_zz_vat_rep_entities.tax_registration_number;
482: lv_tax_calendar_name := cur_rec_jg_zz_vat_rep_entities.tax_calendar_name;
483: lv_enable_allocations_flag := cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag;
484:
485: end if;
486:
487: loop

Line 533: pv_period_set_name => cur_rec_jg_zz_vat_rep_entities.tax_calendar_name,

529:
530: check_gap_in_process_period
531: (
532: pn_vat_reporting_entity_id => pn_vat_reporting_entity_id,
533: pv_period_set_name => cur_rec_jg_zz_vat_rep_entities.tax_calendar_name,
534: pv_tax_calendar_period => pv_tax_calendar_period,
535: pd_start_date => ld_period_start_date,
536: pd_end_date => ld_period_end_date,
537: pv_source => lv_source,

Line 634: if cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag <> 'Y' then

630: goto error_exit_from_procedure;
631: end if;
632:
633:
634: if cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag <> 'Y' then
635:
636: /* Check if allocation records need to be purged, there could be a change in setup */
637: if cur_rec_jg_zz_vat_rep_status.allocation_status_flag <> 'N' then
638: /* invoke the allocation API to purge the allocation data.*/

Line 687: if cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag = 'Y' then

683:
684: if cur_rec_jg_zz_vat_rep_status.allocation_status_flag = 'N' then
685:
686: /* Allocation has not happened, check if it is applicable */
687: if cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag = 'Y' then
688: fnd_message.set_name('JG', 'JG_ZZ_VAT_NO_ALLOCATION');
689: fnd_message.set_token('SOURCE', lv_source);
690: fnd_message.set_token('PROCESS_NAME', pv_process_name);
691: xv_return_message := fnd_message.get;

Line 712: pv_period_set_name => cur_rec_jg_zz_vat_rep_entities.tax_calendar_name,

708: **Changed for Revised approach, it can have gaps
709: check_gap_in_process_period
710: (
711: pn_vat_reporting_entity_id => pn_vat_reporting_entity_id,
712: pv_period_set_name => cur_rec_jg_zz_vat_rep_entities.tax_calendar_name,
713: pv_tax_calendar_period => pv_tax_calendar_period,
714: pd_start_date => cur_rec_jg_zz_vat_rep_status.period_start_date,
715: pd_end_date => cur_rec_jg_zz_vat_rep_status.period_end_date,
716: pv_source => lv_source,

Line 794: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

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

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

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: )
804: is

Line 875: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

871:
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,

Line 932: jg_zz_vat_rep_entities jgvre,

928: -- Bug 13925495 Start
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

Line 1099: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,

1095:
1096: /* ============================= Start of validate_entity_attributes ========================== */
1097: procedure validate_entity_attributes
1098: (
1099: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1100: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1101: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1102: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1103: xv_return_status out nocopy varchar2,

Line 1100: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

1096: /* ============================= Start of validate_entity_attributes ========================== */
1097: procedure validate_entity_attributes
1098: (
1099: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1100: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1101: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1102: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1103: xv_return_status out nocopy varchar2,
1104: xv_return_message out nocopy varchar2

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

1097: procedure validate_entity_attributes
1098: (
1099: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1100: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1101: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1102: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1103: xv_return_status out nocopy varchar2,
1104: xv_return_message out nocopy varchar2
1105: )

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

1098: (
1099: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1100: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1101: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1102: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1103: xv_return_status out nocopy varchar2,
1104: xv_return_message out nocopy varchar2
1105: )
1106: is

Line 1173: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,

1169:
1170: /* =============================== Start of get_accounting_entity ============================ */
1171: function get_accounting_entity
1172: (
1173: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1174: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1175: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1176: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null
1177: ) return number

Line 1174: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

1170: /* =============================== Start of get_accounting_entity ============================ */
1171: function get_accounting_entity
1172: (
1173: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1174: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1175: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1176: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null
1177: ) return number
1178: is

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

1171: function get_accounting_entity
1172: (
1173: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1174: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1175: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1176: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null
1177: ) return number
1178: is
1179:

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

1172: (
1173: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1174: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1175: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1176: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null
1177: ) return number
1178: is
1179:
1180: cursor c_jg_zz_vat_rep_entities is

Line 1180: cursor c_jg_zz_vat_rep_entities is

1176: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null
1177: ) return number
1178: is
1179:
1180: cursor c_jg_zz_vat_rep_entities is
1181: select vat_reporting_entity_id
1182: from jg_zz_vat_rep_entities
1183: where entity_type_code = 'ACCOUNTING'
1184: and entity_level_code = pv_entity_level_code

Line 1182: from jg_zz_vat_rep_entities

1178: is
1179:
1180: cursor c_jg_zz_vat_rep_entities is
1181: select vat_reporting_entity_id
1182: from jg_zz_vat_rep_entities
1183: where entity_type_code = 'ACCOUNTING'
1184: and entity_level_code = pv_entity_level_code
1185: and mapping_vat_rep_entity_id = pn_vat_reporting_entity_id
1186: and ledger_id = pn_ledger_id

Line 1193: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;

1189: or
1190: (pv_entity_level_code = 'BSV' and balancing_segment_value = pv_balancing_segment_value)
1191: );
1192:
1193: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;
1194:
1195: begin
1196:
1197: open c_jg_zz_vat_rep_entities;

Line 1197: open c_jg_zz_vat_rep_entities;

1193: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;
1194:
1195: begin
1196:
1197: open c_jg_zz_vat_rep_entities;
1198: fetch c_jg_zz_vat_rep_entities into ln_vat_reporting_entity_id;
1199: close c_jg_zz_vat_rep_entities;
1200:
1201: return ln_vat_reporting_entity_id;

Line 1198: fetch c_jg_zz_vat_rep_entities into ln_vat_reporting_entity_id;

1194:
1195: begin
1196:
1197: open c_jg_zz_vat_rep_entities;
1198: fetch c_jg_zz_vat_rep_entities into ln_vat_reporting_entity_id;
1199: close c_jg_zz_vat_rep_entities;
1200:
1201: return ln_vat_reporting_entity_id;
1202:

Line 1199: close c_jg_zz_vat_rep_entities;

1195: begin
1196:
1197: open c_jg_zz_vat_rep_entities;
1198: fetch c_jg_zz_vat_rep_entities into ln_vat_reporting_entity_id;
1199: close c_jg_zz_vat_rep_entities;
1200:
1201: return ln_vat_reporting_entity_id;
1202:
1203:

Line 1215: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,

1211:
1212: /* ============================ Start of create_accounting_entity ============================ */
1213: procedure create_accounting_entity
1214: (
1215: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1216: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1217: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type,
1218: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1219: xn_vat_reporting_entity_id out nocopy number,

Line 1216: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

1212: /* ============================ Start of create_accounting_entity ============================ */
1213: procedure create_accounting_entity
1214: (
1215: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1216: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1217: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type,
1218: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1219: xn_vat_reporting_entity_id out nocopy number,
1220: xv_return_status out nocopy varchar2,

Line 1217: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type,

1213: procedure create_accounting_entity
1214: (
1215: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1216: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1217: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type,
1218: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1219: xn_vat_reporting_entity_id out nocopy number,
1220: xv_return_status out nocopy varchar2,
1221: xv_return_message out nocopy varchar2

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

1214: (
1215: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1216: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1217: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type,
1218: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1219: xn_vat_reporting_entity_id out nocopy number,
1220: xv_return_status out nocopy varchar2,
1221: xv_return_message out nocopy varchar2
1222: )

Line 1225: lr_record jg_zz_vat_rep_entities%rowtype;

1221: xv_return_message out nocopy varchar2
1222: )
1223: is
1224:
1225: lr_record jg_zz_vat_rep_entities%rowtype;
1226: lx_row_id rowid;
1227:
1228: begin
1229:

Line 1240: jg_zz_vat_rep_entities_pkg.insert_row

1236: lr_record.last_updated_by := fnd_global.user_id;
1237: lr_record.last_update_date := sysdate;
1238: lr_record.last_update_login := fnd_global.login_id;
1239:
1240: jg_zz_vat_rep_entities_pkg.insert_row
1241: (
1242: x_record => lr_record,
1243: x_vat_reporting_entity_id => xn_vat_reporting_entity_id,
1244: x_row_id => lx_row_id

Line 1263: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

1259:
1260: /* ============================ Start of get_reporting_identifier ============================ */
1261: function get_reporting_identifier
1262: (
1263: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1264: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type default null,
1265: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1266: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1267: pv_called_from in varchar2 /* possible values - PARAMETER_FORM, TABLE_HANDLER, QUERY */

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

1260: /* ============================ Start of get_reporting_identifier ============================ */
1261: function get_reporting_identifier
1262: (
1263: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1264: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type default null,
1265: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1266: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1267: pv_called_from in varchar2 /* possible values - PARAMETER_FORM, TABLE_HANDLER, QUERY */
1268: ) return varchar2

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

1261: function get_reporting_identifier
1262: (
1263: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1264: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type default null,
1265: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1266: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1267: pv_called_from in varchar2 /* possible values - PARAMETER_FORM, TABLE_HANDLER, QUERY */
1268: ) return varchar2
1269: is

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

1262: (
1263: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1264: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type default null,
1265: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1266: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1267: pv_called_from in varchar2 /* possible values - PARAMETER_FORM, TABLE_HANDLER, QUERY */
1268: ) return varchar2
1269: is
1270:

Line 1274: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;

1270:
1271: lv_return_status varchar2(1);
1272: lv_return_message varchar2(254);
1273:
1274: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;
1275: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;
1276: ln_ledger_id jg_zz_vat_rep_entities.ledger_id%type;
1277: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;
1278: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;

Line 1275: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;

1271: lv_return_status varchar2(1);
1272: lv_return_message varchar2(254);
1273:
1274: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;
1275: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;
1276: ln_ledger_id jg_zz_vat_rep_entities.ledger_id%type;
1277: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;
1278: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;
1279: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;

Line 1276: ln_ledger_id jg_zz_vat_rep_entities.ledger_id%type;

1272: lv_return_message varchar2(254);
1273:
1274: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;
1275: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;
1276: ln_ledger_id jg_zz_vat_rep_entities.ledger_id%type;
1277: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;
1278: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;
1279: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;
1280: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;

Line 1277: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;

1273:
1274: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;
1275: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;
1276: ln_ledger_id jg_zz_vat_rep_entities.ledger_id%type;
1277: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;
1278: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;
1279: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;
1280: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
1281: lv_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;

Line 1278: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;

1274: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;
1275: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;
1276: ln_ledger_id jg_zz_vat_rep_entities.ledger_id%type;
1277: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;
1278: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;
1279: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;
1280: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
1281: lv_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;
1282: lv_entity_level_code jg_zz_vat_rep_entities.entity_level_code%type;

Line 1279: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;

1275: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;
1276: ln_ledger_id jg_zz_vat_rep_entities.ledger_id%type;
1277: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;
1278: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;
1279: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;
1280: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
1281: lv_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;
1282: lv_entity_level_code jg_zz_vat_rep_entities.entity_level_code%type;
1283:

Line 1280: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;

1276: ln_ledger_id jg_zz_vat_rep_entities.ledger_id%type;
1277: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;
1278: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;
1279: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;
1280: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
1281: lv_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;
1282: lv_entity_level_code jg_zz_vat_rep_entities.entity_level_code%type;
1283:
1284: cursor c_jg_zz_vat_rep_entities(cpn_vat_reporting_entity_id number) is

Line 1281: lv_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;

1277: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;
1278: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;
1279: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;
1280: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
1281: lv_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;
1282: lv_entity_level_code jg_zz_vat_rep_entities.entity_level_code%type;
1283:
1284: cursor c_jg_zz_vat_rep_entities(cpn_vat_reporting_entity_id number) is
1285: select

Line 1282: lv_entity_level_code jg_zz_vat_rep_entities.entity_level_code%type;

1278: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;
1279: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;
1280: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
1281: lv_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;
1282: lv_entity_level_code jg_zz_vat_rep_entities.entity_level_code%type;
1283:
1284: cursor c_jg_zz_vat_rep_entities(cpn_vat_reporting_entity_id number) is
1285: select
1286: entity_level_code ,

Line 1284: cursor c_jg_zz_vat_rep_entities(cpn_vat_reporting_entity_id number) is

1280: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
1281: lv_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;
1282: lv_entity_level_code jg_zz_vat_rep_entities.entity_level_code%type;
1283:
1284: cursor c_jg_zz_vat_rep_entities(cpn_vat_reporting_entity_id number) is
1285: select
1286: entity_level_code ,
1287: ledger_id ,
1288: legal_entity_id ,

Line 1295: jg_zz_vat_rep_entities

1291: tax_registration_number ,
1292: mapping_vat_rep_entity_id ,
1293: entity_identifier
1294: from
1295: jg_zz_vat_rep_entities
1296: where
1297: vat_reporting_entity_id = cpn_vat_reporting_entity_id;
1298:
1299: cursor c_get_le_identifier(cpn_legal_entity_id number) is

Line 1315: crec_reporting_entities c_jg_zz_vat_rep_entities%rowtype;

1311: from gl_ledgers_public_v
1312: where ledger_id = cpn_ledger_id;
1313:
1314:
1315: crec_reporting_entities c_jg_zz_vat_rep_entities%rowtype;
1316: crec_mapping_entities c_jg_zz_vat_rep_entities%rowtype;
1317:
1318:
1319: begin

Line 1316: crec_mapping_entities c_jg_zz_vat_rep_entities%rowtype;

1312: where ledger_id = cpn_ledger_id;
1313:
1314:
1315: crec_reporting_entities c_jg_zz_vat_rep_entities%rowtype;
1316: crec_mapping_entities c_jg_zz_vat_rep_entities%rowtype;
1317:
1318:
1319: begin
1320:

Line 1372: open c_jg_zz_vat_rep_entities(ln_vat_reporting_entity_id);

1368: end if; /* pv_called_from */
1369:
1370: if ln_vat_reporting_entity_id is not null then
1371:
1372: open c_jg_zz_vat_rep_entities(ln_vat_reporting_entity_id);
1373: fetch c_jg_zz_vat_rep_entities into crec_reporting_entities;
1374: close c_jg_zz_vat_rep_entities;
1375:
1376: if crec_reporting_entities.entity_identifier is not null then

Line 1373: fetch c_jg_zz_vat_rep_entities into crec_reporting_entities;

1369:
1370: if ln_vat_reporting_entity_id is not null then
1371:
1372: open c_jg_zz_vat_rep_entities(ln_vat_reporting_entity_id);
1373: fetch c_jg_zz_vat_rep_entities into crec_reporting_entities;
1374: close c_jg_zz_vat_rep_entities;
1375:
1376: if crec_reporting_entities.entity_identifier is not null then
1377: return crec_reporting_entities.entity_identifier;

Line 1374: close c_jg_zz_vat_rep_entities;

1370: if ln_vat_reporting_entity_id is not null then
1371:
1372: open c_jg_zz_vat_rep_entities(ln_vat_reporting_entity_id);
1373: fetch c_jg_zz_vat_rep_entities into crec_reporting_entities;
1374: close c_jg_zz_vat_rep_entities;
1375:
1376: if crec_reporting_entities.entity_identifier is not null then
1377: return crec_reporting_entities.entity_identifier;
1378: end if;

Line 1392: open c_jg_zz_vat_rep_entities(ln_mapping_vat_rep_entity_id);

1388: end if;
1389:
1390:
1391: if ln_mapping_vat_rep_entity_id is not null then
1392: open c_jg_zz_vat_rep_entities(ln_mapping_vat_rep_entity_id);
1393: fetch c_jg_zz_vat_rep_entities into crec_mapping_entities;
1394: close c_jg_zz_vat_rep_entities;
1395:
1396: lv_tax_regime_code := crec_mapping_entities.tax_regime_code ;

Line 1393: fetch c_jg_zz_vat_rep_entities into crec_mapping_entities;

1389:
1390:
1391: if ln_mapping_vat_rep_entity_id is not null then
1392: open c_jg_zz_vat_rep_entities(ln_mapping_vat_rep_entity_id);
1393: fetch c_jg_zz_vat_rep_entities into crec_mapping_entities;
1394: close c_jg_zz_vat_rep_entities;
1395:
1396: lv_tax_regime_code := crec_mapping_entities.tax_regime_code ;
1397: lv_tax_registration_number := crec_mapping_entities.tax_registration_number ;

Line 1394: close c_jg_zz_vat_rep_entities;

1390:
1391: if ln_mapping_vat_rep_entity_id is not null then
1392: open c_jg_zz_vat_rep_entities(ln_mapping_vat_rep_entity_id);
1393: fetch c_jg_zz_vat_rep_entities into crec_mapping_entities;
1394: close c_jg_zz_vat_rep_entities;
1395:
1396: lv_tax_regime_code := crec_mapping_entities.tax_regime_code ;
1397: lv_tax_registration_number := crec_mapping_entities.tax_registration_number ;
1398:

Line 1443: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,

1439:
1440: /* ============================ Start of maintain_selection_entities ============================ */
1441: procedure maintain_selection_entities
1442: (
1443: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1444: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1445: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1446: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1447: xn_vat_reporting_entity_id out nocopy number,

Line 1444: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

1440: /* ============================ Start of maintain_selection_entities ============================ */
1441: procedure maintain_selection_entities
1442: (
1443: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1444: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1445: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1446: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1447: xn_vat_reporting_entity_id out nocopy number,
1448: xv_return_status out nocopy varchar2,

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

1441: procedure maintain_selection_entities
1442: (
1443: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1444: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1445: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1446: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1447: xn_vat_reporting_entity_id out nocopy number,
1448: xv_return_status out nocopy varchar2,
1449: xv_return_message out nocopy varchar2

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

1442: (
1443: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1444: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1445: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1446: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1447: xn_vat_reporting_entity_id out nocopy number,
1448: xv_return_status out nocopy varchar2,
1449: xv_return_message out nocopy varchar2
1450: )