APPS.JL_AR_DOC_NUMBERING_PKG dependencies on FND_DATE

Line 288: ,global_attribute8, to_char(fnd_date.canonical_to_date(global_attribute9),'YYYY/MM/DD')

284:
285: -- Fetching the document letter,branch number, cai number, cai date
286: BEGIN
287: SELECT substr(global_attribute3,1,1),substr(global_attribute2,1,4)
288: ,global_attribute8, to_char(fnd_date.canonical_to_date(global_attribute9),'YYYY/MM/DD')
289: INTO l_doc_letter, l_branch_num, l_cai_num, l_cai_date
290: FROM ra_batch_sources
291: WHERE batch_source_id = p_batch_source_id;
292:

Line 847: SET global_attribute4 = fnd_date.date_to_canonical(l_max_trx_date)

843: arp_standard.debug('validate_interface_lines: ' || '-- update the dates');
844: END IF;
845: IF l_last_trx_date <> l_max_trx_date THEN
846: UPDATE ra_batch_sources
847: SET global_attribute4 = fnd_date.date_to_canonical(l_max_trx_date)
848: WHERE batch_source_id = l_batch_source_id;
849: END IF;
850:
851: IF l_return_code = 0 THEN