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_ALLOC_PRC_PKG dependencies on JG_ZZ_VAT_REP_STATUS

Line 171: lv_allocation_status_flag jg_zz_vat_rep_status.allocation_status_flag%TYPE;

167: ln_errors_conc_request_id NUMBER(15);
168: lb_ret_value BOOLEAN;
169:
170: ln_allocation_process_id NUMBER(15);
171: lv_allocation_status_flag jg_zz_vat_rep_status.allocation_status_flag%TYPE;
172: lv_curr_allocation_status jg_zz_vat_rep_status.allocation_status_flag%TYPE;
173:
174: /*indicates for how many products the allocation has to happen. will be initialized in code */
175: ln_source_iterations number(1);

Line 172: lv_curr_allocation_status jg_zz_vat_rep_status.allocation_status_flag%TYPE;

168: lb_ret_value BOOLEAN;
169:
170: ln_allocation_process_id NUMBER(15);
171: lv_allocation_status_flag jg_zz_vat_rep_status.allocation_status_flag%TYPE;
172: lv_curr_allocation_status jg_zz_vat_rep_status.allocation_status_flag%TYPE;
173:
174: /*indicates for how many products the allocation has to happen. will be initialized in code */
175: ln_source_iterations number(1);
176: ln_period_type_iterations number(1);

Line 177: ln_rep_status_id jg_zz_vat_rep_status.reporting_status_id%TYPE;

173:
174: /*indicates for how many products the allocation has to happen. will be initialized in code */
175: ln_source_iterations number(1);
176: ln_period_type_iterations number(1);
177: ln_rep_status_id jg_zz_vat_rep_status.reporting_status_id%TYPE;
178: ln_rep_status_id_ap jg_zz_vat_rep_status.reporting_status_id%TYPE;
179: ln_rep_status_id_ar jg_zz_vat_rep_status.reporting_status_id%TYPE;
180: ln_rep_status_id_gl jg_zz_vat_rep_status.reporting_status_id%TYPE;
181: lv_period_type jg_zz_vat_box_allocs.period_type%TYPE;

Line 178: ln_rep_status_id_ap jg_zz_vat_rep_status.reporting_status_id%TYPE;

174: /*indicates for how many products the allocation has to happen. will be initialized in code */
175: ln_source_iterations number(1);
176: ln_period_type_iterations number(1);
177: ln_rep_status_id jg_zz_vat_rep_status.reporting_status_id%TYPE;
178: ln_rep_status_id_ap jg_zz_vat_rep_status.reporting_status_id%TYPE;
179: ln_rep_status_id_ar jg_zz_vat_rep_status.reporting_status_id%TYPE;
180: ln_rep_status_id_gl jg_zz_vat_rep_status.reporting_status_id%TYPE;
181: lv_period_type jg_zz_vat_box_allocs.period_type%TYPE;
182: lv_financial_document_type jg_zz_vat_alloc_rules.financial_document_type%TYPE;

Line 179: ln_rep_status_id_ar jg_zz_vat_rep_status.reporting_status_id%TYPE;

175: ln_source_iterations number(1);
176: ln_period_type_iterations number(1);
177: ln_rep_status_id jg_zz_vat_rep_status.reporting_status_id%TYPE;
178: ln_rep_status_id_ap jg_zz_vat_rep_status.reporting_status_id%TYPE;
179: ln_rep_status_id_ar jg_zz_vat_rep_status.reporting_status_id%TYPE;
180: ln_rep_status_id_gl jg_zz_vat_rep_status.reporting_status_id%TYPE;
181: lv_period_type jg_zz_vat_box_allocs.period_type%TYPE;
182: lv_financial_document_type jg_zz_vat_alloc_rules.financial_document_type%TYPE;
183:

Line 180: ln_rep_status_id_gl jg_zz_vat_rep_status.reporting_status_id%TYPE;

176: ln_period_type_iterations number(1);
177: ln_rep_status_id jg_zz_vat_rep_status.reporting_status_id%TYPE;
178: ln_rep_status_id_ap jg_zz_vat_rep_status.reporting_status_id%TYPE;
179: ln_rep_status_id_ar jg_zz_vat_rep_status.reporting_status_id%TYPE;
180: ln_rep_status_id_gl jg_zz_vat_rep_status.reporting_status_id%TYPE;
181: lv_period_type jg_zz_vat_box_allocs.period_type%TYPE;
182: lv_financial_document_type jg_zz_vat_alloc_rules.financial_document_type%TYPE;
183:
184: lv_fresh_allocation_flag varchar2(1);

Line 195: lv_return_flag jg_zz_vat_rep_status.allocation_status_flag%TYPE;

191: lv_taxable_box jg_zz_vat_box_allocs.taxable_box%TYPE;
192: ln_vat_box_allocation_id jg_zz_vat_box_allocs.vat_box_allocation_id%TYPE;
193: lv_check_alloc_trans number(15);
194:
195: lv_return_flag jg_zz_vat_rep_status.allocation_status_flag%TYPE;
196: lv_return_message VARCHAR2(1996);
197: ln_allocated_cnt NUMBER;
198: ln_del_errored_cnt NUMBER;
199: ln_upd_errored_cnt NUMBER;

Line 275: FROM jg_zz_vat_trx_details dtl, jg_zz_vat_rep_status status

271: dtl.tax_rate_vat_trx_type_code vat_trans_type,
272: nvl(dtl.tax_amt_funcl_curr, dtl.tax_amt) tax_amount,
273: NULL allocation_error_code,
274: NULL period_type
275: FROM jg_zz_vat_trx_details dtl, jg_zz_vat_rep_status status
276: WHERE status.reporting_status_id = dtl.reporting_status_id
277: AND status.vat_reporting_entity_id = pn_vat_reporting_entity_id
278: AND status.tax_calendar_period = cp_period_name
279: AND dtl.extract_source_ledger = cp_source

Line 332: FROM jg_zz_vat_trx_details dtl, jg_zz_vat_rep_status status

328: dtl.tax_rate_vat_trx_type_code vat_trans_type,
329: nvl(dtl.tax_amt_funcl_curr, dtl.tax_amt) tax_amount,
330: NULL allocation_error_code,
331: NULL period_type
332: FROM jg_zz_vat_trx_details dtl, jg_zz_vat_rep_status status
333: WHERE status.reporting_status_id = dtl.reporting_status_id
334: AND status.vat_reporting_entity_id = pn_vat_reporting_entity_id
335: AND status.tax_calendar_period = pv_tax_period_name
336: AND dtl.extract_source_ledger = pv_extract_source_ledger

Line 369: jg_zz_vat_rep_status status

365: err.allocation_error_code allocation_error_code,
366: err.period_type period_type
367: FROM jg_zz_vat_trx_details dtl,
368: jg_zz_vat_box_errors err,
369: jg_zz_vat_rep_status status
370: WHERE status.reporting_status_id = dtl.reporting_status_id
371: AND dtl.vat_transaction_id = err.vat_transaction_id
372: AND status.vat_reporting_entity_id = pn_vat_reporting_entity_id
373: AND status.tax_calendar_period = pv_tax_period_name

Line 969: select jg_zz_vat_rep_status_s2.nextval into ln_allocation_process_id from dual;

965: lv_allocation_status_flag := fnd_api.g_ret_sts_success;
966: end if;
967:
968: if ln_allocation_process_id is null then
969: select jg_zz_vat_rep_status_s2.nextval into ln_allocation_process_id from dual;
970: end if;
971: lv_return_flag := null;
972: lv_return_message := null;
973:

Line 978: /* Call the utility API to update allocation_process columns of jg_zz_vat_rep_status table by passing proper values.*/

974: if gv_debug_flag then
975: fnd_file.put_line(fnd_file.log, 'run allocation - before jg_zz_vat_rep_utility.post_process_update.'
976: );
977: end if;
978: /* Call the utility API to update allocation_process columns of jg_zz_vat_rep_status table by passing proper values.*/
979: jg_zz_vat_rep_utility.post_process_update(
980: pn_vat_reporting_entity_id => pn_vat_reporting_entity_id,
981: pv_tax_calendar_period => pv_tax_calendar_period,
982: pv_source => lv_extract_source_ledger,

Line 1511: from jg_zz_vat_rep_status a

1507: pn_reporting_status_id NUMBER
1508: ) return varchar2 IS
1509: cursor c_get_allocation_status is
1510: select nvl(allocation_status_flag, g_no) allocation_status
1511: from jg_zz_vat_rep_status a
1512: where a.reporting_status_id = pn_reporting_status_id;
1513:
1514: lv_allocation_status jg_zz_vat_rep_status.allocation_status_flag%TYPE;
1515:

Line 1514: lv_allocation_status jg_zz_vat_rep_status.allocation_status_flag%TYPE;

1510: select nvl(allocation_status_flag, g_no) allocation_status
1511: from jg_zz_vat_rep_status a
1512: where a.reporting_status_id = pn_reporting_status_id;
1513:
1514: lv_allocation_status jg_zz_vat_rep_status.allocation_status_flag%TYPE;
1515:
1516: begin
1517: if gv_debug_flag then
1518: fnd_file.put_line(fnd_file.log, 'get_allocation_status - start ->'||lv_allocation_status );