eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_RESOURCE_CHANGES

Line 989: ||' on MSC_ST_RESOURCE_CHANGES '

985: application_short_name => 'MSC',
986: statement_type => AD_DDL.CREATE_INDEX,
987: statement =>
988: 'create index MSC_ST_RES_CHANGES_N1_'||v_instance_code
989: ||' on MSC_ST_RESOURCE_CHANGES '
990: ||'(sr_instance_code, simulation_set, resource_code, department_code, from_date, shift_name, organization_code, company_name) '
991: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
992: object_name =>'MSC_ST_RES_CHANGES_N1_'||v_instance_code);
993:

Line 1004: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_CHANGES', v_instance_id, -1);

1000:
1001: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_GROUPS', v_instance_id, -1);
1002: msc_analyse_tables_pk.analyse_table( 'MSC_ST_DEPARTMENT_RESOURCES', v_instance_id, -1);
1003: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_SHIFTS', v_instance_id, -1);
1004: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_CHANGES', v_instance_id, -1);
1005:
1006: END IF;
1007:
1008: IF v_project_enabled = SYS_YES THEN

Line 26957: lv_simulation_set msc_st_resource_changes.simulation_set%type;

26953: lv_where_str VARCHAR2(5000);
26954: lv_sql_stmt VARCHAR2(5000);
26955: lv_cursor_stmt VARCHAR2(5000);
26956:
26957: lv_simulation_set msc_st_resource_changes.simulation_set%type;
26958: lv_batch_id msc_st_department_resources.batch_id%TYPE;
26959: lv_message_text msc_errors.error_text%TYPE;
26960:
26961:

Line 27015: FROM msc_st_resource_changes

27011: AND batch_id = p_batch_id;
27012:
27013: CURSOR c7(p_batch_id NUMBER) IS
27014: SELECT rowid
27015: FROM msc_st_resource_changes
27016: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
27017: AND sr_instance_code = v_instance_code
27018: AND batch_id = p_batch_id;
27019:

Line 27022: FROM msc_st_resource_changes msrc

27018: AND batch_id = p_batch_id;
27019:
27020: CURSOR c8(p_batch_id NUMBER) IS
27021: SELECT max(rowid)
27022: FROM msc_st_resource_changes msrc
27023: WHERE NOT EXISTS (SELECT 1 FROM msc_simulation_sets mss
27024: WHERE msrc.simulation_set = mss.simulation_set
27025: AND msrc.sr_instance_id = mss.sr_instance_id
27026: AND msrc.organization_id = mss.organization_id)

Line 28946: -- Validation for table MSC_ST_RESOURCE_CHANGES

28942: COMMIT;
28943: END LOOP;
28944:
28945:
28946: -- Validation for table MSC_ST_RESOURCE_CHANGES
28947:
28948: --Duplicate records check for the records whose source is XML
28949:
28950: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 28964: 'UPDATE msc_st_resource_changes msrc1'

28960: -- Duplicate UDK validation for XML message
28961:
28962: v_sql_stmt := 31;
28963: lv_sql_stmt :=
28964: 'UPDATE msc_st_resource_changes msrc1'
28965: ||' SET process_flag = '||G_ERROR_FLG||','
28966: ||' error_text = '||''''||lv_message_text||''''
28967: ||' WHERE message_id < ( SELECT max(message_id)'
28968: ||' FROM msc_st_resource_changes msrc2'

Line 28968: ||' FROM msc_st_resource_changes msrc2'

28964: 'UPDATE msc_st_resource_changes msrc1'
28965: ||' SET process_flag = '||G_ERROR_FLG||','
28966: ||' error_text = '||''''||lv_message_text||''''
28967: ||' WHERE message_id < ( SELECT max(message_id)'
28968: ||' FROM msc_st_resource_changes msrc2'
28969: ||' WHERE msrc2.sr_instance_code '
28970: ||' = msrc1.sr_instance_code'
28971: ||' AND msrc2.organization_code '
28972: ||' = msrc1.organization_code'

Line 29019: 'UPDATE msc_st_resource_changes msrc1'

29015: RAISE ex_logging_err;
29016: END IF;
29017:
29018: lv_sql_stmt :=
29019: 'UPDATE msc_st_resource_changes msrc1'
29020: ||' SET process_flag = '||G_ERROR_FLG||','
29021: ||' error_text = '||''''||lv_message_text||''''
29022: ||' WHERE EXISTS ( SELECT 1'
29023: ||' FROM msc_st_resource_changes msrc2'

Line 29023: ||' FROM msc_st_resource_changes msrc2'

29019: 'UPDATE msc_st_resource_changes msrc1'
29020: ||' SET process_flag = '||G_ERROR_FLG||','
29021: ||' error_text = '||''''||lv_message_text||''''
29022: ||' WHERE EXISTS ( SELECT 1'
29023: ||' FROM msc_st_resource_changes msrc2'
29024: ||' WHERE msrc2.sr_instance_code '
29025: ||' = msrc1.sr_instance_code'
29026: ||' AND msrc2.organization_code '
29027: ||' = msrc1.organization_code'

Line 29096: ' UPDATE msc_st_resource_changes '

29092: CLOSE c1;
29093:
29094: v_sql_stmt := 34;
29095: lv_sql_stmt :=
29096: ' UPDATE msc_st_resource_changes '
29097: ||' SET batch_id = :lv_batch_id'
29098: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
29099: ||' AND sr_instance_code = :v_instance_code'
29100: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 29116: UPDATE msc_st_resource_changes

29112: CLOSE c7;
29113:
29114: v_sql_stmt := 35;
29115: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
29116: UPDATE msc_st_resource_changes
29117: SET st_transaction_id = msc_st_resource_changes_s.NEXTVAL,
29118: refresh_id = v_refresh_id,
29119: last_update_date = v_current_date,
29120: last_updated_by = v_current_user,

Line 29117: SET st_transaction_id = msc_st_resource_changes_s.NEXTVAL,

29113:
29114: v_sql_stmt := 35;
29115: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
29116: UPDATE msc_st_resource_changes
29117: SET st_transaction_id = msc_st_resource_changes_s.NEXTVAL,
29118: refresh_id = v_refresh_id,
29119: last_update_date = v_current_date,
29120: last_updated_by = v_current_user,
29121: creation_date = v_current_date,

Line 29145: 'UPDATE msc_st_resource_changes '

29141: -- Error out records where from_date is NULL
29142:
29143: v_sql_stmt := 37;
29144: lv_sql_Stmt:=
29145: 'UPDATE msc_st_resource_changes '
29146: ||' SET process_flag ='||G_ERROR_FLG||','
29147: ||' error_text = '||''''||lv_message_text||''''
29148: ||' WHERE NVL(from_date,(sysdate-36500)) = (sysdate-36500)'
29149: ||' AND sr_instance_code = :v_instance_code'

Line 29178: 'UPDATE msc_st_resource_changes '

29174:
29175: v_sql_stmt := 38;
29176:
29177: lv_sql_Stmt:=
29178: 'UPDATE msc_st_resource_changes '
29179: ||' SET process_flag ='||G_ERROR_FLG||','
29180: ||' error_text = '||''''||lv_message_text||''''
29181: ||' WHERE NVL(action_type,'||NULL_VALUE||') NOT IN (1,2,3) '
29182: ||' AND sr_instance_code = :v_instance_code'

Line 29212: (p_table_name => 'MSC_ST_RESOURCE_CHANGES',

29208:
29209: lv_where_str := ' AND NVL(deleted_flag,'||NULL_VALUE||')NOT IN (1,2)';
29210:
29211: lv_return := MSC_ST_UTIL.LOG_ERROR
29212: (p_table_name => 'MSC_ST_RESOURCE_CHANGES',
29213: p_instance_code => v_instance_code,
29214: p_row => lv_column_names,
29215: p_severity => G_SEV_WARNING,
29216: p_message_text => lv_message_text,

Line 29244: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_RESOURCE_CHANGES',

29240: END IF;
29241:
29242: -- Derive organization id
29243: lv_return :=
29244: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_RESOURCE_CHANGES',
29245: p_org_partner_name => 'ORGANIZATION_CODE',
29246: p_org_partner_id => 'ORGANIZATION_ID',
29247: p_instance_code => v_instance_code,
29248: p_partner_type => G_ORGANIZATION,

Line 29264: 'UPDATE msc_st_resource_changes msrc'

29260: -- Popluate the Department id from LOCAL_ID table
29261:
29262: v_sql_stmt := 39;
29263: lv_sql_stmt :=
29264: 'UPDATE msc_st_resource_changes msrc'
29265: ||' SET department_id = (SELECT local_id'
29266: ||' FROM msc_local_id_setup mlis'
29267: ||' WHERE mlis.char1 = msrc.sr_instance_code'
29268: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 29295: p_token_value3 => 'MSC_ST_RESOURCE_CHANGES' );

29291: ||' ORGANIZATION_CODE,DEPARTMENT_CODE',
29292: p_token2 => 'MASTER_TABLE',
29293: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
29294: p_token3 => 'CHILD_TABLE' ,
29295: p_token_value3 => 'MSC_ST_RESOURCE_CHANGES' );
29296:
29297: IF lv_return <> 0 THEN
29298: RAISE ex_logging_err;
29299: END IF;

Line 29305: 'UPDATE msc_st_resource_changes '

29301: -- Error out the records where department id is NULL
29302:
29303: v_sql_stmt := 40;
29304: lv_sql_stmt:=
29305: 'UPDATE msc_st_resource_changes '
29306: ||' SET process_flag = '||G_ERROR_FLG||','
29307: ||' error_text = '||''''||lv_message_text||''''
29308: ||' WHERE NVL(department_id,'||NULL_VALUE||') = '||NULL_VALUE
29309: ||' AND sr_instance_code = :v_instance_code'

Line 29322: 'UPDATE msc_st_resource_changes msrc'

29318:
29319: -- Popluate the resource id from LOCAL_ID table
29320: v_sql_stmt := 41;
29321: lv_sql_stmt:=
29322: 'UPDATE msc_st_resource_changes msrc'
29323: ||' SET resource_id = (SELECT local_id'
29324: ||' FROM msc_local_id_setup mlis'
29325: ||' WHERE mlis.char1 = msrc.sr_instance_code'
29326: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 29354: p_token_value3 => 'MSC_ST_RESOURCE_CHANGES' );

29350: ||' ORGANIZATION_CODE,RESOURCE_CODE',
29351: p_token2 => 'MASTER_TABLE',
29352: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
29353: p_token3 => 'CHILD_TABLE' ,
29354: p_token_value3 => 'MSC_ST_RESOURCE_CHANGES' );
29355:
29356: IF lv_return <> 0 THEN
29357: RAISE ex_logging_err;
29358: END IF;

Line 29364: 'UPDATE msc_st_resource_changes '

29360: -- Error out the records where resource id is NULL
29361:
29362: v_sql_stmt := 42;
29363: lv_sql_stmt:=
29364: 'UPDATE msc_st_resource_changes '
29365: ||' SET process_flag = '||G_ERROR_FLG||','
29366: ||' error_text = '||''''||lv_message_text||''''
29367: ||' WHERE NVL(resource_id,'||NULL_VALUE||') = '||NULL_VALUE
29368: ||' AND sr_instance_code = :v_instance_code'

Line 29383: 'UPDATE msc_st_resource_changes msrc'

29379: -- Populate the SHIFT_NUM
29380: v_sql_stmt := 43;
29381:
29382: lv_sql_stmt :=
29383: 'UPDATE msc_st_resource_changes msrc'
29384: ||' SET shift_num =(SELECT mlis.local_id'
29385: ||' FROM msc_local_id_setup mlis, msc_st_trading_partners mtp '
29386: ||' WHERE mtp.sr_instance_id = '||v_instance_id
29387: ||' AND mlis.char1 = msrc.sr_instance_code'

Line 29409: 'UPDATE msc_st_resource_changes msrc'

29405: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
29406:
29407:
29408: lv_sql_stmt :=
29409: 'UPDATE msc_st_resource_changes msrc'
29410: ||' SET shift_num =(SELECT mlis.local_id'
29411: ||' FROM msc_local_id_setup mlis, msc_trading_partners mtp '
29412: ||' WHERE mtp.sr_instance_id = '||v_instance_id
29413: ||' AND mlis.char1 = msrc.sr_instance_code'

Line 29452: 'UPDATE msc_st_resource_changes '

29448:
29449: v_sql_stmt := 30;
29450:
29451: lv_sql_stmt:=
29452: 'UPDATE msc_st_resource_changes '
29453: ||' SET process_flag = '||G_ERROR_FLG||','
29454: ||' error_text = '||''''||lv_message_text||''''
29455: ||' WHERE NVL(shift_num,'||NULL_VALUE||') = '||NULL_VALUE
29456: ||' AND sr_instance_code = :v_instance_code'

Line 29470: 'UPDATE msc_st_resource_changes '

29466:
29467: v_sql_stmt := 31;
29468:
29469: lv_sql_stmt:=
29470: 'UPDATE msc_st_resource_changes '
29471: ||' SET simulation_set = '||''''||lv_simulation_set||''''
29472: ||' WHERE NVL(simulation_set,'||''''||NULL_CHAR||''''||') '
29473: ||' = '||''''||NULL_CHAR||''''
29474: ||' AND sr_instance_code = :v_instance_code'

Line 29491: pEntityName => 'MSC_ST_RESOURCE_CHANGES',

29487: (ERRBUF => lv_error_text,
29488: RETCODE => lv_return,
29489: pBatchID => lv_batch_id,
29490: pInstanceCode => v_instance_code,
29491: pEntityName => 'MSC_ST_RESOURCE_CHANGES',
29492: pInstanceID => v_instance_id);
29493:
29494: IF NVL(lv_return,0) <> 0 THEN
29495: RAISE ex_logging_err;

Line 29501: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_RESOURCE_CHANGES',

29497:
29498:
29499: -- Set the process flag as Valid and populate instance_id
29500: lv_return :=
29501: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_RESOURCE_CHANGES',
29502: p_instance_id => v_instance_id,
29503: p_instance_code => v_instance_code,
29504: p_process_flag => G_VALID,
29505: p_error_text => lv_error_text,

Line 29537: FROM msc_st_resource_changes

29533: NULL,
29534: DELETED_FLAG,
29535: v_refresh_id,
29536: SR_INSTANCE_ID
29537: FROM msc_st_resource_changes
29538: where rowid = lb_rowid(j) ;
29539:
29540: END IF;
29541: CLOSE c8;

Line 29547: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_RESOURCE_CHANGES',

29543:
29544: -- At the end calling the LOG_ERROR for logging all errored out records
29545:
29546: lv_return :=
29547: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_RESOURCE_CHANGES',
29548: p_instance_code => v_instance_code,
29549: p_row => lv_column_names,
29550: p_severity => G_SEV_ERROR,
29551: p_message_text => NULL,

Line 50985: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_CHANGES');

50981: IF lv_count > 0 Then
50982: prec.bom_flag:= SYS_YES;
50983: prec.calendar_flag:=SYS_YES;
50984: End IF;
50985: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_CHANGES');
50986: IF lv_count > 0 Then
50987: prec.bom_flag:= SYS_YES;
50988: prec.calendar_flag:=SYS_YES;
50989: End IF;