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 997: ||' on MSC_ST_RESOURCE_CHANGES '

993: application_short_name => 'MSC',
994: statement_type => AD_DDL.CREATE_INDEX,
995: statement =>
996: 'create index MSC_ST_RES_CHANGES_N1_'||v_instance_code
997: ||' on MSC_ST_RESOURCE_CHANGES '
998: ||'(sr_instance_code, simulation_set, resource_code, department_code, from_date, shift_name, organization_code, company_name) '
999: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1000: object_name =>'MSC_ST_RES_CHANGES_N1_'||v_instance_code);
1001:

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

1008:
1009: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_GROUPS', v_instance_id, -1);
1010: msc_analyse_tables_pk.analyse_table( 'MSC_ST_DEPARTMENT_RESOURCES', v_instance_id, -1);
1011: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_SHIFTS', v_instance_id, -1);
1012: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_CHANGES', v_instance_id, -1);
1013:
1014: END IF;
1015:
1016: IF v_project_enabled = SYS_YES THEN

Line 30471: lv_simulation_set msc_st_resource_changes.simulation_set%type;

30467: lv_where_str VARCHAR2(5000);
30468: lv_sql_stmt VARCHAR2(5000);
30469: lv_cursor_stmt VARCHAR2(5000);
30470:
30471: lv_simulation_set msc_st_resource_changes.simulation_set%type;
30472: lv_batch_id msc_st_department_resources.batch_id%TYPE;
30473: lv_message_text msc_errors.error_text%TYPE;
30474:
30475:

Line 30529: FROM msc_st_resource_changes

30525: AND batch_id = p_batch_id;
30526:
30527: CURSOR c7(p_batch_id NUMBER) IS
30528: SELECT rowid
30529: FROM msc_st_resource_changes
30530: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
30531: AND sr_instance_code = v_instance_code
30532: AND batch_id = p_batch_id;
30533:

Line 30536: FROM msc_st_resource_changes msrc

30532: AND batch_id = p_batch_id;
30533:
30534: CURSOR c8(p_batch_id NUMBER) IS
30535: SELECT max(rowid)
30536: FROM msc_st_resource_changes msrc
30537: WHERE NOT EXISTS (SELECT 1 FROM msc_simulation_sets mss
30538: WHERE msrc.simulation_set = mss.simulation_set
30539: AND msrc.sr_instance_id = mss.sr_instance_id
30540: AND msrc.organization_id = mss.organization_id)

Line 32500: -- Validation for table MSC_ST_RESOURCE_CHANGES

32496: COMMIT;
32497: END LOOP;
32498:
32499:
32500: -- Validation for table MSC_ST_RESOURCE_CHANGES
32501:
32502: --Duplicate records check for the records whose source is XML
32503:
32504: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 32518: 'UPDATE msc_st_resource_changes msrc1'

32514: -- Duplicate UDK validation for XML message
32515:
32516: v_sql_stmt := 31;
32517: lv_sql_stmt :=
32518: 'UPDATE msc_st_resource_changes msrc1'
32519: ||' SET process_flag = '||G_ERROR_FLG||','
32520: ||' error_text = '||''''||lv_message_text||''''
32521: ||' WHERE message_id < ( SELECT max(message_id)'
32522: ||' FROM msc_st_resource_changes msrc2'

Line 32522: ||' FROM msc_st_resource_changes msrc2'

32518: 'UPDATE msc_st_resource_changes msrc1'
32519: ||' SET process_flag = '||G_ERROR_FLG||','
32520: ||' error_text = '||''''||lv_message_text||''''
32521: ||' WHERE message_id < ( SELECT max(message_id)'
32522: ||' FROM msc_st_resource_changes msrc2'
32523: ||' WHERE msrc2.sr_instance_code '
32524: ||' = msrc1.sr_instance_code'
32525: ||' AND msrc2.organization_code '
32526: ||' = msrc1.organization_code'

Line 32573: 'UPDATE MSC_ST_RESOURCE_CHANGES MSRC1'

32569: RAISE ex_logging_err;
32570: END IF;
32571:
32572: LV_SQL_STMT :=
32573: 'UPDATE MSC_ST_RESOURCE_CHANGES MSRC1'
32574: ||' SET PROCESS_FLAG = '||G_ERROR_FLG||','
32575: ||' ERROR_TEXT = '||''''||LV_MESSAGE_TEXT||''''
32576: ||' WHERE '
32577: ||' (SR_INSTANCE_CODE ,'

Line 32604: ||' FROM MSC_ST_RESOURCE_CHANGES MSRC2'

32600: ||' FROM_TIME ,'
32601: ||' TO_TIME ,'
32602: ||' ACTION_TYPE ,'
32603: ||' DELETED_FLAG '
32604: ||' FROM MSC_ST_RESOURCE_CHANGES MSRC2'
32605: ||' WHERE '
32606: ||' MSRC2.PROCESS_FLAG ='||G_IN_PROCESS
32607: ||' AND NVL(MSRC2.MESSAGE_ID,'||NULL_VALUE||') = '||NULL_VALUE
32608: ||' GROUP BY SR_INSTANCE_CODE,ORGANIZATION_CODE,COMPANY_NAME,DEPARTMENT_CODE,'

Line 32653: ' UPDATE msc_st_resource_changes '

32649: CLOSE c1;
32650:
32651: v_sql_stmt := 34;
32652: lv_sql_stmt :=
32653: ' UPDATE msc_st_resource_changes '
32654: ||' SET batch_id = :lv_batch_id'
32655: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
32656: ||' AND sr_instance_code = :v_instance_code'
32657: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 32673: UPDATE msc_st_resource_changes

32669: CLOSE c7;
32670:
32671: v_sql_stmt := 35;
32672: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
32673: UPDATE msc_st_resource_changes
32674: SET st_transaction_id = msc_st_resource_changes_s.NEXTVAL,
32675: refresh_id = v_refresh_id,
32676: last_update_date = v_current_date,
32677: last_updated_by = v_current_user,

Line 32674: SET st_transaction_id = msc_st_resource_changes_s.NEXTVAL,

32670:
32671: v_sql_stmt := 35;
32672: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
32673: UPDATE msc_st_resource_changes
32674: SET st_transaction_id = msc_st_resource_changes_s.NEXTVAL,
32675: refresh_id = v_refresh_id,
32676: last_update_date = v_current_date,
32677: last_updated_by = v_current_user,
32678: creation_date = v_current_date,

Line 32702: 'UPDATE msc_st_resource_changes '

32698: -- Error out records where from_date is NULL
32699:
32700: v_sql_stmt := 37;
32701: lv_sql_Stmt:=
32702: 'UPDATE msc_st_resource_changes '
32703: ||' SET process_flag ='||G_ERROR_FLG||','
32704: ||' error_text = '||''''||lv_message_text||''''
32705: ||' WHERE NVL(from_date,(sysdate-36500)) = (sysdate-36500)'
32706: ||' AND sr_instance_code = :v_instance_code'

Line 32735: 'UPDATE msc_st_resource_changes '

32731:
32732: v_sql_stmt := 38;
32733:
32734: lv_sql_Stmt:=
32735: 'UPDATE msc_st_resource_changes '
32736: ||' SET process_flag ='||G_ERROR_FLG||','
32737: ||' error_text = '||''''||lv_message_text||''''
32738: ||' WHERE NVL(action_type,'||NULL_VALUE||') NOT IN (1,2,3) '
32739: ||' AND sr_instance_code = :v_instance_code'

Line 32769: (p_table_name => 'MSC_ST_RESOURCE_CHANGES',

32765:
32766: lv_where_str := ' AND NVL(deleted_flag,'||NULL_VALUE||')NOT IN (1,2)';
32767:
32768: lv_return := MSC_ST_UTIL.LOG_ERROR
32769: (p_table_name => 'MSC_ST_RESOURCE_CHANGES',
32770: p_instance_code => v_instance_code,
32771: p_row => lv_column_names,
32772: p_severity => G_SEV_WARNING,
32773: p_message_text => lv_message_text,

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

32797: END IF;
32798:
32799: -- Derive organization id
32800: lv_return :=
32801: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_RESOURCE_CHANGES',
32802: p_org_partner_name => 'ORGANIZATION_CODE',
32803: p_org_partner_id => 'ORGANIZATION_ID',
32804: p_instance_code => v_instance_code,
32805: p_partner_type => G_ORGANIZATION,

Line 32821: 'UPDATE msc_st_resource_changes msrc'

32817: -- Popluate the Department id from LOCAL_ID table
32818:
32819: v_sql_stmt := 39;
32820: lv_sql_stmt :=
32821: 'UPDATE msc_st_resource_changes msrc'
32822: ||' SET department_id = (SELECT local_id'
32823: ||' FROM msc_local_id_setup mlis'
32824: ||' WHERE mlis.char1 = msrc.sr_instance_code'
32825: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 32852: p_token_value3 => 'MSC_ST_RESOURCE_CHANGES' );

32848: ||' ORGANIZATION_CODE,DEPARTMENT_CODE',
32849: p_token2 => 'MASTER_TABLE',
32850: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
32851: p_token3 => 'CHILD_TABLE' ,
32852: p_token_value3 => 'MSC_ST_RESOURCE_CHANGES' );
32853:
32854: IF lv_return <> 0 THEN
32855: RAISE ex_logging_err;
32856: END IF;

Line 32862: 'UPDATE msc_st_resource_changes '

32858: -- Error out the records where department id is NULL
32859:
32860: v_sql_stmt := 40;
32861: lv_sql_stmt:=
32862: 'UPDATE msc_st_resource_changes '
32863: ||' SET process_flag = '||G_ERROR_FLG||','
32864: ||' error_text = '||''''||lv_message_text||''''
32865: ||' WHERE NVL(department_id,'||NULL_VALUE||') = '||NULL_VALUE
32866: ||' AND sr_instance_code = :v_instance_code'

Line 32879: 'UPDATE msc_st_resource_changes msrc'

32875:
32876: -- Popluate the resource id from LOCAL_ID table
32877: v_sql_stmt := 41;
32878: lv_sql_stmt:=
32879: 'UPDATE msc_st_resource_changes msrc'
32880: ||' SET resource_id = (SELECT local_id'
32881: ||' FROM msc_local_id_setup mlis'
32882: ||' WHERE mlis.char1 = msrc.sr_instance_code'
32883: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 32911: p_token_value3 => 'MSC_ST_RESOURCE_CHANGES' );

32907: ||' ORGANIZATION_CODE,RESOURCE_CODE',
32908: p_token2 => 'MASTER_TABLE',
32909: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
32910: p_token3 => 'CHILD_TABLE' ,
32911: p_token_value3 => 'MSC_ST_RESOURCE_CHANGES' );
32912:
32913: IF lv_return <> 0 THEN
32914: RAISE ex_logging_err;
32915: END IF;

Line 32921: 'UPDATE msc_st_resource_changes '

32917: -- Error out the records where resource id is NULL
32918:
32919: v_sql_stmt := 42;
32920: lv_sql_stmt:=
32921: 'UPDATE msc_st_resource_changes '
32922: ||' SET process_flag = '||G_ERROR_FLG||','
32923: ||' error_text = '||''''||lv_message_text||''''
32924: ||' WHERE NVL(resource_id,'||NULL_VALUE||') = '||NULL_VALUE
32925: ||' AND sr_instance_code = :v_instance_code'

Line 32940: 'UPDATE msc_st_resource_changes msrc'

32936: -- Populate the SHIFT_NUM
32937: v_sql_stmt := 43;
32938:
32939: lv_sql_stmt :=
32940: 'UPDATE msc_st_resource_changes msrc'
32941: ||' SET shift_num =(SELECT mlis.local_id'
32942: ||' FROM msc_local_id_setup mlis, msc_st_trading_partners mtp '
32943: ||' WHERE mtp.sr_instance_id = '||v_instance_id
32944: ||' AND mlis.char1 = msrc.sr_instance_code'

Line 32966: 'UPDATE msc_st_resource_changes msrc'

32962: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
32963:
32964:
32965: lv_sql_stmt :=
32966: 'UPDATE msc_st_resource_changes msrc'
32967: ||' SET shift_num =(SELECT mlis.local_id'
32968: ||' FROM msc_local_id_setup mlis, msc_trading_partners mtp '
32969: ||' WHERE mtp.sr_instance_id = '||v_instance_id
32970: ||' AND mlis.char1 = msrc.sr_instance_code'

Line 33009: 'UPDATE msc_st_resource_changes '

33005:
33006: v_sql_stmt := 30;
33007:
33008: lv_sql_stmt:=
33009: 'UPDATE msc_st_resource_changes '
33010: ||' SET process_flag = '||G_ERROR_FLG||','
33011: ||' error_text = '||''''||lv_message_text||''''
33012: ||' WHERE NVL(shift_num,'||NULL_VALUE||') = '||NULL_VALUE
33013: ||' AND sr_instance_code = :v_instance_code'

Line 33027: 'UPDATE msc_st_resource_changes '

33023:
33024: v_sql_stmt := 31;
33025:
33026: lv_sql_stmt:=
33027: 'UPDATE msc_st_resource_changes '
33028: ||' SET simulation_set = '||''''||lv_simulation_set||''''
33029: ||' WHERE NVL(simulation_set,'||''''||NULL_CHAR||''''||') '
33030: ||' = '||''''||NULL_CHAR||''''
33031: ||' AND sr_instance_code = :v_instance_code'

Line 33048: pEntityName => 'MSC_ST_RESOURCE_CHANGES',

33044: (ERRBUF => lv_error_text,
33045: RETCODE => lv_return,
33046: pBatchID => lv_batch_id,
33047: pInstanceCode => v_instance_code,
33048: pEntityName => 'MSC_ST_RESOURCE_CHANGES',
33049: pInstanceID => v_instance_id);
33050:
33051: IF NVL(lv_return,0) <> 0 THEN
33052: RAISE ex_logging_err;

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

33054:
33055:
33056: -- Set the process flag as Valid and populate instance_id
33057: lv_return :=
33058: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_RESOURCE_CHANGES',
33059: p_instance_id => v_instance_id,
33060: p_instance_code => v_instance_code,
33061: p_process_flag => G_VALID,
33062: p_error_text => lv_error_text,

Line 33094: FROM msc_st_resource_changes

33090: NULL,
33091: DELETED_FLAG,
33092: v_refresh_id,
33093: SR_INSTANCE_ID
33094: FROM msc_st_resource_changes
33095: where rowid = lb_rowid(j) ;
33096:
33097: END IF;
33098: CLOSE c8;

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

33100:
33101: -- At the end calling the LOG_ERROR for logging all errored out records
33102:
33103: lv_return :=
33104: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_RESOURCE_CHANGES',
33105: p_instance_code => v_instance_code,
33106: p_row => lv_column_names,
33107: p_severity => G_SEV_ERROR,
33108: p_message_text => NULL,

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

55903: IF lv_count > 0 Then
55904: prec.bom_flag:= SYS_YES;
55905: prec.calendar_flag:=SYS_YES;
55906: End IF;
55907: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_CHANGES');
55908: IF lv_count > 0 Then
55909: prec.bom_flag:= SYS_YES;
55910: prec.calendar_flag:=SYS_YES;
55911: End IF;