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 1055: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,

1051:
1052: /* ============================= Start of validate_entity_attributes ========================== */
1053: procedure validate_entity_attributes
1054: (
1055: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1056: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1057: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1058: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1059: xv_return_status out nocopy varchar2,

Line 1056: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

1052: /* ============================= Start of validate_entity_attributes ========================== */
1053: procedure validate_entity_attributes
1054: (
1055: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1056: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1057: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1058: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1059: xv_return_status out nocopy varchar2,
1060: xv_return_message out nocopy varchar2

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

1053: procedure validate_entity_attributes
1054: (
1055: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1056: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1057: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1058: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1059: xv_return_status out nocopy varchar2,
1060: xv_return_message out nocopy varchar2
1061: )

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

1054: (
1055: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1056: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1057: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1058: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1059: xv_return_status out nocopy varchar2,
1060: xv_return_message out nocopy varchar2
1061: )
1062: is

Line 1129: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,

1125:
1126: /* =============================== Start of get_accounting_entity ============================ */
1127: function get_accounting_entity
1128: (
1129: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1130: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1131: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1132: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null
1133: ) return number

Line 1130: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

1126: /* =============================== Start of get_accounting_entity ============================ */
1127: function get_accounting_entity
1128: (
1129: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1130: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1131: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1132: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null
1133: ) return number
1134: is

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

1127: function get_accounting_entity
1128: (
1129: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1130: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1131: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1132: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null
1133: ) return number
1134: is
1135:

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

1128: (
1129: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1130: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1131: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1132: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null
1133: ) return number
1134: is
1135:
1136: cursor c_jg_zz_vat_rep_entities is

Line 1136: cursor c_jg_zz_vat_rep_entities is

1132: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null
1133: ) return number
1134: is
1135:
1136: cursor c_jg_zz_vat_rep_entities is
1137: select vat_reporting_entity_id
1138: from jg_zz_vat_rep_entities
1139: where entity_type_code = 'ACCOUNTING'
1140: and entity_level_code = pv_entity_level_code

Line 1138: from jg_zz_vat_rep_entities

1134: is
1135:
1136: cursor c_jg_zz_vat_rep_entities is
1137: select vat_reporting_entity_id
1138: from jg_zz_vat_rep_entities
1139: where entity_type_code = 'ACCOUNTING'
1140: and entity_level_code = pv_entity_level_code
1141: and mapping_vat_rep_entity_id = pn_vat_reporting_entity_id
1142: and ledger_id = pn_ledger_id

Line 1149: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;

1145: or
1146: (pv_entity_level_code = 'BSV' and balancing_segment_value = pv_balancing_segment_value)
1147: );
1148:
1149: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;
1150:
1151: begin
1152:
1153: open c_jg_zz_vat_rep_entities;

Line 1153: open c_jg_zz_vat_rep_entities;

1149: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;
1150:
1151: begin
1152:
1153: open c_jg_zz_vat_rep_entities;
1154: fetch c_jg_zz_vat_rep_entities into ln_vat_reporting_entity_id;
1155: close c_jg_zz_vat_rep_entities;
1156:
1157: return ln_vat_reporting_entity_id;

Line 1154: fetch c_jg_zz_vat_rep_entities into ln_vat_reporting_entity_id;

1150:
1151: begin
1152:
1153: open c_jg_zz_vat_rep_entities;
1154: fetch c_jg_zz_vat_rep_entities into ln_vat_reporting_entity_id;
1155: close c_jg_zz_vat_rep_entities;
1156:
1157: return ln_vat_reporting_entity_id;
1158:

Line 1155: close c_jg_zz_vat_rep_entities;

1151: begin
1152:
1153: open c_jg_zz_vat_rep_entities;
1154: fetch c_jg_zz_vat_rep_entities into ln_vat_reporting_entity_id;
1155: close c_jg_zz_vat_rep_entities;
1156:
1157: return ln_vat_reporting_entity_id;
1158:
1159:

Line 1171: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,

1167:
1168: /* ============================ Start of create_accounting_entity ============================ */
1169: procedure create_accounting_entity
1170: (
1171: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1172: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1173: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type,
1174: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1175: xn_vat_reporting_entity_id out nocopy number,

Line 1172: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

1168: /* ============================ Start of create_accounting_entity ============================ */
1169: procedure create_accounting_entity
1170: (
1171: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1172: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1173: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type,
1174: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1175: xn_vat_reporting_entity_id out nocopy number,
1176: xv_return_status out nocopy varchar2,

Line 1173: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type,

1169: procedure create_accounting_entity
1170: (
1171: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1172: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1173: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type,
1174: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1175: xn_vat_reporting_entity_id out nocopy number,
1176: xv_return_status out nocopy varchar2,
1177: xv_return_message out nocopy varchar2

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

1170: (
1171: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1172: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1173: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type,
1174: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1175: xn_vat_reporting_entity_id out nocopy number,
1176: xv_return_status out nocopy varchar2,
1177: xv_return_message out nocopy varchar2
1178: )

Line 1181: lr_record jg_zz_vat_rep_entities%rowtype;

1177: xv_return_message out nocopy varchar2
1178: )
1179: is
1180:
1181: lr_record jg_zz_vat_rep_entities%rowtype;
1182: lx_row_id rowid;
1183:
1184: begin
1185:

Line 1196: jg_zz_vat_rep_entities_pkg.insert_row

1192: lr_record.last_updated_by := fnd_global.user_id;
1193: lr_record.last_update_date := sysdate;
1194: lr_record.last_update_login := fnd_global.login_id;
1195:
1196: jg_zz_vat_rep_entities_pkg.insert_row
1197: (
1198: x_record => lr_record,
1199: x_vat_reporting_entity_id => xn_vat_reporting_entity_id,
1200: x_row_id => lx_row_id

Line 1219: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

1215:
1216: /* ============================ Start of get_reporting_identifier ============================ */
1217: function get_reporting_identifier
1218: (
1219: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1220: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type default null,
1221: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1222: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1223: pv_called_from in varchar2 /* possible values - PARAMETER_FORM, TABLE_HANDLER, QUERY */

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

1216: /* ============================ Start of get_reporting_identifier ============================ */
1217: function get_reporting_identifier
1218: (
1219: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1220: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type default null,
1221: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1222: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1223: pv_called_from in varchar2 /* possible values - PARAMETER_FORM, TABLE_HANDLER, QUERY */
1224: ) return varchar2

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

1217: function get_reporting_identifier
1218: (
1219: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1220: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type default null,
1221: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1222: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1223: pv_called_from in varchar2 /* possible values - PARAMETER_FORM, TABLE_HANDLER, QUERY */
1224: ) return varchar2
1225: is

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

1218: (
1219: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1220: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type default null,
1221: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1222: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1223: pv_called_from in varchar2 /* possible values - PARAMETER_FORM, TABLE_HANDLER, QUERY */
1224: ) return varchar2
1225: is
1226:

Line 1230: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;

1226:
1227: lv_return_status varchar2(1);
1228: lv_return_message varchar2(254);
1229:
1230: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;
1231: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;
1232: ln_ledger_id jg_zz_vat_rep_entities.ledger_id%type;
1233: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;
1234: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;

Line 1231: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;

1227: lv_return_status varchar2(1);
1228: lv_return_message varchar2(254);
1229:
1230: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;
1231: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;
1232: ln_ledger_id jg_zz_vat_rep_entities.ledger_id%type;
1233: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;
1234: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;
1235: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;

Line 1232: ln_ledger_id jg_zz_vat_rep_entities.ledger_id%type;

1228: lv_return_message varchar2(254);
1229:
1230: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;
1231: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;
1232: ln_ledger_id jg_zz_vat_rep_entities.ledger_id%type;
1233: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;
1234: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;
1235: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;
1236: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;

Line 1233: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;

1229:
1230: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;
1231: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;
1232: ln_ledger_id jg_zz_vat_rep_entities.ledger_id%type;
1233: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;
1234: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;
1235: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;
1236: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
1237: lv_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;

Line 1234: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;

1230: ln_vat_reporting_entity_id jg_zz_vat_rep_entities.vat_reporting_entity_id%type;
1231: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;
1232: ln_ledger_id jg_zz_vat_rep_entities.ledger_id%type;
1233: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;
1234: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;
1235: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;
1236: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
1237: lv_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;
1238: lv_entity_level_code jg_zz_vat_rep_entities.entity_level_code%type;

Line 1235: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;

1231: ln_mapping_vat_rep_entity_id jg_zz_vat_rep_entities.mapping_vat_rep_entity_id%type;
1232: ln_ledger_id jg_zz_vat_rep_entities.ledger_id%type;
1233: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;
1234: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;
1235: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;
1236: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
1237: lv_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;
1238: lv_entity_level_code jg_zz_vat_rep_entities.entity_level_code%type;
1239:

Line 1236: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;

1232: ln_ledger_id jg_zz_vat_rep_entities.ledger_id%type;
1233: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;
1234: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;
1235: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;
1236: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
1237: lv_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;
1238: lv_entity_level_code jg_zz_vat_rep_entities.entity_level_code%type;
1239:
1240: cursor c_jg_zz_vat_rep_entities(cpn_vat_reporting_entity_id number) is

Line 1237: lv_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;

1233: ln_legal_entity_id jg_zz_vat_rep_entities.legal_entity_id%type;
1234: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;
1235: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;
1236: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
1237: lv_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;
1238: lv_entity_level_code jg_zz_vat_rep_entities.entity_level_code%type;
1239:
1240: cursor c_jg_zz_vat_rep_entities(cpn_vat_reporting_entity_id number) is
1241: select

Line 1238: lv_entity_level_code jg_zz_vat_rep_entities.entity_level_code%type;

1234: lv_balancing_segment_value jg_zz_vat_rep_entities.balancing_segment_value%type;
1235: lv_tax_regime_code jg_zz_vat_rep_entities.tax_regime_code%type;
1236: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
1237: lv_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;
1238: lv_entity_level_code jg_zz_vat_rep_entities.entity_level_code%type;
1239:
1240: cursor c_jg_zz_vat_rep_entities(cpn_vat_reporting_entity_id number) is
1241: select
1242: entity_level_code ,

Line 1240: cursor c_jg_zz_vat_rep_entities(cpn_vat_reporting_entity_id number) is

1236: lv_tax_registration_number jg_zz_vat_rep_entities.tax_registration_number%type;
1237: lv_entity_identifier jg_zz_vat_rep_entities.entity_identifier%type;
1238: lv_entity_level_code jg_zz_vat_rep_entities.entity_level_code%type;
1239:
1240: cursor c_jg_zz_vat_rep_entities(cpn_vat_reporting_entity_id number) is
1241: select
1242: entity_level_code ,
1243: ledger_id ,
1244: legal_entity_id ,

Line 1251: jg_zz_vat_rep_entities

1247: tax_registration_number ,
1248: mapping_vat_rep_entity_id ,
1249: entity_identifier
1250: from
1251: jg_zz_vat_rep_entities
1252: where
1253: vat_reporting_entity_id = cpn_vat_reporting_entity_id;
1254:
1255: cursor c_get_le_identifier(cpn_legal_entity_id number) is

Line 1271: crec_reporting_entities c_jg_zz_vat_rep_entities%rowtype;

1267: from gl_ledgers_public_v
1268: where ledger_id = cpn_ledger_id;
1269:
1270:
1271: crec_reporting_entities c_jg_zz_vat_rep_entities%rowtype;
1272: crec_mapping_entities c_jg_zz_vat_rep_entities%rowtype;
1273:
1274:
1275: begin

Line 1272: crec_mapping_entities c_jg_zz_vat_rep_entities%rowtype;

1268: where ledger_id = cpn_ledger_id;
1269:
1270:
1271: crec_reporting_entities c_jg_zz_vat_rep_entities%rowtype;
1272: crec_mapping_entities c_jg_zz_vat_rep_entities%rowtype;
1273:
1274:
1275: begin
1276:

Line 1328: open c_jg_zz_vat_rep_entities(ln_vat_reporting_entity_id);

1324: end if; /* pv_called_from */
1325:
1326: if ln_vat_reporting_entity_id is not null then
1327:
1328: open c_jg_zz_vat_rep_entities(ln_vat_reporting_entity_id);
1329: fetch c_jg_zz_vat_rep_entities into crec_reporting_entities;
1330: close c_jg_zz_vat_rep_entities;
1331:
1332: if crec_reporting_entities.entity_identifier is not null then

Line 1329: fetch c_jg_zz_vat_rep_entities into crec_reporting_entities;

1325:
1326: if ln_vat_reporting_entity_id is not null then
1327:
1328: open c_jg_zz_vat_rep_entities(ln_vat_reporting_entity_id);
1329: fetch c_jg_zz_vat_rep_entities into crec_reporting_entities;
1330: close c_jg_zz_vat_rep_entities;
1331:
1332: if crec_reporting_entities.entity_identifier is not null then
1333: return crec_reporting_entities.entity_identifier;

Line 1330: close c_jg_zz_vat_rep_entities;

1326: if ln_vat_reporting_entity_id is not null then
1327:
1328: open c_jg_zz_vat_rep_entities(ln_vat_reporting_entity_id);
1329: fetch c_jg_zz_vat_rep_entities into crec_reporting_entities;
1330: close c_jg_zz_vat_rep_entities;
1331:
1332: if crec_reporting_entities.entity_identifier is not null then
1333: return crec_reporting_entities.entity_identifier;
1334: end if;

Line 1348: open c_jg_zz_vat_rep_entities(ln_mapping_vat_rep_entity_id);

1344: end if;
1345:
1346:
1347: if ln_mapping_vat_rep_entity_id is not null then
1348: open c_jg_zz_vat_rep_entities(ln_mapping_vat_rep_entity_id);
1349: fetch c_jg_zz_vat_rep_entities into crec_mapping_entities;
1350: close c_jg_zz_vat_rep_entities;
1351:
1352: lv_tax_regime_code := crec_mapping_entities.tax_regime_code ;

Line 1349: fetch c_jg_zz_vat_rep_entities into crec_mapping_entities;

1345:
1346:
1347: if ln_mapping_vat_rep_entity_id is not null then
1348: open c_jg_zz_vat_rep_entities(ln_mapping_vat_rep_entity_id);
1349: fetch c_jg_zz_vat_rep_entities into crec_mapping_entities;
1350: close c_jg_zz_vat_rep_entities;
1351:
1352: lv_tax_regime_code := crec_mapping_entities.tax_regime_code ;
1353: lv_tax_registration_number := crec_mapping_entities.tax_registration_number ;

Line 1350: close c_jg_zz_vat_rep_entities;

1346:
1347: if ln_mapping_vat_rep_entity_id is not null then
1348: open c_jg_zz_vat_rep_entities(ln_mapping_vat_rep_entity_id);
1349: fetch c_jg_zz_vat_rep_entities into crec_mapping_entities;
1350: close c_jg_zz_vat_rep_entities;
1351:
1352: lv_tax_regime_code := crec_mapping_entities.tax_regime_code ;
1353: lv_tax_registration_number := crec_mapping_entities.tax_registration_number ;
1354:

Line 1399: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,

1395:
1396: /* ============================ Start of maintain_selection_entities ============================ */
1397: procedure maintain_selection_entities
1398: (
1399: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1400: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1401: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1402: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1403: xn_vat_reporting_entity_id out nocopy number,

Line 1400: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

1396: /* ============================ Start of maintain_selection_entities ============================ */
1397: procedure maintain_selection_entities
1398: (
1399: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1400: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1401: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1402: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1403: xn_vat_reporting_entity_id out nocopy number,
1404: xv_return_status out nocopy varchar2,

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

1397: procedure maintain_selection_entities
1398: (
1399: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1400: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1401: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1402: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1403: xn_vat_reporting_entity_id out nocopy number,
1404: xv_return_status out nocopy varchar2,
1405: xv_return_message out nocopy varchar2

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

1398: (
1399: pv_entity_level_code in jg_zz_vat_rep_entities.entity_level_code%type,
1400: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
1401: pn_ledger_id in jg_zz_vat_rep_entities.ledger_id%type default null,
1402: pv_balancing_segment_value in jg_zz_vat_rep_entities.balancing_segment_value%type default null,
1403: xn_vat_reporting_entity_id out nocopy number,
1404: xv_return_status out nocopy varchar2,
1405: xv_return_message out nocopy varchar2
1406: )