APPS.MSC_PQ_UTILS dependencies on FND_LOBS

Line 3448: SELECT COUNT(1) INTO count_row FROM fnd_lobs WHERE file_name=filename;

3444: l_return_code:=l_return_code||' Error getting plan name for plan id: '||l_plan_id ||SQLERRM;
3445: END;
3446: filename :=plan_name||'-'||l_query_name;
3447: BEGIN
3448: SELECT COUNT(1) INTO count_row FROM fnd_lobs WHERE file_name=filename;
3449: IF count_row >0 THEN
3450: exist_flag:='Y';
3451: END IF;
3452: EXCEPTION

Line 3457: l_return_code:=l_return_code||' Too many rows in fnd_lobs for file name'|| filename;

3453: WHEN no_data_found THEN
3454: exist_flag:='N';
3455: WHEN too_many_rows THEN
3456: exist_flag:='Y';
3457: l_return_code:=l_return_code||' Too many rows in fnd_lobs for file name'|| filename;
3458: WHEN OTHERS THEN
3459: exist_flag:=NULL;
3460: l_return_code:=l_return_code||' Error for file name'|| filename||' '||SQLERRM;
3461: END;

Line 3465: DELETE FROM fnd_lobs WHERE file_name=filename;

3461: END;
3462: END IF;
3463: IF exist_flag ='Y' THEN
3464: BEGIN
3465: DELETE FROM fnd_lobs WHERE file_name=filename;
3466: exist_flag :='N';
3467: EXCEPTION
3468: WHEN OTHERS THEN
3469: exist_flag:=NULL;

Line 3547: SELECT NVL(file_id,-123) INTO wsh_id FROM fnd_lobs WHERE file_name=filename;

3543: CLOSE exp_cursor;
3544: file_open := FALSE;
3545: END IF;
3546: BEGIN
3547: SELECT NVL(file_id,-123) INTO wsh_id FROM fnd_lobs WHERE file_name=filename;
3548: EXCEPTION
3549: WHEN OTHERS THEN
3550: wsh_id:=-123;
3551: l_return_code:=l_return_code||' Error getting file id for file name After file export '|| filename||' '||SQLERRM;