220:
221: BEGIN
222: select assignment_set_id
223: into l_cto_aset_id
224: from mrp_assignment_sets
225: where assignment_set_name = 'CTO Configuration Updates';
226:
227: WriteToLog('CTO Seeded Assignment Set Id::'||l_cto_aset_id, 2);
228:
240:
241: WriteToLog('Hence creating a assigment set', 1);
242:
243: l_stmt_num := 16;
244: INSERT INTO mrp_assignment_sets
245: (assignment_set_id ,
246: assignment_set_name,
247: description,
248: created_by,
250: creation_date,
251: last_update_date
252: )
253: VALUES
254: ( MRP_ASSIGNMENT_SETS_S.nextval,
255: 'CTO Configuration Updates',
256: 'Exclusively for use by CTO. Used during Upgrade Concurrent programs',
257: FND_GLOBAL.USER_ID,
258: FND_GLOBAL.USER_ID,
805: --Bugfix 6710393
806: BEGIN
807: select assignment_set_id
808: into l_cto_aset_id
809: from mrp_assignment_sets
810: where assignment_set_name = 'CTO Configuration Updates';
811:
812: --WriteToLog('CTO Seeded Assignment Set Id::'||l_cto_aset_id, 2);
813: