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 1632: 'create index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code

1628: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1629: application_short_name => 'MSC',
1630: statement_type => AD_DDL.CREATE_INDEX,
1631: statement =>
1632: 'create index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code
1633: ||' on MSC_ST_JOB_OP_RESOURCES '
1634: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE, RESOURCE_SEQ_CODE, ALTERNATE_NUM, RESOURCE_CODE ) '
1635: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1636: object_name =>'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);

Line 1633: ||' on MSC_ST_JOB_OP_RESOURCES '

1629: application_short_name => 'MSC',
1630: statement_type => AD_DDL.CREATE_INDEX,
1631: statement =>
1632: 'create index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code
1633: ||' on MSC_ST_JOB_OP_RESOURCES '
1634: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE, RESOURCE_SEQ_CODE, ALTERNATE_NUM, RESOURCE_CODE ) '
1635: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1636: object_name =>'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
1637: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);

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

1632: 'create index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code
1633: ||' on MSC_ST_JOB_OP_RESOURCES '
1634: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE, RESOURCE_SEQ_CODE, ALTERNATE_NUM, RESOURCE_CODE ) '
1635: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1636: object_name =>'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
1637: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
1638:
1639: EXCEPTION
1640: WHEN OTHERS THEN

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

1633: ||' on MSC_ST_JOB_OP_RESOURCES '
1634: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE, RESOURCE_SEQ_CODE, ALTERNATE_NUM, RESOURCE_CODE ) '
1635: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1636: object_name =>'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
1637: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
1638:
1639: EXCEPTION
1640: WHEN OTHERS THEN
1641: 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 1641: 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));

1637: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
1638:
1639: EXCEPTION
1640: WHEN OTHERS THEN
1641: 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));
1642: END;
1643:
1644: END IF;
1645:

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

2737: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2738: application_short_name => 'MSC',
2739: statement_type => AD_DDL.DROP_INDEX,
2740: statement =>
2741: 'drop index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code,
2742: object_name => 'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
2743:
2744: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
2745:

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

2738: application_short_name => 'MSC',
2739: statement_type => AD_DDL.DROP_INDEX,
2740: statement =>
2741: 'drop index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code,
2742: object_name => 'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
2743:
2744: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
2745:
2746: EXCEPTION

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

2740: statement =>
2741: 'drop index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code,
2742: object_name => 'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
2743:
2744: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
2745:
2746: EXCEPTION
2747: WHEN OTHERS THEN
2748: 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 2748: 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));

2744: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
2745:
2746: EXCEPTION
2747: WHEN OTHERS THEN
2748: 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));
2749: END;
2750:
2751: END IF;
2752:

Line 45893: FROM msc_st_job_op_resources

45889: AND sr_instance_code = v_instance_code;
45890:
45891: CURSOR c5(p_batch_id NUMBER) IS
45892: SELECT rowid
45893: FROM msc_st_job_op_resources
45894: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
45895: AND sr_instance_code = v_instance_code
45896: AND batch_id = p_batch_id;
45897:

Line 45900: FROM msc_st_job_op_resources

45896: AND batch_id = p_batch_id;
45897:
45898: CURSOR c6(p_batch_id NUMBER) IS
45899: SELECT rowid
45900: FROM msc_st_job_op_resources
45901: WHERE process_flag = G_IN_PROCESS
45902: AND sr_instance_code = v_instance_code
45903: AND batch_id = p_batch_id
45904: AND NVL(resource_seq_num,NULL_VALUE) = NULL_VALUE

Line 48307: -- Validation for MSC_ST_JOB_OP_RESOURCES

48303: COMMIT;
48304: END LOOP ;
48305:
48306:
48307: -- Validation for MSC_ST_JOB_OP_RESOURCES
48308:
48309: --Duplicate records check for the records whose source is XML
48310:
48311: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE

Line 48324: 'UPDATE msc_st_job_op_resources msrr1 '

48320:
48321: v_sql_stmt := 01;
48322:
48323: lv_sql_stmt:=
48324: 'UPDATE msc_st_job_op_resources msrr1 '
48325: ||' SET process_flag ='||G_ERROR_FLG||','
48326: ||' error_text = '||''''||lv_message_text||''''
48327: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_job_op_resources msrr2'
48328: ||' WHERE msrr2.sr_instance_code '

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

48323: lv_sql_stmt:=
48324: 'UPDATE msc_st_job_op_resources msrr1 '
48325: ||' SET process_flag ='||G_ERROR_FLG||','
48326: ||' error_text = '||''''||lv_message_text||''''
48327: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_job_op_resources msrr2'
48328: ||' WHERE msrr2.sr_instance_code '
48329: ||' = msrr1.sr_instance_code'
48330: ||' AND NVL(msrr2.company_name,'||''''||NULL_CHAR||''''||') '
48331: ||' = NVL(msrr1.company_name,'||''''||NULL_CHAR||''''||') '

Line 48369: 'UPDATE msc_st_job_op_resources msrr1'

48365: END IF;
48366: v_sql_stmt := 02;
48367:
48368: lv_sql_stmt:=
48369: 'UPDATE msc_st_job_op_resources msrr1'
48370: ||' SET process_flag = '||G_ERROR_FLG||','
48371: ||' error_text = '||''''||lv_message_text||''''
48372: ||' WHERE EXISTS ( SELECT 1 '
48373: ||' FROM msc_st_job_op_resources msrr2'

Line 48373: ||' FROM msc_st_job_op_resources msrr2'

48369: 'UPDATE msc_st_job_op_resources msrr1'
48370: ||' SET process_flag = '||G_ERROR_FLG||','
48371: ||' error_text = '||''''||lv_message_text||''''
48372: ||' WHERE EXISTS ( SELECT 1 '
48373: ||' FROM msc_st_job_op_resources msrr2'
48374: ||' WHERE msrr2.sr_instance_code '
48375: ||' = msrr1.sr_instance_code'
48376: ||' AND NVL(msrr2.company_name,'||''''||NULL_CHAR||''''||') '
48377: ||' = NVL(msrr1.company_name,'||''''||NULL_CHAR||''''||') '

Line 48433: ' UPDATE msc_st_job_op_resources '

48429: CLOSE c1;
48430:
48431: v_sql_stmt := 04;
48432: lv_sql_stmt :=
48433: ' UPDATE msc_st_job_op_resources '
48434: ||' SET batch_id = :lv_batch_id'
48435: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
48436: ||' AND sr_instance_code = :v_instance_code'
48437: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 48453: UPDATE msc_st_job_op_resources

48449: CLOSE c5;
48450:
48451: v_sql_stmt := 05;
48452: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
48453: UPDATE msc_st_job_op_resources
48454: SET st_transaction_id = msc_st_job_op_resources_s.NEXTVAL,
48455: refresh_id = v_refresh_id,
48456: last_update_date = v_current_date,
48457: last_updated_by = v_current_user,

Line 48454: SET st_transaction_id = msc_st_job_op_resources_s.NEXTVAL,

48450:
48451: v_sql_stmt := 05;
48452: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
48453: UPDATE msc_st_job_op_resources
48454: SET st_transaction_id = msc_st_job_op_resources_s.NEXTVAL,
48455: refresh_id = v_refresh_id,
48456: last_update_date = v_current_date,
48457: last_updated_by = v_current_user,
48458: creation_date = v_current_date,

Line 48483: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',

48479: lv_where_str :=
48480: ' AND NVL(deleted_flag,'||NULL_VALUE||') NOT IN(1,2)';
48481:
48482: lv_return := MSC_ST_UTIL.LOG_ERROR
48483: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
48484: p_instance_code => v_instance_code,
48485: p_row => lv_column_names,
48486: p_severity => G_SEV_WARNING,
48487: p_message_text => lv_message_text,

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

48511: END IF;
48512:
48513: -- Populate organization id
48514: lv_return :=
48515: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
48516: p_org_partner_name =>'ORGANIZATION_CODE',
48517: p_org_partner_id =>'ORGANIZATION_ID',
48518: p_instance_code => v_instance_code,
48519: p_partner_type => G_ORGANIZATION,

Line 48533: 'UPDATE msc_st_job_op_resources msrr'

48529:
48530: -- Derive WIP_ENTITY_ID
48531: v_sql_stmt := 06;
48532: lv_sql_stmt:=
48533: 'UPDATE msc_st_job_op_resources msrr'
48534: ||' SET wip_entity_id = (SELECT local_id '
48535: ||' FROM msc_local_id_supply mlis'
48536: ||' WHERE mlis.char1 = msrr.sr_instance_code'
48537: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 48567: p_token_value3 => 'MSC_ST_JOB_OP_RESOURCES' );

48563: ||'ORGANIZATION_CODE,WIP_ENTITY_NAME',
48564: p_token2 => 'MASTER_TABLE',
48565: p_token_value2 => 'MSC_ST_SUPPLIES',
48566: p_token3 => 'CHILD_TABLE' ,
48567: p_token_value3 => 'MSC_ST_JOB_OP_RESOURCES' );
48568:
48569: IF lv_return <> 0 THEN
48570: RAISE ex_logging_err;
48571: END IF;

Line 48578: 'UPDATE msc_st_job_op_resources msrr'

48574: -- Error out the records if WIP_ENTITY_ID NULL
48575:
48576: v_sql_stmt := 07;
48577: lv_sql_stmt:=
48578: 'UPDATE msc_st_job_op_resources msrr'
48579: ||' SET process_flag ='||G_ERROR_FLG||','
48580: ||' error_text = '||''''||lv_message_text||''''
48581: ||' WHERE NVL(wip_entity_id,'||NULL_VALUE||') = '||NULL_VALUE
48582: ||' AND sr_instance_code = :v_instance_code'

Line 48595: 'UPDATE msc_st_job_op_resources msrr'

48591: -- Derive resource id
48592: v_sql_stmt := 10;
48593:
48594: lv_sql_stmt :=
48595: 'UPDATE msc_st_job_op_resources msrr'
48596: ||' SET resource_id= (SELECT local_id '
48597: ||' FROM msc_local_id_setup mlis'
48598: ||' WHERE mlis.char1 = msrr.sr_instance_code'
48599: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 48628: p_token_value3 => 'MSC_ST_JOB_OP_RESOURCES' );

48624: ||'ORGANIZATION_CODE,RESOURCE_CODE',
48625: p_token2 => 'MASTER_TABLE',
48626: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
48627: p_token3 => 'CHILD_TABLE' ,
48628: p_token_value3 => 'MSC_ST_JOB_OP_RESOURCES' );
48629:
48630: IF lv_return <> 0 THEN
48631: RAISE ex_logging_err;
48632: END IF;

Line 48640: 'UPDATE msc_st_job_op_resources msrr'

48636:
48637: v_sql_stmt := 11;
48638:
48639: lv_sql_stmt:=
48640: 'UPDATE msc_st_job_op_resources msrr'
48641: ||' SET process_flag ='||G_ERROR_FLG||','
48642: ||' error_text = '||''''||lv_message_text||''''
48643: ||' WHERE NVL(resource_id,'||NULL_VALUE||') = '||NULL_VALUE
48644: ||' AND sr_instance_code = :v_instance_code'

Line 48658: 'UPDATE msc_st_job_op_resources msrs'

48654: -- Popluate the Department id from LOCAL_ID table
48655:
48656: v_sql_stmt := 25;
48657: lv_sql_stmt :=
48658: 'UPDATE msc_st_job_op_resources msrs'
48659: ||' SET department_id = (SELECT local_id'
48660: ||' FROM msc_local_id_setup mlis'
48661: ||' WHERE mlis.char1 = msrs.sr_instance_code'
48662: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 48696: 'UPDATE msc_st_job_op_resources msrr'

48692: -- Error out records where assigned units is NULL
48693: v_sql_stmt := 08;
48694:
48695: lv_sql_stmt:=
48696: 'UPDATE msc_st_job_op_resources msrr'
48697: ||' SET process_flag ='||G_ERROR_FLG||','
48698: ||' error_text = '||''''||lv_message_text||''''
48699: ||' WHERE NVL(assigned_units,'||NULL_VALUE||') = '||NULL_VALUE
48700: ||' AND sr_instance_code = :v_instance_code'

Line 48727: 'UPDATE msc_st_job_op_resources msrr'

48723: -- Error out records where usage_rate_or_amount is NULL
48724: v_sql_stmt := 08;
48725:
48726: lv_sql_stmt:=
48727: 'UPDATE msc_st_job_op_resources msrr'
48728: ||' SET process_flag ='||G_ERROR_FLG||','
48729: ||' error_text = '||''''||lv_message_text||''''
48730: ||' WHERE NVL(usage_rate_or_amount,'||NULL_VALUE||') = '||NULL_VALUE
48731: ||' AND sr_instance_code = :v_instance_code'

Line 48757: 'UPDATE msc_st_job_op_resources msrr'

48753:
48754: -- Error out records where resource sequence code is NULL
48755:
48756: lv_sql_stmt:=
48757: 'UPDATE msc_st_job_op_resources msrr'
48758: ||' SET process_flag ='||G_ERROR_FLG||','
48759: ||' error_text = '||''''||lv_message_text||''''
48760: ||' WHERE NVL(resource_seq_code,'||''''||NULL_CHAR||''''||') '
48761: ||' = '||''''||NULL_CHAR||''''

Line 48789: 'UPDATE msc_st_job_op_resources'

48785: -- Error out the records where RECOMMENDED is not 'Y' or 'N'
48786:
48787: v_sql_stmt := 7;
48788: lv_sql_stmt :=
48789: 'UPDATE msc_st_job_op_resources'
48790: ||' SET process_flag ='||G_ERROR_FLG||','
48791: ||' error_text = '||''''||lv_message_text||''''
48792: ||' WHERE recommended NOT IN (''Y'', ''N'')'
48793: ||' AND sr_instance_code = :v_instance_code'

Line 48806: ' UPDATE msc_st_job_op_resources'

48802: -- If routing_name is is NULL populate the item_name in routing name
48803:
48804: v_sql_stmt := 13;
48805: lv_sql_stmt :=
48806: ' UPDATE msc_st_job_op_resources'
48807: ||' SET routing_name = item_name'
48808: ||' WHERE process_flag = '||G_IN_PROCESS
48809: ||' AND NVL(routing_name,'||''''||NULL_CHAR||''''||')'
48810: ||' = '||''''||NULL_CHAR||''''

Line 48835: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',

48831:
48832: -- Derive the ROUTING_SEQUENCE_ID from LOCAL ID table
48833: lv_return :=
48834: MSC_ST_UTIL.DERIVE_ROUTING_SEQUENCE_ID
48835: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
48836: p_rtg_col_name => 'ROUTING_NAME',
48837: p_rtg_col_id =>'ROUTING_SEQUENCE_ID',
48838: p_instance_code => v_instance_code,
48839: p_severity => G_SEV_ERROR,

Line 48871: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',

48867: lv_where_str :=
48868: ' AND NVL(operation_effectivity_date,(sysdate-36500)) =(sysdate-36500)';
48869:
48870: lv_return := MSC_ST_UTIL.LOG_ERROR
48871: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
48872: p_instance_code => v_instance_code,
48873: p_row => lv_column_names,
48874: p_severity => G_SEV_WARNING,
48875: p_message_text => lv_message_text,

Line 48891: 'UPDATE msc_st_job_op_resources msrr'

48887: -- Derive operation seq num
48888:
48889: v_sql_stmt := 14;
48890: lv_sql_stmt:=
48891: 'UPDATE msc_st_job_op_resources msrr'
48892: ||' SET operation_seq_num = (SELECT number1'
48893: ||' FROM msc_local_id_setup mlis'
48894: ||' WHERE mlis.char1 = msrr.sr_instance_code'
48895: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 48934: 'UPDATE msc_st_job_op_resources'

48930: -- Error out the records whose operation_seq_num is NULL
48931:
48932: v_sql_stmt := 19;
48933: lv_sql_stmt :=
48934: 'UPDATE msc_st_job_op_resources'
48935: ||' SET process_flag ='||G_ERROR_FLG||','
48936: ||' error_text = '||''''||lv_message_text||''''
48937: ||' WHERE NVL(operation_seq_num,'||NULL_VALUE||') ='||NULL_VALUE
48938: ||' AND sr_instance_code = :v_instance_code'

Line 48967: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',

48963:
48964: lv_where_str := ' AND NVL(ALTERNATE_NUM,'||NULL_VALUE||') ='||NULL_VALUE ;
48965:
48966: lv_return := MSC_ST_UTIL.LOG_ERROR
48967: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
48968: p_instance_code => v_instance_code,
48969: p_row => lv_column_names,
48970: p_severity => G_SEV_WARNING,
48971: p_message_text => lv_message_text,

Line 48986: 'UPDATE msc_st_job_op_resources msor'

48982:
48983: -- Derive resource seq num from the local id table
48984:
48985: lv_sql_stmt :=
48986: 'UPDATE msc_st_job_op_resources msor'
48987: ||' SET resource_seq_num = (SELECT local_id '
48988: ||' FROM msc_local_id_setup mlis'
48989: ||' WHERE mlis.char1 = msor.sr_instance_code'
48990: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 49031: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',

49027: lv_where_str := ' AND NVL(principal_flag,'||NULL_VALUE||')'||' NOT IN (1,2)'
49028: ||'AND deleted_flag = 2';
49029:
49030: lv_return := MSC_ST_UTIL.LOG_ERROR
49031: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
49032: p_instance_code => v_instance_code,
49033: p_row => lv_column_names,
49034: p_severity => G_SEV_WARNING,
49035: p_message_text => lv_message_text,

Line 49069: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',

49065: ' AND NVL(basis_type,'||NULL_VALUE||')'
49066: ||' NOT IN (1,2,3,4,5) AND deleted_flag = 2' ;
49067:
49068: lv_return := MSC_ST_UTIL.LOG_ERROR
49069: (p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
49070: p_instance_code => v_instance_code,
49071: p_row => lv_column_names,
49072: p_severity => G_SEV_WARNING,
49073: p_message_text => lv_message_text,

Line 49091: UPDATE msc_st_job_op_resources

49087: IF c6%ROWCOUNT > 0 THEN
49088:
49089: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
49090:
49091: UPDATE msc_st_job_op_resources
49092: SET resource_seq_num =
49093: to_number(decode(length(rtrim(resource_seq_code,'0123456789')),
49094: NULL,resource_seq_code,'1'))
49095: WHERE rowid = lb_rowid(j);

Line 49107: pEntityName => 'MSC_ST_JOB_OP_RESOURCES',

49103: (ERRBUF => lv_error_text,
49104: RETCODE => lv_return,
49105: pBatchID => lv_batch_id,
49106: pInstanceCode => v_instance_code,
49107: pEntityName => 'MSC_ST_JOB_OP_RESOURCES',
49108: pInstanceID => v_instance_id);
49109:
49110: IF NVL(lv_return,0) <> 0 THEN
49111: RAISE ex_logging_err;

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

49112: END IF;
49113:
49114: -- Set the process flag as Valid and populate sr_instance_id
49115: lv_return :=
49116: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
49117: p_instance_id => v_instance_id,
49118: p_instance_code => v_instance_code,
49119: p_process_flag => G_VALID,
49120: p_error_text => lv_error_text,

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

49128:
49129: -- At the end calling the LOG_ERROR for logging all errored out records
49130:
49131: lv_return :=
49132: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_JOB_OP_RESOURCES',
49133: p_instance_code => v_instance_code,
49134: p_row => lv_column_names,
49135: p_severity => G_SEV_ERROR,
49136: p_message_text => NULL,

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

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');
50873: IF lv_count > 0 Then
50874: prec.wip_flag:= SYS_YES;
50875: End IF;
50876: END IF;