APPS.JG_ZZ_VAT_REP_FINAL_REPORTING dependencies on JG_ZZ_VAT_TRX_DETAILS

Line 57: cursor c_jg_zz_vat_trx_details

53:
54: ln_msg_count number;
55: lv_msg_data varchar2(254);
56:
57: cursor c_jg_zz_vat_trx_details
58: (cpn_vat_reporting_entity_id number, cpv_tax_calendar_period varchar2, cpv_source varchar2) is
59: select
60: application_id ,
61: entity_code ,

Line 68: jg_zz_vat_trx_details

64: trx_line_id ,
65: internal_organization_id ,
66: tax_line_id
67: from
68: jg_zz_vat_trx_details
69: where
70: reporting_status_id in
71: (
72: select reporting_status_id

Line 176: open c_jg_zz_vat_trx_details(pn_vat_reporting_entity_id, pv_tax_calendar_period, pv_source);

172: lv_enable_allocations_flag := 'X';
173: end if;
174:
175: /* Revised approach change */
176: open c_jg_zz_vat_trx_details(pn_vat_reporting_entity_id, pv_tax_calendar_period, pv_source);
177: fetch c_jg_zz_vat_trx_details bulk collect into
178: ltn_application_id ,
179: ltv_entity_code ,
180: ltv_event_class_code ,

Line 177: fetch c_jg_zz_vat_trx_details bulk collect into

173: end if;
174:
175: /* Revised approach change */
176: open c_jg_zz_vat_trx_details(pn_vat_reporting_entity_id, pv_tax_calendar_period, pv_source);
177: fetch c_jg_zz_vat_trx_details bulk collect into
178: ltn_application_id ,
179: ltv_entity_code ,
180: ltv_event_class_code ,
181: ltn_trx_id ,

Line 185: close c_jg_zz_vat_trx_details;

181: ltn_trx_id ,
182: ltn_trx_line_id ,
183: ltn_internal_organization_id ,
184: ltn_tax_line_id ;
185: close c_jg_zz_vat_trx_details;
186:
187:
188: /* Call the eBtax API to update transactions in eBtax as finally reported */
189: zx_extract_pkg.zx_upd_legal_reporting_status

Line 218: update jg_zz_vat_trx_details

214: open c_get_final_reporting_id;
215: fetch c_get_final_reporting_id into ln_final_reporting_id;
216: close c_get_final_reporting_id;
217:
218: update jg_zz_vat_trx_details
219: set final_reporting_id = ln_final_reporting_id,
220: last_updated_by = fnd_global.user_id,
221: last_update_date = trunc(sysdate),
222: last_update_login = fnd_global.login_id