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.JAI_AP_DTC_GENERATION_PKG dependencies on JAI_AP_TDS_DEFAULT

Line 278: 1).exists in jai_ap_tds_default but not in ap_invoice_distributions_all.

274: --Added by Chong.lei for Bug#13782492 on 20120301 begin
275: --------------------------------------------------------------------
276: /*Given invoice_id, check all distriutions line in this invoice
277: count distribution line:
278: 1).exists in jai_ap_tds_default but not in ap_invoice_distributions_all.
279: 2).exists in ap_invoice_distributions_all but not in jai_ap_tds_default.
280: 3).both exist in this two tables but with diff accounting date.
281:
282: return pn_diff > 0, then need redefaultation.

Line 279: 2).exists in ap_invoice_distributions_all but not in jai_ap_tds_default.

275: --------------------------------------------------------------------
276: /*Given invoice_id, check all distriutions line in this invoice
277: count distribution line:
278: 1).exists in jai_ap_tds_default but not in ap_invoice_distributions_all.
279: 2).exists in ap_invoice_distributions_all but not in jai_ap_tds_default.
280: 3).both exist in this two tables but with diff accounting date.
281:
282: return pn_diff > 0, then need redefaultation.
283: */

Line 290: 1).exists in jai_ap_tds_default but not in ap_invoice_distributions_all.

286: pn_cnt out nocopy number
287: )is
288: --PRAGMA AUTONOMOUS_TRANSACTION; --commented by Cholei for ZX integration bug#14040855
289: /*Check distribution line:
290: 1).exists in jai_ap_tds_default but not in ap_invoice_distributions_all.
291: 2).exists in ap_invoice_distributions_all but not in jai_ap_tds_default.
292: 3).both exist in this two tables but with diff accounting date.
293: */
294: cursor c_changed_acdate(cn_invoice_id number)

Line 291: 2).exists in ap_invoice_distributions_all but not in jai_ap_tds_default.

287: )is
288: --PRAGMA AUTONOMOUS_TRANSACTION; --commented by Cholei for ZX integration bug#14040855
289: /*Check distribution line:
290: 1).exists in jai_ap_tds_default but not in ap_invoice_distributions_all.
291: 2).exists in ap_invoice_distributions_all but not in jai_ap_tds_default.
292: 3).both exist in this two tables but with diff accounting date.
293: */
294: cursor c_changed_acdate(cn_invoice_id number)
295: is

Line 299: from jai_ap_tds_default jatd full outer join

295: is
296: select sum(
297: decode(to_char(trunc(aida.accounting_date),'YYYYMMDD'), to_char(trunc(jatd.accounting_date),'YYYYMMDD'), 0, 1)
298: )
299: from jai_ap_tds_default jatd full outer join
300: ap_invoice_distributions_all aida on (
301: jatd.invoice_distribution_id = aida.invoice_distribution_id
302: and jatd.invoice_id = aida.invoice_id
303: )

Line 3109: ,cp_tds_section_code jai_ap_tds_default.TDS_SECTION_CODE%TYPE

3105: where invoice_id = p_invoice_id
3106: and match_type <> 'NOT_MATCHED';
3107:
3108: cursor c_check_effective_date(cp_legal_entity_id JAI_AP_TDS_THHOLD_ACCOUNT.LEGAL_ENTITY_ID%TYPE
3109: ,cp_tds_section_code jai_ap_tds_default.TDS_SECTION_CODE%TYPE
3110: ,cp_natural_account_value jai_ap_tds_default.natural_account_value%TYPE
3111: ,cp_accounting_date DATE
3112: ) is
3113: select 1

Line 3110: ,cp_natural_account_value jai_ap_tds_default.natural_account_value%TYPE

3106: and match_type <> 'NOT_MATCHED';
3107:
3108: cursor c_check_effective_date(cp_legal_entity_id JAI_AP_TDS_THHOLD_ACCOUNT.LEGAL_ENTITY_ID%TYPE
3109: ,cp_tds_section_code jai_ap_tds_default.TDS_SECTION_CODE%TYPE
3110: ,cp_natural_account_value jai_ap_tds_default.natural_account_value%TYPE
3111: ,cp_accounting_date DATE
3112: ) is
3113: select 1
3114: from JAI_DTC_SCTN_ACCOUNT_MAPPING jdsam