APPS.JG_ZZ_VAT_ALLOC_PRC_PKG dependencies on JG_ZZ_VAT_BOX_ERRORS

Line 31: delete from jg_zz_vat_box_errors

27: ( select vat_transaction_id
28: from jg_zz_vat_trx_details a
29: where a.reporting_status_id = pn_reporting_status_id);
30:
31: delete from jg_zz_vat_box_errors
32: where vat_transaction_id in
33: ( select vat_transaction_id
34: from jg_zz_vat_trx_details a
35: where a.reporting_status_id = pn_reporting_status_id);

Line 70: INSERT INTO jg_zz_vat_box_errors(

66: ||', pn_last_updated_by:'||pn_last_updated_by
67: ||', pn_last_update_login:'||pn_last_update_login);
68: end if;
69: */
70: INSERT INTO jg_zz_vat_box_errors(
71: vat_transaction_id ,
72: allocation_error_code ,
73: period_type ,
74: creation_date ,

Line 107: UPDATE jg_zz_vat_box_errors

103: xv_return_message out nocopy varchar2
104: ) IS
105:
106: BEGIN
107: UPDATE jg_zz_vat_box_errors
108: SET allocation_error_code = pv_allocation_error_code,
109: last_updated_by = pn_last_updated_by,
110: last_update_date = sysdate,
111: last_update_login = pn_last_update_login

Line 130: DELETE FROM jg_zz_vat_box_errors

126: xv_return_message out nocopy varchar2
127: ) IS
128:
129: BEGIN
130: DELETE FROM jg_zz_vat_box_errors
131: WHERE Vat_transaction_id = pn_vat_transaction_id
132: AND allocation_error_code = pv_allocation_error_code
133: AND period_type = pv_period_type;
134:

Line 364: jg_zz_vat_box_errors err,

360: nvl(dtl.tax_amt_funcl_curr, dtl.tax_amt) tax_amount,
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

Line 502: /* Dynamic cursor that fetches data either from JG_ZZ_VAT_TRX_DETAILS or JG_ZZ_VAT_BOX_ERRORS depending

498: else /*meaning the processing for allocation errors */
499: lv_fresh_allocation_flag := g_no;
500: end if;
501:
502: /* Dynamic cursor that fetches data either from JG_ZZ_VAT_TRX_DETAILS or JG_ZZ_VAT_BOX_ERRORS depending
503: on the REALLOCATE_FLAG value
504: While looping thru transaction -
505: If the record is being processed from JG_ZZ_VAT_TRX_DETAILS, then it is processed for both period_types
506: else if the record is being processed from JG_ZZ_VAT_BOX_ERRORS, then only error period_type is processed

Line 506: else if the record is being processed from JG_ZZ_VAT_BOX_ERRORS, then only error period_type is processed

502: /* Dynamic cursor that fetches data either from JG_ZZ_VAT_TRX_DETAILS or JG_ZZ_VAT_BOX_ERRORS depending
503: on the REALLOCATE_FLAG value
504: While looping thru transaction -
505: If the record is being processed from JG_ZZ_VAT_TRX_DETAILS, then it is processed for both period_types
506: else if the record is being processed from JG_ZZ_VAT_BOX_ERRORS, then only error period_type is processed
507: */
508: l_trxs_for_alloc_csr :=
509: get_transactions_cursor(
510: pv_extract_source_ledger => lv_extract_source_ledger,

Line 760: /* Transactions with Tax Amount = 0 and source = 'AP' should not go in jg_zz_vat_box_errors table */

756: end if;
757:
758: /* allocation error found */
759: if l_trx_rec.tax_amount = 0 and l_trx_rec.extract_source_ledger = 'AP' then
760: /* Transactions with Tax Amount = 0 and source = 'AP' should not go in jg_zz_vat_box_errors table */
761: exit;
762: end if;
763:
764: if lv_fresh_allocation_flag = g_yes then