APPS.OE_SET_UTIL dependencies on FND_PROFILE

Line 6271: IF NVL(FND_PROFILE.VALUE('ONT_SET_FOR_EACH_LINE'),'N') = 'N' THEN

6267: IF l_debug_level > 0 THEN
6268: oe_debug_pub.add( 'INTO SYSTEM SET' , 1 ) ;
6269: END IF;
6270:
6271: IF NVL(FND_PROFILE.VALUE('ONT_SET_FOR_EACH_LINE'),'N') = 'N' THEN
6272:
6273: -- Check if the system set is already created
6274: OPEN C4;
6275: FETCH C4 into l_set_id;

Line 6335: IF NVL(FND_PROFILE.VALUE('ONT_SET_FOR_EACH_LINE'),'N') = 'N' THEN

6331:
6332: END IF; -- lSet_id is not null
6333:
6334: IF l_set_id is null THEN
6335: IF NVL(FND_PROFILE.VALUE('ONT_SET_FOR_EACH_LINE'),'N') = 'N' THEN
6336: OPEN C1;
6337: FETCH C1 INTO lsettempname;
6338: CLOSE C1;
6339: END IF;

Line 6341: IF NVL(FND_PROFILE.VALUE('ONT_SET_FOR_EACH_LINE'),'N') = 'N' THEN

6337: FETCH C1 INTO lsettempname;
6338: CLOSE C1;
6339: END IF;
6340: IF lsettempname IS NULL THEN
6341: IF NVL(FND_PROFILE.VALUE('ONT_SET_FOR_EACH_LINE'),'N') = 'N' THEN
6342: lsettempname := 1;
6343: LOOP
6344: OPEN C3;
6345: FETCH C3 INTO tempname;