[Home] [Help]
29: ***************************************************************/
30:
31: CURSOR cur_max_batch_id IS
32: SELECT MAX(batch_id)
33: FROM igs_ad_imp_batch_det
34: WHERE created_by = FND_GLOBAL.USER_ID;
35: l_max_batch_id NUMBER;
36:
37: CURSOR cur_chk_batch (cp_batch_id igs_ad_interface_ctl.batch_id%TYPE) IS
106: CLOSE cur_user_name;
107:
108: l_batch_desc := 'Quick Entry Batch Created For '||Substr(l_user_name,1,20) ||' on ' || sysdate;
109:
110: INSERT INTO igs_ad_imp_batch_det (
111: batch_id,
112: batch_desc,
113: created_by,
114: creation_date,