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_JOB_OPERATION_NETWORKS

Line 1590: ||' on MSC_ST_JOB_OPERATION_NETWORKS '

1586: application_short_name => 'MSC',
1587: statement_type => AD_DDL.CREATE_INDEX,
1588: statement =>
1589: 'create index MSC_ST_JOB_OP_NETWORKS_N1_'||v_instance_code
1590: ||' on MSC_ST_JOB_OPERATION_NETWORKS '
1591: ||'(SR_INSTANCE_CODE, WIP_ENTITY_NAME, FROM_OPERATION_SEQ_CODE, TO_OPERATION_SEQ_CODE) '
1592: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1593: object_name =>'MSC_ST_JOB_OP_NETWORKS_N1_'||v_instance_code);
1594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OP_NETWORKS_N1_'||v_instance_code);

Line 50756: FROM msc_st_job_operation_networks

50752:
50753:
50754: CURSOR c2(p_batch_id NUMBER) IS
50755: SELECT rowid
50756: FROM msc_st_job_operation_networks
50757: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
50758: AND sr_instance_code = v_instance_code
50759: AND batch_id = p_batch_id;
50760:

Line 50794: -- -- Pre processing for MSC_ST_JOB_OPERATION_NETWORKS

50790: AND deleted_flag = SYS_NO;
50791:
50792: BEGIN
50793:
50794: -- -- Pre processing for MSC_ST_JOB_OPERATION_NETWORKS
50795: --Duplicate records check for the records whose source is XML
50796:
50797: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
50798: (p_app_short_name => 'MSC',

Line 50810: 'UPDATE msc_st_job_operation_networks mson1 '

50806:
50807: v_sql_stmt := 1;
50808:
50809: lv_sql_stmt :=
50810: 'UPDATE msc_st_job_operation_networks mson1 '
50811: ||' SET process_flag = '||G_ERROR_FLG||','
50812: ||' error_text = '||''''||lv_message_text||''''
50813: ||' WHERE message_id < ( SELECT max(message_id) '
50814: ||' FROM msc_st_job_operation_networks mson2'

Line 50814: ||' FROM msc_st_job_operation_networks mson2'

50810: 'UPDATE msc_st_job_operation_networks mson1 '
50811: ||' SET process_flag = '||G_ERROR_FLG||','
50812: ||' error_text = '||''''||lv_message_text||''''
50813: ||' WHERE message_id < ( SELECT max(message_id) '
50814: ||' FROM msc_st_job_operation_networks mson2'
50815: ||' WHERE mson2.wip_entity_name = mson1.wip_entity_name'
50816: ||' AND mson2.organization_code = mson1.organization_code'
50817: ||' AND mson2.from_operation_seq_code = mson1.from_operation_seq_code'
50818: ||' AND mson2.to_operation_seq_code = mson1.to_operation_seq_code'

Line 50852: 'UPDATE msc_st_job_operation_networks mson1'

50848:
50849: v_sql_stmt := 2;
50850:
50851: lv_sql_stmt :=
50852: 'UPDATE msc_st_job_operation_networks mson1'
50853: ||' SET process_flag = '||G_ERROR_FLG||','
50854: ||' error_text = '||''''||lv_message_text||''''
50855: ||' WHERE EXISTS ( SELECT 1 '
50856: ||' FROM msc_st_job_operation_networks mson2'

Line 50856: ||' FROM msc_st_job_operation_networks mson2'

50852: 'UPDATE msc_st_job_operation_networks mson1'
50853: ||' SET process_flag = '||G_ERROR_FLG||','
50854: ||' error_text = '||''''||lv_message_text||''''
50855: ||' WHERE EXISTS ( SELECT 1 '
50856: ||' FROM msc_st_job_operation_networks mson2'
50857: ||' WHERE mson2.wip_entity_name = mson1.wip_entity_name'
50858: ||' AND mson2.organization_code = mson1.organization_code'
50859: ||' AND mson2.from_operation_seq_code = mson1.from_operation_seq_code'
50860: ||' AND mson2.to_operation_seq_code = mson1.to_operation_seq_code'

Line 50915: ' UPDATE msc_st_job_operation_networks '

50911:
50912: v_sql_stmt := 4;
50913:
50914: lv_sql_stmt :=
50915: ' UPDATE msc_st_job_operation_networks '
50916: ||' SET batch_id = :lv_batch_id'
50917: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
50918: ||' AND sr_instance_code = :v_instance_code'
50919: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 50936: UPDATE msc_st_job_operation_networks

50932:
50933: v_sql_stmt := 5;
50934:
50935: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
50936: UPDATE msc_st_job_operation_networks
50937: SET st_transaction_id = msc_st_job_op_networks_s.NEXTVAL,
50938: refresh_id = v_refresh_id,
50939: last_update_date = v_current_date,
50940: last_updated_by = v_current_user,

Line 50962: 'UPDATE msc_st_job_operation_networks'

50958: END IF;
50959:
50960: v_sql_stmt := 6;
50961: lv_sql_stmt :=
50962: 'UPDATE msc_st_job_operation_networks'
50963: ||' SET error_text = '||''''||lv_message_text||''''||','
50964: ||' process_flag = '||G_ERROR_FLG
50965: ||' WHERE NVL(wip_entity_name,'||''''||NULL_CHAR||''''||') '
50966: ||' = '||''''||NULL_CHAR||''''

Line 50986: p_token_value1 => 'MSC_ST_JOB_OPERATION_NETWORKS');

50982: p_error_code => 'MSC_PP_NO_DELETION',
50983: p_message_text => lv_message_text,
50984: p_error_text => lv_error_text,
50985: p_token1 => 'TABLE_NAME',
50986: p_token_value1 => 'MSC_ST_JOB_OPERATION_NETWORKS');
50987:
50988: IF lv_return <> 0 THEN
50989: RAISE ex_logging_err;
50990: END IF;

Line 50995: ' UPDATE msc_st_job_operation_networks '

50991:
50992: --Deletion is not allowed on this table.
50993: v_sql_stmt := 06;
50994: lv_sql_stmt :=
50995: ' UPDATE msc_st_job_operation_networks '
50996: ||' SET process_flag ='||G_ERROR_FLG||','
50997: ||' error_text = '||''''||lv_message_text||''''
50998: ||' WHERE deleted_flag = '||SYS_YES
50999: ||' AND process_flag = '||G_IN_PROCESS

Line 51029: (p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS',

51025: lv_where_str :=
51026: ' AND NVL(deleted_flag,'||NULL_VALUE||') NOT IN(1,2)';
51027:
51028: lv_return := MSC_ST_UTIL.LOG_ERROR
51029: (p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS',
51030: p_instance_code => v_instance_code,
51031: p_row => lv_column_names,
51032: p_severity => G_SEV_WARNING,
51033: p_message_text => lv_message_text,

Line 51062: 'UPDATE msc_st_job_operation_networks'

51058: -- Error out the records whose PLANNING_PCT is NULL
51059:
51060: v_sql_stmt := 7;
51061: lv_sql_stmt :=
51062: 'UPDATE msc_st_job_operation_networks'
51063: ||' SET process_flag ='||G_ERROR_FLG||','
51064: ||' error_text = '||''''||lv_message_text||''''
51065: ||' WHERE NVL(PLANNING_PCT,'||NULL_VALUE||') = '||NULL_VALUE
51066: ||' AND sr_instance_code = :v_instance_code'

Line 51092: 'UPDATE msc_st_job_operation_networks'

51088: -- Error out the records where RECOMMENDED is not 'Y' or 'N'
51089:
51090: v_sql_stmt := 7;
51091: lv_sql_stmt :=
51092: 'UPDATE msc_st_job_operation_networks'
51093: ||' SET process_flag ='||G_ERROR_FLG||','
51094: ||' error_text = '||''''||lv_message_text||''''
51095: ||' WHERE recommended NOT IN (''Y'', ''N'')'
51096: ||' AND sr_instance_code = :v_instance_code'

Line 51122: 'UPDATE msc_st_job_operation_networks'

51118: -- Error out the records whose Assembly Name is NULL
51119:
51120: v_sql_stmt := 8;
51121: lv_sql_stmt :=
51122: 'UPDATE msc_st_job_operation_networks'
51123: ||' SET process_flag ='||G_ERROR_FLG||','
51124: ||' error_text = '||''''||lv_message_text||''''
51125: ||' WHERE NVL(assembly_name,'||''''||NULL_CHAR||''''||') '
51126: ||' = '||''''||NULL_CHAR||''''

Line 51142: 'UPDATE msc_st_job_operation_networks '

51138:
51139: v_sql_stmt := 9;
51140:
51141: lv_sql_stmt :=
51142: 'UPDATE msc_st_job_operation_networks '
51143: ||' SET routing_name = assembly_name'
51144: ||' WHERE sr_instance_code = :v_instance_code'
51145: ||' AND process_flag = '||G_IN_PROCESS
51146: ||' AND NVL(routing_name,'||''''||NULL_CHAR||''''||') '

Line 51169: (p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS',

51165: END IF;
51166:
51167: --Derive Organization_id
51168: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
51169: (p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS',
51170: p_org_partner_name => 'ORGANIZATION_CODE',
51171: p_org_partner_id => 'ORGANIZATION_ID',
51172: p_instance_code => v_instance_code,
51173: p_partner_type => G_ORGANIZATION,

Line 51188: 'UPDATE msc_st_job_operation_networks mss'

51184:
51185: --Deriving wip_entity_id
51186: v_sql_stmt := 10;
51187: lv_sql_stmt :=
51188: 'UPDATE msc_st_job_operation_networks mss'
51189: ||' SET wip_entity_id = (SELECT local_id'
51190: ||' FROM msc_local_id_supply mls'
51191: ||' WHERE mls.char4 = mss.wip_entity_name'
51192: ||' AND mls.char3 = mss.organization_code'

Line 51221: p_token_value3 => 'MSC_ST_JOB_OPERATION_NETWORKS' );

51217: ||'ORGANIZATION_CODE,WIP_ENTITY_NAME',
51218: p_token2 => 'MASTER_TABLE',
51219: p_token_value2 => 'MSC_ST_SUPPLIES',
51220: p_token3 => 'CHILD_TABLE' ,
51221: p_token_value3 => 'MSC_ST_JOB_OPERATION_NETWORKS' );
51222:
51223: IF lv_return <> 0 THEN
51224: RAISE ex_logging_err;
51225: END IF;

Line 51232: 'UPDATE msc_st_job_operation_networks msrr'

51228: -- Error out the records if WIP_ENTITY_ID NULL
51229:
51230: v_sql_stmt := 11;
51231: lv_sql_stmt:=
51232: 'UPDATE msc_st_job_operation_networks msrr'
51233: ||' SET process_flag ='||G_ERROR_FLG||','
51234: ||' error_text = '||''''||lv_message_text||''''
51235: ||' WHERE NVL(wip_entity_id,'||NULL_VALUE||') = '||NULL_VALUE
51236: ||' AND sr_instance_code = :v_instance_code'

Line 51264: 'UPDATE msc_st_job_operation_networks'

51260: -- Error out the records whose from_operation_seq_code or to_operation_seq_code is NULL
51261:
51262: v_sql_stmt := 12;
51263: lv_sql_stmt :=
51264: 'UPDATE msc_st_job_operation_networks'
51265: ||' SET process_flag ='||G_ERROR_FLG||','
51266: ||' error_text = '||''''||lv_message_text||''''
51267: ||' WHERE ( NVL(from_operation_seq_code,'||''''||NULL_CHAR||''''||') = '||''''||NULL_CHAR||''''
51268: ||' OR NVL(to_operation_seq_code,'||''''||NULL_CHAR||''''||') = '||''''||NULL_CHAR||''''||') '

Line 51295: 'UPDATE msc_st_job_operation_networks'

51291: -- Error out the records whose from_operation_seq_code is same as to_op_seq_code
51292:
51293: v_sql_stmt := 13;
51294: lv_sql_stmt :=
51295: 'UPDATE msc_st_job_operation_networks'
51296: ||' SET process_flag ='||G_ERROR_FLG||','
51297: ||' error_text = '||''''||lv_message_text||''''
51298: ||' WHERE NVL(to_operation_seq_code,'||''''||NULL_CHAR||''''||') = NVL(from_operation_seq_code,'||''''||NULL_CHAR||''''||')'
51299: ||' AND sr_instance_code = :v_instance_code'

Line 51322: p_token_value3 => 'MSC_ST_JOB_OPERATION_NETWORKS' );

51318: ||'ORGANIZATION_CODE,ROUTING_NAME',
51319: p_token2 => 'MASTER_TABLE',
51320: p_token_value2 => 'MSC_ST_ROUTINGS',
51321: p_token3 => 'CHILD_TABLE' ,
51322: p_token_value3 => 'MSC_ST_JOB_OPERATION_NETWORKS' );
51323:
51324: IF lv_return <> 0 THEN
51325: RAISE ex_logging_err;
51326: END IF;

Line 51332: (p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS',

51328: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
51329:
51330: lv_return :=
51331: MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID
51332: (p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS',
51333: p_rtg_col_name => 'ROUTING_NAME',
51334: p_rtg_col_id => 'ROUTING_SEQUENCE_ID',
51335: p_instance_code => v_instance_code,
51336: p_severity => G_SEV_ERROR,

Line 51369: (p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS',

51365: lv_where_str :=
51366: ' AND NVL(from_op_effectivity_date,SYSDATE-36500 ) = SYSDATE-36500 ' ;
51367:
51368: lv_return := MSC_ST_UTIL.LOG_ERROR
51369: (p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS',
51370: p_instance_code => v_instance_code,
51371: p_row => lv_column_names,
51372: p_severity => G_SEV_WARNING,
51373: p_message_text => lv_message_text,

Line 51407: (p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS',

51403: lv_where_str :=
51404: ' AND NVL(to_op_effectivity_date,SYSDATE-36500 ) = SYSDATE-36500 ' ;
51405:
51406: lv_return := MSC_ST_UTIL.LOG_ERROR
51407: (p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS',
51408: p_instance_code => v_instance_code,
51409: p_row => lv_column_names,
51410: p_severity => G_SEV_WARNING,
51411: p_message_text => lv_message_text,

Line 51427: 'UPDATE msc_st_job_operation_networks mson'

51423: -- Derive from_op_seq_id, from_op_seq_num
51424:
51425: v_sql_stmt := 16;
51426: lv_sql_Stmt :=
51427: 'UPDATE msc_st_job_operation_networks mson'
51428: ||' SET (from_op_seq_id, from_op_seq_num) = (SELECT local_id, number1'
51429: ||' FROM msc_local_id_setup mlis'
51430: ||' WHERE mlis.char1 = mson.sr_instance_code'
51431: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 51470: 'UPDATE msc_st_job_operation_networks'

51466: -- Error out the records whose from_op_seq_id, from _op_seq_num is NULL
51467:
51468: v_sql_stmt := 17;
51469: lv_sql_stmt :=
51470: 'UPDATE msc_st_job_operation_networks'
51471: ||' SET process_flag ='||G_ERROR_FLG||','
51472: ||' error_text = '||''''||lv_message_text||''''
51473: ||' WHERE (NVL(from_op_seq_id,'||NULL_VALUE||') ='||NULL_VALUE
51474: ||' OR NVL(from_op_seq_num,'||NULL_VALUE||') ='||NULL_VALUE||')'

Line 51489: 'UPDATE msc_st_job_operation_networks mson'

51485: -- Derive to_op_seq_id, to_op_seq_num
51486:
51487: v_sql_stmt := 18;
51488: lv_sql_Stmt :=
51489: 'UPDATE msc_st_job_operation_networks mson'
51490: ||' SET (to_op_seq_id, to_op_seq_num) = (SELECT local_id, number1'
51491: ||' FROM msc_local_id_setup mlis'
51492: ||' WHERE mlis.char1 = mson.sr_instance_code'
51493: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 51532: 'UPDATE msc_st_job_operation_networks'

51528: -- Error out the records whose to_op_seq_id, to_op_seq_num is NULL
51529:
51530: v_sql_stmt := 19;
51531: lv_sql_stmt :=
51532: 'UPDATE msc_st_job_operation_networks'
51533: ||' SET process_flag ='||G_ERROR_FLG||','
51534: ||' error_text = '||''''||lv_message_text||''''
51535: ||' WHERE (NVL(to_op_seq_id,'||NULL_VALUE||') ='||NULL_VALUE
51536: ||' OR NVL(to_op_seq_num,'||NULL_VALUE||') ='||NULL_VALUE||')'

Line 51567: (p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS',

51563: lv_where_str :=
51564: ' AND NVL(transition_type,'||NULL_VALUE||') NOT IN (1,2)';
51565:
51566: lv_return := MSC_ST_UTIL.LOG_ERROR
51567: (p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS',
51568: p_instance_code => v_instance_code,
51569: p_row => lv_column_names,
51570: p_severity => G_SEV_WARNING,
51571: p_message_text => lv_message_text,

Line 51591: pEntityName => 'MSC_ST_JOB_OPERATION_NETWORKS',

51587: (ERRBUF => lv_error_text,
51588: RETCODE => lv_return,
51589: pBatchID => lv_batch_id,
51590: pInstanceCode => v_instance_code,
51591: pEntityName => 'MSC_ST_JOB_OPERATION_NETWORKS',
51592: pInstanceID => v_instance_id);
51593:
51594: IF NVL(lv_return,0) <> 0 THEN
51595: RAISE ex_logging_err;

Line 51619: 'UPDATE msc_st_job_operation_networks mson1'

51615: END IF;
51616:
51617: v_sql_stmt := 21;
51618: lv_sql_stmt :=
51619: 'UPDATE msc_st_job_operation_networks mson1'
51620: ||' SET process_flag = '||G_ERROR_FLG||','
51621: ||' error_text = '||''''||lv_message_text||''''
51622: ||' WHERE 1 < ( SELECT COUNT(*) '
51623: ||' FROM msc_st_job_operation_networks mson2'

Line 51623: ||' FROM msc_st_job_operation_networks mson2'

51619: 'UPDATE msc_st_job_operation_networks mson1'
51620: ||' SET process_flag = '||G_ERROR_FLG||','
51621: ||' error_text = '||''''||lv_message_text||''''
51622: ||' WHERE 1 < ( SELECT COUNT(*) '
51623: ||' FROM msc_st_job_operation_networks mson2'
51624: ||' WHERE mson2.wip_entity_name = mson1.wip_entity_name'
51625: ||' AND mson2.organization_code = mson1.organization_code'
51626: ||' AND mson2.from_operation_seq_code = mson1.from_operation_seq_code'
51627: ||' AND mson2.sr_instance_code = mson1.sr_instance_code'

Line 51662: 'UPDATE msc_st_job_operation_networks mson1'

51658: END IF;
51659:
51660: v_sql_stmt := 22;
51661: lv_sql_stmt :=
51662: 'UPDATE msc_st_job_operation_networks mson1'
51663: ||' SET process_flag = '||G_ERROR_FLG||','
51664: ||' error_text = '||''''||lv_message_text||''''
51665: ||' WHERE 100 <> ( SELECT SUM(planning_pct) '
51666: ||' FROM msc_st_job_operation_networks mson2'

Line 51666: ||' FROM msc_st_job_operation_networks mson2'

51662: 'UPDATE msc_st_job_operation_networks mson1'
51663: ||' SET process_flag = '||G_ERROR_FLG||','
51664: ||' error_text = '||''''||lv_message_text||''''
51665: ||' WHERE 100 <> ( SELECT SUM(planning_pct) '
51666: ||' FROM msc_st_job_operation_networks mson2'
51667: ||' WHERE mson2.wip_entity_name = mson1.wip_entity_name'
51668: ||' AND mson2.organization_code = mson1.organization_code'
51669: ||' AND mson2.from_operation_seq_code = mson1.from_operation_seq_code'
51670: ||' AND mson2.sr_instance_code = mson1.sr_instance_code'

Line 51687: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS',

51683: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code;
51684:
51685: -- Set the process flag as Valid and derive sr_instance_id
51686: lv_return :=
51687: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS',
51688: p_instance_id => v_instance_id,
51689: p_instance_code => v_instance_code,
51690: p_process_flag => G_VALID,
51691: p_error_text => lv_error_text,

Line 51701: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS',

51697:
51698: -- At the end calling the LOG_ERROR for logging all errored out records
51699:
51700: lv_return :=
51701: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS',
51702: p_instance_code => v_instance_code,
51703: p_row => lv_column_names,
51704: p_severity => G_SEV_ERROR,
51705: p_message_text => NULL,

Line 52033: p_token_value3 => 'MSC_ST_JOB_OPERATION_NETWORKS' );

52029: ||'ORGANIZATION_CODE,WIP_ENTITY_NAME',
52030: p_token2 => 'MASTER_TABLE',
52031: p_token_value2 => 'MSC_ST_SUPPLIES',
52032: p_token3 => 'CHILD_TABLE' ,
52033: p_token_value3 => 'MSC_ST_JOB_OPERATION_NETWORKS' );
52034:
52035: IF lv_return <> 0 THEN
52036: RAISE ex_logging_err;
52037: END IF;

Line 55774: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS');

55770: prec.external_repair_flag:=SYS_YES;
55771: prec.ret_fcst_flag:=SYS_YES;--13839374 returns forecast proj
55772: End IF;
55773:
55774: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_OPERATION_NETWORKS');
55775: IF lv_count > 0 Then
55776: prec.wip_flag:= SYS_YES;
55777: End IF;
55778: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_OPERATIONS');