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_ZONE_REGIONS

Line 1338: 'create index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code

1334: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1335: application_short_name => 'MSC',
1336: statement_type => AD_DDL.CREATE_INDEX,
1337: statement =>
1338: 'create index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code
1339: ||' on MSC_ST_ZONE_REGIONS '
1340: ||'(sr_instance_code, country, state, city, postal_code_from, postal_code_to, zone ) '
1341: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1342: object_name =>'MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);

Line 1339: ||' on MSC_ST_ZONE_REGIONS '

1335: application_short_name => 'MSC',
1336: statement_type => AD_DDL.CREATE_INDEX,
1337: statement =>
1338: 'create index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code
1339: ||' on MSC_ST_ZONE_REGIONS '
1340: ||'(sr_instance_code, country, state, city, postal_code_from, postal_code_to, zone ) '
1341: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1342: object_name =>'MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);
1343:

Line 1342: object_name =>'MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);

1338: 'create index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code
1339: ||' on MSC_ST_ZONE_REGIONS '
1340: ||'(sr_instance_code, country, state, city, postal_code_from, postal_code_to, zone ) '
1341: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1342: object_name =>'MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);
1343:
1344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);
1345:
1346: EXCEPTION

Line 1344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);

1340: ||'(sr_instance_code, country, state, city, postal_code_from, postal_code_to, zone ) '
1341: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1342: object_name =>'MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);
1343:
1344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);
1345:
1346: EXCEPTION
1347: WHEN OTHERS THEN
1348: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

Line 1348: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

1344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);
1345:
1346: EXCEPTION
1347: WHEN OTHERS THEN
1348: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1349: END;
1350:
1351: BEGIN
1352: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 1389: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ZONE_REGIONS', v_instance_id, -1);

1385: END;
1386:
1387: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_SOURCING', v_instance_id, -1);
1388: msc_analyse_tables_pk.analyse_table( 'MSC_ST_REGIONS', v_instance_id, -1);
1389: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ZONE_REGIONS', v_instance_id, -1);
1390: msc_analyse_tables_pk.analyse_table( 'MSC_ST_REGION_LOCATIONS', v_instance_id, -1);
1391: msc_analyse_tables_pk.analyse_table( 'MSC_ST_REGION_SITES', v_instance_id, -1);
1392:
1393: END IF;

Line 2510: 'drop index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code,

2506: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2507: application_short_name => 'MSC',
2508: statement_type => AD_DDL.DROP_INDEX,
2509: statement =>
2510: 'drop index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code,
2511: object_name => 'MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);
2512:
2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);
2514:

Line 2511: object_name => 'MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);

2507: application_short_name => 'MSC',
2508: statement_type => AD_DDL.DROP_INDEX,
2509: statement =>
2510: 'drop index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code,
2511: object_name => 'MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);
2512:
2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);
2514:
2515: EXCEPTION

Line 2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);

2509: statement =>
2510: 'drop index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code,
2511: object_name => 'MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);
2512:
2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);
2514:
2515: EXCEPTION
2516: WHEN OTHERS THEN
2517: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

Line 2517: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

2513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);
2514:
2515: EXCEPTION
2516: WHEN OTHERS THEN
2517: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2518: END;
2519:
2520: BEGIN
2521: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 16999: FROM msc_st_zone_regions

16995: AND sr_instance_code = v_instance_code;
16996:
16997: CURSOR c4(p_batch_id NUMBER) IS
16998: SELECT rowid
16999: FROM msc_st_zone_regions
17000: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
17001: AND sr_instance_code = v_instance_code
17002: AND batch_id = p_batch_id;
17003:

Line 17006: FROM msc_st_zone_regions

17002: AND batch_id = p_batch_id;
17003:
17004: CURSOR c5(p_batch_id NUMBER) IS
17005: SELECT rowid
17006: FROM msc_st_zone_regions
17007: WHERE NVL(zone_region_id,NULL_VALUE) = NULL_VALUE
17008: AND process_flag = G_IN_PROCESS
17009: AND NVL(batch_id,NULL_VALUE) =p_batch_id
17010: AND sr_instance_code = v_instance_code;

Line 17708: 'UPDATE msc_st_zone_regions mszr1 '

17704:
17705: --Duplicate records check for the records whose source is XML
17706: v_sql_stmt := 01;
17707: lv_sql_stmt :=
17708: 'UPDATE msc_st_zone_regions mszr1 '
17709: ||' SET process_flag = '||G_ERROR_FLG||','
17710: ||' error_text = '||''''||lv_message_text||''''
17711: ||' WHERE message_id < (SELECT MAX(message_id)'
17712: ||' FROM msc_st_zone_regions mszr2'

Line 17712: ||' FROM msc_st_zone_regions mszr2'

17708: 'UPDATE msc_st_zone_regions mszr1 '
17709: ||' SET process_flag = '||G_ERROR_FLG||','
17710: ||' error_text = '||''''||lv_message_text||''''
17711: ||' WHERE message_id < (SELECT MAX(message_id)'
17712: ||' FROM msc_st_zone_regions mszr2'
17713: ||' WHERE mszr2.sr_instance_code = mszr1.sr_instance_code'
17714: ||' AND mszr2.zone = mszr1.zone'
17715: ||' AND NVL(mszr2.country, NVL(mszr1.country, '||''''||NULL_CHAR||''''||')) = '
17716: ||' NVL(mszr1.country, NVL(mszr2.country, '||''''||NULL_CHAR||''''||'))'

Line 17758: 'UPDATE msc_st_zone_regions mszr1'

17754: --Different SQL is used because in XML we can identify the latest records
17755: --whereas in batch load we cannot.
17756: v_sql_stmt := 02;
17757: lv_sql_stmt :=
17758: 'UPDATE msc_st_zone_regions mszr1'
17759: ||' SET process_flag = '||G_ERROR_FLG||','
17760: ||' error_text = '||''''||lv_message_text||''''
17761: ||' WHERE EXISTS( SELECT 1 '
17762: ||' FROM msc_st_zone_regions mszr2'

Line 17762: ||' FROM msc_st_zone_regions mszr2'

17758: 'UPDATE msc_st_zone_regions mszr1'
17759: ||' SET process_flag = '||G_ERROR_FLG||','
17760: ||' error_text = '||''''||lv_message_text||''''
17761: ||' WHERE EXISTS( SELECT 1 '
17762: ||' FROM msc_st_zone_regions mszr2'
17763: ||' WHERE mszr2.sr_instance_code = mszr1.sr_instance_code'
17764: ||' AND mszr2.zone = mszr1.zone'
17765: ||' AND NVL(mszr2.country, NVL(mszr1.country, '||''''||NULL_CHAR||''''||')) = '
17766: ||' NVL(mszr1.country, NVL(mszr2.country, '||''''||NULL_CHAR||''''||'))'

Line 17814: 'UPDATE msc_st_zone_regions '

17810: INTO lv_batch_id
17811: FROM DUAL;
17812:
17813: lv_sql_stmt :=
17814: 'UPDATE msc_st_zone_regions '
17815: ||' SET batch_id = :lv_batch_id'
17816: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
17817: ||' AND sr_instance_code = :v_instance_code'
17818: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 17837: UPDATE msc_st_zone_regions

17833: CLOSE c4;
17834:
17835: v_sql_stmt := 05;
17836: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
17837: UPDATE msc_st_zone_regions
17838: SET st_transaction_id = msc_st_zone_regions_s.NEXTVAL,
17839: refresh_number = v_refresh_id,
17840: last_update_date = v_current_date,
17841: last_updated_by = v_current_user,

Line 17838: SET st_transaction_id = msc_st_zone_regions_s.NEXTVAL,

17834:
17835: v_sql_stmt := 05;
17836: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
17837: UPDATE msc_st_zone_regions
17838: SET st_transaction_id = msc_st_zone_regions_s.NEXTVAL,
17839: refresh_number = v_refresh_id,
17840: last_update_date = v_current_date,
17841: last_updated_by = v_current_user,
17842: creation_date = v_current_date,

Line 17852: p_token_value1 => 'MSC_ST_ZONE_REGIONS');

17848: p_error_code => 'MSC_PP_NO_DELETION',
17849: p_message_text => lv_message_text,
17850: p_error_text => lv_error_text,
17851: p_token1 => 'TABLE_NAME',
17852: p_token_value1 => 'MSC_ST_ZONE_REGIONS');
17853:
17854:
17855: -- Deletion is not allowed for this table
17856: v_sql_stmt := 06;

Line 17858: 'UPDATE msc_st_zone_regions '

17854:
17855: -- Deletion is not allowed for this table
17856: v_sql_stmt := 06;
17857: lv_sql_stmt :=
17858: 'UPDATE msc_st_zone_regions '
17859: ||' SET process_flag = '||G_ERROR_FLG||','
17860: ||' error_text = '||''''||lv_message_text||''''
17861: ||' WHERE deleted_flag = '||SYS_YES
17862: ||' AND process_flag = '||G_IN_PROCESS

Line 17896: (p_table_name => 'MSC_ST_ZONE_REGIONS',

17892: lv_where_str := ' AND NVL(deleted_flag,'||NULL_VALUE||') '
17893: ||' NOT IN(1,2)';
17894:
17895: lv_return := MSC_ST_UTIL.LOG_ERROR
17896: (p_table_name => 'MSC_ST_ZONE_REGIONS',
17897: p_instance_code => v_instance_code,
17898: p_row => lv_column_names,
17899: p_severity => G_SEV_WARNING,
17900: p_message_text => lv_message_text,

Line 17927: 'UPDATE msc_st_zone_regions '

17923:
17924: -- Error out records where zone/country/country_code is NULL
17925:
17926: lv_sql_stmt :=
17927: 'UPDATE msc_st_zone_regions '
17928: ||' SET process_flag = '||G_ERROR_FLG||','
17929: ||' error_text = '||''''||lv_message_text||''''
17930: ||' WHERE sr_instance_code = :v_instance_code'
17931: ||' AND batch_id = :lv_batch_id'

Line 17950: 'UPDATE msc_st_zone_regions mszr'

17946:
17947:
17948:
17949: lv_sql_stmt :=
17950: 'UPDATE msc_st_zone_regions mszr'
17951: ||' SET region_id = nvl((SELECT local_id'
17952: ||' FROM msc_local_id_setup mls'
17953: ||' WHERE mls.char1 = mszr.sr_instance_code'
17954: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '

Line 17999: 'UPDATE msc_st_zone_regions '

17995:
17996: -- Error out records where region_id is null
17997:
17998: lv_sql_stmt :=
17999: 'UPDATE msc_st_zone_regions '
18000: ||' SET process_flag = '||G_ERROR_FLG||','
18001: ||' error_text = '||''''||lv_message_text||''''
18002: ||' WHERE sr_instance_code = :v_instance_code'
18003: ||' AND batch_id = :lv_batch_id'

Line 18015: 'UPDATE msc_st_zone_regions mszr'

18011: USING v_instance_code,
18012: lv_batch_id;
18013:
18014: lv_sql_stmt :=
18015: 'UPDATE msc_st_zone_regions mszr'
18016: ||' SET parent_region_id = nvl((SELECT local_id'
18017: ||' FROM msc_local_id_setup mls'
18018: ||' WHERE mls.char1 = mszr.sr_instance_code'
18019: ||' AND NVL(mls.char10, '||''''||NULL_CHAR||''''||') = '

Line 18050: 'UPDATE msc_st_zone_regions '

18046:
18047: -- Error out records where parent_region_id is null
18048:
18049: lv_sql_stmt :=
18050: 'UPDATE msc_st_zone_regions '
18051: ||' SET process_flag = '||G_ERROR_FLG||','
18052: ||' error_text = '||''''||lv_message_text||''''
18053: ||' WHERE sr_instance_code = :v_instance_code'
18054: ||' AND batch_id = :lv_batch_id'

Line 18068: 'UPDATE msc_st_zone_regions '

18064:
18065: -- set the default value of party_id to -1
18066:
18067: lv_sql_stmt :=
18068: 'UPDATE msc_st_zone_regions '
18069: ||' SET party_id = -1 '
18070: ||' WHERE sr_instance_code = :v_instance_code'
18071: ||' AND batch_id = :lv_batch_id'
18072: ||' AND process_flag = '||G_IN_PROCESS

Line 18086: 'UPDATE msc_st_zone_regions mszr'

18082:
18083: -- Deriving zone_region_id
18084:
18085: lv_sql_stmt :=
18086: 'UPDATE msc_st_zone_regions mszr'
18087: ||' SET zone_region_id = nvl((SELECT local_id'
18088: ||' FROM msc_local_id_setup mls'
18089: ||' WHERE mls.char1 = mszr.sr_instance_code'
18090: ||' AND NVL(mls.char2, '||''''||NULL_CHAR||''''||') = '

Line 18127: pEntityName => 'MSC_ST_ZONE_REGIONS',

18123: (ERRBUF => lv_error_text,
18124: RETCODE => lv_return,
18125: pBatchID => lv_batch_id,
18126: pInstanceCode => v_instance_code,
18127: pEntityName => 'MSC_ST_ZONE_REGIONS',
18128: pInstanceID => v_instance_id);
18129:
18130: IF NVL(lv_return,0) <> 0 THEN
18131: RAISE ex_logging_err;

Line 18141: UPDATE msc_st_zone_regions

18137:
18138: IF c5%ROWCOUNT > 0 THEN
18139: v_sql_stmt := 12;
18140: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
18141: UPDATE msc_st_zone_regions
18142: SET zone_region_id = msc_st_zone_region_id_s.NEXTVAL
18143: WHERE rowid = lb_rowid(j);
18144:
18145: v_sql_stmt := 13;

Line 18187: FROM msc_st_zone_regions

18183: v_current_date,
18184: v_current_user,
18185: v_current_date,
18186: v_current_user
18187: FROM msc_st_zone_regions
18188: WHERE rowid = lb_rowid(j);
18189:
18190: END IF;
18191: CLOSE c5 ;

Line 18194: (p_table_name => 'MSC_ST_ZONE_REGIONS',

18190: END IF;
18191: CLOSE c5 ;
18192:
18193: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
18194: (p_table_name => 'MSC_ST_ZONE_REGIONS',
18195: p_instance_id => v_instance_id,
18196: p_instance_code => v_instance_code,
18197: p_process_flag => G_VALID,
18198: p_error_text => lv_error_text,

Line 18206: (p_table_name => 'MSC_ST_ZONE_REGIONS',

18202: RAISE ex_logging_err;
18203: END IF;
18204:
18205: lv_return := MSC_ST_UTIL.LOG_ERROR
18206: (p_table_name => 'MSC_ST_ZONE_REGIONS',
18207: p_instance_code => v_instance_code,
18208: p_row => lv_column_names,
18209: p_severity => G_SEV_ERROR,
18210: p_message_text => NULL,

Line 18240: ||' FROM MSC_ST_ZONE_REGIONS msr'

18236: ||' msr.CREATED_BY,'
18237: ||' msr.CREATION_DATE,'
18238: ||' msr.LAST_UPDATED_BY,'
18239: ||' msr.LAST_UPDATE_DATE'
18240: ||' FROM MSC_ST_ZONE_REGIONS msr'
18241: ||' WHERE msr.batch_id = :lv_batch_id'
18242: ||' AND msr.sr_instance_code = :v_instance_code'
18243: ||' AND msr.process_flag = '||G_VALID
18244: ||' AND NOT EXISTS'

Line 55810: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ZONE_REGIONS');

55806: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_REGIONS');
55807: IF lv_count > 0 Then
55808: prec.sourcing_rule_flag:= SYS_YES;
55809: End IF;
55810: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ZONE_REGIONS');
55811: IF lv_count > 0 Then
55812: prec.sourcing_rule_flag:= SYS_YES;
55813: End IF;
55814: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_REGION_SITES');