APPS.JL_AR_DOC_NUMBERING_PKG dependencies on FND_DATE

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

277:
278: -- Fetching the document letter,branch number, cai number, cai date
279: BEGIN
280: SELECT substr(global_attribute3,1,1),substr(global_attribute2,1,4)
281: ,global_attribute8, to_char(fnd_date.canonical_to_date(global_attribute9),'YYYY/MM/DD')
282: INTO l_doc_letter, l_branch_num, l_cai_num, l_cai_date
283: FROM ra_batch_sources
284: WHERE batch_source_id = p_batch_source_id;
285:

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

829: arp_standard.debug('validate_interface_lines: ' || '-- update the dates');
830: END IF;
831: IF l_last_trx_date <> l_max_trx_date THEN
832: UPDATE ra_batch_sources
833: SET global_attribute4 = fnd_date.date_to_canonical(l_max_trx_date)
834: WHERE batch_source_id = l_batch_source_id;
835: END IF;
836:
837: IF l_return_code = 0 THEN