185: ''''||p_master_type||''''||','||
186: 0 || ',' ||1||','||
187: p_list_header_id || ',' ||''''||
188: to_char(sysdate )|| ''''||','||
189: to_char(FND_GLOBAL.login_id )|| ',' ||''''||
190: to_char(sysdate )|| ''''||','||
191: l_created_by|| ',' ||
192: 'ams_list_entries_s.nextval' || ','||
193: 1 || ','||
913: email_address
914: )
915: ( select ams_list_entries_s.nextval,
916: sysdate,
917: fnd_global.user_id,
918: sysdate,
919: nvl(l_created_by, fnd_global.user_id),
920: fnd_global.conc_login_id,
921: p_list_header_id,
915: ( select ams_list_entries_s.nextval,
916: sysdate,
917: fnd_global.user_id,
918: sysdate,
919: nvl(l_created_by, fnd_global.user_id),
920: fnd_global.conc_login_id,
921: p_list_header_id,
922: 0,
923: 'NONE',
916: sysdate,
917: fnd_global.user_id,
918: sysdate,
919: nvl(l_created_by, fnd_global.user_id),
920: fnd_global.conc_login_id,
921: p_list_header_id,
922: 0,
923: 'NONE',
924: 'NONE',