DBA Data[Home] [Help]

APPS.PO_EDA_IDX_FILE_GEN dependencies on PO_EDA_CLM_DOC_NBR_V

Line 617: SELECT ismod INTO l_base_or_mod FROM po_eda_clm_doc_nbr_v WHERE CLM_DOCUMENT_NUMBER = l_doc_numbers(i);

613:
614: FOR i IN l_batch_start..l_batch_end LOOP
615:
616: fnd_file.put_line(FND_FILE.LOG,'CLM Document Numbers ' || l_doc_numbers(i));
617: SELECT ismod INTO l_base_or_mod FROM po_eda_clm_doc_nbr_v WHERE CLM_DOCUMENT_NUMBER = l_doc_numbers(i);
618: p_timestamp := To_Char(SYSDATE,'YYYYMMDDHH24MISSSSS');
619: fnd_file.put_line(FND_FILE.LOG,'Time Stamp '||p_timestamp);
620:
621: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');

Line 737: SELECT ismod INTO l_base_or_mod FROM po_eda_clm_doc_nbr_v WHERE CLM_DOCUMENT_NUMBER = l_doc_numbers(i);

733:
734: FOR i IN l_batch_start..l_batch_end LOOP
735:
736: fnd_file.put_line(FND_FILE.LOG,'CLM Document Numbers ' || l_doc_numbers(i));
737: SELECT ismod INTO l_base_or_mod FROM po_eda_clm_doc_nbr_v WHERE CLM_DOCUMENT_NUMBER = l_doc_numbers(i);
738: p_timestamp := To_Char(SYSDATE,'YYYYMMDDHH24MISSSSS');
739: fnd_file.put_line(FND_FILE.LOG,'Time Stamp '||p_timestamp);
740:
741: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------');