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 961: ||' on MSC_ST_DEPARTMENT_RESOURCES '

957: application_short_name => 'MSC',
958: statement_type => AD_DDL.CREATE_INDEX,
959: statement =>
960: 'create index MSC_ST_DEPT_RES_N1_'||v_instance_code
961: ||' on MSC_ST_DEPARTMENT_RESOURCES '
962: ||'(sr_instance_code, resource_code, department_code, organization_code, company_name) '
963: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
964: object_name =>'MSC_ST_DEPT_RES_N1_'||v_instance_code);
965:

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

1006: 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));
1007: END;
1008:
1009: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_GROUPS', v_instance_id, -1);
1010: msc_analyse_tables_pk.analyse_table( 'MSC_ST_DEPARTMENT_RESOURCES', v_instance_id, -1);
1011: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_SHIFTS', v_instance_id, -1);
1012: msc_analyse_tables_pk.analyse_table( 'MSC_ST_RESOURCE_CHANGES', v_instance_id, -1);
1013:
1014: END IF;

Line 30472: lv_batch_id msc_st_department_resources.batch_id%TYPE;

30468: lv_sql_stmt VARCHAR2(5000);
30469: lv_cursor_stmt VARCHAR2(5000);
30470:
30471: lv_simulation_set msc_st_resource_changes.simulation_set%type;
30472: lv_batch_id msc_st_department_resources.batch_id%TYPE;
30473: lv_message_text msc_errors.error_text%TYPE;
30474:
30475:
30476: ex_logging_err EXCEPTION;

Line 30480: FROM msc_st_department_resources

30476: ex_logging_err EXCEPTION;
30477:
30478: CURSOR c2(p_batch_id NUMBER) IS
30479: SELECT rowid
30480: FROM msc_st_department_resources
30481: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
30482: AND sr_instance_code = v_instance_code
30483: AND batch_id = p_batch_id;
30484:

Line 30487: FROM msc_st_department_resources

30483: AND batch_id = p_batch_id;
30484:
30485: CURSOR c3(p_batch_id NUMBER) IS
30486: SELECT max(rowid)
30487: FROM msc_st_department_resources
30488: WHERE process_flag = G_IN_PROCESS
30489: AND sr_instance_code = v_instance_code
30490: AND batch_id = p_batch_id
30491: AND NVL(department_id,NULL_VALUE) = NULL_VALUE

Line 30499: FROM msc_st_department_resources

30495: organization_code,department_code ;
30496:
30497: CURSOR c4(p_batch_id NUMBER) IS
30498: SELECT max(rowid)
30499: FROM msc_st_department_resources
30500: WHERE process_flag = G_IN_PROCESS
30501: AND sr_instance_code = v_instance_code
30502: AND batch_id = p_batch_id
30503: AND NVL(resource_id,NULL_VALUE) = NULL_VALUE

Line 30511: FROM msc_st_department_resources

30507: organization_code,resource_code ;
30508:
30509: CURSOR c5 (p_batch_id NUMBER) IS
30510: SELECT rowid
30511: FROM msc_st_department_resources
30512: WHERE process_flag = G_IN_PROCESS
30513: AND sr_instance_code = v_instance_code
30514: AND batch_id = p_batch_id
30515: AND NVL(department_id,NULL_VALUE) = NULL_VALUE

Line 30943: 'UPDATE msc_st_department_resources msdr1'

30939: END IF;
30940:
30941: v_sql_stmt := 01;
30942: lv_sql_stmt :=
30943: 'UPDATE msc_st_department_resources msdr1'
30944: ||' SET process_flag = '||G_ERROR_FLG||','
30945: ||' error_text = '||''''||lv_message_text||''''
30946: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_department_resources msdr2'
30947: ||' WHERE msdr2.sr_instance_code = msdr1.sr_instance_code'

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

30942: lv_sql_stmt :=
30943: 'UPDATE msc_st_department_resources msdr1'
30944: ||' SET process_flag = '||G_ERROR_FLG||','
30945: ||' error_text = '||''''||lv_message_text||''''
30946: ||' WHERE message_id < ( SELECT max(message_id) FROM msc_st_department_resources msdr2'
30947: ||' WHERE msdr2.sr_instance_code = msdr1.sr_instance_code'
30948: ||' AND NVL(msdr2.company_name,'||''''||NULL_CHAR||''''||') '
30949: ||' = NVL(msdr1.company_name,'||''''||NULL_CHAR||''''||') '
30950: ||' AND msdr2.organization_code = msdr1.organization_code'

Line 30977: 'UPDATE msc_st_department_resources msdr1'

30973: IF lv_return <> 0 THEN
30974: RAISE ex_logging_err;
30975: END IF;
30976: lv_sql_stmt :=
30977: 'UPDATE msc_st_department_resources msdr1'
30978: ||' SET process_flag ='|| G_ERROR_FLG||','
30979: ||' error_text = '||''''||lv_message_text||''''
30980: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_department_resources msdr2'
30981: ||' WHERE msdr2.sr_instance_code = msdr1.sr_instance_code'

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

30976: lv_sql_stmt :=
30977: 'UPDATE msc_st_department_resources msdr1'
30978: ||' SET process_flag ='|| G_ERROR_FLG||','
30979: ||' error_text = '||''''||lv_message_text||''''
30980: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_department_resources msdr2'
30981: ||' WHERE msdr2.sr_instance_code = msdr1.sr_instance_code'
30982: ||' AND NVL(msdr2.company_name,'||''''||NULL_CHAR||''''||') '
30983: ||' = NVL(msdr1.company_name,'||''''||NULL_CHAR||''''||') '
30984: ||' AND msdr2.organization_code = msdr1.organization_code'

Line 31059: ' UPDATE msc_st_department_resources '

31055: CLOSE c1;
31056:
31057: v_sql_stmt := 04;
31058: lv_sql_stmt :=
31059: ' UPDATE msc_st_department_resources '
31060: ||' SET batch_id = :lv_batch_id'
31061: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
31062: ||' AND sr_instance_code = :v_instance_code'
31063: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 31079: UPDATE msc_st_department_resources

31075: CLOSE c2;
31076:
31077: v_sql_stmt := 05;
31078: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
31079: UPDATE msc_st_department_resources
31080: SET st_transaction_id = msc_st_department_resources_s.NEXTVAL,
31081: refresh_id = v_refresh_id,
31082: last_update_date = v_current_date,
31083: last_updated_by = v_current_user,

Line 31080: SET st_transaction_id = msc_st_department_resources_s.NEXTVAL,

31076:
31077: v_sql_stmt := 05;
31078: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
31079: UPDATE msc_st_department_resources
31080: SET st_transaction_id = msc_st_department_resources_s.NEXTVAL,
31081: refresh_id = v_refresh_id,
31082: last_update_date = v_current_date,
31083: last_updated_by = v_current_user,
31084: creation_date = v_current_date,

Line 31096: p_token_value1 => 'MSC_ST_DEPARTMENT_RESOURCES');

31092: p_error_code => 'MSC_PP_NO_DELETION',
31093: p_message_text => lv_message_text,
31094: p_error_text => lv_error_text,
31095: p_token1 => 'TABLE_NAME',
31096: p_token_value1 => 'MSC_ST_DEPARTMENT_RESOURCES');
31097:
31098: IF lv_return <> 0 THEN
31099: RAISE ex_logging_err;
31100: END IF;

Line 31104: ' UPDATE msc_st_department_resources '

31100: END IF;
31101: --Deletion is not allowed on this table.
31102: v_sql_stmt := 06;
31103: lv_sql_stmt :=
31104: ' UPDATE msc_st_department_resources '
31105: ||' SET process_flag ='||G_ERROR_FLG||','
31106: ||' error_text = '||''''||lv_message_text||''''
31107: ||' WHERE deleted_flag = '||SYS_YES
31108: ||' AND process_flag = '||G_IN_PROCESS

Line 31139: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

31135: lv_where_str :=
31136: ' AND NVL(SCHEDULE_TO_INSTANCE,'||NULL_VALUE||') NOT IN (''1'',''2'')';
31137:
31138: lv_return := MSC_ST_UTIL.LOG_ERROR
31139: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
31140: p_instance_code => v_instance_code,
31141: p_row => lv_column_names,
31142: p_severity => G_SEV_WARNING,
31143: p_message_text => lv_message_text,

Line 31175: ' UPDATE msc_st_department_resources mdr'

31171: -- in the msc_st_resource_groups entity.
31172: v_sql_stmt := 08;
31173:
31174: lv_sql_stmt :=
31175: ' UPDATE msc_st_department_resources mdr'
31176: ||' SET process_flag = '||G_ERROR_FLG||','
31177: ||' error_text = '||''''||lv_message_text||''''
31178: ||' WHERE NOT EXISTS (SELECT 1'
31179: ||' FROM msc_resource_groups mrg'

Line 31216: ' UPDATE msc_st_department_resources '

31212: -- Error out record if department_code is null/resource_code is NULL and line_flag=2
31213:
31214: v_sql_stmt := 07;
31215: lv_sql_stmt :=
31216: ' UPDATE msc_st_department_resources '
31217: ||' SET process_flag = '||G_ERROR_FLG||','
31218: ||' error_text = '||''''||lv_message_text||''''
31219: ||' WHERE (NVL(department_code,'||''''||NULL_CHAR||''''||')'
31220: ||' = '||''''||NULL_CHAR||''''

Line 31253: 'UPDATE msc_st_department_resources '

31249:
31250: v_sql_stmt:= 08;
31251:
31252: lv_sql_stmt :=
31253: 'UPDATE msc_st_department_resources '
31254: ||' SET process_flag ='|| G_ERROR_FLG||','
31255: ||' error_text ='||''''||lv_message_text||''''
31256: ||' WHERE (NVL(max_rate,'||NULL_VALUE||') ='||NULL_VALUE
31257: ||' OR NVL(min_rate,'||NULL_VALUE||') ='|| NULL_VALUE

Line 31292: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

31288: lv_where_str :=
31289: ' AND NVL(deleted_flag,'||NULL_VALUE||') <>'||SYS_NO;
31290:
31291: lv_return := MSC_ST_UTIL.LOG_ERROR
31292: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
31293: p_instance_code => v_instance_code,
31294: p_row => lv_column_names,
31295: p_severity => G_SEV_WARNING,
31296: p_message_text => lv_message_text,

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

31321: END IF;
31322:
31323: -- Derive organization id
31324: lv_return :=
31325: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
31326: p_org_partner_name => 'ORGANIZATION_CODE',
31327: p_org_partner_id => 'ORGANIZATION_ID',
31328: p_instance_code => v_instance_code,
31329: p_partner_type => G_ORGANIZATION,

Line 31361: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

31357: lv_where_str :=
31358: ' AND NVL(line_flag,'||NULL_VALUE||') NOT IN (''1'',''2'')';
31359:
31360: lv_return := MSC_ST_UTIL.LOG_ERROR
31361: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
31362: p_instance_code => v_instance_code,
31363: p_row => lv_column_names,
31364: p_severity => G_SEV_WARNING,
31365: p_message_text => lv_message_text,

Line 31399: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

31395: lv_where_str :=
31396: ' AND NVL(available_24_hours_flag,'||NULL_VALUE||') NOT IN (1,2)';
31397:
31398: lv_return := MSC_ST_UTIL.LOG_ERROR
31399: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
31400: p_instance_code => v_instance_code,
31401: p_row => lv_column_names,
31402: p_severity => G_SEV_WARNING,
31403: p_message_text => lv_message_text,

Line 31437: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

31433: lv_where_str :=
31434: ' AND NVL(ctp_flag,'||NULL_VALUE||') NOT IN (1,2) AND line_flag = ''2'' ';
31435:
31436: lv_return := MSC_ST_UTIL.LOG_ERROR
31437: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
31438: p_instance_code => v_instance_code,
31439: p_row => lv_column_names,
31440: p_severity => G_SEV_WARNING,
31441: p_message_text => lv_message_text,

Line 31475: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

31471: ' AND NVL(resource_type,'||NULL_VALUE||')'
31472: ||' NOT IN (1,2,3,4,5) AND line_flag = ''2'' ';
31473:
31474: lv_return := MSC_ST_UTIL.LOG_ERROR
31475: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
31476: p_instance_code => v_instance_code,
31477: p_row => lv_column_names,
31478: p_severity => G_SEV_WARNING,
31479: p_message_text => lv_message_text,

Line 31515: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

31511: ' AND NVL(resource_include_flag,'||NULL_VALUE||')'
31512: ||' NOT IN (1,2) AND line_flag = 2';
31513:
31514: lv_return := MSC_ST_UTIL.LOG_ERROR
31515: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
31516: p_instance_code => v_instance_code,
31517: p_row => lv_column_names,
31518: p_severity => G_SEV_WARNING,
31519: p_message_text => lv_message_text,

Line 31555: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',

31551: ' AND NVL(aggregated_resource_flag,'||NULL_VALUE||')'
31552: ||' NOT IN (1,2) AND LINE_FLAG = 2';
31553:
31554: lv_return := MSC_ST_UTIL.LOG_ERROR
31555: (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
31556: p_instance_code => v_instance_code,
31557: p_row => lv_column_names,
31558: p_severity => G_SEV_WARNING,
31559: p_message_text => lv_message_text,

Line 31577: 'UPDATE msc_st_department_resources msdr'

31573: -- Now derive department id
31574: v_sql_stmt:= 10;
31575:
31576: lv_sql_stmt :=
31577: 'UPDATE msc_st_department_resources msdr'
31578: ||' SET department_id= (SELECT local_id'
31579: ||' FROM msc_local_id_setup mlis'
31580: ||' WHERE mlis.char1 = msdr.sr_instance_code'
31581: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 31601: 'UPDATE msc_st_department_resources msdr'

31597: -- Now derive line id
31598: v_sql_stmt:= 10;
31599:
31600: lv_sql_stmt :=
31601: 'UPDATE msc_st_department_resources msdr'
31602: ||' SET department_id= (SELECT local_id '
31603: ||' FROM msc_local_id_setup mlis'
31604: ||' WHERE mlis.char1 = msdr.sr_instance_code'
31605: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 31626: 'UPDATE msc_st_department_resources msdr'

31622:
31623: v_sql_stmt:= 11;
31624:
31625: lv_sql_stmt :=
31626: 'UPDATE msc_st_department_resources msdr'
31627: ||' SET resource_id= (SELECT local_id'
31628: ||' FROM msc_local_id_setup mlis'
31629: ||' WHERE mlis.char1 = msdr.sr_instance_code'
31630: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 31647: 'UPDATE msc_st_department_resources msdr'

31643:
31644: -- Set resoure_id=-1 for line resources
31645:
31646: lv_sql_stmt :=
31647: 'UPDATE msc_st_department_resources msdr'
31648: ||' SET resource_id= -1 '
31649: ||' WHERE msdr.sr_instance_code = :v_instance_code'
31650: ||' AND msdr.process_flag ='|| G_IN_PROCESS
31651: ||' AND NVL(msdr.resource_code, '||''''||NULL_CHAR||''''||') '

Line 31668: pEntityName => 'MSC_ST_DEPARTMENT_RESOURCES',

31664: (ERRBUF => lv_error_text,
31665: RETCODE => lv_return,
31666: pBatchID => lv_batch_id,
31667: pInstanceCode => v_instance_code,
31668: pEntityName => 'MSC_ST_DEPARTMENT_RESOURCES',
31669: pInstanceID => v_instance_id);
31670:
31671: IF NVL(lv_return,0) <> 0 THEN
31672: RAISE ex_logging_err;

Line 31686: UPDATE msc_st_department_resources

31682: IF c3%ROWCOUNT > 0 THEN
31683:
31684: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
31685:
31686: UPDATE msc_st_department_resources
31687: SET department_id = msc_st_sr_inventory_item_id_s.NEXTVAL
31688: WHERE rowid = lb_rowid(j);
31689:
31690:

Line 31729: FROM msc_st_department_resources

31725: v_current_date,
31726: v_current_user,
31727: v_current_date,
31728: v_current_user
31729: FROM msc_st_department_resources
31730: WHERE rowid = lb_rowid(j);
31731:
31732: END IF;
31733: CLOSE c3;

Line 31739: 'UPDATE msc_st_department_resources msdr'

31735: -- Now derive department id
31736: v_sql_stmt:= 15;
31737:
31738: lv_sql_stmt :=
31739: 'UPDATE msc_st_department_resources msdr'
31740: ||' SET department_id= (SELECT local_id'
31741: ||' FROM msc_local_id_setup mlis'
31742: ||' WHERE mlis.char1 = msdr.sr_instance_code'
31743: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 31762: 'UPDATE msc_st_department_resources msdr'

31758:
31759: -- Update owning_department_code as department_code if that is NULL
31760: v_sql_stmt := 16;
31761: lv_sql_stmt :=
31762: 'UPDATE msc_st_department_resources msdr'
31763: ||' SET owning_department_code = department_code'
31764: ||' WHERE NVL(owning_department_code,'||''''||NULL_CHAR||''''||') '
31765: ||' = '||''''||NULL_CHAR||''''
31766: ||' AND sr_instance_code = :v_instance_code'

Line 31780: 'UPDATE msc_st_department_resources msdr'

31776: -- Now derive owning_department id
31777: v_sql_stmt := 17;
31778:
31779: lv_sql_stmt :=
31780: 'UPDATE msc_st_department_resources msdr'
31781: ||' SET owning_department_id= (SELECT local_id'
31782: ||' FROM msc_local_id_setup mlis'
31783: ||' WHERE mlis.char1 = msdr.sr_instance_code'
31784: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 31812: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

31808: p_token1 => 'COLUMN_NAMES',
31809: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
31810: ||'ORGANIZATION_CODE,OWNING_DEPARTMENT_CODE',
31811: p_token2 => 'MASTER_TABLE',
31812: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
31813: p_token3 => 'CHILD_TABLE' ,
31814: p_token_value3 => 'MSC_ST_DEPARTMENT_RESOURCES' );
31815:
31816: IF lv_return <> 0 THEN

Line 31814: p_token_value3 => 'MSC_ST_DEPARTMENT_RESOURCES' );

31810: ||'ORGANIZATION_CODE,OWNING_DEPARTMENT_CODE',
31811: p_token2 => 'MASTER_TABLE',
31812: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
31813: p_token3 => 'CHILD_TABLE' ,
31814: p_token_value3 => 'MSC_ST_DEPARTMENT_RESOURCES' );
31815:
31816: IF lv_return <> 0 THEN
31817: RAISE ex_logging_err;
31818: END IF;

Line 31822: ' UPDATE msc_st_department_resources '

31818: END IF;
31819: v_sql_stmt := 18;
31820:
31821: lv_sql_stmt :=
31822: ' UPDATE msc_st_department_resources '
31823: ||' SET process_flag ='||G_ERROR_FLG||','
31824: ||' error_text = '||''''||lv_message_text||''''
31825: ||' WHERE NVL(owning_department_id,'||NULL_VALUE||') ='|| NULL_VALUE
31826: ||' AND deleted_flag = '||SYS_NO

Line 31850: UPDATE msc_st_department_resources

31846: IF c4%ROWCOUNT > 0 THEN
31847:
31848: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
31849:
31850: UPDATE msc_st_department_resources
31851: SET resource_id = msc_st_sr_inventory_item_id_s.NEXTVAL
31852: WHERE rowid = lb_rowid(j);
31853:
31854:

Line 31895: FROM msc_st_department_resources

31891: v_current_date,
31892: v_current_user,
31893: v_current_date,
31894: v_current_user
31895: FROM msc_st_department_resources
31896: WHERE rowid = lb_rowid(j);
31897:
31898: END IF;
31899: CLOSE c4;

Line 31906: 'UPDATE msc_st_department_resources msdr'

31902:
31903: v_sql_stmt:= 21;
31904:
31905: lv_sql_stmt :=
31906: 'UPDATE msc_st_department_resources msdr'
31907: ||' SET resource_id= (SELECT local_id'
31908: ||' FROM msc_local_id_setup mlis'
31909: ||' WHERE mlis.char1 = msdr.sr_instance_code'
31910: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 31935: UPDATE msc_st_department_resources

31931: IF c5%ROWCOUNT > 0 THEN
31932:
31933: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
31934:
31935: UPDATE msc_st_department_resources
31936: SET department_id = msc_st_sr_inventory_item_id_s.NEXTVAL
31937: WHERE rowid = lb_rowid(j);
31938:
31939:

Line 31978: FROM msc_st_department_resources

31974: v_current_date,
31975: v_current_user,
31976: v_current_date,
31977: v_current_user
31978: FROM msc_st_department_resources
31979: WHERE rowid = lb_rowid(j);
31980:
31981: END IF;
31982: CLOSE c5;

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

31982: CLOSE c5;
31983:
31984: -- Set the process flag as Valid and poulate instance_id
31985: lv_return :=
31986: MSC_ST_UTIL.SET_PROCESS_FLAG(p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
31987: p_instance_id => v_instance_id,
31988: p_instance_code => v_instance_code,
31989: p_process_flag => G_VALID,
31990: p_error_text => lv_error_text,

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

31997:
31998: -- At the end calling the LOG_ERROR for logging all errored out records
31999:
32000: lv_return :=
32001: MSC_ST_UTIL.LOG_ERROR(p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES',
32002: p_instance_code => v_instance_code,
32003: p_row => lv_column_names,
32004: p_severity => G_SEV_ERROR,
32005: p_message_text => NULL,

Line 32274: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

32270: p_token1 => 'COLUMN_NAMES',
32271: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME'
32272: ||' ORGANIZATION_CODE,DEPARTMENT_CODE',
32273: p_token2 => 'MASTER_TABLE',
32274: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
32275: p_token3 => 'CHILD_TABLE' ,
32276: p_token_value3 => 'MSC_ST_RESOURCE_SHIFTS' );
32277:
32278: IF lv_return <> 0 THEN

Line 32331: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

32327: p_token1 => 'COLUMN_NAMES',
32328: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
32329: ||' ORGANIZATION_CODE,RESOURCE_CODE',
32330: p_token2 => 'MASTER_TABLE',
32331: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
32332: p_token3 => 'CHILD_TABLE' ,
32333: p_token_value3 => 'MSC_ST_RESOURCE_SHIFTS' );
32334:
32335: IF lv_return <> 0 THEN

Line 32850: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

32846: p_token1 => 'COLUMN_NAMES',
32847: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
32848: ||' ORGANIZATION_CODE,DEPARTMENT_CODE',
32849: p_token2 => 'MASTER_TABLE',
32850: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
32851: p_token3 => 'CHILD_TABLE' ,
32852: p_token_value3 => 'MSC_ST_RESOURCE_CHANGES' );
32853:
32854: IF lv_return <> 0 THEN

Line 32909: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

32905: p_token1 => 'COLUMN_NAMES',
32906: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
32907: ||' ORGANIZATION_CODE,RESOURCE_CODE',
32908: p_token2 => 'MASTER_TABLE',
32909: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
32910: p_token3 => 'CHILD_TABLE' ,
32911: p_token_value3 => 'MSC_ST_RESOURCE_CHANGES' );
32912:
32913: IF lv_return <> 0 THEN

Line 33779: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

33775: p_token1 => 'COLUMN_NAMES',
33776: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
33777: ||'ORGANIZATION_CODE,DEPARTMENT_CODE',
33778: p_token2 => 'MASTER_TABLE',
33779: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
33780: p_token3 => 'CHILD_TABLE' ,
33781: p_token_value3 => 'MSC_ST_SETUP_TRANSITIONS' );
33782:
33783: IF lv_return <> 0 THEN

Line 33835: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

33831: p_token1 => 'COLUMN_NAMES',
33832: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
33833: ||'ORGANIZATION_CODE,OWNING_DEPARTMENT_CODE',
33834: p_token2 => 'MASTER_TABLE',
33835: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
33836: p_token3 => 'CHILD_TABLE' ,
33837: p_token_value3 => 'MSC_ST_DEPARTMENT_RESOURCES' );
33838:
33839: IF lv_return <> 0 THEN

Line 33837: p_token_value3 => 'MSC_ST_DEPARTMENT_RESOURCES' );

33833: ||'ORGANIZATION_CODE,OWNING_DEPARTMENT_CODE',
33834: p_token2 => 'MASTER_TABLE',
33835: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
33836: p_token3 => 'CHILD_TABLE' ,
33837: p_token_value3 => 'MSC_ST_DEPARTMENT_RESOURCES' );
33838:
33839: IF lv_return <> 0 THEN
33840: RAISE ex_logging_err;
33841: END IF;

Line 45018: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

45014: p_token1 => 'COLUMN_NAMES',
45015: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
45016: ||'ORGANIZATION_CODE,DEPARTMENT_CODE',
45017: p_token2 => 'MASTER_TABLE',
45018: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
45019: p_token3 => 'CHILD_TABLE' ,
45020: p_token_value3 => 'MSC_ST_ROUTING_OPERATIONS' );
45021:
45022: IF lv_return <> 0 THEN

Line 45923: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

45919: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
45920: ||' ORGANIZATION_CODE,DEPARTMENT_CODE'
45921: ||' OR RESOURCE_CODE' ,
45922: p_token2 => 'MASTER_TABLE',
45923: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
45924: p_token3 => 'CHILD_TABLE' ,
45925: p_token_value3 => 'MSC_ST_OPERATION_RESOURCES' );
45926:
45927: IF lv_return <> 0 THEN

Line 48791: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

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

Line 48880: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

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

Line 52274: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

52270: p_token1 => 'COLUMN_NAMES',
52271: p_token_value1 => 'SR_INSTANCE_CODE,COMPANY_NAME,'
52272: ||'ORGANIZATION_CODE,DEPARTMENT_CODE',
52273: p_token2 => 'MASTER_TABLE',
52274: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',
52275: p_token3 => 'CHILD_TABLE' ,
52276: p_token_value3 => 'MSC_ST_JOB_OPERATIONS' );
52277:
52278: IF lv_return <> 0 THEN

Line 53510: p_token_value2 => 'MSC_ST_DEPARTMENT_RESOURCES',

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

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

55886: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_GROUPS');
55887: IF lv_count > 0 Then
55888: prec.bom_flag:= SYS_YES;
55889: End IF;
55890: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_DEPARTMENT_RESOURCES');
55891: IF lv_count > 0 Then
55892: prec.bom_flag:= SYS_YES;
55893: End IF;
55894: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_SETUPS');