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_DEPARTMENT_RESOURCES

Line 953: ||' on MSC_ST_DEPARTMENT_RESOURCES '

949: application_short_name => 'MSC',
950: statement_type => AD_DDL.CREATE_INDEX,
951: statement =>
952: 'create index MSC_ST_DEPT_RES_N1_'||v_instance_code
953: ||' on MSC_ST_DEPARTMENT_RESOURCES '
954: ||'(sr_instance_code, resource_code, department_code, organization_code, company_name) '
955: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
956: object_name =>'MSC_ST_DEPT_RES_N1_'||v_instance_code);
957:

Line 1002: msc_analyse_tables_pk.analyse_table( 'MSC_ST_DEPARTMENT_RESOURCES', v_instance_id, -1);

998: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_RES_CHANGES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
999: END;
1000:
1001: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_GROUPS', v_instance_id, -1);
1002: msc_analyse_tables_pk.analyse_table( 'MSC_ST_DEPARTMENT_RESOURCES', v_instance_id, -1);
1003: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_SHIFTS', v_instance_id, -1);
1004: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_CHANGES', v_instance_id, -1);
1005:
1006: END IF;

Line 26958: lv_batch_id msc_st_department_resources.batch_id%TYPE;

26954: lv_sql_stmt VARCHAR2(5000);
26955: lv_cursor_stmt VARCHAR2(5000);
26956:
26957: lv_simulation_set msc_st_resource_changes.simulation_set%type;
26958: lv_batch_id msc_st_department_resources.batch_id%TYPE;
26959: lv_message_text msc_errors.error_text%TYPE;
26960:
26961:
26962: ex_logging_err EXCEPTION;

Line 26966: FROM msc_st_department_resources

26962: ex_logging_err EXCEPTION;
26963:
26964: CURSOR c2(p_batch_id NUMBER) IS
26965: SELECT rowid
26966: FROM msc_st_department_resources
26967: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
26968: AND sr_instance_code = v_instance_code
26969: AND batch_id = p_batch_id;
26970:

Line 26973: FROM msc_st_department_resources

26969: AND batch_id = p_batch_id;
26970:
26971: CURSOR c3(p_batch_id NUMBER) IS
26972: SELECT max(rowid)
26973: FROM msc_st_department_resources
26974: WHERE process_flag = G_IN_PROCESS
26975: AND sr_instance_code = v_instance_code
26976: AND batch_id = p_batch_id
26977: AND NVL(department_id,NULL_VALUE) = NULL_VALUE

Line 26985: FROM msc_st_department_resources

26981: organization_code,department_code ;
26982:
26983: CURSOR c4(p_batch_id NUMBER) IS
26984: SELECT max(rowid)
26985: FROM msc_st_department_resources
26986: WHERE process_flag = G_IN_PROCESS
26987: AND sr_instance_code = v_instance_code
26988: AND batch_id = p_batch_id
26989: AND NVL(resource_id,NULL_VALUE) = NULL_VALUE

Line 26997: FROM msc_st_department_resources

26993: organization_code,resource_code ;
26994:
26995: CURSOR c5 (p_batch_id NUMBER) IS
26996: SELECT rowid
26997: FROM msc_st_department_resources
26998: WHERE process_flag = G_IN_PROCESS
26999: AND sr_instance_code = v_instance_code
27000: AND batch_id = p_batch_id
27001: AND NVL(department_id,NULL_VALUE) = NULL_VALUE

Line 27429: 'UPDATE msc_st_department_resources msdr1'

27425: END IF;
27426:
27427: v_sql_stmt := 01;
27428: lv_sql_stmt :=
27429: 'UPDATE msc_st_department_resources msdr1'
27430: ||' SET process_flag = '||G_ERROR_FLG||','
27431: ||' error_text = '||''''||lv_message_text||''''
27432: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_department_resources msdr2'
27433: ||' WHERE msdr2.sr_instance_code = msdr1.sr_instance_code'

Line 27432: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_department_resources msdr2'

27428: lv_sql_stmt :=
27429: 'UPDATE msc_st_department_resources msdr1'
27430: ||' SET process_flag = '||G_ERROR_FLG||','
27431: ||' error_text = '||''''||lv_message_text||''''
27432: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_department_resources msdr2'
27433: ||' WHERE msdr2.sr_instance_code = msdr1.sr_instance_code'
27434: ||' AND NVL(msdr2.company_name,'||''''||NULL_CHAR||''''||') '
27435: ||' = NVL(msdr1.company_name,'||''''||NULL_CHAR||''''||') '
27436: ||' AND msdr2.organization_code = msdr1.organization_code'

Line 27463: 'UPDATE msc_st_department_resources msdr1'

27459: IF lv_return <> 0 THEN
27460: RAISE ex_logging_err;
27461: END IF;
27462: lv_sql_stmt :=
27463: 'UPDATE msc_st_department_resources msdr1'
27464: ||' SET process_flag ='|| G_ERROR_FLG||','
27465: ||' error_text = '||''''||lv_message_text||''''
27466: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_department_resources msdr2'
27467: ||' WHERE msdr2.sr_instance_code = msdr1.sr_instance_code'

Line 27466: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_department_resources msdr2'

27462: lv_sql_stmt :=
27463: 'UPDATE msc_st_department_resources msdr1'
27464: ||' SET process_flag ='|| G_ERROR_FLG||','
27465: ||' error_text = '||''''||lv_message_text||''''
27466: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_department_resources msdr2'
27467: ||' WHERE msdr2.sr_instance_code = msdr1.sr_instance_code'
27468: ||' AND NVL(msdr2.company_name,'||''''||NULL_CHAR||''''||') '
27469: ||' = NVL(msdr1.company_name,'||''''||NULL_CHAR||''''||') '
27470: ||' AND msdr2.organization_code = msdr1.organization_code'

Line 27545: ' UPDATE msc_st_department_resources '

27541: CLOSE c1;
27542:
27543: v_sql_stmt := 04;
27544: lv_sql_stmt :=
27545: ' UPDATE msc_st_department_resources '
27546: ||' SET batch_id = :lv_batch_id'
27547: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
27548: ||' AND sr_instance_code = :v_instance_code'
27549: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 27565: UPDATE msc_st_department_resources

27561: CLOSE c2;
27562:
27563: v_sql_stmt := 05;
27564: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
27565: UPDATE msc_st_department_resources
27566: SET st_transaction_id = msc_st_department_resources_s.NEXTVAL,
27567: refresh_id = v_refresh_id,
27568: last_update_date = v_current_date,
27569: last_updated_by = v_current_user,

Line 27566: SET st_transaction_id = msc_st_department_resources_s.NEXTVAL,

27562:
27563: v_sql_stmt := 05;
27564: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
27565: UPDATE msc_st_department_resources
27566: SET st_transaction_id = msc_st_department_resources_s.NEXTVAL,
27567: refresh_id = v_refresh_id,
27568: last_update_date = v_current_date,
27569: last_updated_by = v_current_user,
27570: creation_date = v_current_date,

Line 27582: p_token_value1 => 'MSC_ST_DEPARTMENT_RESOURCES');

27578: p_error_code => 'MSC_PP_NO_DELETION',
27579: p_message_text => lv_message_text,
27580: p_error_text => lv_error_text,
27581: p_token1 => 'TABLE_NAME',
27582: p_token_value1 => 'MSC_ST_DEPARTMENT_RESOURCES');
27583:
27584: IF lv_return <> 0 THEN
27585: RAISE ex_logging_err;
27586: END IF;

Line 27590: ' UPDATE msc_st_department_resources '

27586: END IF;
27587: --Deletion is not allowed on this table.
27588: v_sql_stmt := 06;
27589: lv_sql_stmt :=
27590: ' UPDATE msc_st_department_resources '
27591: ||' SET process_flag ='||G_ERROR_FLG||','
27592: ||' error_text = '||''''||lv_message_text||''''
27593: ||' WHERE deleted_flag = '||SYS_YES
27594: ||' AND process_flag = '||G_IN_PROCESS

Line 27621: ' UPDATE msc_st_department_resources mdr'

27617: -- in the msc_st_resource_groups entity.
27618: v_sql_stmt := 08;
27619:
27620: lv_sql_stmt :=
27621: ' UPDATE msc_st_department_resources mdr'
27622: ||' SET process_flag = '||G_ERROR_FLG||','
27623: ||' error_text = '||''''||lv_message_text||''''
27624: ||' WHERE NOT EXISTS (SELECT 1'
27625: ||' FROM msc_resource_groups mrg'

Line 27662: ' UPDATE msc_st_department_resources '

27658: -- Error out record if department_code is null/resource_code is NULL and line_flag=2
27659:
27660: v_sql_stmt := 07;
27661: lv_sql_stmt :=
27662: ' UPDATE msc_st_department_resources '
27663: ||' SET process_flag = '||G_ERROR_FLG||','
27664: ||' error_text = '||''''||lv_message_text||''''
27665: ||' WHERE (NVL(department_code,'||''''||NULL_CHAR||''''||')'
27666: ||' = '||''''||NULL_CHAR||''''

Line 27699: 'UPDATE msc_st_department_resources '

27695:
27696: v_sql_stmt:= 08;
27697:
27698: lv_sql_stmt :=
27699: 'UPDATE msc_st_department_resources '
27700: ||' SET process_flag ='|| G_ERROR_FLG||','
27701: ||' error_text ='||''''||lv_message_text||''''
27702: ||' WHERE (NVL(max_rate,'||NULL_VALUE||') ='||NULL_VALUE
27703: ||' OR NVL(min_rate,'||NULL_VALUE||') ='|| NULL_VALUE

Line 27738: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

27734: lv_where_str :=
27735: ' AND NVL(deleted_flag,'||NULL_VALUE||') <>'||SYS_NO;
27736:
27737: lv_return := MSC_ST_UTIL.LOG_ERROR
27738: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
27739: p_instance_code => v_instance_code,
27740: p_row => lv_column_names,
27741: p_severity => G_SEV_WARNING,
27742: p_message_text => lv_message_text,

Line 27771: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

27767: END IF;
27768:
27769: -- Derive organization id
27770: lv_return :=
27771: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
27772: p_org_partner_name => 'ORGANIZATION_CODE',
27773: p_org_partner_id => 'ORGANIZATION_ID',
27774: p_instance_code => v_instance_code,
27775: p_partner_type => G_ORGANIZATION,

Line 27807: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

27803: lv_where_str :=
27804: ' AND NVL(line_flag,'||NULL_VALUE||') NOT IN (''1'',''2'')';
27805:
27806: lv_return := MSC_ST_UTIL.LOG_ERROR
27807: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
27808: p_instance_code => v_instance_code,
27809: p_row => lv_column_names,
27810: p_severity => G_SEV_WARNING,
27811: p_message_text => lv_message_text,

Line 27845: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

27841: lv_where_str :=
27842: ' AND NVL(available_24_hours_flag,'||NULL_VALUE||') NOT IN (1,2)';
27843:
27844: lv_return := MSC_ST_UTIL.LOG_ERROR
27845: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
27846: p_instance_code => v_instance_code,
27847: p_row => lv_column_names,
27848: p_severity => G_SEV_WARNING,
27849: p_message_text => lv_message_text,

Line 27883: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

27879: lv_where_str :=
27880: ' AND NVL(ctp_flag,'||NULL_VALUE||') NOT IN (1,2) AND line_flag = ''2'' ';
27881:
27882: lv_return := MSC_ST_UTIL.LOG_ERROR
27883: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
27884: p_instance_code => v_instance_code,
27885: p_row => lv_column_names,
27886: p_severity => G_SEV_WARNING,
27887: p_message_text => lv_message_text,

Line 27921: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

27917: ' AND NVL(resource_type,'||NULL_VALUE||')'
27918: ||' NOT IN (1,2,3,4,5) AND line_flag = ''2'' ';
27919:
27920: lv_return := MSC_ST_UTIL.LOG_ERROR
27921: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
27922: p_instance_code => v_instance_code,
27923: p_row => lv_column_names,
27924: p_severity => G_SEV_WARNING,
27925: p_message_text => lv_message_text,

Line 27961: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

27957: ' AND NVL(resource_include_flag,'||NULL_VALUE||')'
27958: ||' NOT IN (1,2) AND line_flag = 2';
27959:
27960: lv_return := MSC_ST_UTIL.LOG_ERROR
27961: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
27962: p_instance_code => v_instance_code,
27963: p_row => lv_column_names,
27964: p_severity => G_SEV_WARNING,
27965: p_message_text => lv_message_text,

Line 28001: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

27997: ' AND NVL(aggregated_resource_flag,'||NULL_VALUE||')'
27998: ||' NOT IN (1,2) AND LINE_FLAG = 2';
27999:
28000: lv_return := MSC_ST_UTIL.LOG_ERROR
28001: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
28002: p_instance_code => v_instance_code,
28003: p_row => lv_column_names,
28004: p_severity => G_SEV_WARNING,
28005: p_message_text => lv_message_text,

Line 28023: 'UPDATE msc_st_department_resources msdr'

28019: -- Now derive department id
28020: v_sql_stmt:= 10;
28021:
28022: lv_sql_stmt :=
28023: 'UPDATE msc_st_department_resources msdr'
28024: ||' SET department_id= (SELECT local_id'
28025: ||' FROM msc_local_id_setup mlis'
28026: ||' WHERE mlis.char1 = msdr.sr_instance_code'
28027: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 28047: 'UPDATE msc_st_department_resources msdr'

28043: -- Now derive line id
28044: v_sql_stmt:= 10;
28045:
28046: lv_sql_stmt :=
28047: 'UPDATE msc_st_department_resources msdr'
28048: ||' SET department_id= (SELECT local_id '
28049: ||' FROM msc_local_id_setup mlis'
28050: ||' WHERE mlis.char1 = msdr.sr_instance_code'
28051: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 28072: 'UPDATE msc_st_department_resources msdr'

28068:
28069: v_sql_stmt:= 11;
28070:
28071: lv_sql_stmt :=
28072: 'UPDATE msc_st_department_resources msdr'
28073: ||' SET resource_id= (SELECT local_id'
28074: ||' FROM msc_local_id_setup mlis'
28075: ||' WHERE mlis.char1 = msdr.sr_instance_code'
28076: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 28093: 'UPDATE msc_st_department_resources msdr'

28089:
28090: -- Set resoure_id=-1 for line resources
28091:
28092: lv_sql_stmt :=
28093: 'UPDATE msc_st_department_resources msdr'
28094: ||' SET resource_id= -1 '
28095: ||' WHERE msdr.sr_instance_code = :v_instance_code'
28096: ||' AND msdr.process_flag ='|| G_IN_PROCESS
28097: ||' AND NVL(msdr.resource_code, '||''''||NULL_CHAR||''''||') '

Line 28114: pEntityName => 'MSC_ST_DEPARTMENT_RESOURCES',

28110: (ERRBUF => lv_error_text,
28111: RETCODE => lv_return,
28112: pBatchID => lv_batch_id,
28113: pInstanceCode => v_instance_code,
28114: pEntityName => 'MSC_ST_DEPARTMENT_RESOURCES',
28115: pInstanceID => v_instance_id);
28116:
28117: IF NVL(lv_return,0) <> 0 THEN
28118: RAISE ex_logging_err;

Line 28132: UPDATE msc_st_department_resources

28128: IF c3%ROWCOUNT > 0 THEN
28129:
28130: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
28131:
28132: UPDATE msc_st_department_resources
28133: SET department_id = msc_st_sr_inventory_item_id_s.NEXTVAL
28134: WHERE rowid = lb_rowid(j);
28135:
28136:

Line 28175: FROM msc_st_department_resources

28171: v_current_date,
28172: v_current_user,
28173: v_current_date,
28174: v_current_user
28175: FROM msc_st_department_resources
28176: WHERE rowid = lb_rowid(j);
28177:
28178: END IF;
28179: CLOSE c3;

Line 28185: 'UPDATE msc_st_department_resources msdr'

28181: -- Now derive department id
28182: v_sql_stmt:= 15;
28183:
28184: lv_sql_stmt :=
28185: 'UPDATE msc_st_department_resources msdr'
28186: ||' SET department_id= (SELECT local_id'
28187: ||' FROM msc_local_id_setup mlis'
28188: ||' WHERE mlis.char1 = msdr.sr_instance_code'
28189: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 28208: 'UPDATE msc_st_department_resources msdr'

28204:
28205: -- Update owning_department_code as department_code if that is NULL
28206: v_sql_stmt := 16;
28207: lv_sql_stmt :=
28208: 'UPDATE msc_st_department_resources msdr'
28209: ||' SET owning_department_code = department_code'
28210: ||' WHERE NVL(owning_department_code,'||''''||NULL_CHAR||''''||') '
28211: ||' = '||''''||NULL_CHAR||''''
28212: ||' AND sr_instance_code = :v_instance_code'

Line 28226: 'UPDATE msc_st_department_resources msdr'

28222: -- Now derive owning_department id
28223: v_sql_stmt := 17;
28224:
28225: lv_sql_stmt :=
28226: 'UPDATE msc_st_department_resources msdr'
28227: ||' SET owning_department_id= (SELECT local_id'
28228: ||' FROM msc_local_id_setup mlis'
28229: ||' WHERE mlis.char1 = msdr.sr_instance_code'
28230: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 28258: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

28254: p_token1 => 'COLUMN_NAMES',
28255: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
28256: ||'ORGANIZATION_CODE,OWNING_DEPARTMENT_CODE',
28257: p_token2 => 'MASTER_TABLE',
28258: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
28259: p_token3 => 'CHILD_TABLE' ,
28260: p_token_value3 => 'MSC_ST_DEPARTMENT_RESOURCES' );
28261:
28262: IF lv_return <> 0 THEN

Line 28260: p_token_value3 => 'MSC_ST_DEPARTMENT_RESOURCES' );

28256: ||'ORGANIZATION_CODE,OWNING_DEPARTMENT_CODE',
28257: p_token2 => 'MASTER_TABLE',
28258: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
28259: p_token3 => 'CHILD_TABLE' ,
28260: p_token_value3 => 'MSC_ST_DEPARTMENT_RESOURCES' );
28261:
28262: IF lv_return <> 0 THEN
28263: RAISE ex_logging_err;
28264: END IF;

Line 28268: ' UPDATE msc_st_department_resources '

28264: END IF;
28265: v_sql_stmt := 18;
28266:
28267: lv_sql_stmt :=
28268: ' UPDATE msc_st_department_resources '
28269: ||' SET process_flag ='||G_ERROR_FLG||','
28270: ||' error_text = '||''''||lv_message_text||''''
28271: ||' WHERE NVL(owning_department_id,'||NULL_VALUE||') ='|| NULL_VALUE
28272: ||' AND deleted_flag = '||SYS_NO

Line 28296: UPDATE msc_st_department_resources

28292: IF c4%ROWCOUNT > 0 THEN
28293:
28294: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
28295:
28296: UPDATE msc_st_department_resources
28297: SET resource_id = msc_st_sr_inventory_item_id_s.NEXTVAL
28298: WHERE rowid = lb_rowid(j);
28299:
28300:

Line 28341: FROM msc_st_department_resources

28337: v_current_date,
28338: v_current_user,
28339: v_current_date,
28340: v_current_user
28341: FROM msc_st_department_resources
28342: WHERE rowid = lb_rowid(j);
28343:
28344: END IF;
28345: CLOSE c4;

Line 28352: 'UPDATE msc_st_department_resources msdr'

28348:
28349: v_sql_stmt:= 21;
28350:
28351: lv_sql_stmt :=
28352: 'UPDATE msc_st_department_resources msdr'
28353: ||' SET resource_id= (SELECT local_id'
28354: ||' FROM msc_local_id_setup mlis'
28355: ||' WHERE mlis.char1 = msdr.sr_instance_code'
28356: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 28381: UPDATE msc_st_department_resources

28377: IF c5%ROWCOUNT > 0 THEN
28378:
28379: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
28380:
28381: UPDATE msc_st_department_resources
28382: SET department_id = msc_st_sr_inventory_item_id_s.NEXTVAL
28383: WHERE rowid = lb_rowid(j);
28384:
28385:

Line 28424: FROM msc_st_department_resources

28420: v_current_date,
28421: v_current_user,
28422: v_current_date,
28423: v_current_user
28424: FROM msc_st_department_resources
28425: WHERE rowid = lb_rowid(j);
28426:
28427: END IF;
28428: CLOSE c5;

Line 28432: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

28428: CLOSE c5;
28429:
28430: -- Set the process flag as Valid and poulate instance_id
28431: lv_return :=
28432: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
28433: p_instance_id => v_instance_id,
28434: p_instance_code => v_instance_code,
28435: p_process_flag => G_VALID,
28436: p_error_text => lv_error_text,

Line 28447: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

28443:
28444: -- At the end calling the LOG_ERROR for logging all errored out records
28445:
28446: lv_return :=
28447: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
28448: p_instance_code => v_instance_code,
28449: p_row => lv_column_names,
28450: p_severity => G_SEV_ERROR,
28451: p_message_text => NULL,

Line 28720: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

28716: p_token1 => 'COLUMN_NAMES',
28717: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME'
28718: ||' ORGANIZATION_CODE,DEPARTMENT_CODE',
28719: p_token2 => 'MASTER_TABLE',
28720: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
28721: p_token3 => 'CHILD_TABLE' ,
28722: p_token_value3 => 'MSC_ST_RESOURCE_SHIFTS' );
28723:
28724: IF lv_return <> 0 THEN

Line 28777: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

28773: p_token1 => 'COLUMN_NAMES',
28774: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
28775: ||' ORGANIZATION_CODE,RESOURCE_CODE',
28776: p_token2 => 'MASTER_TABLE',
28777: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
28778: p_token3 => 'CHILD_TABLE' ,
28779: p_token_value3 => 'MSC_ST_RESOURCE_SHIFTS' );
28780:
28781: IF lv_return <> 0 THEN

Line 29293: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

29289: p_token1 => 'COLUMN_NAMES',
29290: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
29291: ||' ORGANIZATION_CODE,DEPARTMENT_CODE',
29292: p_token2 => 'MASTER_TABLE',
29293: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
29294: p_token3 => 'CHILD_TABLE' ,
29295: p_token_value3 => 'MSC_ST_RESOURCE_CHANGES' );
29296:
29297: IF lv_return <> 0 THEN

Line 29352: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

29348: p_token1 => 'COLUMN_NAMES',
29349: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
29350: ||' ORGANIZATION_CODE,RESOURCE_CODE',
29351: p_token2 => 'MASTER_TABLE',
29352: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
29353: p_token3 => 'CHILD_TABLE' ,
29354: p_token_value3 => 'MSC_ST_RESOURCE_CHANGES' );
29355:
29356: IF lv_return <> 0 THEN

Line 40234: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

40230: p_token1 => 'COLUMN_NAMES',
40231: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
40232: ||'ORGANIZATION_CODE,DEPARTMENT_CODE',
40233: p_token2 => 'MASTER_TABLE',
40234: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
40235: p_token3 => 'CHILD_TABLE' ,
40236: p_token_value3 => 'MSC_ST_ROUTING_OPERATIONS' );
40237:
40238: IF lv_return <> 0 THEN

Line 41106: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

41102: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
41103: ||' ORGANIZATION_CODE,DEPARTMENT_CODE'
41104: ||' OR RESOURCE_CODE' ,
41105: p_token2 => 'MASTER_TABLE',
41106: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
41107: p_token3 => 'CHILD_TABLE' ,
41108: p_token_value3 => 'MSC_ST_OPERATION_RESOURCES' );
41109:
41110: IF lv_return <> 0 THEN

Line 43914: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

43910: p_token1 => 'COLUMN_NAMES',
43911: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
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

Line 44003: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

43999: p_token1 => 'COLUMN_NAMES',
44000: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
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

Line 47390: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

47386: p_token1 => 'COLUMN_NAMES',
47387: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
47388: ||'ORGANIZATION_CODE,DEPARTMENT_CODE',
47389: p_token2 => 'MASTER_TABLE',
47390: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
47391: p_token3 => 'CHILD_TABLE' ,
47392: p_token_value3 => 'MSC_ST_JOB_OPERATIONS' );
47393:
47394: IF lv_return <> 0 THEN

Line 48626: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

48622: p_token1 => 'COLUMN_NAMES',
48623: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
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

Line 50976: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES');

50972: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_GROUPS');
50973: IF lv_count > 0 Then
50974: prec.bom_flag:= SYS_YES;
50975: End IF;
50976: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES');
50977: IF lv_count > 0 Then
50978: prec.bom_flag:= SYS_YES;
50979: End IF;
50980: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_SHIFTS');