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 1624: ||' on MSC_ST_JOB_REQUIREMENT_OPS '

1620: application_short_name => 'MSC',
1621: statement_type => AD_DDL.CREATE_INDEX,
1622: statement =>
1623: 'create index MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code
1624: ||' on MSC_ST_JOB_REQUIREMENT_OPS '
1625: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE, COMPONENT_NAME, PRIMARY_COMPONENT_NAME ) '
1626: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1627: object_name =>'MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code);
1628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code);

Line 50770: FROM msc_st_job_requirement_ops

50766: AND batch_id = p_batch_id;
50767:
50768: CURSOR c4 (p_batch_id NUMBER) IS
50769: SELECT rowid
50770: FROM msc_st_job_requirement_ops
50771: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
50772: AND batch_id = p_batch_id
50773: AND sr_instance_code = v_instance_code;
50774:

Line 52348: -- Validation for MSC_ST_JOB_REQUIREMENT_OPS

52344:
52345: COMMIT;
52346: END LOOP;
52347:
52348: -- Validation for MSC_ST_JOB_REQUIREMENT_OPS
52349:
52350: --Duplicate records check for the records whose source is XML
52351:
52352: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 52365: 'UPDATE msc_st_job_requirement_ops msd1'

52361:
52362: v_sql_stmt := 18;
52363:
52364: lv_sql_stmt :=
52365: 'UPDATE msc_st_job_requirement_ops msd1'
52366: ||' SET process_flag = '||G_ERROR_FLG||','
52367: ||' error_text = '||''''||lv_message_text||''''
52368: ||' WHERE message_id < (SELECT MAX(message_id)'
52369: ||' FROM msc_st_job_requirement_ops msd2'

Line 52369: ||' FROM msc_st_job_requirement_ops msd2'

52365: 'UPDATE msc_st_job_requirement_ops msd1'
52366: ||' SET process_flag = '||G_ERROR_FLG||','
52367: ||' error_text = '||''''||lv_message_text||''''
52368: ||' WHERE message_id < (SELECT MAX(message_id)'
52369: ||' FROM msc_st_job_requirement_ops msd2'
52370: ||' WHERE msd2.sr_instance_code '
52371: ||' = msd1.sr_instance_code '
52372: ||' AND msd2.organization_code '
52373: ||' = msd1.organization_code '

Line 52419: 'UPDATE msc_st_job_requirement_ops msd1'

52415:
52416: v_sql_stmt := 02;
52417:
52418: lv_sql_stmt :=
52419: 'UPDATE msc_st_job_requirement_ops msd1'
52420: ||' SET process_flag = '||G_ERROR_FLG||','
52421: ||' error_text = '||''''||lv_message_text||''''
52422: ||' WHERE EXISTS( SELECT 1 '
52423: ||' FROM msc_st_job_requirement_ops msd2'

Line 52423: ||' FROM msc_st_job_requirement_ops msd2'

52419: 'UPDATE msc_st_job_requirement_ops msd1'
52420: ||' SET process_flag = '||G_ERROR_FLG||','
52421: ||' error_text = '||''''||lv_message_text||''''
52422: ||' WHERE EXISTS( SELECT 1 '
52423: ||' FROM msc_st_job_requirement_ops msd2'
52424: ||' WHERE msd2.sr_instance_code '
52425: ||' = msd1.sr_instance_code '
52426: ||' AND msd2.organization_code '
52427: ||' = msd1.organization_code '

Line 52487: ' UPDATE msc_st_job_requirement_ops '

52483: FROM DUAL;
52484:
52485: v_sql_stmt := 04;
52486: lv_sql_stmt :=
52487: ' UPDATE msc_st_job_requirement_ops '
52488: ||' SET batch_id = :lv_batch_id'
52489: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
52490: ||' AND sr_instance_code = :v_instance_code'
52491: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 52510: UPDATE msc_st_job_requirement_ops

52506: CLOSE c4;
52507:
52508: v_sql_stmt := 03;
52509: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
52510: UPDATE msc_st_job_requirement_ops
52511: SET st_transaction_id = msc_st_job_requirement_ops_s.NEXTVAL,
52512: refresh_id = v_refresh_id,
52513: last_update_date = v_current_date,
52514: last_updated_by = v_current_user,

Line 52511: SET st_transaction_id = msc_st_job_requirement_ops_s.NEXTVAL,

52507:
52508: v_sql_stmt := 03;
52509: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
52510: UPDATE msc_st_job_requirement_ops
52511: SET st_transaction_id = msc_st_job_requirement_ops_s.NEXTVAL,
52512: refresh_id = v_refresh_id,
52513: last_update_date = v_current_date,
52514: last_updated_by = v_current_user,
52515: creation_date = v_current_date,

Line 52540: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

52536: lv_where_str :=
52537: ' AND NVL(deleted_flag,'||NULL_VALUE||') NOT IN(1,2)';
52538:
52539: lv_return := MSC_ST_UTIL.LOG_ERROR
52540: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
52541: p_instance_code => v_instance_code,
52542: p_row => lv_column_names,
52543: p_severity => G_SEV_WARNING,
52544: p_message_text => lv_message_text,

Line 52571: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

52567: END IF;
52568:
52569: --Derive Organization_id
52570: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
52571: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
52572: p_org_partner_name => 'ORGANIZATION_CODE',
52573: p_org_partner_id => 'ORGANIZATION_ID',
52574: p_instance_code => v_instance_code,
52575: p_partner_type => G_ORGANIZATION,

Line 52590: 'UPDATE msc_st_job_requirement_ops mss'

52586:
52587: --Deriving wip_entity_id
52588: v_sql_stmt := 10;
52589: lv_sql_stmt :=
52590: 'UPDATE msc_st_job_requirement_ops mss'
52591: ||' SET wip_entity_id = (SELECT local_id'
52592: ||' FROM msc_local_id_supply mls'
52593: ||' WHERE mls.char4 = mss.wip_entity_name'
52594: ||' AND mls.char3 = mss.organization_code'

Line 52623: p_token_value3 => 'MSC_ST_JOB_REQUIREMENT_OPS' );

52619: ||'ORGANIZATION_CODE,WIP_ENTITY_NAME',
52620: p_token2 => 'MASTER_TABLE',
52621: p_token_value2 => 'MSC_ST_SUPPLIES',
52622: p_token3 => 'CHILD_TABLE' ,
52623: p_token_value3 => 'MSC_ST_JOB_REQUIREMENT_OPS' );
52624:
52625: IF lv_return <> 0 THEN
52626: RAISE ex_logging_err;
52627: END IF;

Line 52633: 'UPDATE msc_st_job_requirement_ops msrr'

52629:
52630: -- Error out the records if WIP_ENTITY_ID NULL
52631:
52632: lv_sql_stmt:=
52633: 'UPDATE msc_st_job_requirement_ops msrr'
52634: ||' SET process_flag ='||G_ERROR_FLG||','
52635: ||' error_text = '||''''||lv_message_text||''''
52636: ||' WHERE NVL(wip_entity_id,'||NULL_VALUE||') = '||NULL_VALUE
52637: ||' AND sr_instance_code = :v_instance_code'

Line 52663: 'UPDATE msc_st_job_requirement_ops'

52659: -- Error out the records where RECOMMENDED is not 'Y' or 'N'
52660:
52661: v_sql_stmt := 7;
52662: lv_sql_stmt :=
52663: 'UPDATE msc_st_job_requirement_ops'
52664: ||' SET process_flag ='||G_ERROR_FLG||','
52665: ||' error_text = '||''''||lv_message_text||''''
52666: ||' WHERE recommended NOT IN (''Y'', ''N'',''y'',''n'')'
52667: ||' AND sr_instance_code = :v_instance_code'

Line 52691: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

52687: END IF;
52688:
52689: --Derive component_item_id
52690: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
52691: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
52692: p_item_col_name => 'COMPONENT_NAME',
52693: p_item_col_id => 'COMPONENT_ITEM_ID',
52694: p_instance_id => v_instance_id,
52695: p_instance_code => v_instance_code,

Line 52722: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

52718: END IF;
52719:
52720: --Derive primary_component_id
52721: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
52722: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
52723: p_item_col_name => 'PRIMARY_COMPONENT_NAME',
52724: p_item_col_id => 'PRIMARY_COMPONENT_ID',
52725: p_instance_id => v_instance_id,
52726: p_instance_code => v_instance_code,

Line 52753: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

52749: END IF;
52750:
52751: --Derive primary_component_id
52752: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
52753: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
52754: p_item_col_name => 'SOURCE_PHANTOM_NAME',
52755: p_item_col_id => 'SOURCE_PHANTOM_ID',
52756: p_instance_id => v_instance_id,
52757: p_instance_code => v_instance_code,

Line 52788: 'UPDATE msc_st_job_requirement_ops '

52784: -- Error out records where QUANTITY_PER_ASSEMBLY is NULL;
52785:
52786: v_sql_stmt := 06;
52787: lv_sql_stmt :=
52788: 'UPDATE msc_st_job_requirement_ops '
52789: ||' SET process_flag = '||G_ERROR_FLG||','
52790: ||' error_text = '||''''||lv_message_text||''''
52791: ||' WHERE NVL(quantity_per_assembly,'||NULL_VALUE||')='||NULL_VALUE
52792: ||' AND process_flag = '||G_IN_PROCESS

Line 52823: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

52819: lv_where_str :=
52820: ' AND NVL(effectivity_date,SYSDATE-36500 ) = SYSDATE-36500 ' ;
52821:
52822: lv_return := MSC_ST_UTIL.LOG_ERROR
52823: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
52824: p_instance_code => v_instance_code,
52825: p_row => lv_column_names,
52826: p_severity => G_SEV_WARNING,
52827: p_message_text => lv_message_text,

Line 52860: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

52856: lv_where_str :=
52857: ' AND NVL(COMPONENT_YIELD_FACTOR,'||NULL_VALUE||') = '||NULL_VALUE ;
52858:
52859: lv_return := MSC_ST_UTIL.LOG_ERROR
52860: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
52861: p_instance_code => v_instance_code,
52862: p_row => lv_column_names,
52863: p_severity => G_SEV_WARNING,
52864: p_message_text => lv_message_text,

Line 52897: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

52893: lv_where_str :=
52894: ' AND NVL(PLANNING_FACTOR,'||NULL_VALUE||') = '||NULL_VALUE ;
52895:
52896: lv_return := MSC_ST_UTIL.LOG_ERROR
52897: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
52898: p_instance_code => v_instance_code,
52899: p_row => lv_column_names,
52900: p_severity => G_SEV_WARNING,
52901: p_message_text => lv_message_text,

Line 52934: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

52930: lv_where_str := ' AND NVL(wip_supply_type,'||NULL_VALUE||') NOT IN (1,2,3,4,5,6,7)'
52931: ||' AND deleted_flag ='||SYS_NO ;
52932:
52933: lv_return := MSC_ST_UTIL.LOG_ERROR
52934: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
52935: p_instance_code => v_instance_code,
52936: p_row => lv_column_names,
52937: p_severity => G_SEV_WARNING,
52938: p_message_text => lv_message_text,

Line 52954: ' UPDATE msc_st_job_requirement_ops'

52950: -- If routing_name is is NULL populate the assembly_item_name in routing name
52951:
52952: v_sql_stmt := 11;
52953: lv_sql_stmt :=
52954: ' UPDATE msc_st_job_requirement_ops'
52955: ||' SET routing_name = assembly_item_name'
52956: ||' WHERE process_flag = '||G_IN_PROCESS
52957: ||' AND NVL(routing_name,'||''''||NULL_CHAR||''''||')'
52958: ||' = '||''''||NULL_CHAR||''''

Line 52982: p_token_value3 => 'MSC_ST_JOB_REQUIREMENT_OPS' );

52978: ||'ORGANIZATION_CODE,ROUTING_NAME',
52979: p_token2 => 'MASTER_TABLE',
52980: p_token_value2 => 'MSC_ST_ROUTINGS',
52981: p_token3 => 'CHILD_TABLE' ,
52982: p_token_value3 => 'MSC_ST_JOB_REQUIREMENT_OPS' );
52983:
52984: IF lv_return <> 0 THEN
52985: RAISE ex_logging_err;
52986: END IF;

Line 52992: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

52988: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
52989:
52990: lv_return :=
52991: MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID
52992: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
52993: p_rtg_col_name => 'ROUTING_NAME',
52994: p_rtg_col_id => 'ROUTING_SEQUENCE_ID',
52995: p_instance_code => v_instance_code,
52996: p_severity => G_SEV_ERROR,

Line 53011: 'UPDATE msc_st_job_requirement_ops msd'

53007: -- Derive operation seq num from local id table
53008:
53009: v_sql_stmt := 12;
53010: lv_sql_stmt:=
53011: 'UPDATE msc_st_job_requirement_ops msd'
53012: ||' SET operation_seq_num= (SELECT number1'
53013: ||' FROM msc_local_id_setup mlis'
53014: ||' WHERE mlis.char1 = msd.sr_instance_code'
53015: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 53053: 'UPDATE msc_st_job_requirement_ops'

53049: -- Error out the records whose operation_seq_num is NULL
53050:
53051: v_sql_stmt := 19;
53052: lv_sql_stmt :=
53053: 'UPDATE msc_st_job_requirement_ops'
53054: ||' SET process_flag ='||G_ERROR_FLG||','
53055: ||' error_text = '||''''||lv_message_text||''''
53056: ||' WHERE NVL(operation_seq_num,'||NULL_VALUE||') ='||NULL_VALUE
53057: ||' AND sr_instance_code = :v_instance_code'

Line 53069: 'UPDATE msc_st_job_requirement_ops mjro'

53065:
53066: -- Derive the component_sequence_id
53067:
53068: lv_sql_stmt :=
53069: 'UPDATE msc_st_job_requirement_ops mjro'
53070: ||' SET component_sequence_id= (SELECT local_id '
53071: ||' FROM msc_local_id_setup mlis'
53072: ||' WHERE mlis.char1 = mjro.sr_instance_code'
53073: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 53111: 'UPDATE msc_st_job_requirement_ops'

53107: -- Error out the records where component_sequence_id is NULL
53108:
53109:
53110: lv_sql_stmt :=
53111: 'UPDATE msc_st_job_requirement_ops'
53112: ||' SET process_flag ='||G_ERROR_FLG||','
53113: ||' error_text = '||''''||lv_message_text||''''
53114: ||' WHERE NVL(component_sequence_id,'||NULL_VALUE||') ='||NULL_VALUE
53115: ||' AND sr_instance_code = :v_instance_code'

Line 53126: 'UPDATE msc_st_job_requirement_ops mjro'

53122:
53123: -- Derive department id
53124:
53125: lv_sql_stmt :=
53126: 'UPDATE msc_st_job_requirement_ops mjro'
53127: ||' SET department_id= (SELECT local_id'
53128: ||' FROM msc_local_id_setup mlis'
53129: ||' WHERE mlis.char1 = mjro.sr_instance_code'
53130: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 53153: pEntityName => 'MSC_ST_JOB_REQUIREMENT_OPS',

53149: (ERRBUF => lv_error_text,
53150: RETCODE => lv_return,
53151: pBatchID => lv_batch_id,
53152: pInstanceCode => v_instance_code,
53153: pEntityName => 'MSC_ST_JOB_REQUIREMENT_OPS',
53154: pInstanceID => v_instance_id);
53155:
53156: IF NVL(lv_return,0) <> 0 THEN
53157: RAISE ex_logging_err;

Line 53161: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

53157: RAISE ex_logging_err;
53158: END IF;
53159:
53160: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
53161: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
53162: p_instance_id => v_instance_id,
53163: p_instance_code => v_instance_code,
53164: p_process_flag => G_VALID,
53165: p_error_text => lv_error_text,

Line 53174: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',

53170: RAISE ex_logging_err;
53171: END IF;
53172:
53173: lv_return := MSC_ST_UTIL.LOG_ERROR
53174: (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS',
53175: p_instance_code => v_instance_code,
53176: p_row => lv_column_names,
53177: p_severity => G_SEV_ERROR,
53178: p_message_text => NULL,

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

55778: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_OPERATIONS');
55779: IF lv_count > 0 Then
55780: prec.wip_flag:= SYS_YES;
55781: End IF;
55782: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_REQUIREMENT_OPS');
55783: IF lv_count > 0 Then
55784: prec.wip_flag:= SYS_YES;
55785: End IF;
55786: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_OP_RESOURCES');