DBA Data[Home] [Help]

APPS.JA_INTERFACE_VAL dependencies on FND_DATE

Line 388: SELECT fnd_date.canonical_to_date(p_global_attribute2)

384:
385: -- Check if Tax Invoice Date is of Standard Date Format
386:
387: BEGIN
388: SELECT fnd_date.canonical_to_date(p_global_attribute2)
389: INTO l_tax_inv_date
390: FROM dual;
391: EXCEPTION
392: WHEN OTHERS THEN

Line 443: and end_date >= fnd_date.canonical_to_date(p_global_attribute2));

439: where application_id=200
440: and set_of_books_id = p_set_of_books_id
441: and closing_status in ('O','F')
442: and adjustment_period_flag = 'N'
443: and end_date >= fnd_date.canonical_to_date(p_global_attribute2));
444: EXCEPTION
445: WHEN OTHERS THEN
446: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
447: p_parent_id,

Line 560: X_temp := fnd_date.canonical_to_date(p_global_attribute4);

556: /*
557: DECLARE
558: X_temp varchar2(30);
559: BEGIN
560: X_temp := fnd_date.canonical_to_date(p_global_attribute4);
561: EXCEPTION
562: WHEN OTHERS THEN
563: jg_globe_flex_val_shared.insert_rejections('AP_INVOICES_INTERFACE',
564: p_parent_id,