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_OPERATION_RESOURCES

Line 854: ||' on MSC_ST_OPERATION_RESOURCES '

850: application_short_name => 'MSC',
851: statement_type => AD_DDL.CREATE_INDEX,
852: statement =>
853: 'create index MSC_ST_OPER_RES_N1_'||v_instance_code
854: ||' on MSC_ST_OPERATION_RESOURCES '
855: ||'(sr_instance_code, assembly_name, resource_code, organization_code, company_name, alternate_number, operation_seq_code, resource_seq_code, routing_name, alternate_routing_designator) '
856: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
857: object_name =>'MSC_ST_OPER_RES_N1_'||v_instance_code);
858:

Line 886: msc_analyse_tables_pk.analyse_table( 'MSC_ST_OPERATION_RESOURCES', v_instance_id, -1);

882: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_OPER_NTWK_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
883: END;
884:
885: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ROUTINGS', v_instance_id, -1);
886: msc_analyse_tables_pk.analyse_table( 'MSC_ST_OPERATION_RESOURCES', v_instance_id, -1);
887: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ROUTING_OPERATIONS', v_instance_id, -1);
888: msc_analyse_tables_pk.analyse_table( 'MSC_ST_OPERATION_NETWORKS', v_instance_id, -1);
889:
890:

Line 43513: FROM msc_st_operation_resources

43509: AND deleted_flag = SYS_NO;
43510:
43511: CURSOR c6(p_batch_id NUMBER) IS
43512: SELECT rowid
43513: FROM msc_st_operation_resources
43514: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
43515: AND sr_instance_code = v_instance_code
43516: AND batch_id = p_batch_id;
43517:

Line 43520: FROM msc_st_operation_resources

43516: AND batch_id = p_batch_id;
43517:
43518: CURSOR c7(p_batch_id NUMBER) IS
43519: SELECT max(rowid)
43520: FROM msc_st_operation_resources
43521: WHERE process_flag = G_IN_PROCESS
43522: AND sr_instance_code = v_instance_code
43523: AND batch_id = p_batch_id
43524: AND NVL(resource_seq_num,NULL_VALUE) = NULL_VALUE

Line 43533: FROM msc_st_operation_resources

43529: alternate_routing_designator,alternate_number;
43530:
43531: CURSOR c8(p_batch_id NUMBER) IS
43532: SELECT max(rowid)
43533: FROM msc_st_operation_resources
43534: WHERE process_flag = G_IN_PROCESS
43535: AND sr_instance_code = v_instance_code
43536: AND batch_id = p_batch_id
43537: AND NVL(resource_seq_num,NULL_VALUE) <> NULL_VALUE

Line 45287: -- Validation for the MSC_ST_OPERATION_RESOURCES

45283:
45284: COMMIT;
45285: END LOOP;
45286:
45287: -- Validation for the MSC_ST_OPERATION_RESOURCES
45288:
45289: --Duplicate records check for the records whose source is XML
45290:
45291: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 45305: 'UPDATE msc_st_operation_resources msor1 '

45301:
45302: v_sql_stmt := 32;
45303:
45304: lv_sql_stmt:=
45305: 'UPDATE msc_st_operation_resources msor1 '
45306: ||' SET process_flag = '||G_ERROR_FLG||','
45307: ||' error_text = '||''''||lv_message_text||''''
45308: ||' WHERE message_id < ( SELECT max(message_id)'
45309: ||' FROM msc_st_operation_resources msor2'

Line 45309: ||' FROM msc_st_operation_resources msor2'

45305: 'UPDATE msc_st_operation_resources msor1 '
45306: ||' SET process_flag = '||G_ERROR_FLG||','
45307: ||' error_text = '||''''||lv_message_text||''''
45308: ||' WHERE message_id < ( SELECT max(message_id)'
45309: ||' FROM msc_st_operation_resources msor2'
45310: ||' WHERE msor2.sr_instance_code = msor1.sr_instance_code'
45311: ||' AND msor2.organization_code = msor1.organization_code'
45312: ||' AND NVL(msor2.company_name,'||''''||NULL_CHAR||''''||') '
45313: ||' = NVL(msor1.company_name,'||''''||NULL_CHAR||''''||') '

Line 45352: 'UPDATE msc_st_operation_resources msor1'

45348: END IF;
45349:
45350: v_sql_stmt := 33;
45351: lv_sql_stmt :=
45352: 'UPDATE msc_st_operation_resources msor1'
45353: ||' SET process_flag = '||G_ERROR_FLG||','
45354: ||' error_text = '||''''||lv_message_text||''''
45355: ||' WHERE EXISTS ( SELECT 1 '
45356: ||' FROM msc_st_operation_resources msor2'

Line 45356: ||' FROM msc_st_operation_resources msor2'

45352: 'UPDATE msc_st_operation_resources msor1'
45353: ||' SET process_flag = '||G_ERROR_FLG||','
45354: ||' error_text = '||''''||lv_message_text||''''
45355: ||' WHERE EXISTS ( SELECT 1 '
45356: ||' FROM msc_st_operation_resources msor2'
45357: ||' WHERE msor2.sr_instance_code = msor1.sr_instance_code'
45358: ||' AND msor2.organization_code = msor1.organization_code'
45359: ||' AND NVL(msor2.company_name,'||''''||NULL_CHAR||''''||') '
45360: ||' = NVL(msor1.company_name,'||''''||NULL_CHAR||''''||') '

Line 45420: ' UPDATE msc_st_operation_resources '

45416: CLOSE c1;
45417:
45418: v_sql_stmt := 34;
45419: lv_sql_stmt :=
45420: ' UPDATE msc_st_operation_resources '
45421: ||' SET batch_id = :lv_batch_id'
45422: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
45423: ||' AND sr_instance_code = :v_instance_code'
45424: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 45440: UPDATE msc_st_operation_resources

45436: CLOSE c6;
45437:
45438: v_sql_stmt := 35;
45439: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
45440: UPDATE msc_st_operation_resources
45441: SET st_transaction_id = msc_st_operation_resources_s.NEXTVAL,
45442: refresh_id = v_refresh_id,
45443: last_update_date = v_current_date,
45444: last_updated_by = v_current_user,

Line 45441: SET st_transaction_id = msc_st_operation_resources_s.NEXTVAL,

45437:
45438: v_sql_stmt := 35;
45439: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
45440: UPDATE msc_st_operation_resources
45441: SET st_transaction_id = msc_st_operation_resources_s.NEXTVAL,
45442: refresh_id = v_refresh_id,
45443: last_update_date = v_current_date,
45444: last_updated_by = v_current_user,
45445: creation_date = v_current_date,

Line 45472: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',

45468: lv_where_str :=
45469: ' AND NVL(deleted_flag,'||NULL_VALUE||') NOT IN(1,2)';
45470:
45471: lv_return := MSC_ST_UTIL.LOG_ERROR
45472: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',
45473: p_instance_code => v_instance_code,
45474: p_row => lv_column_names,
45475: p_severity => G_SEV_WARNING,
45476: p_message_text => 'lv_message_text',

Line 45494: 'UPDATE msc_st_operation_resources '

45490: -- then populate the ASSEMBLY_NAME in that
45491:
45492: v_sql_stmt := 36;
45493: lv_sql_stmt :=
45494: 'UPDATE msc_st_operation_resources '
45495: ||' SET routing_name = assembly_name'
45496: ||' WHERE sr_instance_code = :v_instance_code'
45497: ||' AND process_flag ='||G_IN_PROCESS
45498: ||' AND NVL(routing_name,'||''''||NULL_CHAR||''''||')'

Line 45513: 'UPDATE msc_st_operation_resources '

45509: -- Error out records where resource_usage is NULL
45510:
45511: v_sql_stmt := 37;
45512: lv_sql_stmt :=
45513: 'UPDATE msc_st_operation_resources '
45514: ||' SET process_flag ='||G_ERROR_FLG||','
45515: ||' error_text = '||''''||lv_message_text||''''
45516: ||' WHERE NVL(resource_usage,'||NULL_VALUE||') ='||NULL_VALUE
45517: ||' AND sr_instance_code = :v_instance_code'

Line 45543: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',

45539:
45540: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
45541: lv_return :=
45542: MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID
45543: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',
45544: p_rtg_col_name => 'ROUTING_NAME',
45545: p_rtg_col_id =>'ROUTING_SEQUENCE_ID',
45546: p_instance_code => v_instance_code,
45547: p_severity => G_SEV_ERROR,

Line 45574: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',

45570: END IF;
45571:
45572: --Derive Organization_id
45573: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
45574: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',
45575: p_org_partner_name => 'ORGANIZATION_CODE',
45576: p_org_partner_id => 'ORGANIZATION_ID',
45577: p_instance_code => v_instance_code,
45578: p_partner_type => G_ORGANIZATION,

Line 45611: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',

45607: lv_where_str := ' AND NVL(operation_seq_code,'||''''||NULL_CHAR||''''
45608: ||' ) ='||''''||NULL_CHAR||'''' ;
45609:
45610: lv_return := MSC_ST_UTIL.LOG_ERROR
45611: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',
45612: p_instance_code => v_instance_code,
45613: p_row => lv_column_names,
45614: p_severity => G_SEV_WARNING,
45615: p_message_text => lv_message_text,

Line 45649: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',

45645: lv_where_str :=
45646: ' AND NVL(operation_effectivity_date, SYSDATE-36500 ) = SYSDATE-36500 ' ;
45647:
45648: lv_return := MSC_ST_UTIL.LOG_ERROR
45649: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',
45650: p_instance_code => v_instance_code,
45651: p_row => lv_column_names,
45652: p_severity => G_SEV_WARNING,
45653: p_message_text => lv_message_text,

Line 45669: 'UPDATE msc_st_operation_resources msor'

45665: -- Derive operation sequence id from local id table
45666:
45667: v_sql_stmt := 38;
45668: lv_sql_stmt:=
45669: 'UPDATE msc_st_operation_resources msor'
45670: ||' SET operation_sequence_id= (SELECT local_id'
45671: ||' FROM msc_local_id_setup mlis'
45672: ||' WHERE mlis.char1 = msor.sr_instance_code'
45673: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 45706: p_token_value3 => 'MSC_ST_OPERATION_RESOURCES' );

45702: ||' ALTERNATE_ROUTING_DESIGNATOR' ,
45703: p_token2 => 'MASTER_TABLE',
45704: p_token_value2 => 'MSC_ST_ROUTING_OPERATIONS',
45705: p_token3 => 'CHILD_TABLE' ,
45706: p_token_value3 => 'MSC_ST_OPERATION_RESOURCES' );
45707:
45708: IF lv_return <> 0 THEN
45709: RAISE ex_logging_err;
45710: END IF;

Line 45718: 'UPDATE msc_st_operation_resources'

45714:
45715: v_sql_stmt := 39;
45716:
45717: lv_sql_stmt :=
45718: 'UPDATE msc_st_operation_resources'
45719: ||' SET process_flag = '||G_ERROR_FLG||','
45720: ||' error_text = '||''''||lv_message_text||''''
45721: ||' WHERE NVL(operation_sequence_id,'||NULL_VALUE||') = '||NULL_VALUE
45722: ||' AND sr_instance_code = :v_instance_code'

Line 45753: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',

45749: lv_where_str := ' AND NVL(resource_seq_code,'||''''||NULL_CHAR||''''
45750: ||' ) ='||''''||NULL_CHAR||'''' ;
45751:
45752: lv_return := MSC_ST_UTIL.LOG_ERROR
45753: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',
45754: p_instance_code => v_instance_code,
45755: p_row => lv_column_names,
45756: p_severity => G_SEV_WARNING,
45757: p_message_text => lv_message_text,

Line 45789: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',

45785:
45786: lv_where_str := ' AND NVL(alternate_number,'||NULL_VALUE||') ='||NULL_VALUE ;
45787:
45788: lv_return := MSC_ST_UTIL.LOG_ERROR
45789: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',
45790: p_instance_code => v_instance_code,
45791: p_row => lv_column_names,
45792: p_severity => G_SEV_WARNING,
45793: p_message_text => lv_message_text,

Line 45809: 'UPDATE msc_st_operation_resources msor'

45805: -- Derive resource seq num from the local id table
45806:
45807: v_sql_stmt := 40;
45808: lv_sql_stmt :=
45809: 'UPDATE msc_st_operation_resources msor'
45810: ||' SET resource_seq_num = (SELECT local_id '
45811: ||' FROM msc_local_id_setup mlis'
45812: ||' WHERE mlis.char1 = msor.sr_instance_code'
45813: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 45850: 'UPDATE msc_st_operation_resources '

45846: -- and resource_seq_num is NULL
45847:
45848: v_sql_stmt := 41;
45849: lv_sql_stmt :=
45850: 'UPDATE msc_st_operation_resources '
45851: ||' SET process_flag = '||G_ERROR_FLG||','
45852: ||' error_text = '||''''||lv_message_text||''''
45853: ||' WHERE NVL(resource_seq_num,'||NULL_VALUE||') ='||NULL_VALUE
45854: ||' AND deleted_flag = '||SYS_YES

Line 45870: 'UPDATE msc_st_operation_resources msor'

45866: -- Derive resource id
45867: v_sql_stmt := 42;
45868:
45869: lv_sql_stmt :=
45870: 'UPDATE msc_st_operation_resources msor'
45871: ||' SET resource_id = (SELECT local_id'
45872: ||' FROM msc_local_id_setup mlis'
45873: ||' WHERE mlis.char1 = msor.sr_instance_code'
45874: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 45893: 'UPDATE msc_st_operation_resources msor'

45889: -- Derive department id
45890: v_sql_stmt := 43;
45891:
45892: lv_sql_stmt :=
45893: 'UPDATE msc_st_operation_resources msor'
45894: ||' SET department_id = (SELECT local_id'
45895: ||' FROM msc_local_id_setup mlis'
45896: ||' WHERE mlis.char1 = msor.sr_instance_code'
45897: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 45925: p_token_value3 => 'MSC_ST_OPERATION_RESOURCES' );

45921: ||' OR RESOURCE_CODE' ,
45922: p_token2 => 'MASTER_TABLE',
45923: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
45924: p_token3 => 'CHILD_TABLE' ,
45925: p_token_value3 => 'MSC_ST_OPERATION_RESOURCES' );
45926:
45927: IF lv_return <> 0 THEN
45928: RAISE ex_logging_err;
45929: END IF;

Line 45935: 'UPDATE msc_st_operation_resources'

45931: -- Error out records where resource_id or department_id is NULL
45932:
45933: v_sql_stmt := 44;
45934: lv_sql_stmt :=
45935: 'UPDATE msc_st_operation_resources'
45936: ||' SET process_flag ='||G_ERROR_FLG||','
45937: ||' error_text = '||''''||lv_message_text||''''
45938: ||' WHERE (NVL(resource_id,'||NULL_VALUE||') ='|| NULL_VALUE
45939: ||' OR NVL(department_id,'||NULL_VALUE||') ='|| NULL_VALUE||')'

Line 45951: 'UPDATE msc_st_operation_resources msor'

45947: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
45948:
45949:
45950: lv_sql_stmt :=
45951: 'UPDATE msc_st_operation_resources msor'
45952: ||' SET setup_id= (SELECT local_id'
45953: ||' FROM msc_local_id_setup mlis'
45954: ||' WHERE mlis.char1 = msor.sr_instance_code'
45955: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||')'

Line 45981: p_token_value3 => 'MSC_ST_OPERATION_RESOURCES' );

45977: p_token_value1 => 'SETUP_CODE',
45978: p_token2 => 'MASTER_TABLE',
45979: p_token_value2 => 'MSC_ST_RESOURCE_SETUPS',
45980: p_token3 => 'CHILD_TABLE' ,
45981: p_token_value3 => 'MSC_ST_OPERATION_RESOURCES' );
45982:
45983: IF lv_return <> 0 THEN
45984: RAISE ex_logging_err;
45985: END IF;

Line 45989: ' UPDATE msc_st_operation_resources '

45985: END IF;
45986: v_sql_stmt := 06;
45987:
45988: lv_sql_stmt :=
45989: ' UPDATE msc_st_operation_resources '
45990: ||' SET process_flag ='||G_ERROR_FLG||','
45991: ||' error_text = '||''''||lv_message_text||''''
45992: ||' WHERE NVL(setup_id,'||NULL_VALUE||') ='|| NULL_VALUE
45993: ||' AND setup_code is not NULL'

Line 46029: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',

46025: ' AND NVL(basis_type,'||NULL_VALUE||')'
46026: ||' NOT IN (1,2,3,4,5) AND deleted_flag = 2' ;
46027:
46028: lv_return := MSC_ST_UTIL.LOG_ERROR
46029: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',
46030: p_instance_code => v_instance_code,
46031: p_row => lv_column_names,
46032: p_severity => G_SEV_WARNING,
46033: p_message_text => lv_message_text,

Line 46065: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',

46061: lv_where_str := ' AND NVL(principal_flag,'||NULL_VALUE||')'||' NOT IN (1,2)'
46062: ||'AND deleted_flag = 2';
46063:
46064: lv_return := MSC_ST_UTIL.LOG_ERROR
46065: (p_table_name => 'MSC_ST_OPERATION_RESOURCES',
46066: p_instance_code => v_instance_code,
46067: p_row => lv_column_names,
46068: p_severity => G_SEV_WARNING,
46069: p_message_text => lv_message_text,

Line 46088: pEntityName => 'MSC_ST_OPERATION_RESOURCES',

46084: (ERRBUF => lv_error_text,
46085: RETCODE => lv_return,
46086: pBatchID => lv_batch_id,
46087: pInstanceCode => v_instance_code,
46088: pEntityName => 'MSC_ST_OPERATION_RESOURCES',
46089: pInstanceID => v_instance_id);
46090:
46091: IF NVL(lv_return,0) <> 0 THEN
46092: RAISE ex_logging_err;

Line 46107: UPDATE msc_st_operation_resources

46103: IF c7%ROWCOUNT > 0 THEN
46104:
46105: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
46106:
46107: UPDATE msc_st_operation_resources
46108: SET resource_seq_num =
46109: to_number(decode(length(rtrim(resource_seq_code,'0123456789')),
46110: NULL,resource_seq_code,'1'))
46111: WHERE rowid = lb_rowid(j);

Line 46166: FROM msc_st_operation_resources

46162: v_current_date,
46163: v_current_user,
46164: v_current_date,
46165: v_current_user
46166: FROM msc_st_operation_resources
46167: WHERE rowid = lb_rowid(j) ;
46168:
46169: END IF;
46170: CLOSE c7;

Line 46176: 'UPDATE msc_st_operation_resources msor'

46172: -- Update resource seq num from the local id table
46173:
46174: v_sql_stmt := 47;
46175: lv_sql_stmt :=
46176: 'UPDATE msc_st_operation_resources msor'
46177: ||' SET resource_seq_num = (SELECT local_id '
46178: ||' FROM msc_local_id_setup mlis'
46179: ||' WHERE mlis.char1 = msor.sr_instance_code'
46180: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 46244: FROM msc_st_operation_resources

46240: last_update_date,
46241: last_updated_by,
46242: creation_date,
46243: created_by
46244: FROM msc_st_operation_resources
46245: WHERE rowid = lb_rowid(j) ;
46246:
46247: END IF ;
46248: CLOSE c8 ;

Line 46252: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_OPERATION_RESOURCES',

46248: CLOSE c8 ;
46249:
46250: -- Set the process flag as Valid and derive sr_instance_id
46251: lv_return :=
46252: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_OPERATION_RESOURCES',
46253: p_instance_id => v_instance_id,
46254: p_instance_code => v_instance_code,
46255: p_process_flag => G_VALID,
46256: p_error_text => lv_error_text,

Line 46268: MSC_ST_UTIL.LOG_ERROR(p_table_name =>'MSC_ST_OPERATION_RESOURCES',

46264:
46265: -- At the end calling the LOG_ERROR for logging all errored out records
46266:
46267: lv_return :=
46268: MSC_ST_UTIL.LOG_ERROR(p_table_name =>'MSC_ST_OPERATION_RESOURCES',
46269: p_instance_code =>v_instance_code,
46270: p_row =>lv_column_names,
46271: p_severity =>G_SEV_ERROR,
46272: p_message_text =>NULL,

Line 55860: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_OPERATION_RESOURCES');

55856: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_EXCEPTIONS');
55857: END IF;
55858:
55859: IF v_rtg_enabled = SYS_YES THEN
55860: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_OPERATION_RESOURCES');
55861: IF lv_count > 0 Then
55862: prec.bom_flag:= SYS_YES;
55863: End IF;
55864: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ROUTING_OPERATIONS');