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_REQUIREMENTS

Line 1404: ||' on MSC_ST_RESOURCE_REQUIREMENTS '

1400: application_short_name => 'MSC',
1401: statement_type => AD_DDL.CREATE_INDEX,
1402: statement =>
1403: 'create index MSC_ST_RES_REQ_N1_'||v_instance_code
1404: ||' on MSC_ST_RESOURCE_REQUIREMENTS '
1405: ||'(sr_instance_code, resource_code, wip_entity_name, operation_seq_code, organization_code, company_name, resource_seq_code) '
1406: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1407: object_name =>'MSC_ST_RES_REQ_N1_'||v_instance_code);
1408:

Line 1416: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_REQUIREMENTS', v_instance_id, -1);

1412: WHEN OTHERS THEN
1413: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_RES_REQ_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1414: END;
1415:
1416: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_REQUIREMENTS', v_instance_id, -1);
1417:
1418: END IF;
1419:
1420: IF v_uom_class_enabled = SYS_YES THEN

Line 48393: lv_batch_id msc_st_resource_requirements.batch_id%TYPE;

48389: lv_error_text VARCHAR2(250);
48390: lv_where_str VARCHAR2(5000);
48391: lv_sql_stmt VARCHAR2(5000);
48392: lv_cursor_stmt VARCHAR2(5000);
48393: lv_batch_id msc_st_resource_requirements.batch_id%TYPE;
48394: lv_message_text msc_errors.error_text%TYPE;
48395:
48396: ex_logging_err EXCEPTION;
48397:

Line 48400: FROM msc_st_resource_requirements

48396: ex_logging_err EXCEPTION;
48397:
48398: CURSOR c2(p_batch_id NUMBER) IS
48399: SELECT rowid
48400: FROM msc_st_resource_requirements
48401: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
48402: AND sr_instance_code = v_instance_code
48403: AND batch_id = p_batch_id;
48404:

Line 48407: FROM msc_st_resource_requirements

48403: AND batch_id = p_batch_id;
48404:
48405: CURSOR c3(p_batch_id NUMBER) IS
48406: SELECT max(rowid)
48407: FROM msc_st_resource_requirements
48408: WHERE process_flag = G_IN_PROCESS
48409: AND sr_instance_code = v_instance_code
48410: AND batch_id = p_batch_id
48411: AND NVL(operation_sequence_id,NULL_VALUE) = NULL_VALUE

Line 48418: FROM msc_st_resource_requirements

48414: operation_seq_code,alternate_routing_designator,operation_effectivity_date;
48415:
48416: CURSOR c4(p_batch_id NUMBER) IS
48417: SELECT max(rowid)
48418: FROM msc_st_resource_requirements
48419: WHERE process_flag = G_IN_PROCESS
48420: AND sr_instance_code = v_instance_code
48421: AND batch_id = p_batch_id
48422: AND NVL(resource_seq_num,NULL_VALUE) = NULL_VALUE

Line 48445: 'UPDATE msc_st_resource_requirements msrr1 '

48441:
48442: v_sql_stmt := 01;
48443:
48444: lv_sql_stmt:=
48445: 'UPDATE msc_st_resource_requirements msrr1 '
48446: ||' SET process_flag ='||G_ERROR_FLG||','
48447: ||' error_text = '||''''||lv_message_text||''''
48448: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_resource_requirements msrr2'
48449: ||' WHERE msrr2.sr_instance_code '

Line 48448: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_resource_requirements msrr2'

48444: lv_sql_stmt:=
48445: 'UPDATE msc_st_resource_requirements msrr1 '
48446: ||' SET process_flag ='||G_ERROR_FLG||','
48447: ||' error_text = '||''''||lv_message_text||''''
48448: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_resource_requirements msrr2'
48449: ||' WHERE msrr2.sr_instance_code '
48450: ||' = msrr1.sr_instance_code'
48451: ||' AND NVL(msrr2.company_name,'||''''||NULL_CHAR||''''||') '
48452: ||' = NVL(msrr1.company_name,'||''''||NULL_CHAR||''''||') '

Line 48486: 'UPDATE msc_st_resource_requirements msrr1'

48482: END IF;
48483: v_sql_stmt := 02;
48484:
48485: lv_sql_stmt:=
48486: 'UPDATE msc_st_resource_requirements msrr1'
48487: ||' SET process_flag = '||G_ERROR_FLG||','
48488: ||' error_text = '||''''||lv_message_text||''''
48489: ||' WHERE EXISTS ( SELECT 1 '
48490: ||' FROM msc_st_resource_requirements msrr2'

Line 48490: ||' FROM msc_st_resource_requirements msrr2'

48486: 'UPDATE msc_st_resource_requirements msrr1'
48487: ||' SET process_flag = '||G_ERROR_FLG||','
48488: ||' error_text = '||''''||lv_message_text||''''
48489: ||' WHERE EXISTS ( SELECT 1 '
48490: ||' FROM msc_st_resource_requirements msrr2'
48491: ||' WHERE msrr2.sr_instance_code '
48492: ||' = msrr1.sr_instance_code'
48493: ||' AND NVL(msrr2.company_name,'||''''||NULL_CHAR||''''||') '
48494: ||' = NVL(msrr1.company_name,'||''''||NULL_CHAR||''''||') '

Line 48556: ' UPDATE msc_st_resource_requirements '

48552: CLOSE c1;
48553:
48554: v_sql_stmt := 04;
48555: lv_sql_stmt :=
48556: ' UPDATE msc_st_resource_requirements '
48557: ||' SET batch_id = :lv_batch_id'
48558: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
48559: ||' AND sr_instance_code = :v_instance_code'
48560: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 48577: UPDATE msc_st_resource_requirements

48573: CLOSE c2;
48574:
48575: v_sql_stmt := 05;
48576: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
48577: UPDATE msc_st_resource_requirements
48578: SET st_transaction_id = msc_st_resource_requirements_s.NEXTVAL,
48579: refresh_id = v_refresh_id,
48580: last_update_date = v_current_date,
48581: last_updated_by = v_current_user,

Line 48578: SET st_transaction_id = msc_st_resource_requirements_s.NEXTVAL,

48574:
48575: v_sql_stmt := 05;
48576: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
48577: UPDATE msc_st_resource_requirements
48578: SET st_transaction_id = msc_st_resource_requirements_s.NEXTVAL,
48579: refresh_id = v_refresh_id,
48580: last_update_date = v_current_date,
48581: last_updated_by = v_current_user,
48582: creation_date = v_current_date,

Line 48608: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

48604: lv_where_str :=
48605: ' AND NVL(deleted_flag,'||NULL_VALUE||') NOT IN(1,2)';
48606:
48607: lv_return := MSC_ST_UTIL.LOG_ERROR
48608: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
48609: p_instance_code => v_instance_code,
48610: p_row => lv_column_names,
48611: p_severity => G_SEV_WARNING,
48612: p_message_text => lv_message_text,

Line 48642: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

48638:
48639: -- Populate organization id , call utilty package- msc_st_util's procedure
48640:
48641: lv_return :=
48642: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
48643: p_org_partner_name =>'ORGANIZATION_CODE',
48644: p_org_partner_id =>'ORGANIZATION_ID',
48645: p_instance_code => v_instance_code,
48646: p_partner_type => G_ORGANIZATION,

Line 48661: 'UPDATE msc_st_resource_requirements msrr'

48657:
48658: -- Derive WIP_ENTITY_ID
48659: v_sql_stmt := 06;
48660: lv_sql_stmt:=
48661: 'UPDATE msc_st_resource_requirements msrr'
48662: ||' SET wip_entity_id = (SELECT local_id '
48663: ||' FROM msc_local_id_supply mlis'
48664: ||' WHERE mlis.char1 = msrr.sr_instance_code'
48665: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 48695: p_token_value3 => 'MSC_ST_RESOURCE_REQUIREMENTS' );

48691: ||'ORGANIZATION_CODE,WIP_ENTITY_NAME',
48692: p_token2 => 'MASTER_TABLE',
48693: p_token_value2 => 'MSC_ST_SUPPLIES',
48694: p_token3 => 'CHILD_TABLE' ,
48695: p_token_value3 => 'MSC_ST_RESOURCE_REQUIREMENTS' );
48696:
48697: IF lv_return <> 0 THEN
48698: RAISE ex_logging_err;
48699: END IF;

Line 48706: 'UPDATE msc_st_resource_requirements msrr'

48702: -- Error out the records if WIP_ENTITY_ID NULL
48703:
48704: v_sql_stmt := 07;
48705: lv_sql_stmt:=
48706: 'UPDATE msc_st_resource_requirements msrr'
48707: ||' SET process_flag ='||G_ERROR_FLG||','
48708: ||' error_text = '||''''||lv_message_text||''''
48709: ||' WHERE NVL(wip_entity_id,'||NULL_VALUE||') = '||NULL_VALUE
48710: ||' AND sr_instance_code = :v_instance_code'

Line 48724: 'UPDATE msc_st_resource_requirements msrr'

48720: -- Set supply_id = wip_entity_id
48721: v_sql_stmt := 09;
48722:
48723: lv_sql_stmt:=
48724: 'UPDATE msc_st_resource_requirements msrr'
48725: ||' SET supply_id = wip_entity_id '
48726: ||' WHERE sr_instance_code = :v_instance_code'
48727: ||' AND process_flag = '||G_IN_PROCESS
48728: ||' AND NVL(wip_entity_id,'||NULL_VALUE||')='||NULL_VALUE

Line 48742: 'UPDATE msc_st_resource_requirements msrr'

48738: /*
48739: v_sql_stmt := 10;
48740:
48741: lv_sql_stmt :=
48742: 'UPDATE msc_st_resource_requirements msrr'
48743: ||' SET resource_id= (SELECT local_id '
48744: ||' FROM msc_local_id_setup mlis'
48745: ||' WHERE mlis.char1 = msrr.sr_instance_code'
48746: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 48767: 'UPDATE msc_st_resource_requirements msrr'

48763: */
48764: -- set the resource_id, department_id, resource_seq_num to -1 for those records where resource_code is null and resource is an unscheduled resource
48765:
48766: lv_sql_stmt:=
48767: 'UPDATE msc_st_resource_requirements msrr'
48768: ||' SET resource_id = -1, department_id = -1, resource_seq_num = -1 '
48769: ||' WHERE sr_instance_code = :v_instance_code'
48770: ||' AND deleted_flag = '||SYS_NO
48771: ||' AND process_flag = '|| G_IN_PROCESS

Line 48793: p_token_value3 => 'MSC_ST_RESOURCE_REQUIREMENTS' );

48789: ||'ORGANIZATION_CODE,RESOURCE_CODE',
48790: p_token2 => 'MASTER_TABLE',
48791: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
48792: p_token3 => 'CHILD_TABLE' ,
48793: p_token_value3 => 'MSC_ST_RESOURCE_REQUIREMENTS' );
48794:
48795: IF lv_return <> 0 THEN
48796: RAISE ex_logging_err;
48797: END IF;

Line 48802: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

48798:
48799: /* created the new function to derive resource_id for bug 3768813 */
48800: lv_where_str :=' AND schedule_flag <> 2';
48801: lv_return := MSC_ST_UTIL.DERIVE_RESOURCE_ID
48802: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
48803: p_resource_col_name => 'RESOURCE_CODE',
48804: p_department_col_name => 'DEPARTMENT_CODE',
48805: p_resource_col_id => 'RESOURCE_ID',
48806: p_instance_code => v_instance_code,

Line 48824: 'UPDATE msc_st_resource_requirements msrr'

48820:
48821: v_sql_stmt := 11;
48822:
48823: lv_sql_stmt:=
48824: 'UPDATE msc_st_resource_requirements msrr'
48825: ||' SET process_flag ='||G_ERROR_FLG||','
48826: ||' error_text = '||''''||lv_message_text||''''
48827: ||' WHERE NVL(resource_id,'||NULL_VALUE||') = '||NULL_VALUE
48828: ||' AND sr_instance_code = :v_instance_code'

Line 48846: 'UPDATE msc_st_resource_requirements msrr'

48842: /*
48843: v_sql_stmt := 12;
48844:
48845: lv_sql_stmt :=
48846: 'UPDATE msc_st_resource_requirements msrr'
48847: ||' SET department_id = (SELECT local_id'
48848: ||' FROM msc_local_id_setup mlis'
48849: ||' WHERE mlis.char1 = msrr.sr_instance_code'
48850: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 48882: p_token_value3 => 'MSC_ST_RESOURCE_REQUIREMENTS' );

48878: ||'ORGANIZATION_CODE,DEPARTMENT_CODE',
48879: p_token2 => 'MASTER_TABLE',
48880: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
48881: p_token3 => 'CHILD_TABLE' ,
48882: p_token_value3 => 'MSC_ST_RESOURCE_REQUIREMENTS' );
48883:
48884: IF lv_return <> 0 THEN
48885: RAISE ex_logging_err;
48886: END IF;

Line 48890: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

48886: END IF;
48887:
48888: /* created the new function to derive department_id for bug 3768813 */
48889: lv_return := MSC_ST_UTIL.DERIVE_DEPARTMENT_ID
48890: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
48891: p_resource_col_name => 'RESOURCE_CODE',
48892: p_department_col_name => 'DEPARTMENT_CODE',
48893: p_department_col_id => 'DEPARTMENT_ID',
48894: p_instance_code => v_instance_code,

Line 48912: 'UPDATE msc_st_resource_requirements msrr'

48908:
48909: v_sql_stmt := 11;
48910:
48911: lv_sql_stmt:=
48912: 'UPDATE msc_st_resource_requirements msrr'
48913: ||' SET process_flag ='||G_ERROR_FLG||','
48914: ||' error_text = '||''''||lv_message_text||''''
48915: ||' WHERE NVL(department_id,'||NULL_VALUE||') = '||NULL_VALUE
48916: ||' AND sr_instance_code = :v_instance_code'

Line 48943: 'UPDATE msc_st_resource_requirements msrr'

48939: END IF;
48940:
48941: -- set the assigned units to 0 if resource_code is NULL
48942: lv_sql_stmt:=
48943: 'UPDATE msc_st_resource_requirements msrr'
48944: ||' SET assigned_units = 0 '
48945: ||' WHERE NVL(assigned_units,'||NULL_VALUE||') = '||NULL_VALUE
48946: ||' AND resource_id = -1 '
48947: ||' AND sr_instance_code = :v_instance_code'

Line 48961: 'UPDATE msc_st_resource_requirements msrr'

48957: -- Error out records where assigned units NULL
48958: v_sql_stmt := 08;
48959:
48960: lv_sql_stmt:=
48961: 'UPDATE msc_st_resource_requirements msrr'
48962: ||' SET process_flag ='||G_ERROR_FLG||','
48963: ||' error_text = '||''''||lv_message_text||''''
48964: ||' WHERE NVL(assigned_units,'||NULL_VALUE||') = '||NULL_VALUE
48965: ||' AND sr_instance_code = :v_instance_code'

Line 48997: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

48993: ' AND NVL(operation_seq_code,'||''''||NULL_CHAR||''''||') '
48994: ||' = '||''''||NULL_CHAR||'''' ;
48995:
48996: lv_return := MSC_ST_UTIL.LOG_ERROR
48997: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
48998: p_instance_code => v_instance_code,
48999: p_row => lv_column_names,
49000: p_severity => G_SEV_WARNING,
49001: p_message_text => lv_message_text,

Line 49034: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

49030: lv_where_str :=
49031: ' AND NVL(operation_effectivity_date,(sysdate-36500)) =(sysdate-36500)';
49032:
49033: lv_return := MSC_ST_UTIL.LOG_ERROR
49034: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
49035: p_instance_code => v_instance_code,
49036: p_row => lv_column_names,
49037: p_severity => G_SEV_WARNING,
49038: p_message_text => lv_message_text,

Line 49066: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

49062: END IF;
49063:
49064: --Derive Inventory_item_id
49065: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
49066: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
49067: p_item_col_name => 'ITEM_NAME',
49068: p_item_col_id => 'INVENTORY_ITEM_ID',
49069: p_instance_id => v_instance_id,
49070: p_instance_code => v_instance_code,

Line 49086: ' UPDATE msc_st_resource_requirements'

49082: -- If routing_name is is NULL populate the item_name in routing name
49083:
49084: v_sql_stmt := 13;
49085: lv_sql_stmt :=
49086: ' UPDATE msc_st_resource_requirements'
49087: ||' SET routing_name = item_name'
49088: ||' WHERE process_flag = '||G_IN_PROCESS
49089: ||' AND NVL(routing_name,'||''''||NULL_CHAR||''''||')'
49090: ||' = '||''''||NULL_CHAR||''''

Line 49103: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

49099: /* Bug 3768813 */
49100: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
49101:
49102: lv_return :=msc_st_util.derive_routing_sequence_id
49103: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
49104: p_rtg_col_name => 'ROUTING_NAME',
49105: p_rtg_col_id =>'ROUTING_SEQUENCE_ID',
49106: p_instance_code => v_instance_code,
49107: p_batch_id => lv_batch_id,

Line 49119: 'UPDATE msc_st_resource_requirements msrr'

49115: -- Derive operation seq num and operation_seq_id
49116:
49117: v_sql_stmt := 14;
49118: lv_sql_stmt:=
49119: 'UPDATE msc_st_resource_requirements msrr'
49120: ||' SET operation_seq_num = (SELECT number1'
49121: ||' FROM msc_local_id_setup mlis'
49122: ||' WHERE mlis.char1 = msrr.sr_instance_code'
49123: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 49148: 'UPDATE msc_st_resource_requirements msrr'

49144: -- Derive operation_sequence id
49145: /*
49146: v_sql_stmt := 15;
49147: lv_sql_Stmt :=
49148: 'UPDATE msc_st_resource_requirements msrr'
49149: ||' SET operation_sequence_id= (SELECT local_id'
49150: ||' FROM msc_local_id_setup mlis'
49151: ||' WHERE mlis.char1 = msrr.sr_instance_code'
49152: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 49175: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

49171: */
49172:
49173: /* created new function to derive operation sequence id for bug 3768813 */
49174: lv_return := MSC_ST_UTIL.DERIVE_OPERATION_SEQUENCE_ID
49175: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
49176: p_operation_seq_num => 'OPERATION_SEQ_NUM',
49177: p_routing_col_name => 'ROUTING_NAME',
49178: p_sequence_col_id => 'OPERATION_SEQUENCE_ID',
49179: p_op_effectivity_date => 'OPERATION_EFFECTIVITY_DATE',

Line 49206: 'UPDATE msc_st_resource_requirements '

49202:
49203: -- Error out the records where delete flag yes and operation_sequence_id is NULL
49204: v_sql_stmt := 16;
49205: lv_sql_stmt:=
49206: 'UPDATE msc_st_resource_requirements '
49207: ||' SET process_flag ='||G_ERROR_FLG||','
49208: ||' error_text = '||''''||lv_message_text||''''
49209: ||' WHERE NVL(operation_sequence_id,'||NULL_VALUE||') ='|| NULL_VALUE
49210: ||' AND deleted_flag = '||SYS_YES

Line 49223: 'UPDATE msc_st_resource_requirements msor'

49219:
49220: -- Derive resource seq num from the local id table
49221:
49222: lv_sql_stmt :=
49223: 'UPDATE msc_st_resource_requirements msor'
49224: ||' SET resource_seq_num = (SELECT local_id '
49225: ||' FROM msc_local_id_setup mlis'
49226: ||' WHERE mlis.char1 = msor.sr_instance_code'
49227: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 49270: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

49266: lv_where_str :=
49267: ' AND (yield < 0 OR yield > 1 OR NVL(yield,'||NULL_VALUE||') ='|| NULL_VALUE||')';
49268:
49269: lv_return := MSC_ST_UTIL.LOG_ERROR
49270: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
49271: p_instance_code => v_instance_code,
49272: p_row => lv_column_names,
49273: p_severity => G_SEV_WARNING,
49274: p_message_text => lv_message_text,

Line 49307: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

49303: lv_where_str := ' AND NVL(schedule_flag,'||NULL_VALUE||') '
49304: ||' NOT IN(1,2,3,4)';
49305:
49306: lv_return := MSC_ST_UTIL.LOG_ERROR
49307: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
49308: p_instance_code => v_instance_code,
49309: p_row => lv_column_names,
49310: p_severity => G_SEV_WARNING,
49311: p_message_text => lv_message_text,

Line 49339: UPDATE msc_st_resource_requirements

49335: IF lv_return <> 0 THEN
49336: RAISE ex_logging_err;
49337: END IF;
49338:
49339: UPDATE msc_st_resource_requirements
49340: SET process_flag = G_ERROR_FLG,
49341: error_text = lv_message_text
49342: WHERE deleted_flag = SYS_NO
49343: AND sr_instance_code = v_instance_code

Line 49351: UPDATE msc_st_resource_requirements msrr

49347:
49348: -- Updating UNADJUSTED_RESOURCE_HOURS with the value in OPERATION_HOURS_REQUIRED
49349: -- for bug 7565280
49350:
49351: UPDATE msc_st_resource_requirements msrr
49352: SET UNADJUSTED_RESOURCE_HOURS = OPERATION_HOURS_REQUIRED
49353: WHERE sr_instance_code = v_instance_code
49354: AND process_flag = G_IN_PROCESS
49355: AND batch_id = lv_batch_id;

Line 49364: pEntityName => 'MSC_ST_RESOURCE_REQUIREMENTS',

49360: (ERRBUF => lv_error_text,
49361: RETCODE => lv_return,
49362: pBatchID => lv_batch_id,
49363: pInstanceCode => v_instance_code,
49364: pEntityName => 'MSC_ST_RESOURCE_REQUIREMENTS',
49365: pInstanceID => v_instance_id);
49366:
49367: IF NVL(lv_return,0) <> 0 THEN
49368: RAISE ex_logging_err;

Line 49380: UPDATE msc_st_resource_requirements

49376: IF c3%ROWCOUNT > 0 THEN
49377:
49378: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
49379:
49380: UPDATE msc_st_resource_requirements
49381: SET operation_sequence_id = msc_st_operation_sequence_id_s.NEXTVAL ,
49382: operation_seq_num =
49383: to_number(decode(length(rtrim(operation_seq_code,'0123456789')),
49384: NULL,operation_seq_code,'1'))

Line 49442: FROM msc_st_resource_requirements

49438: v_current_date,
49439: v_current_user,
49440: v_current_date,
49441: v_current_user
49442: FROM msc_st_resource_requirements
49443: WHERE rowid = lb_rowid(j);
49444:
49445: END IF;
49446: close c3;

Line 49452: 'UPDATE msc_st_resource_requirements msrr'

49448: -- Update operation_sequence_id
49449:
49450: v_sql_stmt := 19;
49451: lv_sql_Stmt :=
49452: 'UPDATE msc_st_resource_requirements msrr'
49453: ||' SET (operation_sequence_id, operation_seq_num) = (SELECT local_id, number1'
49454: ||' FROM msc_local_id_setup mlis'
49455: ||' WHERE mlis.char1 = msrr.sr_instance_code'
49456: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 49484: UPDATE msc_st_resource_requirements

49480: IF c4%ROWCOUNT > 0 THEN
49481:
49482: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
49483:
49484: UPDATE msc_st_resource_requirements
49485: SET resource_seq_num =
49486: to_number(decode(length(rtrim(resource_seq_code,'0123456789')),
49487: NULL,resource_seq_code,'1'))
49488: WHERE rowid = lb_rowid(j);

Line 49544: FROM msc_st_resource_requirements

49540: v_current_date,
49541: v_current_user,
49542: v_current_date,
49543: v_current_user
49544: FROM msc_st_resource_requirements
49545: WHERE rowid = lb_rowid(j) ;
49546:
49547: END IF;
49548: CLOSE c4;

Line 49553: 'UPDATE msc_st_resource_requirements msor'

49549:
49550: -- Update resource seq num from the local id table
49551:
49552: lv_sql_stmt :=
49553: 'UPDATE msc_st_resource_requirements msor'
49554: ||' SET resource_seq_num = (SELECT local_id '
49555: ||' FROM msc_local_id_setup mlis'
49556: ||' WHERE mlis.char1 = msor.sr_instance_code'
49557: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 49581: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

49577: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
49578:
49579: -- Set the processf flag as Valid and populate sr_instance_id
49580: lv_return :=
49581: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
49582: p_instance_id => v_instance_id,
49583: p_instance_code => v_instance_code,
49584: p_process_flag => G_VALID,
49585: p_error_text => lv_error_text,

Line 49597: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

49593:
49594: -- At the end calling the LOG_ERROR for logging all errored out records
49595:
49596: lv_return :=
49597: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
49598: p_instance_code => v_instance_code,
49599: p_row => lv_column_names,
49600: p_severity => G_SEV_ERROR,
49601: p_message_text => NULL,

Line 55879: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',p_erp_enabled => 'Y'); /* bug 3768813 */

55875: End IF;
55876: END IF;
55877:
55878: IF v_res_dmd_enabled = SYS_YES THEN
55879: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',p_erp_enabled => 'Y'); /* bug 3768813 */
55880: IF lv_count > 0 Then
55881: prec.wip_flag:= SYS_YES;
55882: End IF;
55883: END IF;