DBA Data[Home] [Help]

APPS.CTO_UPDATE_CONFIGS_PK dependencies on MRP_ASSIGNMENT_SETS

Line 224: from mrp_assignment_sets

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:

Line 244: INSERT INTO mrp_assignment_sets

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,

Line 254: ( MRP_ASSIGNMENT_SETS_S.nextval,

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,

Line 809: from mrp_assignment_sets

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: