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_OP_RESOURCES

Line 1640: 'create index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code

1636: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1637: application_short_name => 'MSC',
1638: statement_type => AD_DDL.CREATE_INDEX,
1639: statement =>
1640: 'create index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code
1641: ||' on MSC_ST_JOB_OP_RESOURCES '
1642: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE, RESOURCE_SEQ_CODE, ALTERNATE_NUM, RESOURCE_CODE ) '
1643: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1644: object_name =>'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);

Line 1641: ||' on MSC_ST_JOB_OP_RESOURCES '

1637: application_short_name => 'MSC',
1638: statement_type => AD_DDL.CREATE_INDEX,
1639: statement =>
1640: 'create index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code
1641: ||' on MSC_ST_JOB_OP_RESOURCES '
1642: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE, RESOURCE_SEQ_CODE, ALTERNATE_NUM, RESOURCE_CODE ) '
1643: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1644: object_name =>'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
1645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);

Line 1644: object_name =>'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);

1640: 'create index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code
1641: ||' on MSC_ST_JOB_OP_RESOURCES '
1642: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE, RESOURCE_SEQ_CODE, ALTERNATE_NUM, RESOURCE_CODE ) '
1643: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1644: object_name =>'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
1645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
1646:
1647: EXCEPTION
1648: WHEN OTHERS THEN

Line 1645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);

1641: ||' on MSC_ST_JOB_OP_RESOURCES '
1642: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE, RESOURCE_SEQ_CODE, ALTERNATE_NUM, RESOURCE_CODE ) '
1643: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1644: object_name =>'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
1645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
1646:
1647: EXCEPTION
1648: WHEN OTHERS THEN
1649: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code ||'. Error:'||substr(SQLERRM,1,240));

Line 1649: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code ||'. Error:'||substr(SQLERRM,1,240));

1645: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
1646:
1647: EXCEPTION
1648: WHEN OTHERS THEN
1649: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code ||'. Error:'||substr(SQLERRM,1,240));
1650: END;
1651:
1652: END IF;
1653:

Line 2749: 'drop index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code,

2745: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2746: application_short_name => 'MSC',
2747: statement_type => AD_DDL.DROP_INDEX,
2748: statement =>
2749: 'drop index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code,
2750: object_name => 'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
2751:
2752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
2753:

Line 2750: object_name => 'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);

2746: application_short_name => 'MSC',
2747: statement_type => AD_DDL.DROP_INDEX,
2748: statement =>
2749: 'drop index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code,
2750: object_name => 'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
2751:
2752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
2753:
2754: EXCEPTION

Line 2752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);

2748: statement =>
2749: 'drop index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code,
2750: object_name => 'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
2751:
2752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
2753:
2754: EXCEPTION
2755: WHEN OTHERS THEN
2756: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

Line 2756: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

2752: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
2753:
2754: EXCEPTION
2755: WHEN OTHERS THEN
2756: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2757: END;
2758:
2759: END IF;
2760:

Line 50777: FROM msc_st_job_op_resources

50773: AND sr_instance_code = v_instance_code;
50774:
50775: CURSOR c5(p_batch_id NUMBER) IS
50776: SELECT rowid
50777: FROM msc_st_job_op_resources
50778: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
50779: AND sr_instance_code = v_instance_code
50780: AND batch_id = p_batch_id;
50781:

Line 50784: FROM msc_st_job_op_resources

50780: AND batch_id = p_batch_id;
50781:
50782: CURSOR c6(p_batch_id NUMBER) IS
50783: SELECT rowid
50784: FROM msc_st_job_op_resources
50785: WHERE process_flag = G_IN_PROCESS
50786: AND sr_instance_code = v_instance_code
50787: AND batch_id = p_batch_id
50788: AND NVL(resource_seq_num,NULL_VALUE) = NULL_VALUE

Line 53191: -- Validation for MSC_ST_JOB_OP_RESOURCES

53187: COMMIT;
53188: END LOOP ;
53189:
53190:
53191: -- Validation for MSC_ST_JOB_OP_RESOURCES
53192:
53193: --Duplicate records check for the records whose source is XML
53194:
53195: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 53208: 'UPDATE msc_st_job_op_resources msrr1 '

53204:
53205: v_sql_stmt := 01;
53206:
53207: lv_sql_stmt:=
53208: 'UPDATE msc_st_job_op_resources msrr1 '
53209: ||' SET process_flag ='||G_ERROR_FLG||','
53210: ||' error_text = '||''''||lv_message_text||''''
53211: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_job_op_resources msrr2'
53212: ||' WHERE msrr2.sr_instance_code '

Line 53211: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_job_op_resources msrr2'

53207: lv_sql_stmt:=
53208: 'UPDATE msc_st_job_op_resources msrr1 '
53209: ||' SET process_flag ='||G_ERROR_FLG||','
53210: ||' error_text = '||''''||lv_message_text||''''
53211: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_job_op_resources msrr2'
53212: ||' WHERE msrr2.sr_instance_code '
53213: ||' = msrr1.sr_instance_code'
53214: ||' AND NVL(msrr2.company_name,'||''''||NULL_CHAR||''''||') '
53215: ||' = NVL(msrr1.company_name,'||''''||NULL_CHAR||''''||') '

Line 53253: 'UPDATE msc_st_job_op_resources msrr1'

53249: END IF;
53250: v_sql_stmt := 02;
53251:
53252: lv_sql_stmt:=
53253: 'UPDATE msc_st_job_op_resources msrr1'
53254: ||' SET process_flag = '||G_ERROR_FLG||','
53255: ||' error_text = '||''''||lv_message_text||''''
53256: ||' WHERE EXISTS ( SELECT 1 '
53257: ||' FROM msc_st_job_op_resources msrr2'

Line 53257: ||' FROM msc_st_job_op_resources msrr2'

53253: 'UPDATE msc_st_job_op_resources msrr1'
53254: ||' SET process_flag = '||G_ERROR_FLG||','
53255: ||' error_text = '||''''||lv_message_text||''''
53256: ||' WHERE EXISTS ( SELECT 1 '
53257: ||' FROM msc_st_job_op_resources msrr2'
53258: ||' WHERE msrr2.sr_instance_code '
53259: ||' = msrr1.sr_instance_code'
53260: ||' AND NVL(msrr2.company_name,'||''''||NULL_CHAR||''''||') '
53261: ||' = NVL(msrr1.company_name,'||''''||NULL_CHAR||''''||') '

Line 53317: ' UPDATE msc_st_job_op_resources '

53313: CLOSE c1;
53314:
53315: v_sql_stmt := 04;
53316: lv_sql_stmt :=
53317: ' UPDATE msc_st_job_op_resources '
53318: ||' SET batch_id = :lv_batch_id'
53319: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
53320: ||' AND sr_instance_code = :v_instance_code'
53321: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 53337: UPDATE msc_st_job_op_resources

53333: CLOSE c5;
53334:
53335: v_sql_stmt := 05;
53336: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
53337: UPDATE msc_st_job_op_resources
53338: SET st_transaction_id = msc_st_job_op_resources_s.NEXTVAL,
53339: refresh_id = v_refresh_id,
53340: last_update_date = v_current_date,
53341: last_updated_by = v_current_user,

Line 53338: SET st_transaction_id = msc_st_job_op_resources_s.NEXTVAL,

53334:
53335: v_sql_stmt := 05;
53336: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
53337: UPDATE msc_st_job_op_resources
53338: SET st_transaction_id = msc_st_job_op_resources_s.NEXTVAL,
53339: refresh_id = v_refresh_id,
53340: last_update_date = v_current_date,
53341: last_updated_by = v_current_user,
53342: creation_date = v_current_date,

Line 53367: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',

53363: lv_where_str :=
53364: ' AND NVL(deleted_flag,'||NULL_VALUE||') NOT IN(1,2)';
53365:
53366: lv_return := MSC_ST_UTIL.LOG_ERROR
53367: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
53368: p_instance_code => v_instance_code,
53369: p_row => lv_column_names,
53370: p_severity => G_SEV_WARNING,
53371: p_message_text => lv_message_text,

Line 53399: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_JOB_OP_RESOURCES',

53395: END IF;
53396:
53397: -- Populate organization id
53398: lv_return :=
53399: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
53400: p_org_partner_name =>'ORGANIZATION_CODE',
53401: p_org_partner_id =>'ORGANIZATION_ID',
53402: p_instance_code => v_instance_code,
53403: p_partner_type => G_ORGANIZATION,

Line 53417: 'UPDATE msc_st_job_op_resources msrr'

53413:
53414: -- Derive WIP_ENTITY_ID
53415: v_sql_stmt := 06;
53416: lv_sql_stmt:=
53417: 'UPDATE msc_st_job_op_resources msrr'
53418: ||' SET wip_entity_id = (SELECT local_id '
53419: ||' FROM msc_local_id_supply mlis'
53420: ||' WHERE mlis.char1 = msrr.sr_instance_code'
53421: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 53451: p_token_value3 => 'MSC_ST_JOB_OP_RESOURCES' );

53447: ||'ORGANIZATION_CODE,WIP_ENTITY_NAME',
53448: p_token2 => 'MASTER_TABLE',
53449: p_token_value2 => 'MSC_ST_SUPPLIES',
53450: p_token3 => 'CHILD_TABLE' ,
53451: p_token_value3 => 'MSC_ST_JOB_OP_RESOURCES' );
53452:
53453: IF lv_return <> 0 THEN
53454: RAISE ex_logging_err;
53455: END IF;

Line 53462: 'UPDATE msc_st_job_op_resources msrr'

53458: -- Error out the records if WIP_ENTITY_ID NULL
53459:
53460: v_sql_stmt := 07;
53461: lv_sql_stmt:=
53462: 'UPDATE msc_st_job_op_resources msrr'
53463: ||' SET process_flag ='||G_ERROR_FLG||','
53464: ||' error_text = '||''''||lv_message_text||''''
53465: ||' WHERE NVL(wip_entity_id,'||NULL_VALUE||') = '||NULL_VALUE
53466: ||' AND sr_instance_code = :v_instance_code'

Line 53479: 'UPDATE msc_st_job_op_resources msrr'

53475: -- Derive resource id
53476: v_sql_stmt := 10;
53477:
53478: lv_sql_stmt :=
53479: 'UPDATE msc_st_job_op_resources msrr'
53480: ||' SET resource_id= (SELECT local_id '
53481: ||' FROM msc_local_id_setup mlis'
53482: ||' WHERE mlis.char1 = msrr.sr_instance_code'
53483: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 53512: p_token_value3 => 'MSC_ST_JOB_OP_RESOURCES' );

53508: ||'ORGANIZATION_CODE,RESOURCE_CODE',
53509: p_token2 => 'MASTER_TABLE',
53510: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
53511: p_token3 => 'CHILD_TABLE' ,
53512: p_token_value3 => 'MSC_ST_JOB_OP_RESOURCES' );
53513:
53514: IF lv_return <> 0 THEN
53515: RAISE ex_logging_err;
53516: END IF;

Line 53524: 'UPDATE msc_st_job_op_resources msrr'

53520:
53521: v_sql_stmt := 11;
53522:
53523: lv_sql_stmt:=
53524: 'UPDATE msc_st_job_op_resources msrr'
53525: ||' SET process_flag ='||G_ERROR_FLG||','
53526: ||' error_text = '||''''||lv_message_text||''''
53527: ||' WHERE NVL(resource_id,'||NULL_VALUE||') = '||NULL_VALUE
53528: ||' AND sr_instance_code = :v_instance_code'

Line 53542: 'UPDATE msc_st_job_op_resources msrs'

53538: -- Popluate the Department id from LOCAL_ID table
53539:
53540: v_sql_stmt := 25;
53541: lv_sql_stmt :=
53542: 'UPDATE msc_st_job_op_resources msrs'
53543: ||' SET department_id = (SELECT local_id'
53544: ||' FROM msc_local_id_setup mlis'
53545: ||' WHERE mlis.char1 = msrs.sr_instance_code'
53546: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 53580: 'UPDATE msc_st_job_op_resources msrr'

53576: -- Error out records where assigned units is NULL
53577: v_sql_stmt := 08;
53578:
53579: lv_sql_stmt:=
53580: 'UPDATE msc_st_job_op_resources msrr'
53581: ||' SET process_flag ='||G_ERROR_FLG||','
53582: ||' error_text = '||''''||lv_message_text||''''
53583: ||' WHERE NVL(assigned_units,'||NULL_VALUE||') = '||NULL_VALUE
53584: ||' AND sr_instance_code = :v_instance_code'

Line 53611: 'UPDATE msc_st_job_op_resources msrr'

53607: -- Error out records where usage_rate_or_amount is NULL
53608: v_sql_stmt := 08;
53609:
53610: lv_sql_stmt:=
53611: 'UPDATE msc_st_job_op_resources msrr'
53612: ||' SET process_flag ='||G_ERROR_FLG||','
53613: ||' error_text = '||''''||lv_message_text||''''
53614: ||' WHERE NVL(usage_rate_or_amount,'||NULL_VALUE||') = '||NULL_VALUE
53615: ||' AND sr_instance_code = :v_instance_code'

Line 53641: 'UPDATE msc_st_job_op_resources msrr'

53637:
53638: -- Error out records where resource sequence code is NULL
53639:
53640: lv_sql_stmt:=
53641: 'UPDATE msc_st_job_op_resources msrr'
53642: ||' SET process_flag ='||G_ERROR_FLG||','
53643: ||' error_text = '||''''||lv_message_text||''''
53644: ||' WHERE NVL(resource_seq_code,'||''''||NULL_CHAR||''''||') '
53645: ||' = '||''''||NULL_CHAR||''''

Line 53673: 'UPDATE msc_st_job_op_resources'

53669: -- Error out the records where RECOMMENDED is not 'Y' or 'N'
53670:
53671: v_sql_stmt := 7;
53672: lv_sql_stmt :=
53673: 'UPDATE msc_st_job_op_resources'
53674: ||' SET process_flag ='||G_ERROR_FLG||','
53675: ||' error_text = '||''''||lv_message_text||''''
53676: ||' WHERE recommended NOT IN (''Y'', ''N'')'
53677: ||' AND sr_instance_code = :v_instance_code'

Line 53690: ' UPDATE msc_st_job_op_resources'

53686: -- If routing_name is is NULL populate the item_name in routing name
53687:
53688: v_sql_stmt := 13;
53689: lv_sql_stmt :=
53690: ' UPDATE msc_st_job_op_resources'
53691: ||' SET routing_name = item_name'
53692: ||' WHERE process_flag = '||G_IN_PROCESS
53693: ||' AND NVL(routing_name,'||''''||NULL_CHAR||''''||')'
53694: ||' = '||''''||NULL_CHAR||''''

Line 53719: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',

53715:
53716: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
53717: lv_return :=
53718: MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID
53719: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
53720: p_rtg_col_name => 'ROUTING_NAME',
53721: p_rtg_col_id =>'ROUTING_SEQUENCE_ID',
53722: p_instance_code => v_instance_code,
53723: p_severity => G_SEV_ERROR,

Line 53755: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',

53751: lv_where_str :=
53752: ' AND NVL(operation_effectivity_date,(sysdate-36500)) =(sysdate-36500)';
53753:
53754: lv_return := MSC_ST_UTIL.LOG_ERROR
53755: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
53756: p_instance_code => v_instance_code,
53757: p_row => lv_column_names,
53758: p_severity => G_SEV_WARNING,
53759: p_message_text => lv_message_text,

Line 53775: 'UPDATE msc_st_job_op_resources msrr'

53771: -- Derive operation seq num
53772:
53773: v_sql_stmt := 14;
53774: lv_sql_stmt:=
53775: 'UPDATE msc_st_job_op_resources msrr'
53776: ||' SET operation_seq_num = (SELECT number1'
53777: ||' FROM msc_local_id_setup mlis'
53778: ||' WHERE mlis.char1 = msrr.sr_instance_code'
53779: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 53818: 'UPDATE msc_st_job_op_resources'

53814: -- Error out the records whose operation_seq_num is NULL
53815:
53816: v_sql_stmt := 19;
53817: lv_sql_stmt :=
53818: 'UPDATE msc_st_job_op_resources'
53819: ||' SET process_flag ='||G_ERROR_FLG||','
53820: ||' error_text = '||''''||lv_message_text||''''
53821: ||' WHERE NVL(operation_seq_num,'||NULL_VALUE||') ='||NULL_VALUE
53822: ||' AND sr_instance_code = :v_instance_code'

Line 53851: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',

53847:
53848: lv_where_str := ' AND NVL(ALTERNATE_NUM,'||NULL_VALUE||') ='||NULL_VALUE ;
53849:
53850: lv_return := MSC_ST_UTIL.LOG_ERROR
53851: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
53852: p_instance_code => v_instance_code,
53853: p_row => lv_column_names,
53854: p_severity => G_SEV_WARNING,
53855: p_message_text => lv_message_text,

Line 53870: 'UPDATE msc_st_job_op_resources msor'

53866:
53867: -- Derive resource seq num from the local id table
53868:
53869: lv_sql_stmt :=
53870: 'UPDATE msc_st_job_op_resources msor'
53871: ||' SET resource_seq_num = (SELECT local_id '
53872: ||' FROM msc_local_id_setup mlis'
53873: ||' WHERE mlis.char1 = msor.sr_instance_code'
53874: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 53915: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',

53911: lv_where_str := ' AND NVL(principal_flag,'||NULL_VALUE||')'||' NOT IN (1,2)'
53912: ||'AND deleted_flag = 2';
53913:
53914: lv_return := MSC_ST_UTIL.LOG_ERROR
53915: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
53916: p_instance_code => v_instance_code,
53917: p_row => lv_column_names,
53918: p_severity => G_SEV_WARNING,
53919: p_message_text => lv_message_text,

Line 53953: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',

53949: ' AND NVL(basis_type,'||NULL_VALUE||')'
53950: ||' NOT IN (1,2,3,4,5) AND deleted_flag = 2' ;
53951:
53952: lv_return := MSC_ST_UTIL.LOG_ERROR
53953: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
53954: p_instance_code => v_instance_code,
53955: p_row => lv_column_names,
53956: p_severity => G_SEV_WARNING,
53957: p_message_text => lv_message_text,

Line 53975: UPDATE msc_st_job_op_resources

53971: IF c6%ROWCOUNT > 0 THEN
53972:
53973: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
53974:
53975: UPDATE msc_st_job_op_resources
53976: SET resource_seq_num =
53977: to_number(decode(length(rtrim(resource_seq_code,'0123456789')),
53978: NULL,resource_seq_code,'1'))
53979: WHERE rowid = lb_rowid(j);

Line 53991: pEntityName => 'MSC_ST_JOB_OP_RESOURCES',

53987: (ERRBUF => lv_error_text,
53988: RETCODE => lv_return,
53989: pBatchID => lv_batch_id,
53990: pInstanceCode => v_instance_code,
53991: pEntityName => 'MSC_ST_JOB_OP_RESOURCES',
53992: pInstanceID => v_instance_id);
53993:
53994: IF NVL(lv_return,0) <> 0 THEN
53995: RAISE ex_logging_err;

Line 54000: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_JOB_OP_RESOURCES',

53996: END IF;
53997:
53998: -- Set the process flag as Valid and populate sr_instance_id
53999: lv_return :=
54000: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
54001: p_instance_id => v_instance_id,
54002: p_instance_code => v_instance_code,
54003: p_process_flag => G_VALID,
54004: p_error_text => lv_error_text,

Line 54016: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_JOB_OP_RESOURCES',

54012:
54013: -- At the end calling the LOG_ERROR for logging all errored out records
54014:
54015: lv_return :=
54016: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
54017: p_instance_code => v_instance_code,
54018: p_row => lv_column_names,
54019: p_severity => G_SEV_ERROR,
54020: p_message_text => NULL,

Line 55786: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_JOB_OP_RESOURCES');

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');
55787: IF lv_count > 0 Then
55788: prec.wip_flag:= SYS_YES;
55789: End IF;
55790: END IF;