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 893: ||' on MSC_ST_ITEM_CATEGORIES '

889: application_short_name => 'MSC',
890: statement_type => AD_DDL.CREATE_INDEX,
891: statement =>
892: 'create index MSC_ST_ITEM_CAT_N1_'||v_instance_code
893: ||' on MSC_ST_ITEM_CATEGORIES '
894: ||'(sr_instance_code,item_name, category_name, category_set_name, organization_code, company_name) '
895: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
896: object_name =>'MSC_ST_ITEM_CAT_N1_'||v_instance_code);
897:

Line 911: ||' on MSC_ST_ITEM_CATEGORIES '

907: application_short_name => 'MSC',
908: statement_type => AD_DDL.CREATE_INDEX,
909: statement =>
910: 'create index MSC_ST_ITEM_CAT_N2_'||v_instance_code
911: ||' on MSC_ST_ITEM_CATEGORIES '
912: ||'(sr_instance_code,batch_id) '
913: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
914: object_name =>'MSC_ST_ITEM_CAT_N2_'||v_instance_code);
915:

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

919: WHEN OTHERS THEN
920: 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));
921: END;
922:
923: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_CATEGORIES', v_instance_id, -1);
924:
925: END IF;
926:
927: IF v_resources_enabled = SYS_YES THEN

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

23537:
23538: END LOAD_SAFETY_STOCKS;
23539:
23540: /*==========================================================================+
23541: | DESCRIPTION : This procedure validates the data in MSC_ST_ITEM_CATEGORIES|
23542: | table. |
23543: +==========================================================================*/
23544: PROCEDURE LOAD_CATEGORY IS
23545: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;

Line 23552: lv_batch_id msc_st_item_categories.batch_id%TYPE;

23548: lv_error_text VARCHAR2(250);
23549: lv_where_str VARCHAR2(5000);
23550: lv_sql_stmt VARCHAR2(5000);
23551: lv_column_names VARCHAR2(5000); --stores concatenated column names
23552: lv_batch_id msc_st_item_categories.batch_id%TYPE;
23553: lv_message_text msc_errors.error_text%TYPE;
23554:
23555: ex_logging_err EXCEPTION;
23556:

Line 23567: FROM msc_st_item_categories

23563: lb_comp CharTblTyp;
23564:
23565: CURSOR c_udk is
23566: SELECT item_name, category_name, category_set_name, organization_code, company_name
23567: FROM msc_st_item_categories
23568: WHERE sr_instance_code = v_instance_code
23569: AND process_flag= G_IN_PROCESS
23570: AND NVL(message_id,NULL_VALUE) = NULL_VALUE
23571: GROUP BY sr_instance_code, item_name, category_name, category_set_name, organization_code, company_name

Line 23576: FROM msc_st_item_categories

23572: HAVING COUNT(*) > 1;
23573:
23574: CURSOR c1(p_batch_id NUMBER) IS
23575: SELECT rowid
23576: FROM msc_st_item_categories
23577: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
23578: AND batch_id = p_batch_id
23579: AND sr_instance_code = v_instance_code;
23580:

Line 23583: FROM msc_st_item_categories

23579: AND sr_instance_code = v_instance_code;
23580:
23581: CURSOR c2(p_batch_id NUMBER) IS
23582: SELECT max(rowid)
23583: FROM msc_st_item_categories
23584: WHERE NVL(sr_category_id,NULL_VALUE) = NULL_VALUE
23585: AND process_flag = G_IN_PROCESS
23586: AND batch_id = p_batch_id
23587: AND sr_instance_code = v_instance_code

Line 23605: 'UPDATE msc_st_item_categories mic1 '

23601:
23602: --Duplicate records check for the records whose source is XML
23603: v_sql_stmt := 01;
23604: lv_sql_stmt :=
23605: 'UPDATE msc_st_item_categories mic1 '
23606: ||' SET process_flag = '||G_ERROR_FLG||','
23607: ||' error_text = '||''''||lv_message_text||''''
23608: ||' WHERE message_id < (SELECT MAX(message_id)'
23609: ||' FROM msc_st_item_categories mic2'

Line 23609: ||' FROM msc_st_item_categories mic2'

23605: 'UPDATE msc_st_item_categories mic1 '
23606: ||' SET process_flag = '||G_ERROR_FLG||','
23607: ||' error_text = '||''''||lv_message_text||''''
23608: ||' WHERE message_id < (SELECT MAX(message_id)'
23609: ||' FROM msc_st_item_categories mic2'
23610: ||' WHERE mic2.sr_instance_code = mic1.sr_instance_code'
23611: ||' AND mic2.organization_code = mic1.organization_code'
23612: ||' AND NVL(mic2.company_name, '||''''||NULL_CHAR||''''||') = '
23613: ||' NVL(mic1.company_name, '||''''||NULL_CHAR||''''||')'

Line 23646: 'UPDATE msc_st_item_categories mic1 '

23642: --whereas in batch load we cannot.
23643: /*
23644: v_sql_stmt := 02;
23645: lv_sql_stmt :=
23646: 'UPDATE msc_st_item_categories mic1 '
23647: ||' SET process_flag = '||G_ERROR_FLG||','
23648: ||' error_text = '||''''||lv_message_text||''''
23649: ||' WHERE EXISTS( SELECT 1 '
23650: ||' FROM msc_st_item_categories mic2'

Line 23650: ||' FROM msc_st_item_categories mic2'

23646: 'UPDATE msc_st_item_categories mic1 '
23647: ||' SET process_flag = '||G_ERROR_FLG||','
23648: ||' error_text = '||''''||lv_message_text||''''
23649: ||' WHERE EXISTS( SELECT 1 '
23650: ||' FROM msc_st_item_categories mic2'
23651: ||' WHERE mic2.sr_instance_code = mic1.sr_instance_code'
23652: ||' AND mic2.organization_code = mic1.organization_code'
23653: ||' AND NVL(mic2.company_name, '||''''||NULL_CHAR||''''||') = '
23654: ||' NVL(mic1.company_name, '||''''||NULL_CHAR||''''||')'

Line 23680: UPDATE msc_st_item_categories

23676: FETCH c_udk BULK COLLECT INTO lb_item, lb_cat, lb_cat_set, lb_org, lb_comp;
23677: CLOSE c_udk;
23678:
23679: FORALL j IN lb_item.FIRST..lb_item.LAST
23680: UPDATE msc_st_item_categories
23681: SET process_flag = G_ERROR_FLG, error_text = lv_message_text
23682: WHERE sr_instance_code = v_instance_code
23683: AND item_name = lb_item(j)
23684: AND category_name = lb_cat(j)

Line 23720: 'UPDATE msc_st_item_categories '

23716: FROM dual;
23717:
23718: v_sql_stmt := 04;
23719: lv_sql_stmt :=
23720: 'UPDATE msc_st_item_categories '
23721: ||' SET batch_id = :lv_batch_id'
23722: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
23723: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE
23724: ||' AND sr_instance_code = :v_instance_code'

Line 23741: UPDATE msc_st_item_categories

23737: CLOSE c1;
23738:
23739: v_sql_stmt := 05;
23740: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
23741: UPDATE msc_st_item_categories
23742: SET st_transaction_id = msc_st_item_categories_s.NEXTVAL,
23743: refresh_id = v_refresh_id,
23744: last_update_date = v_current_date,
23745: last_updated_by = v_current_user,

Line 23742: SET st_transaction_id = msc_st_item_categories_s.NEXTVAL,

23738:
23739: v_sql_stmt := 05;
23740: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
23741: UPDATE msc_st_item_categories
23742: SET st_transaction_id = msc_st_item_categories_s.NEXTVAL,
23743: refresh_id = v_refresh_id,
23744: last_update_date = v_current_date,
23745: last_updated_by = v_current_user,
23746: creation_date = v_current_date,

Line 23756: p_token_value1 => 'MSC_ST_ITEM_CATEGORIES');

23752: p_error_code => 'MSC_PP_NO_DELETION',
23753: p_message_text => lv_message_text,
23754: p_error_text => lv_error_text,
23755: p_token1 => 'TABLE_NAME',
23756: p_token_value1 => 'MSC_ST_ITEM_CATEGORIES');
23757:
23758: IF lv_return <> 0 THEN
23759: RAISE ex_logging_err;
23760: END IF;

Line 23765: 'UPDATE msc_st_item_categories '

23761:
23762: --Deletion is not allowed on this table.
23763: v_sql_stmt := 06;
23764: lv_sql_stmt :=
23765: 'UPDATE msc_st_item_categories '
23766: ||' SET process_flag = '||G_ERROR_FLG||','
23767: ||' error_text = '||''''||lv_message_text||''''
23768: ||' WHERE deleted_flag = '||SYS_YES
23769: ||' AND process_flag = '||G_IN_PROCESS

Line 23801: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',

23797:
23798: --Log a warning for those records where the deleted_flag has a value other
23799: --SYS_NO
23800: lv_return := MSC_ST_UTIL.LOG_ERROR
23801: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',
23802: p_instance_code => v_instance_code,
23803: p_row => lv_column_names,
23804: p_severity => G_SEV_WARNING,
23805: p_message_text => lv_message_text,

Line 23831: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',

23827: END IF;
23828:
23829: --Derive Organization_id
23830: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
23831: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',
23832: p_org_partner_name => 'ORGANIZATION_CODE',
23833: p_org_partner_id => 'ORGANIZATION_ID',
23834: p_instance_code => v_instance_code,
23835: p_partner_type => G_ORGANIZATION,

Line 23861: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',

23857: END IF;
23858:
23859: --Derive Inventory_item_id
23860: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
23861: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',
23862: p_item_col_name => 'ITEM_NAME',
23863: p_item_col_id => 'INVENTORY_ITEM_ID',
23864: p_instance_id => v_instance_id,
23865: p_instance_code => v_instance_code,

Line 23881: 'UPDATE msc_st_item_categories '

23877:
23878: --Derive sr_category_set_id
23879: v_sql_stmt := 07;
23880: lv_sql_stmt :=
23881: 'UPDATE msc_st_item_categories '
23882: ||' SET sr_category_set_id = (SELECT local_id'
23883: ||' FROM msc_local_id_misc'
23884: ||' WHERE char1 = sr_instance_code'
23885: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||') = '

Line 23915: 'UPDATE msc_st_item_categories '

23911: END IF;
23912:
23913: v_sql_stmt := 08;
23914: lv_sql_stmt :=
23915: 'UPDATE msc_st_item_categories '
23916: ||' SET process_flag = '||G_ERROR_FLG||','
23917: ||' error_text = '||''''||lv_message_text||''''
23918: ||' WHERE NVL(sr_category_set_id,'||NULL_VALUE||') = '||NULL_VALUE
23919: ||' AND process_flag = '||G_IN_PROCESS

Line 23933: 'UPDATE msc_st_item_categories '

23929:
23930: --Derive sr_category_id
23931: v_sql_stmt := 09;
23932: lv_sql_stmt :=
23933: 'UPDATE msc_st_item_categories '
23934: ||' SET sr_category_id = (SELECT local_id '
23935: ||' FROM msc_local_id_misc'
23936: ||' WHERE char1 = sr_instance_code'
23937: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||') = '

Line 23957: pEntityName => 'MSC_ST_ITEM_CATEGORIES',

23953: (ERRBUF => lv_error_text,
23954: RETCODE => lv_return,
23955: pBatchID => lv_batch_id,
23956: pInstanceCode => v_instance_code,
23957: pEntityName => 'MSC_ST_ITEM_CATEGORIES',
23958: pInstanceID => v_instance_id);
23959:
23960: IF NVL(lv_return,0) <> 0 THEN
23961: RAISE ex_logging_err;

Line 23971: UPDATE msc_st_item_categories

23967: IF c2%ROWCOUNT > 0 THEN
23968:
23969: v_sql_stmt := 10;
23970: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
23971: UPDATE msc_st_item_categories
23972: SET sr_category_id = msc_st_sr_category_id_s.NEXTVAL
23973: WHERE rowid = lb_rowid(j);
23974:
23975: v_sql_stmt := 11;

Line 24011: FROM msc_st_item_categories

24007: v_current_date,
24008: v_current_user,
24009: v_current_date,
24010: v_current_user
24011: FROM msc_st_item_categories
24012: WHERE rowid = lb_rowid(j);
24013:
24014: END IF;
24015: CLOSE c2 ;

Line 24020: 'UPDATE msc_st_item_categories '

24016:
24017: --Derive sr_category_id
24018: v_sql_stmt := 09;
24019: lv_sql_stmt :=
24020: 'UPDATE msc_st_item_categories '
24021: ||' SET sr_category_id = (SELECT local_id '
24022: ||' FROM msc_local_id_misc'
24023: ||' WHERE char1 = sr_instance_code'
24024: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||') = '

Line 24042: 'UPDATE msc_st_item_categories '

24038:
24039:
24040: v_sql_stmt := 12;
24041: lv_sql_stmt :=
24042: 'UPDATE msc_st_item_categories '
24043: ||' SET summary_flag = ''N'' '
24044: ||' WHERE process_flag = '||G_IN_PROCESS
24045: ||' AND batch_id = :lv_batch_id'
24046: ||' AND sr_instance_code = :v_instance_code';

Line 24055: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',

24051: USING lv_batch_id,
24052: v_instance_code;
24053:
24054: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
24055: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',
24056: p_instance_id => v_instance_id,
24057: p_instance_code => v_instance_code,
24058: p_process_flag => G_VALID,
24059: p_error_text => lv_error_text,

Line 24068: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',

24064: RAISE ex_logging_err;
24065: END IF;
24066:
24067: lv_return := MSC_ST_UTIL.LOG_ERROR
24068: (p_table_name => 'MSC_ST_ITEM_CATEGORIES',
24069: p_instance_code => v_instance_code,
24070: p_row => lv_column_names,
24071: p_severity => G_SEV_ERROR,
24072: p_message_text => NULL,

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

51084: End IF;
51085: END IF;
51086:
51087: IF v_item_cat_enabled = SYS_YES THEN
51088: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ITEM_CATEGORIES');
51089: IF lv_count > 0 Then
51090: prec.item_flag:= SYS_YES;
51091: End IF;
51092: END IF;