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_ITEM_CATEGORIES

Line 901: ||' on MSC_ST_ITEM_CATEGORIES '

897: application_short_name => 'MSC',
898: statement_type => AD_DDL.CREATE_INDEX,
899: statement =>
900: 'create index MSC_ST_ITEM_CAT_N1_'||v_instance_code
901: ||' on MSC_ST_ITEM_CATEGORIES '
902: ||'(sr_instance_code,item_name, category_name, category_set_name, organization_code, company_name) '
903: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
904: object_name =>'MSC_ST_ITEM_CAT_N1_'||v_instance_code);
905:

Line 919: ||' on MSC_ST_ITEM_CATEGORIES '

915: application_short_name => 'MSC',
916: statement_type => AD_DDL.CREATE_INDEX,
917: statement =>
918: 'create index MSC_ST_ITEM_CAT_N2_'||v_instance_code
919: ||' on MSC_ST_ITEM_CATEGORIES '
920: ||'(sr_instance_code,batch_id) '
921: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
922: object_name =>'MSC_ST_ITEM_CAT_N2_'||v_instance_code);
923:

Line 931: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_CATEGORIES', v_instance_id, -1);

927: WHEN OTHERS THEN
928: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ITEM_CAT_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
929: END;
930:
931: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_CATEGORIES', v_instance_id, -1);
932:
933: END IF;
934:
935: IF v_resources_enabled = SYS_YES THEN

Line 27030: | DESCRIPTION : This procedure validates the data in MSC_ST_ITEM_CATEGORIES|

27026:
27027: END LOAD_SAFETY_STOCKS;
27028:
27029: /*==========================================================================+
27030: | DESCRIPTION : This procedure validates the data in MSC_ST_ITEM_CATEGORIES|
27031: | table. |
27032: +==========================================================================*/
27033: PROCEDURE LOAD_CATEGORY IS
27034: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;

Line 27041: lv_batch_id msc_st_item_categories.batch_id%TYPE;

27037: lv_error_text VARCHAR2(250);
27038: lv_where_str VARCHAR2(5000);
27039: lv_sql_stmt VARCHAR2(5000);
27040: lv_column_names VARCHAR2(5000); --stores concatenated column names
27041: lv_batch_id msc_st_item_categories.batch_id%TYPE;
27042: lv_message_text msc_errors.error_text%TYPE;
27043:
27044: ex_logging_err EXCEPTION;
27045:

Line 27056: FROM msc_st_item_categories

27052: lb_comp CharTblTyp;
27053:
27054: CURSOR c_udk is
27055: SELECT item_name, category_name, category_set_name, organization_code, company_name
27056: FROM msc_st_item_categories
27057: WHERE sr_instance_code = v_instance_code
27058: AND process_flag= G_IN_PROCESS
27059: AND NVL(message_id,NULL_VALUE) = NULL_VALUE
27060: GROUP BY sr_instance_code, item_name, category_name, category_set_name, organization_code, company_name

Line 27065: FROM msc_st_item_categories

27061: HAVING COUNT(*) > 1;
27062:
27063: CURSOR c1(p_batch_id NUMBER) IS
27064: SELECT rowid
27065: FROM msc_st_item_categories
27066: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
27067: AND batch_id = p_batch_id
27068: AND sr_instance_code = v_instance_code;
27069:

Line 27072: FROM msc_st_item_categories

27068: AND sr_instance_code = v_instance_code;
27069:
27070: CURSOR c2(p_batch_id NUMBER) IS
27071: SELECT max(rowid)
27072: FROM msc_st_item_categories
27073: WHERE NVL(sr_category_id,NULL_VALUE) = NULL_VALUE
27074: AND process_flag = G_IN_PROCESS
27075: AND batch_id = p_batch_id
27076: AND sr_instance_code = v_instance_code

Line 27094: 'UPDATE msc_st_item_categories mic1 '

27090:
27091: --Duplicate records check for the records whose source is XML
27092: v_sql_stmt := 01;
27093: lv_sql_stmt :=
27094: 'UPDATE msc_st_item_categories mic1 '
27095: ||' SET process_flag = '||G_ERROR_FLG||','
27096: ||' error_text = '||''''||lv_message_text||''''
27097: ||' WHERE message_id < (SELECT MAX(message_id)'
27098: ||' FROM msc_st_item_categories mic2'

Line 27098: ||' FROM msc_st_item_categories mic2'

27094: 'UPDATE msc_st_item_categories mic1 '
27095: ||' SET process_flag = '||G_ERROR_FLG||','
27096: ||' error_text = '||''''||lv_message_text||''''
27097: ||' WHERE message_id < (SELECT MAX(message_id)'
27098: ||' FROM msc_st_item_categories mic2'
27099: ||' WHERE mic2.sr_instance_code = mic1.sr_instance_code'
27100: ||' AND mic2.organization_code = mic1.organization_code'
27101: ||' AND NVL(mic2.company_name, '||''''||NULL_CHAR||''''||') = '
27102: ||' NVL(mic1.company_name, '||''''||NULL_CHAR||''''||')'

Line 27135: 'UPDATE msc_st_item_categories mic1 '

27131: --whereas in batch load we cannot.
27132: /*
27133: v_sql_stmt := 02;
27134: lv_sql_stmt :=
27135: 'UPDATE msc_st_item_categories mic1 '
27136: ||' SET process_flag = '||G_ERROR_FLG||','
27137: ||' error_text = '||''''||lv_message_text||''''
27138: ||' WHERE EXISTS( SELECT 1 '
27139: ||' FROM msc_st_item_categories mic2'

Line 27139: ||' FROM msc_st_item_categories mic2'

27135: 'UPDATE msc_st_item_categories mic1 '
27136: ||' SET process_flag = '||G_ERROR_FLG||','
27137: ||' error_text = '||''''||lv_message_text||''''
27138: ||' WHERE EXISTS( SELECT 1 '
27139: ||' FROM msc_st_item_categories mic2'
27140: ||' WHERE mic2.sr_instance_code = mic1.sr_instance_code'
27141: ||' AND mic2.organization_code = mic1.organization_code'
27142: ||' AND NVL(mic2.company_name, '||''''||NULL_CHAR||''''||') = '
27143: ||' NVL(mic1.company_name, '||''''||NULL_CHAR||''''||')'

Line 27169: UPDATE msc_st_item_categories

27165: FETCH c_udk BULK COLLECT INTO lb_item, lb_cat, lb_cat_set, lb_org, lb_comp;
27166: CLOSE c_udk;
27167:
27168: FORALL j IN lb_item.FIRST..lb_item.LAST
27169: UPDATE msc_st_item_categories
27170: SET process_flag = G_ERROR_FLG, error_text = lv_message_text
27171: WHERE sr_instance_code = v_instance_code
27172: AND item_name = lb_item(j)
27173: AND category_name = lb_cat(j)

Line 27209: 'UPDATE msc_st_item_categories '

27205: FROM dual;
27206:
27207: v_sql_stmt := 04;
27208: lv_sql_stmt :=
27209: 'UPDATE msc_st_item_categories '
27210: ||' SET batch_id = :lv_batch_id'
27211: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
27212: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE
27213: ||' AND sr_instance_code = :v_instance_code'

Line 27230: UPDATE msc_st_item_categories

27226: CLOSE c1;
27227:
27228: v_sql_stmt := 05;
27229: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
27230: UPDATE msc_st_item_categories
27231: SET st_transaction_id = msc_st_item_categories_s.NEXTVAL,
27232: refresh_id = v_refresh_id,
27233: last_update_date = v_current_date,
27234: last_updated_by = v_current_user,

Line 27231: SET st_transaction_id = msc_st_item_categories_s.NEXTVAL,

27227:
27228: v_sql_stmt := 05;
27229: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
27230: UPDATE msc_st_item_categories
27231: SET st_transaction_id = msc_st_item_categories_s.NEXTVAL,
27232: refresh_id = v_refresh_id,
27233: last_update_date = v_current_date,
27234: last_updated_by = v_current_user,
27235: creation_date = v_current_date,

Line 27245: p_token_value1 => 'MSC_ST_ITEM_CATEGORIES');

27241: p_error_code => 'MSC_PP_NO_DELETION',
27242: p_message_text => lv_message_text,
27243: p_error_text => lv_error_text,
27244: p_token1 => 'TABLE_NAME',
27245: p_token_value1 => 'MSC_ST_ITEM_CATEGORIES');
27246:
27247: IF lv_return <> 0 THEN
27248: RAISE ex_logging_err;
27249: END IF;

Line 27254: 'UPDATE msc_st_item_categories '

27250:
27251: --Deletion is not allowed on this table.
27252: v_sql_stmt := 06;
27253: lv_sql_stmt :=
27254: 'UPDATE msc_st_item_categories '
27255: ||' SET process_flag = '||G_ERROR_FLG||','
27256: ||' error_text = '||''''||lv_message_text||''''
27257: ||' WHERE deleted_flag = '||SYS_YES
27258: ||' AND process_flag = '||G_IN_PROCESS

Line 27290: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',

27286:
27287: --Log a warning for those records where the deleted_flag has a value other
27288: --SYS_NO
27289: lv_return := MSC_ST_UTIL.LOG_ERROR
27290: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',
27291: p_instance_code => v_instance_code,
27292: p_row => lv_column_names,
27293: p_severity => G_SEV_WARNING,
27294: p_message_text => lv_message_text,

Line 27320: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',

27316: END IF;
27317:
27318: --Derive Organization_id
27319: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
27320: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',
27321: p_org_partner_name => 'ORGANIZATION_CODE',
27322: p_org_partner_id => 'ORGANIZATION_ID',
27323: p_instance_code => v_instance_code,
27324: p_partner_type => G_ORGANIZATION,

Line 27350: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',

27346: END IF;
27347:
27348: --Derive Inventory_item_id
27349: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
27350: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',
27351: p_item_col_name => 'ITEM_NAME',
27352: p_item_col_id => 'INVENTORY_ITEM_ID',
27353: p_instance_id => v_instance_id,
27354: p_instance_code => v_instance_code,

Line 27370: 'UPDATE msc_st_item_categories '

27366:
27367: --Derive sr_category_set_id
27368: v_sql_stmt := 07;
27369: lv_sql_stmt :=
27370: 'UPDATE msc_st_item_categories '
27371: ||' SET sr_category_set_id = (SELECT local_id'
27372: ||' FROM msc_local_id_misc'
27373: ||' WHERE char1 = sr_instance_code'
27374: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||') = '

Line 27404: 'UPDATE msc_st_item_categories '

27400: END IF;
27401:
27402: v_sql_stmt := 08;
27403: lv_sql_stmt :=
27404: 'UPDATE msc_st_item_categories '
27405: ||' SET process_flag = '||G_ERROR_FLG||','
27406: ||' error_text = '||''''||lv_message_text||''''
27407: ||' WHERE NVL(sr_category_set_id,'||NULL_VALUE||') = '||NULL_VALUE
27408: ||' AND process_flag = '||G_IN_PROCESS

Line 27422: 'UPDATE msc_st_item_categories '

27418:
27419: --Derive sr_category_id
27420: v_sql_stmt := 09;
27421: lv_sql_stmt :=
27422: 'UPDATE msc_st_item_categories '
27423: ||' SET sr_category_id = (SELECT local_id '
27424: ||' FROM msc_local_id_misc'
27425: ||' WHERE char1 = sr_instance_code'
27426: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||') = '

Line 27446: pEntityName => 'MSC_ST_ITEM_CATEGORIES',

27442: (ERRBUF => lv_error_text,
27443: RETCODE => lv_return,
27444: pBatchID => lv_batch_id,
27445: pInstanceCode => v_instance_code,
27446: pEntityName => 'MSC_ST_ITEM_CATEGORIES',
27447: pInstanceID => v_instance_id);
27448:
27449: IF NVL(lv_return,0) <> 0 THEN
27450: RAISE ex_logging_err;

Line 27460: UPDATE msc_st_item_categories

27456: IF c2%ROWCOUNT > 0 THEN
27457:
27458: v_sql_stmt := 10;
27459: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
27460: UPDATE msc_st_item_categories
27461: SET sr_category_id = msc_st_sr_category_id_s.NEXTVAL
27462: WHERE rowid = lb_rowid(j);
27463:
27464: v_sql_stmt := 11;

Line 27500: FROM msc_st_item_categories

27496: v_current_date,
27497: v_current_user,
27498: v_current_date,
27499: v_current_user
27500: FROM msc_st_item_categories
27501: WHERE rowid = lb_rowid(j);
27502:
27503: END IF;
27504: CLOSE c2 ;

Line 27509: 'UPDATE msc_st_item_categories '

27505:
27506: --Derive sr_category_id
27507: v_sql_stmt := 09;
27508: lv_sql_stmt :=
27509: 'UPDATE msc_st_item_categories '
27510: ||' SET sr_category_id = (SELECT local_id '
27511: ||' FROM msc_local_id_misc'
27512: ||' WHERE char1 = sr_instance_code'
27513: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||') = '

Line 27531: 'UPDATE msc_st_item_categories '

27527:
27528:
27529: v_sql_stmt := 12;
27530: lv_sql_stmt :=
27531: 'UPDATE msc_st_item_categories '
27532: ||' SET summary_flag = ''N'' '
27533: ||' WHERE process_flag = '||G_IN_PROCESS
27534: ||' AND batch_id = :lv_batch_id'
27535: ||' AND sr_instance_code = :v_instance_code';

Line 27544: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',

27540: USING lv_batch_id,
27541: v_instance_code;
27542:
27543: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
27544: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',
27545: p_instance_id => v_instance_id,
27546: p_instance_code => v_instance_code,
27547: p_process_flag => G_VALID,
27548: p_error_text => lv_error_text,

Line 27557: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',

27553: RAISE ex_logging_err;
27554: END IF;
27555:
27556: lv_return := MSC_ST_UTIL.LOG_ERROR
27557: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',
27558: p_instance_code => v_instance_code,
27559: p_row => lv_column_names,
27560: p_severity => G_SEV_ERROR,
27561: p_message_text => NULL,

Line 56010: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ITEM_CATEGORIES');

56006: End IF;
56007: END IF;
56008:
56009: IF v_item_cat_enabled = SYS_YES THEN
56010: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ITEM_CATEGORIES');
56011: IF lv_count > 0 Then
56012: prec.item_flag:= SYS_YES;
56013: End IF;
56014: END IF;