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 170: lv_allocation_status_flag jg_zz_vat_rep_status.allocation_status_flag%TYPE;

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

Line 171: lv_curr_allocation_status jg_zz_vat_rep_status.allocation_status_flag%TYPE;

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

Line 176: ln_rep_status_id jg_zz_vat_rep_status.reporting_status_id%TYPE;

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

Line 177: ln_rep_status_id_ap jg_zz_vat_rep_status.reporting_status_id%TYPE;

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

Line 178: ln_rep_status_id_ar jg_zz_vat_rep_status.reporting_status_id%TYPE;

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

Line 179: ln_rep_status_id_gl jg_zz_vat_rep_status.reporting_status_id%TYPE;

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

Line 194: lv_return_flag jg_zz_vat_rep_status.allocation_status_flag%TYPE;

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

Line 273: FROM jg_zz_vat_trx_details dtl, jg_zz_vat_rep_status status

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

Line 329: FROM jg_zz_vat_trx_details dtl, jg_zz_vat_rep_status status

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

Line 365: jg_zz_vat_rep_status status

361: err.allocation_error_code allocation_error_code,
362: err.period_type period_type
363: FROM jg_zz_vat_trx_details dtl,
364: jg_zz_vat_box_errors err,
365: jg_zz_vat_rep_status status
366: WHERE status.reporting_status_id = dtl.reporting_status_id
367: AND dtl.vat_transaction_id = err.vat_transaction_id
368: AND status.vat_reporting_entity_id = pn_vat_reporting_entity_id
369: AND status.tax_calendar_period = pv_tax_period_name

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

903: lv_allocation_status_flag := fnd_api.g_ret_sts_success;
904: end if;
905:
906: if ln_allocation_process_id is null then
907: select jg_zz_vat_rep_status_s2.nextval into ln_allocation_process_id from dual;
908: end if;
909: lv_return_flag := null;
910: lv_return_message := null;
911:

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

912: if gv_debug_flag then
913: fnd_file.put_line(fnd_file.log, 'run allocation - before jg_zz_vat_rep_utility.post_process_update.'
914: );
915: end if;
916: /* Call the utility API to update allocation_process columns of jg_zz_vat_rep_status table by passing proper values.*/
917: jg_zz_vat_rep_utility.post_process_update(
918: pn_vat_reporting_entity_id => pn_vat_reporting_entity_id,
919: pv_tax_calendar_period => pv_tax_calendar_period,
920: pv_source => lv_extract_source_ledger,

Line 1311: from jg_zz_vat_rep_status a

1307: pn_reporting_status_id NUMBER
1308: ) return varchar2 IS
1309: cursor c_get_allocation_status is
1310: select nvl(allocation_status_flag, g_no) allocation_status
1311: from jg_zz_vat_rep_status a
1312: where a.reporting_status_id = pn_reporting_status_id;
1313:
1314: lv_allocation_status jg_zz_vat_rep_status.allocation_status_flag%TYPE;
1315:

Line 1314: lv_allocation_status jg_zz_vat_rep_status.allocation_status_flag%TYPE;

1310: select nvl(allocation_status_flag, g_no) allocation_status
1311: from jg_zz_vat_rep_status a
1312: where a.reporting_status_id = pn_reporting_status_id;
1313:
1314: lv_allocation_status jg_zz_vat_rep_status.allocation_status_flag%TYPE;
1315:
1316: begin
1317: if gv_debug_flag then
1318: fnd_file.put_line(fnd_file.log, 'get_allocation_status - start ->'||lv_allocation_status );