APPS.MSC_CL_PRE_PROCESS dependencies on MSC_GROUPS

Line 6376: FROM msc_st_groups msg,msc_groups mg

6372: msg.ATTRIBUTE12,
6373: msg.ATTRIBUTE13,
6374: msg.ATTRIBUTE14,
6375: msg.ATTRIBUTE15
6376: FROM msc_st_groups msg,msc_groups mg
6377: WHERE msg.process_flag = G_VALID
6378: AND msg.sr_instance_code = v_instance_code
6379: AND msg.batch_id = p_batch_id
6380: AND msg.group_id = mg.group_id;

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

10133:
10134: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
10135:
10136:
10137: -- The following values are mandatory in MSC_GROUPS
10138: -- 1.Group name
10139: -- 2.Effective Date
10140: -- 3.Contact Doc URL
10141: -- 4.Group Owner Id.

Line 10307: ||' FROM MSC_GROUPS mg'

10303: 'UPDATE MSC_ST_GROUPS msg'
10304: ||' SET process_flag = '||G_ERROR_FLG||','
10305: ||' error_text = '||''''||lv_message_text||''''
10306: ||' WHERE EXISTS(SELECT 1 '
10307: ||' FROM MSC_GROUPS mg'
10308: ||' where mg.GROUP_OWNER_ID <> msg.GROUP_OWNER_ID '
10309: ||' AND mg.group_id = msg.group_id )'
10310: ||' AND group_id IS NOT NULL'
10311: ||' AND batch_id = :lv_batch_id'

Line 10449: UPDATE msc_groups

10445: IF c11%ROWCOUNT > 0 THEN
10446: v_sql_stmt := 66;
10447:
10448: FORALL j IN lb_GROUP_ID.FIRST..lb_GROUP_ID.LAST
10449: UPDATE msc_groups
10450: SET description = lb_description(j),
10451: group_type = lb_group_type(j),
10452: owner_contact = lb_contact_user_id(j),
10453: contract_doc_url = lb_contract_doc_url(j),

Line 10484: 'INSERT INTO MSC_GROUPS'

10480: --runs in the incremental mode.
10481:
10482: v_sql_stmt := 67;
10483: lv_sql_stmt :=
10484: 'INSERT INTO MSC_GROUPS'
10485: ||'( GROUP_ID ,'
10486: ||' GROUP_NAME ,'
10487: ||' DESCRIPTION ,'
10488: ||' GROUP_TYPE ,'

Line 10552: ||' FROM MSC_GROUPS mg'

10548: ||' WHERE sr_instance_code = :sr_instance_code'
10549: ||' AND batch_id = :lv_batch_id'
10550: ||' AND process_flag = '||G_VALID
10551: ||' AND NOT EXISTS( SELECT 1 '
10552: ||' FROM MSC_GROUPS mg'
10553: ||' WHERE mg.group_id = msg.group_id)';
10554:
10555:
10556: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

Line 10890: ||' FROM msc_groups mg'

10886: 'UPDATE msc_st_group_companies msg'
10887: ||' SET process_flag = '||G_ERROR_FLG||','
10888: ||' error_text = '||''''||lv_message_text||''''
10889: ||' WHERE NOT EXISTS(SELECT 1 '
10890: ||' FROM msc_groups mg'
10891: ||' where mg.group_owner_id = msg.posting_party_id '
10892: ||' AND mg.group_id = msg.group_id '
10893: ||' UNION '
10894: ||' SELECT 1 '