192:
193: -- select members of the disjunction
194: CURSOR period_cursor( p_disj_id IN NUMBER ) IS
195: SELECT PER.concurrent_period_name, PER.rowid
196: FROM fnd_conc_release_periods PER,
197: fnd_conc_rel_disj_members MEMB
198: WHERE PER.application_id = 101
199: AND MEMB.disjunction_application_id = 101
200: AND MEMB.disjunction_id = p_disj_id
236: FNDCP_SCH.Disj_Dismember( 'SQLGL', disj_name,
237: 'SQLGL', per_name, 'P' );
238:
239: -- disable member period of the disjunction
240: -- UPDATE fnd_conc_release_periods PER
241: -- SET PER.enabled_flag = 'N'
242: -- WHERE PER.rowid = my_rowid2;
243:
244: -- IF ( SQL%NOTFOUND ) THEN
241: -- SET PER.enabled_flag = 'N'
242: -- WHERE PER.rowid = my_rowid2;
243:
244: -- IF ( SQL%NOTFOUND ) THEN
245: -- -2 : Update failed on fnd_conc_release_periods
246: -- return_code := -2;
247: -- RAISE NO_UPDATE;
248: -- END IF;
249: