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_REQUIREMENT_OPS

Line 1616: ||' on MSC_ST_JOB_REQUIREMENT_OPS '

1612: application_short_name => 'MSC',
1613: statement_type => AD_DDL.CREATE_INDEX,
1614: statement =>
1615: 'create index MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code
1616: ||' on MSC_ST_JOB_REQUIREMENT_OPS '
1617: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE, COMPONENT_NAME, PRIMARY_COMPONENT_NAME ) '
1618: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1619: object_name =>'MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code);
1620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code);

Line 45886: FROM msc_st_job_requirement_ops

45882: AND batch_id = p_batch_id;
45883:
45884: CURSOR c4 (p_batch_id NUMBER) IS
45885: SELECT rowid
45886: FROM msc_st_job_requirement_ops
45887: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
45888: AND batch_id = p_batch_id
45889: AND sr_instance_code = v_instance_code;
45890:

Line 47464: -- Validation for MSC_ST_JOB_REQUIREMENT_OPS

47460:
47461: COMMIT;
47462: END LOOP;
47463:
47464: -- Validation for MSC_ST_JOB_REQUIREMENT_OPS
47465:
47466: --Duplicate records check for the records whose source is XML
47467:
47468: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 47481: 'UPDATE msc_st_job_requirement_ops msd1'

47477:
47478: v_sql_stmt := 18;
47479:
47480: lv_sql_stmt :=
47481: 'UPDATE msc_st_job_requirement_ops msd1'
47482: ||' SET process_flag = '||G_ERROR_FLG||','
47483: ||' error_text = '||''''||lv_message_text||''''
47484: ||' WHERE message_id < (SELECT MAX(message_id)'
47485: ||' FROM msc_st_job_requirement_ops msd2'

Line 47485: ||' FROM msc_st_job_requirement_ops msd2'

47481: 'UPDATE msc_st_job_requirement_ops msd1'
47482: ||' SET process_flag = '||G_ERROR_FLG||','
47483: ||' error_text = '||''''||lv_message_text||''''
47484: ||' WHERE message_id < (SELECT MAX(message_id)'
47485: ||' FROM msc_st_job_requirement_ops msd2'
47486: ||' WHERE msd2.sr_instance_code '
47487: ||' = msd1.sr_instance_code '
47488: ||' AND msd2.organization_code '
47489: ||' = msd1.organization_code '

Line 47535: 'UPDATE msc_st_job_requirement_ops msd1'

47531:
47532: v_sql_stmt := 02;
47533:
47534: lv_sql_stmt :=
47535: 'UPDATE msc_st_job_requirement_ops msd1'
47536: ||' SET process_flag = '||G_ERROR_FLG||','
47537: ||' error_text = '||''''||lv_message_text||''''
47538: ||' WHERE EXISTS( SELECT 1 '
47539: ||' FROM msc_st_job_requirement_ops msd2'

Line 47539: ||' FROM msc_st_job_requirement_ops msd2'

47535: 'UPDATE msc_st_job_requirement_ops msd1'
47536: ||' SET process_flag = '||G_ERROR_FLG||','
47537: ||' error_text = '||''''||lv_message_text||''''
47538: ||' WHERE EXISTS( SELECT 1 '
47539: ||' FROM msc_st_job_requirement_ops msd2'
47540: ||' WHERE msd2.sr_instance_code '
47541: ||' = msd1.sr_instance_code '
47542: ||' AND msd2.organization_code '
47543: ||' = msd1.organization_code '

Line 47603: ' UPDATE msc_st_job_requirement_ops '

47599: FROM DUAL;
47600:
47601: v_sql_stmt := 04;
47602: lv_sql_stmt :=
47603: ' UPDATE msc_st_job_requirement_ops '
47604: ||' SET batch_id = :lv_batch_id'
47605: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
47606: ||' AND sr_instance_code = :v_instance_code'
47607: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 47626: UPDATE msc_st_job_requirement_ops

47622: CLOSE c4;
47623:
47624: v_sql_stmt := 03;
47625: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
47626: UPDATE msc_st_job_requirement_ops
47627: SET st_transaction_id = msc_st_job_requirement_ops_s.NEXTVAL,
47628: refresh_id = v_refresh_id,
47629: last_update_date = v_current_date,
47630: last_updated_by = v_current_user,

Line 47627: SET st_transaction_id = msc_st_job_requirement_ops_s.NEXTVAL,

47623:
47624: v_sql_stmt := 03;
47625: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
47626: UPDATE msc_st_job_requirement_ops
47627: SET st_transaction_id = msc_st_job_requirement_ops_s.NEXTVAL,
47628: refresh_id = v_refresh_id,
47629: last_update_date = v_current_date,
47630: last_updated_by = v_current_user,
47631: creation_date = v_current_date,

Line 47656: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

47652: lv_where_str :=
47653: ' AND NVL(deleted_flag,'||NULL_VALUE||') NOT IN(1,2)';
47654:
47655: lv_return := MSC_ST_UTIL.LOG_ERROR
47656: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
47657: p_instance_code => v_instance_code,
47658: p_row => lv_column_names,
47659: p_severity => G_SEV_WARNING,
47660: p_message_text => lv_message_text,

Line 47687: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

47683: END IF;
47684:
47685: --Derive Organization_id
47686: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
47687: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
47688: p_org_partner_name => 'ORGANIZATION_CODE',
47689: p_org_partner_id => 'ORGANIZATION_ID',
47690: p_instance_code => v_instance_code,
47691: p_partner_type => G_ORGANIZATION,

Line 47706: 'UPDATE msc_st_job_requirement_ops mss'

47702:
47703: --Deriving wip_entity_id
47704: v_sql_stmt := 10;
47705: lv_sql_stmt :=
47706: 'UPDATE msc_st_job_requirement_ops mss'
47707: ||' SET wip_entity_id = (SELECT local_id'
47708: ||' FROM msc_local_id_supply mls'
47709: ||' WHERE mls.char4 = mss.wip_entity_name'
47710: ||' AND mls.char3 = mss.organization_code'

Line 47739: p_token_value3 => 'MSC_ST_JOB_REQUIREMENT_OPS' );

47735: ||'ORGANIZATION_CODE,WIP_ENTITY_NAME',
47736: p_token2 => 'MASTER_TABLE',
47737: p_token_value2 => 'MSC_ST_SUPPLIES',
47738: p_token3 => 'CHILD_TABLE' ,
47739: p_token_value3 => 'MSC_ST_JOB_REQUIREMENT_OPS' );
47740:
47741: IF lv_return <> 0 THEN
47742: RAISE ex_logging_err;
47743: END IF;

Line 47749: 'UPDATE msc_st_job_requirement_ops msrr'

47745:
47746: -- Error out the records if WIP_ENTITY_ID NULL
47747:
47748: lv_sql_stmt:=
47749: 'UPDATE msc_st_job_requirement_ops msrr'
47750: ||' SET process_flag ='||G_ERROR_FLG||','
47751: ||' error_text = '||''''||lv_message_text||''''
47752: ||' WHERE NVL(wip_entity_id,'||NULL_VALUE||') = '||NULL_VALUE
47753: ||' AND sr_instance_code = :v_instance_code'

Line 47779: 'UPDATE msc_st_job_requirement_ops'

47775: -- Error out the records where RECOMMENDED is not 'Y' or 'N'
47776:
47777: v_sql_stmt := 7;
47778: lv_sql_stmt :=
47779: 'UPDATE msc_st_job_requirement_ops'
47780: ||' SET process_flag ='||G_ERROR_FLG||','
47781: ||' error_text = '||''''||lv_message_text||''''
47782: ||' WHERE recommended NOT IN (''Y'', ''N'',''y'',''n'')'
47783: ||' AND sr_instance_code = :v_instance_code'

Line 47807: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

47803: END IF;
47804:
47805: --Derive component_item_id
47806: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
47807: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
47808: p_item_col_name => 'COMPONENT_NAME',
47809: p_item_col_id => 'COMPONENT_ITEM_ID',
47810: p_instance_id => v_instance_id,
47811: p_instance_code => v_instance_code,

Line 47838: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

47834: END IF;
47835:
47836: --Derive primary_component_id
47837: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
47838: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
47839: p_item_col_name => 'PRIMARY_COMPONENT_NAME',
47840: p_item_col_id => 'PRIMARY_COMPONENT_ID',
47841: p_instance_id => v_instance_id,
47842: p_instance_code => v_instance_code,

Line 47869: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

47865: END IF;
47866:
47867: --Derive primary_component_id
47868: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
47869: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
47870: p_item_col_name => 'SOURCE_PHANTOM_NAME',
47871: p_item_col_id => 'SOURCE_PHANTOM_ID',
47872: p_instance_id => v_instance_id,
47873: p_instance_code => v_instance_code,

Line 47904: 'UPDATE msc_st_job_requirement_ops '

47900: -- Error out records where QUANTITY_PER_ASSEMBLY is NULL;
47901:
47902: v_sql_stmt := 06;
47903: lv_sql_stmt :=
47904: 'UPDATE msc_st_job_requirement_ops '
47905: ||' SET process_flag = '||G_ERROR_FLG||','
47906: ||' error_text = '||''''||lv_message_text||''''
47907: ||' WHERE NVL(quantity_per_assembly,'||NULL_VALUE||')='||NULL_VALUE
47908: ||' AND process_flag = '||G_IN_PROCESS

Line 47939: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

47935: lv_where_str :=
47936: ' AND NVL(effectivity_date,SYSDATE-36500 ) = SYSDATE-36500 ' ;
47937:
47938: lv_return := MSC_ST_UTIL.LOG_ERROR
47939: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
47940: p_instance_code => v_instance_code,
47941: p_row => lv_column_names,
47942: p_severity => G_SEV_WARNING,
47943: p_message_text => lv_message_text,

Line 47976: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

47972: lv_where_str :=
47973: ' AND NVL(COMPONENT_YIELD_FACTOR,'||NULL_VALUE||') = '||NULL_VALUE ;
47974:
47975: lv_return := MSC_ST_UTIL.LOG_ERROR
47976: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
47977: p_instance_code => v_instance_code,
47978: p_row => lv_column_names,
47979: p_severity => G_SEV_WARNING,
47980: p_message_text => lv_message_text,

Line 48013: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

48009: lv_where_str :=
48010: ' AND NVL(PLANNING_FACTOR,'||NULL_VALUE||') = '||NULL_VALUE ;
48011:
48012: lv_return := MSC_ST_UTIL.LOG_ERROR
48013: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
48014: p_instance_code => v_instance_code,
48015: p_row => lv_column_names,
48016: p_severity => G_SEV_WARNING,
48017: p_message_text => lv_message_text,

Line 48050: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

48046: lv_where_str := ' AND NVL(wip_supply_type,'||NULL_VALUE||') NOT IN (1,2,3,4,5,6,7)'
48047: ||' AND deleted_flag ='||SYS_NO ;
48048:
48049: lv_return := MSC_ST_UTIL.LOG_ERROR
48050: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
48051: p_instance_code => v_instance_code,
48052: p_row => lv_column_names,
48053: p_severity => G_SEV_WARNING,
48054: p_message_text => lv_message_text,

Line 48070: ' UPDATE msc_st_job_requirement_ops'

48066: -- If routing_name is is NULL populate the assembly_item_name in routing name
48067:
48068: v_sql_stmt := 11;
48069: lv_sql_stmt :=
48070: ' UPDATE msc_st_job_requirement_ops'
48071: ||' SET routing_name = assembly_item_name'
48072: ||' WHERE process_flag = '||G_IN_PROCESS
48073: ||' AND NVL(routing_name,'||''''||NULL_CHAR||''''||')'
48074: ||' = '||''''||NULL_CHAR||''''

Line 48098: p_token_value3 => 'MSC_ST_JOB_REQUIREMENT_OPS' );

48094: ||'ORGANIZATION_CODE,ROUTING_NAME',
48095: p_token2 => 'MASTER_TABLE',
48096: p_token_value2 => 'MSC_ST_ROUTINGS',
48097: p_token3 => 'CHILD_TABLE' ,
48098: p_token_value3 => 'MSC_ST_JOB_REQUIREMENT_OPS' );
48099:
48100: IF lv_return <> 0 THEN
48101: RAISE ex_logging_err;
48102: END IF;

Line 48108: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

48104: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
48105:
48106: lv_return :=
48107: MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID
48108: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
48109: p_rtg_col_name => 'ROUTING_NAME',
48110: p_rtg_col_id => 'ROUTING_SEQUENCE_ID',
48111: p_instance_code => v_instance_code,
48112: p_severity => G_SEV_ERROR,

Line 48127: 'UPDATE msc_st_job_requirement_ops msd'

48123: -- Derive operation seq num from local id table
48124:
48125: v_sql_stmt := 12;
48126: lv_sql_stmt:=
48127: 'UPDATE msc_st_job_requirement_ops msd'
48128: ||' SET operation_seq_num= (SELECT number1'
48129: ||' FROM msc_local_id_setup mlis'
48130: ||' WHERE mlis.char1 = msd.sr_instance_code'
48131: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 48169: 'UPDATE msc_st_job_requirement_ops'

48165: -- Error out the records whose operation_seq_num is NULL
48166:
48167: v_sql_stmt := 19;
48168: lv_sql_stmt :=
48169: 'UPDATE msc_st_job_requirement_ops'
48170: ||' SET process_flag ='||G_ERROR_FLG||','
48171: ||' error_text = '||''''||lv_message_text||''''
48172: ||' WHERE NVL(operation_seq_num,'||NULL_VALUE||') ='||NULL_VALUE
48173: ||' AND sr_instance_code = :v_instance_code'

Line 48185: 'UPDATE msc_st_job_requirement_ops mjro'

48181:
48182: -- Derive the component_sequence_id
48183:
48184: lv_sql_stmt :=
48185: 'UPDATE msc_st_job_requirement_ops mjro'
48186: ||' SET component_sequence_id= (SELECT local_id '
48187: ||' FROM msc_local_id_setup mlis'
48188: ||' WHERE mlis.char1 = mjro.sr_instance_code'
48189: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 48227: 'UPDATE msc_st_job_requirement_ops'

48223: -- Error out the records where component_sequence_id is NULL
48224:
48225:
48226: lv_sql_stmt :=
48227: 'UPDATE msc_st_job_requirement_ops'
48228: ||' SET process_flag ='||G_ERROR_FLG||','
48229: ||' error_text = '||''''||lv_message_text||''''
48230: ||' WHERE NVL(component_sequence_id,'||NULL_VALUE||') ='||NULL_VALUE
48231: ||' AND sr_instance_code = :v_instance_code'

Line 48242: 'UPDATE msc_st_job_requirement_ops mjro'

48238:
48239: -- Derive department id
48240:
48241: lv_sql_stmt :=
48242: 'UPDATE msc_st_job_requirement_ops mjro'
48243: ||' SET department_id= (SELECT local_id'
48244: ||' FROM msc_local_id_setup mlis'
48245: ||' WHERE mlis.char1 = mjro.sr_instance_code'
48246: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 48269: pEntityName => 'MSC_ST_JOB_REQUIREMENT_OPS',

48265: (ERRBUF => lv_error_text,
48266: RETCODE => lv_return,
48267: pBatchID => lv_batch_id,
48268: pInstanceCode => v_instance_code,
48269: pEntityName => 'MSC_ST_JOB_REQUIREMENT_OPS',
48270: pInstanceID => v_instance_id);
48271:
48272: IF NVL(lv_return,0) <> 0 THEN
48273: RAISE ex_logging_err;

Line 48277: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

48273: RAISE ex_logging_err;
48274: END IF;
48275:
48276: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
48277: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
48278: p_instance_id => v_instance_id,
48279: p_instance_code => v_instance_code,
48280: p_process_flag => G_VALID,
48281: p_error_text => lv_error_text,

Line 48290: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

48286: RAISE ex_logging_err;
48287: END IF;
48288:
48289: lv_return := MSC_ST_UTIL.LOG_ERROR
48290: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
48291: p_instance_code => v_instance_code,
48292: p_row => lv_column_names,
48293: p_severity => G_SEV_ERROR,
48294: p_message_text => NULL,

Line 50868: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS');

50864: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_OPERATIONS');
50865: IF lv_count > 0 Then
50866: prec.wip_flag:= SYS_YES;
50867: End IF;
50868: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS');
50869: IF lv_count > 0 Then
50870: prec.wip_flag:= SYS_YES;
50871: End IF;
50872: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_OP_RESOURCES');