DBA Data[Home] [Help]

APPS.CTO_UPDATE_CONFIGS_PK dependencies on MRP_ASSIGNMENT_SETS

Line 200: from mrp_assignment_sets

196:
197: BEGIN
198: select assignment_set_id
199: into l_cto_aset_id
200: from mrp_assignment_sets
201: where assignment_set_name = 'CTO Configuration Updates';
202:
203: WriteToLog('CTO Seeded Assignment Set Id::'||l_cto_aset_id, 2);
204:

Line 220: INSERT INTO mrp_assignment_sets

216:
217: WriteToLog('Hence creating a assigment set', 1);
218:
219: l_stmt_num := 16;
220: INSERT INTO mrp_assignment_sets
221: (assignment_set_id ,
222: assignment_set_name,
223: description,
224: created_by,

Line 230: ( MRP_ASSIGNMENT_SETS_S.nextval,

226: creation_date,
227: last_update_date
228: )
229: VALUES
230: ( MRP_ASSIGNMENT_SETS_S.nextval,
231: 'CTO Configuration Updates',
232: 'Exclusively for use by CTO. Used during Upgrade Concurrent programs',
233: FND_GLOBAL.USER_ID,
234: FND_GLOBAL.USER_ID,