APPS.MSC_CL_PRE_PROCESS dependencies on MSC_PLANNERS

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

15811: ||' WHERE process_flag = '||G_IN_PROCESS
15812: ||' AND batch_id = :lv_batch_id'
15813: ||' AND sr_instance_code = :v_instance_code'
15814: ||' AND EXISTS'
15815: ||' (SELECT 1 FROM msc_planners msp2'
15816: ||' WHERE msp2.organization_id = msp1.organization_id'
15817: ||' AND msp2.planner_code = msp1.planner_code'
15818: ||' AND msp2.sr_instance_id = ' ||v_instance_id ||')';
15819:

Line 15898: DELETE from MSC_PLANNERS x where

15894:
15895: BEGIN
15896:
15897: if (c_rec.deleted_flag= SYS_YES) then
15898: DELETE from MSC_PLANNERS x where
15899: x.PLANNER_CODE = c_rec.PLANNER_CODE
15900: AND x.ORGANIZATION_ID = c_rec.ORGANIZATION_ID
15901: AND x.SR_INSTANCE_ID = v_instance_id
15902: AND c_rec.deleted_flag= SYS_YES;

Line 15907: UPDATE MSC_PLANNERS x set

15903:
15904:
15905: else
15906:
15907: UPDATE MSC_PLANNERS x set
15908: DESCRIPTION =c_rec.DESCRIPTION,
15909: DISABLE_DATE =c_rec.DISABLE_DATE,
15910: ELECTRONIC_MAIL_ADDRESS =c_rec.ELECTRONIC_MAIL_ADDRESS,
15911: EMPLOYEE_ID =c_rec.EMPLOYEE_ID,

Line 15925: INSERT INTO MSC_PLANNERS

15921:
15922:
15923: IF SQL%NOTFOUND THEN
15924:
15925: INSERT INTO MSC_PLANNERS
15926: ( PLANNER_CODE,
15927: ORGANIZATION_ID,
15928: DESCRIPTION,
15929: DISABLE_DATE,

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

15957:
15958: EXCEPTION
15959: WHEN OTHERS THEN
15960: lv_error_text := substr('MSC_CL_PRE_PROCESS.LOAD_PLANNERS'||
15961: 'Error in Inserting or Updating into MSC_PLANNERS'|| SQLERRM, 1, 240);
15962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
15963: ROLLBACK;
15964: END;
15965: END LOOP;