DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on PSP_GMS_BATCH_NAME_S

Line 5310: /***** SELECT to_char(psp_gms_batch_name_s.nextval)

5306: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' operating_unit_csr operating_unit_csr%rowcount'||operating_unit_csr%rowcount);
5307: CLOSE operating_unit_csr;
5308:
5309:
5310: /***** SELECT to_char(psp_gms_batch_name_s.nextval)
5311: INTO g_gms_batch_name --- replaced with global for 3473294
5312: FROM dual; *****/
5313:
5314: FOR I in 1..org_id_tab.count

Line 5316: SELECT to_char(psp_gms_batch_name_s.nextval)

5312: FROM dual; *****/
5313:
5314: FOR I in 1..org_id_tab.count
5315: LOOP
5316: SELECT to_char(psp_gms_batch_name_s.nextval)
5317: INTO gms_batch_name_tab(i)
5318: FROM dual;
5319: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' gms_batch_name_tab(' || I || '): ' || gms_batch_name_tab(i));
5320: END LOOP;