[Home] [Help]
6401: msg.ATTRIBUTE12,
6402: msg.ATTRIBUTE13,
6403: msg.ATTRIBUTE14,
6404: msg.ATTRIBUTE15
6405: FROM msc_st_group_companies msg,msc_group_companies mg
6406: WHERE msg.process_flag = G_VALID
6407: AND msg.sr_instance_code = v_instance_code
6408: AND msg.batch_id = p_batch_id
6409: AND msg.group_id = mg.group_id
10641: IF lv_return <> 0 THEN
10642: RAISE ex_logging_err;
10643: END IF;
10644:
10645: -- Effective Date is a mandatory column in MSC_GROUP_COMPANIES , set error message
10646: lv_return :=
10647: MSC_ST_util.GET_ERROR_MESSAGE (p_app_short_name => 'MSC',
10648: p_error_code => 'MSC_PP_COL_VAL_NULL',
10649: p_message_text => lv_message_text,
10942: IF lv_return <> 0 THEN
10943: RAISE ex_logging_err;
10944: END IF;
10945:
10946: -- Updation of the record in msc_group_companies
10947: OPEN c13(lv_batch_id);
10948: FETCH c13 BULK COLLECT INTO
10949: lb_group_id,
10950: lb_company_id,
10971: IF c13%ROWCOUNT > 0 THEN
10972: v_sql_stmt := 81;
10973: FORALL j IN lb_GROUP_ID.FIRST..lb_GROUP_ID.LAST
10974:
10975: UPDATE msc_group_companies
10976: SET contact_user = lb_contact_user_id(j),
10977: effective_date = lb_effective_date(j),
10978: disable_date = lb_disable_date(j),
10979: last_update_date = v_current_date,
11004: --runs in the incremental mode.
11005:
11006: v_sql_stmt := 82;
11007: lv_sql_stmt :=
11008: 'INSERT INTO MSC_GROUP_COMPANIES'
11009: ||'( GROUP_ID ,'
11010: ||' COMPANY_ID ,'
11011: ||' EFFECTIVE_DATE ,'
11012: ||' DISABLE_DATE ,'
11063: ||' WHERE sr_instance_code = :sr_instance_code'
11064: ||' AND batch_id = :lv_batch_id'
11065: ||' AND process_flag = '||G_VALID
11066: ||' AND NOT EXISTS( SELECT 1 '
11067: ||' FROM msc_group_companies mgc'
11068: ||' WHERE mgc.group_id = msg.group_id '
11069: ||' AND mgc.company_id = msg.company_id)';
11070:
11071: