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 1005: 'Before call to fnd_date.date_to_canonical to get canonical date format ');

1001:
1002: --Bug 5251425 : To get the taiwan specific date format.
1003: IF ( g_level_statement>= g_current_runtime_level ) THEN
1004: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1005: 'Before call to fnd_date.date_to_canonical to get canonical date format ');
1006: END IF;
1007: l_canonical_date := fnd_date.date_to_canonical(l_trx_date_tbl(i));
1008: l_roc_year := TO_NUMBER(SUBSTRB(l_canonical_date,1,4)) - 1911;
1009: l_roc_mmdd := SUBSTRB(l_canonical_date,6,5);

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

1003: IF ( g_level_statement>= g_current_runtime_level ) THEN
1004: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1005: 'Before call to fnd_date.date_to_canonical to get canonical date format ');
1006: END IF;
1007: l_canonical_date := fnd_date.date_to_canonical(l_trx_date_tbl(i));
1008: l_roc_year := TO_NUMBER(SUBSTRB(l_canonical_date,1,4)) - 1911;
1009: l_roc_mmdd := SUBSTRB(l_canonical_date,6,5);
1010: l_roc_date := TO_CHAR(l_roc_year) || '/' || l_roc_mmdd;
1011: x_trx_date_tbl(i) := to_date(l_roc_date,'YYYY/MM/DD');

Line 2427: global_attribute4 = fnd_date.date_to_canonical(sysdate)

2423:
2424: UPDATE
2425: ap_invoices
2426: SET
2427: global_attribute4 = fnd_date.date_to_canonical(sysdate)
2428: WHERE
2429: invoice_id = p_invoice_id;
2430:
2431: IF ( g_level_statement>= g_current_runtime_level ) THEN