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_SETUP_TRANSITIONS

Line 33497: lv_batch_id msc_st_setup_transitions.batch_id%TYPE;

33493: lv_message_text msc_errors.error_text%TYPE;
33494: lv_error_text VARCHAR2(250);
33495: lv_sql_stmt VARCHAR2(5000);
33496: lv_cursor_stmt VARCHAR2(5000);
33497: lv_batch_id msc_st_setup_transitions.batch_id%TYPE;
33498: lv_column_names VARCHAR2(5000); --stores concatenated column names
33499: CURSOR c2(p_batch_id NUMBER) IS
33500: SELECT rowid
33501: FROM msc_st_setup_transitions

Line 33501: FROM msc_st_setup_transitions

33497: lv_batch_id msc_st_setup_transitions.batch_id%TYPE;
33498: lv_column_names VARCHAR2(5000); --stores concatenated column names
33499: CURSOR c2(p_batch_id NUMBER) IS
33500: SELECT rowid
33501: FROM msc_st_setup_transitions
33502: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
33503: AND sr_instance_code = v_instance_code
33504: AND batch_id = p_batch_id;
33505:

Line 33522: ' UPDATE msc_st_setup_transitions '

33518: CLOSE c1;
33519:
33520: v_sql_stmt := 02;
33521: lv_sql_stmt :=
33522: ' UPDATE msc_st_setup_transitions '
33523: ||' SET batch_id = :lv_batch_id'
33524: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
33525: ||' AND sr_instance_code = :v_instance_code'
33526: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 33547: 'UPDATE msc_st_setup_transitions msst1 '

33543: IF lv_return <> 0 THEN
33544: RAISE ex_logging_err;
33545: END IF;
33546: lv_sql_stmt :=
33547: 'UPDATE msc_st_setup_transitions msst1 '
33548: ||'SET process_flag ='|| G_ERROR_FLG||','
33549: ||' error_text = '||''''||lv_message_text||''''
33550: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_setup_transitions msst2'
33551: ||' WHERE msst2.sr_instance_code = msst1.sr_instance_code'

Line 33550: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_setup_transitions msst2'

33546: lv_sql_stmt :=
33547: 'UPDATE msc_st_setup_transitions msst1 '
33548: ||'SET process_flag ='|| G_ERROR_FLG||','
33549: ||' error_text = '||''''||lv_message_text||''''
33550: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_setup_transitions msst2'
33551: ||' WHERE msst2.sr_instance_code = msst1.sr_instance_code'
33552: ||' AND NVL(msst2.company_name,'||''''||NULL_CHAR||''''||') '
33553: ||' = NVL(msst1.company_name,'||''''||NULL_CHAR||''''||') '
33554: ||' AND msst2.organization_code = msst1.organization_code'

Line 33588: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name =>'MSC_ST_SETUP_TRANSITIONS',

33584: END IF;
33585:
33586: -- Populate organization id
33587: lv_return :=
33588: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name =>'MSC_ST_SETUP_TRANSITIONS',
33589: p_org_partner_name =>'ORGANIZATION_CODE',
33590: p_org_partner_id =>'ORGANIZATION_ID',
33591: p_instance_code => v_instance_code,
33592: p_partner_type => G_ORGANIZATION,

Line 33614: 'UPDATE msc_st_setup_transitions msst'

33610: -- Deriving the from_setup_id...
33611: v_sql_stmt := 03;
33612:
33613: lv_sql_stmt :=
33614: 'UPDATE msc_st_setup_transitions msst'
33615: ||' SET from_setup_id= (SELECT local_id'
33616: ||' FROM msc_local_id_setup mlis'
33617: ||' WHERE mlis.char1 = msst.sr_instance_code'
33618: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||')'

Line 33652: ' UPDATE msc_st_setup_transitions '

33648: END IF;
33649: v_sql_stmt := 04;
33650:
33651: lv_sql_stmt :=
33652: ' UPDATE msc_st_setup_transitions '
33653: ||' SET process_flag ='||G_ERROR_FLG||','
33654: ||' error_text = '||''''||lv_message_text||''''
33655: ||' WHERE NVL(from_setup_id,'||NULL_VALUE||') ='|| NULL_VALUE
33656: ||' AND deleted_flag = '||SYS_NO

Line 33671: 'UPDATE msc_st_setup_transitions msst'

33667:
33668: -- Deriving the to_setup_id...
33669: v_sql_stmt := 05;
33670: lv_sql_stmt :=
33671: 'UPDATE msc_st_setup_transitions msst'
33672: ||' SET to_setup_id= (SELECT local_id'
33673: ||' FROM msc_local_id_setup mlis'
33674: ||' WHERE mlis.char1 = msst.sr_instance_code'
33675: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||')'

Line 33710: ' UPDATE msc_st_setup_transitions '

33706: END IF;
33707: v_sql_stmt := 06;
33708:
33709: lv_sql_stmt :=
33710: ' UPDATE msc_st_setup_transitions '
33711: ||' SET process_flag ='||G_ERROR_FLG||','
33712: ||' error_text = '||''''||lv_message_text||''''
33713: ||' WHERE NVL(to_setup_id,'||NULL_VALUE||') ='|| NULL_VALUE
33714: ||' AND deleted_flag = '||SYS_NO

Line 33728: 'UPDATE msc_st_setup_transitions msst'

33724:
33725: v_sql_stmt:= 07;
33726:
33727: lv_sql_stmt :=
33728: 'UPDATE msc_st_setup_transitions msst'
33729: ||' SET standard_operation_id= (SELECT local_id'
33730: ||' FROM msc_local_id_setup mlis'
33731: ||' WHERE mlis.char1 = msst.sr_instance_code'
33732: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||')'

Line 33749: 'UPDATE MSC_ST_SETUP_TRANSITIONS msrc'

33745: --- Deriving DeptID...
33746: /*
33747: v_sql_stmt := 08;
33748: lv_sql_stmt :=
33749: 'UPDATE MSC_ST_SETUP_TRANSITIONS msrc'
33750: ||' SET department_id = (SELECT local_id'
33751: ||' FROM msc_local_id_setup mlis'
33752: ||' WHERE mlis.char1 = msrc.sr_instance_code'
33753: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '

Line 33781: p_token_value3 => 'MSC_ST_SETUP_TRANSITIONS' );

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
33784: RAISE ex_logging_err;
33785: END IF;

Line 33791: 'UPDATE MSC_ST_SETUP_TRANSITIONS '

33787: -- Error out the records where department id is NULL
33788:
33789: v_sql_stmt := 09;
33790: lv_sql_stmt:=
33791: 'UPDATE MSC_ST_SETUP_TRANSITIONS '
33792: ||' SET process_flag = '||G_ERROR_FLG||','
33793: ||' error_text = '||''''||lv_message_text||''''
33794: ||' WHERE NVL(department_id,'||NULL_VALUE||') = '||NULL_VALUE
33795: ||' AND sr_instance_code = :v_instance_code'

Line 33807: 'UPDATE msc_st_setup_transitions msst'

33803: */
33804: -- Now derive the resource_id
33805: v_sql_stmt := 10;
33806: lv_sql_stmt :=
33807: 'UPDATE msc_st_setup_transitions msst'
33808: ||' SET resource_id= (SELECT local_id'
33809: ||' FROM msc_local_id_setup mlis'
33810: ||' WHERE mlis.char1 = msst.sr_instance_code'
33811: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||')'

Line 33845: ' UPDATE msc_st_setup_transitions '

33841: END IF;
33842: v_sql_stmt := 11;
33843:
33844: lv_sql_stmt :=
33845: ' UPDATE msc_st_setup_transitions '
33846: ||' SET process_flag ='||G_ERROR_FLG||','
33847: ||' error_text = '||''''||lv_message_text||''''
33848: ||' WHERE NVL(resource_id,'||NULL_VALUE||') ='|| NULL_VALUE
33849: ||' AND deleted_flag = '||SYS_NO

Line 33861: (p_table_name => 'MSC_ST_SETUP_TRANSITIONS',

33857:
33858:
33859:
33860: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
33861: (p_table_name => 'MSC_ST_SETUP_TRANSITIONS',
33862: p_instance_id => v_instance_id,
33863: p_instance_code => v_instance_code,
33864: p_process_flag => G_VALID,
33865: p_error_text => lv_error_text,

Line 33876: (p_table_name => 'MSC_ST_SETUP_TRANSITIONS',

33872:
33873: -- Inserting all the errored out records into MSC_ERRORS
33874:
33875: lv_return := MSC_ST_UTIL.LOG_ERROR
33876: (p_table_name => 'MSC_ST_SETUP_TRANSITIONS',
33877: p_instance_code => v_instance_code,
33878: p_row => lv_column_names,
33879: p_severity => G_SEV_ERROR,
33880: p_error_text => lv_error_text,

Line 55898: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SETUP_TRANSITIONS');

55894: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_SETUPS');
55895: IF lv_count > 0 Then
55896: prec.bom_flag:= SYS_YES;
55897: End IF;
55898: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SETUP_TRANSITIONS');
55899: IF lv_count > 0 Then
55900: prec.bom_flag:= SYS_YES;
55901: End IF;
55902: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_SHIFTS');