APPS.JG_ZZ_VAT_REP_FINAL_REPORTING dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 31: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,

27: procedure execute_final_reporting
28: (
29: xv_errbuf out nocopy varchar2, /* out parameter for concurrent program */
30: xv_retcode out nocopy varchar2, /* out parameter for concurrent program */
31: pn_vat_reporting_entity_id in jg_zz_vat_rep_entities.vat_reporting_entity_id%type,
32: pv_tax_calendar_period in gl_periods.period_name%type,
33: pv_source in varchar2
34: )
35: is

Line 43: lv_enable_allocations_flag jg_zz_vat_rep_entities.enable_allocations_flag%type;

39: ln_reporting_status_id_gl jg_zz_vat_rep_status.reporting_status_id%type;
40: lv_return_status varchar2(1);
41: lv_return_message varchar2(254);
42: ln_final_reporting_id number;
43: lv_enable_allocations_flag jg_zz_vat_rep_entities.enable_allocations_flag%type;
44:
45: /* Revised approach change */
46: ltn_application_id zx_extract_pkg.application_id_tbl;
47: ltv_entity_code zx_extract_pkg.entity_code_tbl;

Line 81: cursor c_jg_zz_vat_rep_entities (pn_vat_reporting_entity_id number) is

77: );
78:
79: /* Revised approach change */
80:
81: cursor c_jg_zz_vat_rep_entities (pn_vat_reporting_entity_id number) is
82: select enable_allocations_flag
83: from jg_zz_vat_rep_entities
84: where vat_reporting_entity_id = pn_vat_reporting_entity_id;
85:

Line 83: from jg_zz_vat_rep_entities

79: /* Revised approach change */
80:
81: cursor c_jg_zz_vat_rep_entities (pn_vat_reporting_entity_id number) is
82: select enable_allocations_flag
83: from jg_zz_vat_rep_entities
84: where vat_reporting_entity_id = pn_vat_reporting_entity_id;
85:
86: cursor c_get_final_reporting_id is
87: Select jg_zz_vat_rep_status_s3.nextval

Line 91: cur_rec_jg_zz_vat_rep_entities c_jg_zz_vat_rep_entities%rowtype;

87: Select jg_zz_vat_rep_status_s3.nextval
88: From dual;
89:
90:
91: cur_rec_jg_zz_vat_rep_entities c_jg_zz_vat_rep_entities%rowtype;
92:
93: CURSOR c_get_last_rep_period_status (pn_vat_reporting_entity_id number,pn_period varchar2) is
94: SELECT 'Y'
95: FROM JG_ZZ_VAT_REP_STATUS RPS

Line 100: FROM jg_zz_vat_rep_entities legal

96: WHERE RPS.VAT_REPORTING_ENTITY_ID= pn_vat_reporting_entity_id
97: AND RPS.TAX_CALENDAR_PERIOD = pn_period
98: AND RPS.period_start_date >
99: NVL((SELECT glp.end_date
100: FROM jg_zz_vat_rep_entities legal
101: ,jg_zz_vat_rep_entities acct
102: ,gl_periods glp
103: WHERE acct.entity_type_code='ACCOUNTING'
104: AND acct.vat_reporting_entity_id = pn_vat_reporting_entity_id

Line 101: ,jg_zz_vat_rep_entities acct

97: AND RPS.TAX_CALENDAR_PERIOD = pn_period
98: AND RPS.period_start_date >
99: NVL((SELECT glp.end_date
100: FROM jg_zz_vat_rep_entities legal
101: ,jg_zz_vat_rep_entities acct
102: ,gl_periods glp
103: WHERE acct.entity_type_code='ACCOUNTING'
104: AND acct.vat_reporting_entity_id = pn_vat_reporting_entity_id
105: AND acct.mapping_vat_rep_entity_id= legal.vat_reporting_entity_id

Line 111: l_entity_level_code JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE;

107: AND glp.period_name = acct.last_reported_period),RPS.period_start_date-1)
108: AND rownum=1;
109:
110: l_last_reoprted_status VARCHAR2(100);
111: l_entity_level_code JG_ZZ_VAT_REP_ENTITIES.entity_level_code%TYPE;
112:
113:
114: begin
115:

Line 118: FROM jg_zz_vat_rep_entities

114: begin
115:
116: SELECT entity_level_code
117: INTO l_entity_level_code
118: FROM jg_zz_vat_rep_entities
119: WHERE vat_reporting_entity_id =pn_vat_reporting_entity_id;
120:
121: IF l_entity_level_code='LEDGER' or l_entity_level_code='BSV' THEN
122:

Line 167: open c_jg_zz_vat_rep_entities(pn_vat_reporting_entity_id );

163: goto exit_from_procedure;
164: end if;
165:
166: /* Check if Allocation is disabled, if disabled this needs to be updated at final reporting */
167: open c_jg_zz_vat_rep_entities(pn_vat_reporting_entity_id );
168: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;
169: close c_jg_zz_vat_rep_entities;
170:
171: if cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag = 'X' then

Line 168: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;

164: end if;
165:
166: /* Check if Allocation is disabled, if disabled this needs to be updated at final reporting */
167: open c_jg_zz_vat_rep_entities(pn_vat_reporting_entity_id );
168: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;
169: close c_jg_zz_vat_rep_entities;
170:
171: if cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag = 'X' then
172: lv_enable_allocations_flag := 'X';

Line 169: close c_jg_zz_vat_rep_entities;

165:
166: /* Check if Allocation is disabled, if disabled this needs to be updated at final reporting */
167: open c_jg_zz_vat_rep_entities(pn_vat_reporting_entity_id );
168: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;
169: close c_jg_zz_vat_rep_entities;
170:
171: if cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag = 'X' then
172: lv_enable_allocations_flag := 'X';
173: end if;

Line 171: if cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag = 'X' then

167: open c_jg_zz_vat_rep_entities(pn_vat_reporting_entity_id );
168: fetch c_jg_zz_vat_rep_entities into cur_rec_jg_zz_vat_rep_entities;
169: close c_jg_zz_vat_rep_entities;
170:
171: if cur_rec_jg_zz_vat_rep_entities.enable_allocations_flag = 'X' then
172: lv_enable_allocations_flag := 'X';
173: end if;
174:
175: /* Revised approach change */