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_RESOURCE_SETUPS

Line 33144: TYPE SetupCode IS TABLE OF MSC_ST_RESOURCE_SETUPS.SETUP_CODE%TYPE INDEX BY BINARY_INTEGER;

33140: --bug 8310366 Validation of all columns for the RESOURCE_SETUP entity (SDS Changes)
33141:
33142: PROCEDURE LOAD_RESOURCE_SETUPS IS
33143: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
33144: TYPE SetupCode IS TABLE OF MSC_ST_RESOURCE_SETUPS.SETUP_CODE%TYPE INDEX BY BINARY_INTEGER;
33145: TYPE OrganizationCode is TABLE OF MSC_ST_RESOURCE_SETUPS.ORGANIZATION_CODE%TYPE INDEX BY BINARY_INTEGER;
33146: TYPE CompanyName is TABLE OF MSC_ST_RESOURCE_SETUPS.COMPANY_NAME%TYPE INDEX BY BINARY_INTEGER;
33147: TYPE CurTyp IS REF CURSOR;
33148: c1 CurTyp;

Line 33145: TYPE OrganizationCode is TABLE OF MSC_ST_RESOURCE_SETUPS.ORGANIZATION_CODE%TYPE INDEX BY BINARY_INTEGER;

33141:
33142: PROCEDURE LOAD_RESOURCE_SETUPS IS
33143: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
33144: TYPE SetupCode IS TABLE OF MSC_ST_RESOURCE_SETUPS.SETUP_CODE%TYPE INDEX BY BINARY_INTEGER;
33145: TYPE OrganizationCode is TABLE OF MSC_ST_RESOURCE_SETUPS.ORGANIZATION_CODE%TYPE INDEX BY BINARY_INTEGER;
33146: TYPE CompanyName is TABLE OF MSC_ST_RESOURCE_SETUPS.COMPANY_NAME%TYPE INDEX BY BINARY_INTEGER;
33147: TYPE CurTyp IS REF CURSOR;
33148: c1 CurTyp;
33149: lb_rowid RowidTab; --bulk collects rowid

Line 33146: TYPE CompanyName is TABLE OF MSC_ST_RESOURCE_SETUPS.COMPANY_NAME%TYPE INDEX BY BINARY_INTEGER;

33142: PROCEDURE LOAD_RESOURCE_SETUPS IS
33143: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
33144: TYPE SetupCode IS TABLE OF MSC_ST_RESOURCE_SETUPS.SETUP_CODE%TYPE INDEX BY BINARY_INTEGER;
33145: TYPE OrganizationCode is TABLE OF MSC_ST_RESOURCE_SETUPS.ORGANIZATION_CODE%TYPE INDEX BY BINARY_INTEGER;
33146: TYPE CompanyName is TABLE OF MSC_ST_RESOURCE_SETUPS.COMPANY_NAME%TYPE INDEX BY BINARY_INTEGER;
33147: TYPE CurTyp IS REF CURSOR;
33148: c1 CurTyp;
33149: lb_rowid RowidTab; --bulk collects rowid
33150: stpCode SetupCode; --bulk collects setupcode

Line 33156: lv_batch_id msc_st_resource_setups.batch_id%TYPE;

33152: compName CompanyName; -- bulk collects company name
33153: lv_return NUMBER;
33154: lv_error_text VARCHAR2(250);
33155: lv_cursor_stmt VARCHAR2(5000);
33156: lv_batch_id msc_st_resource_setups.batch_id%TYPE;
33157: lv_sql_stmt VARCHAR2(5000);
33158: lv_message_text msc_errors.error_text%TYPE;
33159: lv_column_names VARCHAR2(5000); --stores concatenated column names
33160: CURSOR c2(p_batch_id NUMBER) IS

Line 33162: FROM msc_st_resource_setups

33158: lv_message_text msc_errors.error_text%TYPE;
33159: lv_column_names VARCHAR2(5000); --stores concatenated column names
33160: CURSOR c2(p_batch_id NUMBER) IS
33161: SELECT rowid
33162: FROM msc_st_resource_setups
33163: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG) --Check the where clause conditions. Look for any additions or deletions
33164: AND sr_instance_code = v_instance_code
33165: AND batch_id = p_batch_id;
33166:

Line 33169: FROM msc_st_resource_setups

33165: AND batch_id = p_batch_id;
33166:
33167: CURSOR c3(p_batch_id NUMBER) IS
33168: SELECT max(rowid),setup_code,organization_code,company_name
33169: FROM msc_st_resource_setups
33170: WHERE process_flag = G_IN_PROCESS
33171: AND sr_instance_code = v_instance_code
33172: AND batch_id = p_batch_id
33173: AND NVL(setup_id,NULL_VALUE) = NULL_VALUE

Line 33194: 'UPDATE msc_st_resource_setups msrs1 '

33190: RAISE ex_logging_err;
33191: END IF;
33192:
33193: lv_sql_stmt :=
33194: 'UPDATE msc_st_resource_setups msrs1 '
33195: ||'SET process_flag ='|| G_ERROR_FLG||','
33196: ||' error_text = '||''''||lv_message_text||''''
33197: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_resource_setups msrs2'
33198: ||' WHERE msrs2.sr_instance_code = msrs1.sr_instance_code'

Line 33197: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_resource_setups msrs2'

33193: lv_sql_stmt :=
33194: 'UPDATE msc_st_resource_setups msrs1 '
33195: ||'SET process_flag ='|| G_ERROR_FLG||','
33196: ||' error_text = '||''''||lv_message_text||''''
33197: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_resource_setups msrs2'
33198: ||' WHERE msrs2.sr_instance_code = msrs1.sr_instance_code'
33199: ||' AND NVL(msrs2.company_name,'||''''||NULL_CHAR||''''||') '
33200: ||' = NVL(msrs1.company_name,'||''''||NULL_CHAR||''''||') '
33201: ||' AND msrs2.organization_code = msrs1.organization_code'

Line 33229: ' UPDATE msc_st_resource_setups '

33225: CLOSE c1;
33226:
33227: v_sql_stmt := 02;
33228: lv_sql_stmt :=
33229: ' UPDATE msc_st_resource_setups '
33230: ||' SET batch_id = :lv_batch_id'
33231: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
33232: ||' AND sr_instance_code = :v_instance_code'
33233: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 33254: UPDATE msc_st_resource_setups

33250: FETCH c2 BULK COLLECT INTO lb_rowid;
33251: CLOSE c2;
33252: v_sql_stmt := 03;
33253: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
33254: UPDATE msc_st_resource_setups
33255: SET st_transaction_id = msc_st_regions_s.NEXTVAL,
33256: refresh_id = v_refresh_id,
33257: last_update_date = v_current_date,
33258: last_updated_by = v_current_user,

Line 33269: 'UPDATE msc_st_resource_setups msrs'

33265:
33266: v_sql_stmt:= 04;
33267:
33268: lv_sql_stmt :=
33269: 'UPDATE msc_st_resource_setups msrs'
33270: ||' SET setup_id= (SELECT local_id'
33271: ||' FROM msc_local_id_setup mlis'
33272: ||' WHERE mlis.char1 = msrs.sr_instance_code'
33273: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||')'

Line 33305: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name =>'MSC_ST_RESOURCE_SETUPS',

33301:
33302: v_sql_stmt:= 05;
33303:
33304: lv_return :=
33305: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name =>'MSC_ST_RESOURCE_SETUPS',
33306: p_org_partner_name =>'ORGANIZATION_CODE',
33307: p_org_partner_id =>'ORGANIZATION_ID',
33308: p_instance_code => v_instance_code,
33309: p_partner_type => G_ORGANIZATION,

Line 33325: 'UPDATE msc_st_resource_setups msrs'

33321:
33322: v_sql_stmt:= 06;
33323:
33324: lv_sql_stmt :=
33325: 'UPDATE msc_st_resource_setups msrs'
33326: ||' SET resource_id= (SELECT local_id'
33327: ||' FROM msc_local_id_setup mlis'
33328: ||' WHERE mlis.char1 = msrs.sr_instance_code'
33329: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||')'

Line 33359: ' UPDATE msc_st_resource_setups '

33355: END IF;
33356:
33357:
33358: lv_sql_stmt :=
33359: ' UPDATE msc_st_resource_setups '
33360: ||' SET process_flag ='||G_ERROR_FLG||','
33361: ||' error_text = '||''''||lv_message_text||''''
33362: ||' WHERE NVL(resource_id,'||NULL_VALUE||') ='|| NULL_VALUE
33363: ||' AND deleted_flag = '||SYS_NO

Line 33383: UPDATE msc_st_resource_setups

33379:
33380: IF c3%ROWCOUNT > 0 THEN
33381:
33382: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
33383: UPDATE msc_st_resource_setups
33384: SET setup_id = msc_st_resource_setups_s.NEXTVAL
33385: WHERE rowid = lb_rowid(j);
33386:
33387: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST

Line 33384: SET setup_id = msc_st_resource_setups_s.NEXTVAL

33380: IF c3%ROWCOUNT > 0 THEN
33381:
33382: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
33383: UPDATE msc_st_resource_setups
33384: SET setup_id = msc_st_resource_setups_s.NEXTVAL
33385: WHERE rowid = lb_rowid(j);
33386:
33387: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
33388: UPDATE msc_st_resource_setups

Line 33388: UPDATE msc_st_resource_setups

33384: SET setup_id = msc_st_resource_setups_s.NEXTVAL
33385: WHERE rowid = lb_rowid(j);
33386:
33387: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
33388: UPDATE msc_st_resource_setups
33389: SET setup_id =(select setup_id from msc_st_resource_setups where rowid = lb_rowid(j))
33390: WHERE setup_code=stpCode(j)
33391: AND organization_code = orgCode(j)
33392: AND company_name = compName(j)

Line 33389: SET setup_id =(select setup_id from msc_st_resource_setups where rowid = lb_rowid(j))

33385: WHERE rowid = lb_rowid(j);
33386:
33387: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
33388: UPDATE msc_st_resource_setups
33389: SET setup_id =(select setup_id from msc_st_resource_setups where rowid = lb_rowid(j))
33390: WHERE setup_code=stpCode(j)
33391: AND organization_code = orgCode(j)
33392: AND company_name = compName(j)
33393: AND process_flag = G_IN_PROCESS

Line 33431: FROM msc_st_resource_setups

33427: v_current_date,
33428: v_current_user,
33429: v_current_date,
33430: v_current_user
33431: FROM msc_st_resource_setups
33432: WHERE rowid= lb_rowid(j) ;
33433:
33434: END IF;
33435: CLOSE c3;

Line 33438: (p_table_name => 'MSC_ST_RESOURCE_SETUPS',

33434: END IF;
33435: CLOSE c3;
33436:
33437: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
33438: (p_table_name => 'MSC_ST_RESOURCE_SETUPS',
33439: p_instance_id => v_instance_id,
33440: p_instance_code => v_instance_code,
33441: p_process_flag => G_VALID,
33442: p_error_text => lv_error_text,

Line 33453: (p_table_name => 'MSC_ST_RESOURCE_SETUPS',

33449:
33450: -- Inserting all the errored out records into MSC_ERRORS
33451:
33452: lv_return := MSC_ST_UTIL.LOG_ERROR
33453: (p_table_name => 'MSC_ST_RESOURCE_SETUPS',
33454: p_instance_code => v_instance_code,
33455: p_row => lv_column_names,
33456: p_severity => G_SEV_ERROR,
33457: p_error_text => lv_error_text,

Line 33642: p_token_value2 => 'MSC_ST_RESOURCE_SETUPS',

33638: p_error_text => lv_error_text,
33639: p_token1 => 'COLUMN_NAMES',
33640: p_token_value1 => 'FROM_SETUP_CODE',
33641: p_token2 => 'MASTER_TABLE',
33642: p_token_value2 => 'MSC_ST_RESOURCE_SETUPS',
33643: p_token3 => 'CHILD_TABLE' ,
33644: p_token_value3 => 'MSC_ST_RESOURCE_SETUPS' );
33645:
33646: IF lv_return <> 0 THEN

Line 33644: p_token_value3 => 'MSC_ST_RESOURCE_SETUPS' );

33640: p_token_value1 => 'FROM_SETUP_CODE',
33641: p_token2 => 'MASTER_TABLE',
33642: p_token_value2 => 'MSC_ST_RESOURCE_SETUPS',
33643: p_token3 => 'CHILD_TABLE' ,
33644: p_token_value3 => 'MSC_ST_RESOURCE_SETUPS' );
33645:
33646: IF lv_return <> 0 THEN
33647: RAISE ex_logging_err;
33648: END IF;

Line 33699: p_token_value2 => 'MSC_ST_RESOURCE_SETUPS',

33695: p_error_text => lv_error_text,
33696: p_token1 => 'COLUMN_NAMES',
33697: p_token_value1 => 'TO_SETUP_CODE',
33698: p_token2 => 'MASTER_TABLE',
33699: p_token_value2 => 'MSC_ST_RESOURCE_SETUPS',
33700: p_token3 => 'CHILD_TABLE' ,
33701: p_token_value3 => 'MSC_ST_RESOURCE_SETUPS' );
33702:
33703:

Line 33701: p_token_value3 => 'MSC_ST_RESOURCE_SETUPS' );

33697: p_token_value1 => 'TO_SETUP_CODE',
33698: p_token2 => 'MASTER_TABLE',
33699: p_token_value2 => 'MSC_ST_RESOURCE_SETUPS',
33700: p_token3 => 'CHILD_TABLE' ,
33701: p_token_value3 => 'MSC_ST_RESOURCE_SETUPS' );
33702:
33703:
33704: IF lv_return <> 0 THEN
33705: RAISE ex_logging_err;

Line 45979: p_token_value2 => 'MSC_ST_RESOURCE_SETUPS',

45975: p_error_text => lv_error_text,
45976: p_token1 => 'COLUMN_NAMES',
45977: p_token_value1 => 'SETUP_CODE',
45978: p_token2 => 'MASTER_TABLE',
45979: p_token_value2 => 'MSC_ST_RESOURCE_SETUPS',
45980: p_token3 => 'CHILD_TABLE' ,
45981: p_token_value3 => 'MSC_ST_OPERATION_RESOURCES' );
45982:
45983: IF lv_return <> 0 THEN

Line 55894: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_RESOURCE_SETUPS');

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');
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');