APPS.MSC_CL_PRE_PROCESS dependencies on MSC_PLANNERS

Line 12328: ||' (SELECT 1 FROM msc_planners msp2'

12324: ||' WHERE process_flag = '||G_IN_PROCESS
12325: ||' AND batch_id = :lv_batch_id'
12326: ||' AND sr_instance_code = :v_instance_code'
12327: ||' AND EXISTS'
12328: ||' (SELECT 1 FROM msc_planners msp2'
12329: ||' WHERE msp2.organization_id = msp1.organization_id'
12330: ||' AND msp2.planner_code = msp1.planner_code'
12331: ||' AND msp2.sr_instance_id = ' ||v_instance_id ||')';
12332:

Line 12411: DELETE from MSC_PLANNERS x where

12407:
12408: BEGIN
12409:
12410: if (c_rec.deleted_flag= SYS_YES) then
12411: DELETE from MSC_PLANNERS x where
12412: x.PLANNER_CODE = c_rec.PLANNER_CODE
12413: AND x.ORGANIZATION_ID = c_rec.ORGANIZATION_ID
12414: AND x.SR_INSTANCE_ID = v_instance_id
12415: AND c_rec.deleted_flag= SYS_YES;

Line 12420: UPDATE MSC_PLANNERS x set

12416:
12417:
12418: else
12419:
12420: UPDATE MSC_PLANNERS x set
12421: DESCRIPTION =c_rec.DESCRIPTION,
12422: DISABLE_DATE =c_rec.DISABLE_DATE,
12423: ELECTRONIC_MAIL_ADDRESS =c_rec.ELECTRONIC_MAIL_ADDRESS,
12424: EMPLOYEE_ID =c_rec.EMPLOYEE_ID,

Line 12438: INSERT INTO MSC_PLANNERS

12434:
12435:
12436: IF SQL%NOTFOUND THEN
12437:
12438: INSERT INTO MSC_PLANNERS
12439: ( PLANNER_CODE,
12440: ORGANIZATION_ID,
12441: DESCRIPTION,
12442: DISABLE_DATE,

Line 12474: 'Error in Inserting or Updating into MSC_PLANNERS'|| SQLERRM, 1, 240);

12470:
12471: EXCEPTION
12472: WHEN OTHERS THEN
12473: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_PLANNERS'||
12474: 'Error in Inserting or Updating into MSC_PLANNERS'|| SQLERRM, 1, 240);
12475: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
12476: ROLLBACK;
12477: END;
12478: END LOOP;