APPS.MSC_CL_PRE_PROCESS dependencies on MSC_GROUPS

Line 6369: FROM msc_st_groups msg,msc_groups mg

6365: msg.ATTRIBUTE12,
6366: msg.ATTRIBUTE13,
6367: msg.ATTRIBUTE14,
6368: msg.ATTRIBUTE15
6369: FROM msc_st_groups msg,msc_groups mg
6370: WHERE msg.process_flag = G_VALID
6371: AND msg.sr_instance_code = v_instance_code
6372: AND msg.batch_id = p_batch_id
6373: AND msg.group_id = mg.group_id;

Line 10011: -- The following values are mandatory in MSC_GROUPS

10007:
10008: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
10009:
10010:
10011: -- The following values are mandatory in MSC_GROUPS
10012: -- 1.Group name
10013: -- 2.Effective Date
10014: -- 3.Contact Doc URL
10015: -- 4.Group Owner Id.

Line 10181: ||' FROM MSC_GROUPS mg'

10177: 'UPDATE MSC_ST_GROUPS msg'
10178: ||' SET process_flag = '||G_ERROR_FLG||','
10179: ||' error_text = '||''''||lv_message_text||''''
10180: ||' WHERE EXISTS(SELECT 1 '
10181: ||' FROM MSC_GROUPS mg'
10182: ||' where mg.GROUP_OWNER_ID <> msg.GROUP_OWNER_ID '
10183: ||' AND mg.group_id = msg.group_id )'
10184: ||' AND group_id IS NOT NULL'
10185: ||' AND batch_id = :lv_batch_id'

Line 10323: UPDATE msc_groups

10319: IF c11%ROWCOUNT > 0 THEN
10320: v_sql_stmt := 66;
10321:
10322: FORALL j IN lb_GROUP_ID.FIRST..lb_GROUP_ID.LAST
10323: UPDATE msc_groups
10324: SET description = lb_description(j),
10325: group_type = lb_group_type(j),
10326: owner_contact = lb_contact_user_id(j),
10327: contract_doc_url = lb_contract_doc_url(j),

Line 10358: 'INSERT INTO MSC_GROUPS'

10354: --runs in the incremental mode.
10355:
10356: v_sql_stmt := 67;
10357: lv_sql_stmt :=
10358: 'INSERT INTO MSC_GROUPS'
10359: ||'( GROUP_ID ,'
10360: ||' GROUP_NAME ,'
10361: ||' DESCRIPTION ,'
10362: ||' GROUP_TYPE ,'

Line 10426: ||' FROM MSC_GROUPS mg'

10422: ||' WHERE sr_instance_code = :sr_instance_code'
10423: ||' AND batch_id = :lv_batch_id'
10424: ||' AND process_flag = '||G_VALID
10425: ||' AND NOT EXISTS( SELECT 1 '
10426: ||' FROM MSC_GROUPS mg'
10427: ||' WHERE mg.group_id = msg.group_id)';
10428:
10429:
10430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

Line 10764: ||' FROM msc_groups mg'

10760: 'UPDATE msc_st_group_companies msg'
10761: ||' SET process_flag = '||G_ERROR_FLG||','
10762: ||' error_text = '||''''||lv_message_text||''''
10763: ||' WHERE NOT EXISTS(SELECT 1 '
10764: ||' FROM msc_groups mg'
10765: ||' where mg.group_owner_id = msg.posting_party_id '
10766: ||' AND mg.group_id = msg.group_id '
10767: ||' UNION '
10768: ||' SELECT 1 '