[Home] [Help]
6408: msg.ATTRIBUTE12,
6409: msg.ATTRIBUTE13,
6410: msg.ATTRIBUTE14,
6411: msg.ATTRIBUTE15
6412: FROM msc_st_group_companies msg,msc_group_companies mg
6413: WHERE msg.process_flag = G_VALID
6414: AND msg.sr_instance_code = v_instance_code
6415: AND msg.batch_id = p_batch_id
6416: AND msg.group_id = mg.group_id
10767: IF lv_return <> 0 THEN
10768: RAISE ex_logging_err;
10769: END IF;
10770:
10771: -- Effective Date is a mandatory column in MSC_GROUP_COMPANIES , set error message
10772: lv_return :=
10773: MSC_ST_util.GET_ERROR_MESSAGE (p_app_short_name => 'MSC',
10774: p_error_code => 'MSC_PP_COL_VAL_NULL',
10775: p_message_text => lv_message_text,
11068: IF lv_return <> 0 THEN
11069: RAISE ex_logging_err;
11070: END IF;
11071:
11072: -- Updation of the record in msc_group_companies
11073: OPEN c13(lv_batch_id);
11074: FETCH c13 BULK COLLECT INTO
11075: lb_group_id,
11076: lb_company_id,
11097: IF c13%ROWCOUNT > 0 THEN
11098: v_sql_stmt := 81;
11099: FORALL j IN lb_GROUP_ID.FIRST..lb_GROUP_ID.LAST
11100:
11101: UPDATE msc_group_companies
11102: SET contact_user = lb_contact_user_id(j),
11103: effective_date = lb_effective_date(j),
11104: disable_date = lb_disable_date(j),
11105: last_update_date = v_current_date,
11130: --runs in the incremental mode.
11131:
11132: v_sql_stmt := 82;
11133: lv_sql_stmt :=
11134: 'INSERT INTO MSC_GROUP_COMPANIES'
11135: ||'( GROUP_ID ,'
11136: ||' COMPANY_ID ,'
11137: ||' EFFECTIVE_DATE ,'
11138: ||' DISABLE_DATE ,'
11189: ||' WHERE sr_instance_code = :sr_instance_code'
11190: ||' AND batch_id = :lv_batch_id'
11191: ||' AND process_flag = '||G_VALID
11192: ||' AND NOT EXISTS( SELECT 1 '
11193: ||' FROM msc_group_companies mgc'
11194: ||' WHERE mgc.group_id = msg.group_id '
11195: ||' AND mgc.company_id = msg.company_id)';
11196:
11197: