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 1396: ||' on MSC_ST_RESOURCE_REQUIREMENTS '

1392: application_short_name => 'MSC',
1393: statement_type => AD_DDL.CREATE_INDEX,
1394: statement =>
1395: 'create index MSC_ST_RES_REQ_N1_'||v_instance_code
1396: ||' on MSC_ST_RESOURCE_REQUIREMENTS '
1397: ||'(sr_instance_code, resource_code, wip_entity_name, operation_seq_code, organization_code, company_name, resource_seq_code) '
1398: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1399: object_name =>'MSC_ST_RES_REQ_N1_'||v_instance_code);
1400:

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

1404: WHEN OTHERS THEN
1405: 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));
1406: END;
1407:
1408: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_REQUIREMENTS', v_instance_id, -1);
1409:
1410: END IF;
1411:
1412: IF v_uom_class_enabled = SYS_YES THEN

Line 43516: lv_batch_id msc_st_resource_requirements.batch_id%TYPE;

43512: lv_error_text VARCHAR2(250);
43513: lv_where_str VARCHAR2(5000);
43514: lv_sql_stmt VARCHAR2(5000);
43515: lv_cursor_stmt VARCHAR2(5000);
43516: lv_batch_id msc_st_resource_requirements.batch_id%TYPE;
43517: lv_message_text msc_errors.error_text%TYPE;
43518:
43519: ex_logging_err EXCEPTION;
43520:

Line 43523: FROM msc_st_resource_requirements

43519: ex_logging_err EXCEPTION;
43520:
43521: CURSOR c2(p_batch_id NUMBER) IS
43522: SELECT rowid
43523: FROM msc_st_resource_requirements
43524: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
43525: AND sr_instance_code = v_instance_code
43526: AND batch_id = p_batch_id;
43527:

Line 43530: FROM msc_st_resource_requirements

43526: AND batch_id = p_batch_id;
43527:
43528: CURSOR c3(p_batch_id NUMBER) IS
43529: SELECT max(rowid)
43530: FROM msc_st_resource_requirements
43531: WHERE process_flag = G_IN_PROCESS
43532: AND sr_instance_code = v_instance_code
43533: AND batch_id = p_batch_id
43534: AND NVL(operation_sequence_id,NULL_VALUE) = NULL_VALUE

Line 43541: FROM msc_st_resource_requirements

43537: operation_seq_code,alternate_routing_designator,operation_effectivity_date;
43538:
43539: CURSOR c4(p_batch_id NUMBER) IS
43540: SELECT max(rowid)
43541: FROM msc_st_resource_requirements
43542: WHERE process_flag = G_IN_PROCESS
43543: AND sr_instance_code = v_instance_code
43544: AND batch_id = p_batch_id
43545: AND NVL(resource_seq_num,NULL_VALUE) = NULL_VALUE

Line 43568: 'UPDATE msc_st_resource_requirements msrr1 '

43564:
43565: v_sql_stmt := 01;
43566:
43567: lv_sql_stmt:=
43568: 'UPDATE msc_st_resource_requirements msrr1 '
43569: ||' SET process_flag ='||G_ERROR_FLG||','
43570: ||' error_text = '||''''||lv_message_text||''''
43571: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_resource_requirements msrr2'
43572: ||' WHERE msrr2.sr_instance_code '

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

43567: lv_sql_stmt:=
43568: 'UPDATE msc_st_resource_requirements msrr1 '
43569: ||' SET process_flag ='||G_ERROR_FLG||','
43570: ||' error_text = '||''''||lv_message_text||''''
43571: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_resource_requirements msrr2'
43572: ||' WHERE msrr2.sr_instance_code '
43573: ||' = msrr1.sr_instance_code'
43574: ||' AND NVL(msrr2.company_name,'||''''||NULL_CHAR||''''||') '
43575: ||' = NVL(msrr1.company_name,'||''''||NULL_CHAR||''''||') '

Line 43609: 'UPDATE msc_st_resource_requirements msrr1'

43605: END IF;
43606: v_sql_stmt := 02;
43607:
43608: lv_sql_stmt:=
43609: 'UPDATE msc_st_resource_requirements msrr1'
43610: ||' SET process_flag = '||G_ERROR_FLG||','
43611: ||' error_text = '||''''||lv_message_text||''''
43612: ||' WHERE EXISTS ( SELECT 1 '
43613: ||' FROM msc_st_resource_requirements msrr2'

Line 43613: ||' FROM msc_st_resource_requirements msrr2'

43609: 'UPDATE msc_st_resource_requirements msrr1'
43610: ||' SET process_flag = '||G_ERROR_FLG||','
43611: ||' error_text = '||''''||lv_message_text||''''
43612: ||' WHERE EXISTS ( SELECT 1 '
43613: ||' FROM msc_st_resource_requirements msrr2'
43614: ||' WHERE msrr2.sr_instance_code '
43615: ||' = msrr1.sr_instance_code'
43616: ||' AND NVL(msrr2.company_name,'||''''||NULL_CHAR||''''||') '
43617: ||' = NVL(msrr1.company_name,'||''''||NULL_CHAR||''''||') '

Line 43679: ' UPDATE msc_st_resource_requirements '

43675: CLOSE c1;
43676:
43677: v_sql_stmt := 04;
43678: lv_sql_stmt :=
43679: ' UPDATE msc_st_resource_requirements '
43680: ||' SET batch_id = :lv_batch_id'
43681: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
43682: ||' AND sr_instance_code = :v_instance_code'
43683: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 43700: UPDATE msc_st_resource_requirements

43696: CLOSE c2;
43697:
43698: v_sql_stmt := 05;
43699: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
43700: UPDATE msc_st_resource_requirements
43701: SET st_transaction_id = msc_st_resource_requirements_s.NEXTVAL,
43702: refresh_id = v_refresh_id,
43703: last_update_date = v_current_date,
43704: last_updated_by = v_current_user,

Line 43701: SET st_transaction_id = msc_st_resource_requirements_s.NEXTVAL,

43697:
43698: v_sql_stmt := 05;
43699: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
43700: UPDATE msc_st_resource_requirements
43701: SET st_transaction_id = msc_st_resource_requirements_s.NEXTVAL,
43702: refresh_id = v_refresh_id,
43703: last_update_date = v_current_date,
43704: last_updated_by = v_current_user,
43705: creation_date = v_current_date,

Line 43731: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

43727: lv_where_str :=
43728: ' AND NVL(deleted_flag,'||NULL_VALUE||') NOT IN(1,2)';
43729:
43730: lv_return := MSC_ST_UTIL.LOG_ERROR
43731: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
43732: p_instance_code => v_instance_code,
43733: p_row => lv_column_names,
43734: p_severity => G_SEV_WARNING,
43735: p_message_text => lv_message_text,

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

43761:
43762: -- Populate organization id , call utilty package- msc_st_util's procedure
43763:
43764: lv_return :=
43765: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
43766: p_org_partner_name =>'ORGANIZATION_CODE',
43767: p_org_partner_id =>'ORGANIZATION_ID',
43768: p_instance_code => v_instance_code,
43769: p_partner_type => G_ORGANIZATION,

Line 43784: 'UPDATE msc_st_resource_requirements msrr'

43780:
43781: -- Derive WIP_ENTITY_ID
43782: v_sql_stmt := 06;
43783: lv_sql_stmt:=
43784: 'UPDATE msc_st_resource_requirements msrr'
43785: ||' SET wip_entity_id = (SELECT local_id '
43786: ||' FROM msc_local_id_supply mlis'
43787: ||' WHERE mlis.char1 = msrr.sr_instance_code'
43788: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 43818: p_token_value3 => 'MSC_ST_RESOURCE_REQUIREMENTS' );

43814: ||'ORGANIZATION_CODE,WIP_ENTITY_NAME',
43815: p_token2 => 'MASTER_TABLE',
43816: p_token_value2 => 'MSC_ST_SUPPLIES',
43817: p_token3 => 'CHILD_TABLE' ,
43818: p_token_value3 => 'MSC_ST_RESOURCE_REQUIREMENTS' );
43819:
43820: IF lv_return <> 0 THEN
43821: RAISE ex_logging_err;
43822: END IF;

Line 43829: 'UPDATE msc_st_resource_requirements msrr'

43825: -- Error out the records if WIP_ENTITY_ID NULL
43826:
43827: v_sql_stmt := 07;
43828: lv_sql_stmt:=
43829: 'UPDATE msc_st_resource_requirements msrr'
43830: ||' SET process_flag ='||G_ERROR_FLG||','
43831: ||' error_text = '||''''||lv_message_text||''''
43832: ||' WHERE NVL(wip_entity_id,'||NULL_VALUE||') = '||NULL_VALUE
43833: ||' AND sr_instance_code = :v_instance_code'

Line 43847: 'UPDATE msc_st_resource_requirements msrr'

43843: -- Set supply_id = wip_entity_id
43844: v_sql_stmt := 09;
43845:
43846: lv_sql_stmt:=
43847: 'UPDATE msc_st_resource_requirements msrr'
43848: ||' SET supply_id = wip_entity_id '
43849: ||' WHERE sr_instance_code = :v_instance_code'
43850: ||' AND process_flag = '||G_IN_PROCESS
43851: ||' AND NVL(wip_entity_id,'||NULL_VALUE||')='||NULL_VALUE

Line 43865: 'UPDATE msc_st_resource_requirements msrr'

43861: /*
43862: v_sql_stmt := 10;
43863:
43864: lv_sql_stmt :=
43865: 'UPDATE msc_st_resource_requirements msrr'
43866: ||' SET resource_id= (SELECT local_id '
43867: ||' FROM msc_local_id_setup mlis'
43868: ||' WHERE mlis.char1 = msrr.sr_instance_code'
43869: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 43890: 'UPDATE msc_st_resource_requirements msrr'

43886: */
43887: -- 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
43888:
43889: lv_sql_stmt:=
43890: 'UPDATE msc_st_resource_requirements msrr'
43891: ||' SET resource_id = -1, department_id = -1, resource_seq_num = -1 '
43892: ||' WHERE sr_instance_code = :v_instance_code'
43893: ||' AND deleted_flag = '||SYS_NO
43894: ||' AND process_flag = '|| G_IN_PROCESS

Line 43916: p_token_value3 => 'MSC_ST_RESOURCE_REQUIREMENTS' );

43912: ||'ORGANIZATION_CODE,RESOURCE_CODE',
43913: p_token2 => 'MASTER_TABLE',
43914: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
43915: p_token3 => 'CHILD_TABLE' ,
43916: p_token_value3 => 'MSC_ST_RESOURCE_REQUIREMENTS' );
43917:
43918: IF lv_return <> 0 THEN
43919: RAISE ex_logging_err;
43920: END IF;

Line 43925: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

43921:
43922: /* created the new function to derive resource_id for bug 3768813 */
43923: lv_where_str :=' AND schedule_flag <> 2';
43924: lv_return := MSC_ST_UTIL.DERIVE_RESOURCE_ID
43925: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
43926: p_resource_col_name => 'RESOURCE_CODE',
43927: p_department_col_name => 'DEPARTMENT_CODE',
43928: p_resource_col_id => 'RESOURCE_ID',
43929: p_instance_code => v_instance_code,

Line 43947: 'UPDATE msc_st_resource_requirements msrr'

43943:
43944: v_sql_stmt := 11;
43945:
43946: lv_sql_stmt:=
43947: 'UPDATE msc_st_resource_requirements msrr'
43948: ||' SET process_flag ='||G_ERROR_FLG||','
43949: ||' error_text = '||''''||lv_message_text||''''
43950: ||' WHERE NVL(resource_id,'||NULL_VALUE||') = '||NULL_VALUE
43951: ||' AND sr_instance_code = :v_instance_code'

Line 43969: 'UPDATE msc_st_resource_requirements msrr'

43965: /*
43966: v_sql_stmt := 12;
43967:
43968: lv_sql_stmt :=
43969: 'UPDATE msc_st_resource_requirements msrr'
43970: ||' SET department_id = (SELECT local_id'
43971: ||' FROM msc_local_id_setup mlis'
43972: ||' WHERE mlis.char1 = msrr.sr_instance_code'
43973: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 44005: p_token_value3 => 'MSC_ST_RESOURCE_REQUIREMENTS' );

44001: ||'ORGANIZATION_CODE,DEPARTMENT_CODE',
44002: p_token2 => 'MASTER_TABLE',
44003: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
44004: p_token3 => 'CHILD_TABLE' ,
44005: p_token_value3 => 'MSC_ST_RESOURCE_REQUIREMENTS' );
44006:
44007: IF lv_return <> 0 THEN
44008: RAISE ex_logging_err;
44009: END IF;

Line 44013: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

44009: END IF;
44010:
44011: /* created the new function to derive department_id for bug 3768813 */
44012: lv_return := MSC_ST_UTIL.DERIVE_DEPARTMENT_ID
44013: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
44014: p_resource_col_name => 'RESOURCE_CODE',
44015: p_department_col_name => 'DEPARTMENT_CODE',
44016: p_department_col_id => 'DEPARTMENT_ID',
44017: p_instance_code => v_instance_code,

Line 44035: 'UPDATE msc_st_resource_requirements msrr'

44031:
44032: v_sql_stmt := 11;
44033:
44034: lv_sql_stmt:=
44035: 'UPDATE msc_st_resource_requirements msrr'
44036: ||' SET process_flag ='||G_ERROR_FLG||','
44037: ||' error_text = '||''''||lv_message_text||''''
44038: ||' WHERE NVL(department_id,'||NULL_VALUE||') = '||NULL_VALUE
44039: ||' AND sr_instance_code = :v_instance_code'

Line 44066: 'UPDATE msc_st_resource_requirements msrr'

44062: END IF;
44063:
44064: -- set the assigned units to 0 if resource_code is NULL
44065: lv_sql_stmt:=
44066: 'UPDATE msc_st_resource_requirements msrr'
44067: ||' SET assigned_units = 0 '
44068: ||' WHERE NVL(assigned_units,'||NULL_VALUE||') = '||NULL_VALUE
44069: ||' AND resource_id = -1 '
44070: ||' AND sr_instance_code = :v_instance_code'

Line 44084: 'UPDATE msc_st_resource_requirements msrr'

44080: -- Error out records where assigned units NULL
44081: v_sql_stmt := 08;
44082:
44083: lv_sql_stmt:=
44084: 'UPDATE msc_st_resource_requirements msrr'
44085: ||' SET process_flag ='||G_ERROR_FLG||','
44086: ||' error_text = '||''''||lv_message_text||''''
44087: ||' WHERE NVL(assigned_units,'||NULL_VALUE||') = '||NULL_VALUE
44088: ||' AND sr_instance_code = :v_instance_code'

Line 44120: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

44116: ' AND NVL(operation_seq_code,'||''''||NULL_CHAR||''''||') '
44117: ||' = '||''''||NULL_CHAR||'''' ;
44118:
44119: lv_return := MSC_ST_UTIL.LOG_ERROR
44120: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
44121: p_instance_code => v_instance_code,
44122: p_row => lv_column_names,
44123: p_severity => G_SEV_WARNING,
44124: p_message_text => lv_message_text,

Line 44157: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

44153: lv_where_str :=
44154: ' AND NVL(operation_effectivity_date,(sysdate-36500)) =(sysdate-36500)';
44155:
44156: lv_return := MSC_ST_UTIL.LOG_ERROR
44157: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
44158: p_instance_code => v_instance_code,
44159: p_row => lv_column_names,
44160: p_severity => G_SEV_WARNING,
44161: p_message_text => lv_message_text,

Line 44189: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

44185: END IF;
44186:
44187: --Derive Inventory_item_id
44188: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
44189: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
44190: p_item_col_name => 'ITEM_NAME',
44191: p_item_col_id => 'INVENTORY_ITEM_ID',
44192: p_instance_id => v_instance_id,
44193: p_instance_code => v_instance_code,

Line 44209: ' UPDATE msc_st_resource_requirements'

44205: -- If routing_name is is NULL populate the item_name in routing name
44206:
44207: v_sql_stmt := 13;
44208: lv_sql_stmt :=
44209: ' UPDATE msc_st_resource_requirements'
44210: ||' SET routing_name = item_name'
44211: ||' WHERE process_flag = '||G_IN_PROCESS
44212: ||' AND NVL(routing_name,'||''''||NULL_CHAR||''''||')'
44213: ||' = '||''''||NULL_CHAR||''''

Line 44226: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

44222: /* Bug 3768813 */
44223: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
44224:
44225: lv_return :=msc_st_util.derive_routing_sequence_id
44226: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
44227: p_rtg_col_name => 'ROUTING_NAME',
44228: p_rtg_col_id =>'ROUTING_SEQUENCE_ID',
44229: p_instance_code => v_instance_code,
44230: p_batch_id => lv_batch_id,

Line 44242: 'UPDATE msc_st_resource_requirements msrr'

44238: -- Derive operation seq num and operation_seq_id
44239:
44240: v_sql_stmt := 14;
44241: lv_sql_stmt:=
44242: 'UPDATE msc_st_resource_requirements msrr'
44243: ||' SET operation_seq_num = (SELECT number1'
44244: ||' FROM msc_local_id_setup mlis'
44245: ||' WHERE mlis.char1 = msrr.sr_instance_code'
44246: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 44271: 'UPDATE msc_st_resource_requirements msrr'

44267: -- Derive operation_sequence id
44268: /*
44269: v_sql_stmt := 15;
44270: lv_sql_Stmt :=
44271: 'UPDATE msc_st_resource_requirements msrr'
44272: ||' SET operation_sequence_id= (SELECT local_id'
44273: ||' FROM msc_local_id_setup mlis'
44274: ||' WHERE mlis.char1 = msrr.sr_instance_code'
44275: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 44298: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

44294: */
44295:
44296: /* created new function to derive operation sequence id for bug 3768813 */
44297: lv_return := MSC_ST_UTIL.DERIVE_OPERATION_SEQUENCE_ID
44298: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
44299: p_operation_seq_num => 'OPERATION_SEQ_NUM',
44300: p_routing_col_name => 'ROUTING_NAME',
44301: p_sequence_col_id => 'OPERATION_SEQUENCE_ID',
44302: p_op_effectivity_date => 'OPERATION_EFFECTIVITY_DATE',

Line 44329: 'UPDATE msc_st_resource_requirements '

44325:
44326: -- Error out the records where delete flag yes and operation_sequence_id is NULL
44327: v_sql_stmt := 16;
44328: lv_sql_stmt:=
44329: 'UPDATE msc_st_resource_requirements '
44330: ||' SET process_flag ='||G_ERROR_FLG||','
44331: ||' error_text = '||''''||lv_message_text||''''
44332: ||' WHERE NVL(operation_sequence_id,'||NULL_VALUE||') ='|| NULL_VALUE
44333: ||' AND deleted_flag = '||SYS_YES

Line 44346: 'UPDATE msc_st_resource_requirements msor'

44342:
44343: -- Derive resource seq num from the local id table
44344:
44345: lv_sql_stmt :=
44346: 'UPDATE msc_st_resource_requirements msor'
44347: ||' SET resource_seq_num = (SELECT local_id '
44348: ||' FROM msc_local_id_setup mlis'
44349: ||' WHERE mlis.char1 = msor.sr_instance_code'
44350: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 44393: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

44389: lv_where_str :=
44390: ' AND (yield < 0 OR yield > 1 OR NVL(yield,'||NULL_VALUE||') ='|| NULL_VALUE||')';
44391:
44392: lv_return := MSC_ST_UTIL.LOG_ERROR
44393: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
44394: p_instance_code => v_instance_code,
44395: p_row => lv_column_names,
44396: p_severity => G_SEV_WARNING,
44397: p_message_text => lv_message_text,

Line 44430: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',

44426: lv_where_str := ' AND NVL(schedule_flag,'||NULL_VALUE||') '
44427: ||' NOT IN(1,2,3,4)';
44428:
44429: lv_return := MSC_ST_UTIL.LOG_ERROR
44430: (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
44431: p_instance_code => v_instance_code,
44432: p_row => lv_column_names,
44433: p_severity => G_SEV_WARNING,
44434: p_message_text => lv_message_text,

Line 44462: UPDATE msc_st_resource_requirements

44458: IF lv_return <> 0 THEN
44459: RAISE ex_logging_err;
44460: END IF;
44461:
44462: UPDATE msc_st_resource_requirements
44463: SET process_flag = G_ERROR_FLG,
44464: error_text = lv_message_text
44465: WHERE deleted_flag = SYS_NO
44466: AND sr_instance_code = v_instance_code

Line 44480: pEntityName => 'MSC_ST_RESOURCE_REQUIREMENTS',

44476: (ERRBUF => lv_error_text,
44477: RETCODE => lv_return,
44478: pBatchID => lv_batch_id,
44479: pInstanceCode => v_instance_code,
44480: pEntityName => 'MSC_ST_RESOURCE_REQUIREMENTS',
44481: pInstanceID => v_instance_id);
44482:
44483: IF NVL(lv_return,0) <> 0 THEN
44484: RAISE ex_logging_err;

Line 44496: UPDATE msc_st_resource_requirements

44492: IF c3%ROWCOUNT > 0 THEN
44493:
44494: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
44495:
44496: UPDATE msc_st_resource_requirements
44497: SET operation_sequence_id = msc_st_operation_sequence_id_s.NEXTVAL ,
44498: operation_seq_num =
44499: to_number(decode(length(rtrim(operation_seq_code,'0123456789')),
44500: NULL,operation_seq_code,'1'))

Line 44558: FROM msc_st_resource_requirements

44554: v_current_date,
44555: v_current_user,
44556: v_current_date,
44557: v_current_user
44558: FROM msc_st_resource_requirements
44559: WHERE rowid = lb_rowid(j);
44560:
44561: END IF;
44562: close c3;

Line 44568: 'UPDATE msc_st_resource_requirements msrr'

44564: -- Update operation_sequence_id
44565:
44566: v_sql_stmt := 19;
44567: lv_sql_Stmt :=
44568: 'UPDATE msc_st_resource_requirements msrr'
44569: ||' SET (operation_sequence_id, operation_seq_num) = (SELECT local_id, number1'
44570: ||' FROM msc_local_id_setup mlis'
44571: ||' WHERE mlis.char1 = msrr.sr_instance_code'
44572: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 44600: UPDATE msc_st_resource_requirements

44596: IF c4%ROWCOUNT > 0 THEN
44597:
44598: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
44599:
44600: UPDATE msc_st_resource_requirements
44601: SET resource_seq_num =
44602: to_number(decode(length(rtrim(resource_seq_code,'0123456789')),
44603: NULL,resource_seq_code,'1'))
44604: WHERE rowid = lb_rowid(j);

Line 44660: FROM msc_st_resource_requirements

44656: v_current_date,
44657: v_current_user,
44658: v_current_date,
44659: v_current_user
44660: FROM msc_st_resource_requirements
44661: WHERE rowid = lb_rowid(j) ;
44662:
44663: END IF;
44664: CLOSE c4;

Line 44669: 'UPDATE msc_st_resource_requirements msor'

44665:
44666: -- Update resource seq num from the local id table
44667:
44668: lv_sql_stmt :=
44669: 'UPDATE msc_st_resource_requirements msor'
44670: ||' SET resource_seq_num = (SELECT local_id '
44671: ||' FROM msc_local_id_setup mlis'
44672: ||' WHERE mlis.char1 = msor.sr_instance_code'
44673: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

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

44693: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
44694:
44695: -- Set the processf flag as Valid and populate sr_instance_id
44696: lv_return :=
44697: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
44698: p_instance_id => v_instance_id,
44699: p_instance_code => v_instance_code,
44700: p_process_flag => G_VALID,
44701: p_error_text => lv_error_text,

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

44709:
44710: -- At the end calling the LOG_ERROR for logging all errored out records
44711:
44712: lv_return :=
44713: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',
44714: p_instance_code => v_instance_code,
44715: p_row => lv_column_names,
44716: p_severity => G_SEV_ERROR,
44717: p_message_text => NULL,

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

50961: End IF;
50962: END IF;
50963:
50964: IF v_res_dmd_enabled = SYS_YES THEN
50965: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_REQUIREMENTS',p_erp_enabled => 'Y'); /* bug 3768813 */
50966: IF lv_count > 0 Then
50967: prec.wip_flag:= SYS_YES;
50968: End IF;
50969: END IF;