APPS.ZX_JA_EXTRACT_PKG dependencies on FND_DATE

Line 312: lp_where_export_date_from:= ' and fnd_date.canonical_to_date(rct.global_attribute8) >= ' ||

308: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWRZTR' then
309: /* Taiwanese Receivables Zero-Rate Tax Report */
310:
311: if P_TRL_GLOBAL_VARIABLES_REC.EXP_CERT_DATE_FROM is NOT NULL then
312: lp_where_export_date_from:= ' and fnd_date.canonical_to_date(rct.global_attribute8) >= ' ||
313: P_TRL_GLOBAL_VARIABLES_REC.exp_cert_date_from ;
314: end if;
315:
316: if P_TRL_GLOBAL_VARIABLES_REC.EXP_CERT_DATE_TO is NOT NULL then

Line 317: lp_where_export_date_to:= ' and fnd_date.canonical_to_date(rct.global_attribute8) <= ' ||

313: P_TRL_GLOBAL_VARIABLES_REC.exp_cert_date_from ;
314: end if;
315:
316: if P_TRL_GLOBAL_VARIABLES_REC.EXP_CERT_DATE_TO is NOT NULL then
317: lp_where_export_date_to:= ' and fnd_date.canonical_to_date(rct.global_attribute8) <= ' ||
318: P_TRL_GLOBAL_VARIABLES_REC.exp_cert_date_to ;
319: end if;
320:
321: if P_TRL_GLOBAL_VARIABLES_REC.EXP_METHOD is NOT NULL then

Line 990: 'Before call to fnd_date.date_to_canonical to get canonical date format ');

986:
987: --Bug 5251425 : To get the taiwan specific date format.
988: IF ( g_level_statement>= g_current_runtime_level ) THEN
989: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
990: 'Before call to fnd_date.date_to_canonical to get canonical date format ');
991: END IF;
992: l_canonical_date := fnd_date.date_to_canonical(l_trx_date_tbl(i));
993: l_roc_year := TO_NUMBER(SUBSTRB(l_canonical_date,1,4)) - 1911;
994: l_roc_mmdd := SUBSTRB(l_canonical_date,6,5);

Line 992: l_canonical_date := fnd_date.date_to_canonical(l_trx_date_tbl(i));

988: IF ( g_level_statement>= g_current_runtime_level ) THEN
989: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
990: 'Before call to fnd_date.date_to_canonical to get canonical date format ');
991: END IF;
992: l_canonical_date := fnd_date.date_to_canonical(l_trx_date_tbl(i));
993: l_roc_year := TO_NUMBER(SUBSTRB(l_canonical_date,1,4)) - 1911;
994: l_roc_mmdd := SUBSTRB(l_canonical_date,6,5);
995: l_roc_date := TO_CHAR(l_roc_year) || '/' || l_roc_mmdd;
996: x_trx_date_tbl(i) := to_date(l_roc_date,'YYYY/MM/DD');

Line 2354: global_attribute4 = fnd_date.date_to_canonical(sysdate)

2350:
2351: UPDATE
2352: ap_invoices
2353: SET
2354: global_attribute4 = fnd_date.date_to_canonical(sysdate)
2355: WHERE
2356: invoice_id = p_invoice_id;
2357:
2358: IF ( g_level_statement>= g_current_runtime_level ) THEN