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_CATEGORY_SETS

Line 15721: | DESCRIPTION : This procedure validates the data in MSC_ST_CATEGORY_SETS |

15717: END LOAD_REGIONS;
15718:
15719:
15720: /*==========================================================================+
15721: | DESCRIPTION : This procedure validates the data in MSC_ST_CATEGORY_SETS |
15722: | table. |
15723: +==========================================================================*/
15724: PROCEDURE LOAD_CATEGORY_SET IS
15725: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;

Line 15732: lv_batch_id msc_st_category_sets.batch_id%TYPE;

15728: lv_error_text VARCHAR2(250);
15729: lv_where_str VARCHAR2(5000);
15730: lv_sql_stmt VARCHAR2(5000);
15731: lv_column_names VARCHAR2(5000); --stores concatenated column names
15732: lv_batch_id msc_st_category_sets.batch_id%TYPE;
15733: lv_message_text msc_errors.error_text%TYPE;
15734: ex_logging_err EXCEPTION;
15735:
15736: CURSOR c1(p_batch_id NUMBER) IS

Line 15738: FROM msc_st_category_sets

15734: ex_logging_err EXCEPTION;
15735:
15736: CURSOR c1(p_batch_id NUMBER) IS
15737: SELECT rowid
15738: FROM msc_st_category_sets
15739: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
15740: AND batch_id = p_batch_id
15741: AND sr_instance_code = v_instance_code;
15742:

Line 15745: FROM msc_st_category_sets

15741: AND sr_instance_code = v_instance_code;
15742:
15743: CURSOR c2(p_batch_id NUMBER) IS
15744: SELECT rowid
15745: FROM msc_st_category_sets
15746: WHERE NVL(sr_category_set_id,NULL_VALUE) = NULL_VALUE
15747: AND process_flag = G_IN_PROCESS
15748: AND batch_id = p_batch_id
15749: AND sr_instance_code = v_instance_code;

Line 15767: 'UPDATE msc_st_category_sets mcs1 '

15763:
15764: --Duplicate records check for the records whose source is XML
15765: v_sql_stmt := 01;
15766: lv_sql_stmt :=
15767: 'UPDATE msc_st_category_sets mcs1 '
15768: ||' SET process_flag = '||G_ERROR_FLG||','
15769: ||' error_text = '||''''||lv_message_text||''''
15770: ||' WHERE message_id < (SELECT MAX(message_id)'
15771: ||' FROM msc_st_category_sets mcs2'

Line 15771: ||' FROM msc_st_category_sets mcs2'

15767: 'UPDATE msc_st_category_sets mcs1 '
15768: ||' SET process_flag = '||G_ERROR_FLG||','
15769: ||' error_text = '||''''||lv_message_text||''''
15770: ||' WHERE message_id < (SELECT MAX(message_id)'
15771: ||' FROM msc_st_category_sets mcs2'
15772: ||' WHERE mcs2.sr_instance_code = mcs1.sr_instance_code'
15773: ||' AND NVL(mcs2.company_name, '||''''||NULL_CHAR||''''||') = '
15774: ||' NVL(mcs1.company_name, '||''''||NULL_CHAR||''''||')'
15775: ||' AND mcs2.category_set_name = mcs1.category_set_name'

Line 15804: 'UPDATE msc_st_category_sets mcs1'

15800: --Different SQL is used because in XML we can identify the latest records
15801: --whereas in batch load we cannot.
15802: v_sql_stmt := 02;
15803: lv_sql_stmt :=
15804: 'UPDATE msc_st_category_sets mcs1'
15805: ||' SET process_flag = '||G_ERROR_FLG||','
15806: ||' error_text = '||''''||lv_message_text||''''
15807: ||' WHERE EXISTS( SELECT 1 '
15808: ||' FROM msc_st_category_sets mcs2'

Line 15808: ||' FROM msc_st_category_sets mcs2'

15804: 'UPDATE msc_st_category_sets mcs1'
15805: ||' SET process_flag = '||G_ERROR_FLG||','
15806: ||' error_text = '||''''||lv_message_text||''''
15807: ||' WHERE EXISTS( SELECT 1 '
15808: ||' FROM msc_st_category_sets mcs2'
15809: ||' WHERE mcs2.sr_instance_code = mcs1.sr_instance_code'
15810: ||' AND NVL(mcs2.company_name, '||''''||NULL_CHAR||''''||') = '
15811: ||' NVL(mcs1.company_name, '||''''||NULL_CHAR||''''||')'
15812: ||' AND mcs2.category_set_name = mcs1.category_set_name'

Line 15844: ' UPDATE msc_st_category_sets '

15840: FROM dual;
15841:
15842: v_sql_stmt := 04;
15843: lv_sql_stmt :=
15844: ' UPDATE msc_st_category_sets '
15845: ||' SET batch_id = :lv_batch_id'
15846: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
15847: ||' AND sr_instance_code = :v_instance_code'
15848: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 15866: UPDATE msc_st_category_sets

15862: CLOSE c1;
15863:
15864: v_sql_stmt := 05;
15865: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
15866: UPDATE msc_st_category_sets
15867: SET st_transaction_id = msc_st_category_sets_s.NEXTVAL,
15868: refresh_id = v_refresh_id,
15869: last_update_date = v_current_date,
15870: last_updated_by = v_current_user,

Line 15867: SET st_transaction_id = msc_st_category_sets_s.NEXTVAL,

15863:
15864: v_sql_stmt := 05;
15865: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
15866: UPDATE msc_st_category_sets
15867: SET st_transaction_id = msc_st_category_sets_s.NEXTVAL,
15868: refresh_id = v_refresh_id,
15869: last_update_date = v_current_date,
15870: last_updated_by = v_current_user,
15871: creation_date = v_current_date,

Line 15881: p_token_value1 => 'MSC_ST_CATEGORY_SETS');

15877: p_error_code => 'MSC_PP_NO_DELETION',
15878: p_message_text => lv_message_text,
15879: p_error_text => lv_error_text,
15880: p_token1 => 'TABLE_NAME',
15881: p_token_value1 => 'MSC_ST_CATEGORY_SETS');
15882:
15883: IF lv_return <> 0 THEN
15884: RAISE ex_logging_err;
15885: END IF;

Line 15890: ' UPDATE msc_st_category_sets '

15886:
15887: --Deletion is not allowed for this entity.
15888: v_sql_stmt := 06;
15889: lv_sql_stmt :=
15890: ' UPDATE msc_st_category_sets '
15891: ||' SET process_flag = '||G_ERROR_FLG||','
15892: ||' error_text = '||''''||lv_message_text||''''
15893: ||' WHERE deleted_flag = '||SYS_YES
15894: ||' AND process_flag = '||G_IN_PROCESS

Line 15926: (p_table_name => 'MSC_ST_CATEGORY_SETS',

15922:
15923: --Logging a warning for those records where the deleted_flag value
15924: --is other than Yes/No.
15925: lv_return := MSC_ST_UTIL.LOG_ERROR
15926: (p_table_name => 'MSC_ST_CATEGORY_SETS',
15927: p_instance_code => v_instance_code,
15928: p_row => lv_column_names,
15929: p_severity => G_SEV_WARNING,
15930: p_message_text => lv_message_text,

Line 15956: ' UPDATE msc_st_category_sets '

15952: END IF;
15953:
15954: v_sql_stmt := 07;
15955: lv_sql_stmt :=
15956: ' UPDATE msc_st_category_sets '
15957: ||' SET process_flag = '||G_ERROR_FLG||','
15958: ||' error_text = '||''''||lv_message_text||''''
15959: ||' WHERE NVL(category_set_name,'||''''||NULL_CHAR||''''||')'
15960: ||' = '||''''||NULL_CHAR||''''

Line 15986: ' UPDATE msc_st_category_sets '

15982: END IF;
15983:
15984: v_sql_stmt := 08;
15985: lv_sql_stmt :=
15986: ' UPDATE msc_st_category_sets '
15987: ||' SET process_flag = '||G_ERROR_FLG||','
15988: ||' error_text = '||''''||lv_message_text||''''
15989: ||' WHERE (NVL(control_level,'||NULL_VALUE||') NOT IN(1,2)'
15990: ||' OR NVL(default_flag,' ||NULL_VALUE||') NOT IN(1,2))'

Line 16016: 'UPDATE msc_st_category_sets mcs1'

16012: --There can be only one record in the staging/ODS with the
16013: --default_flag = 'YES'
16014: v_sql_stmt := 09;
16015: lv_sql_stmt :=
16016: 'UPDATE msc_st_category_sets mcs1'
16017: ||' SET process_flag = '||G_ERROR_FLG||','
16018: ||' error_text = '||''''||lv_message_text||''''
16019: ||' WHERE EXISTS( SELECT 1 '
16020: ||' FROM msc_st_category_sets mcs2'

Line 16020: ||' FROM msc_st_category_sets mcs2'

16016: 'UPDATE msc_st_category_sets mcs1'
16017: ||' SET process_flag = '||G_ERROR_FLG||','
16018: ||' error_text = '||''''||lv_message_text||''''
16019: ||' WHERE EXISTS( SELECT 1 '
16020: ||' FROM msc_st_category_sets mcs2'
16021: ||' WHERE mcs2.sr_instance_code = mcs1.sr_instance_code'
16022: ||' AND mcs2.process_flag IN(2,5)'
16023: ||' AND mcs2.default_flag = '||SYS_YES
16024: ||' GROUP BY sr_instance_code'

Line 16049: ' UPDATE msc_st_category_sets'

16045:
16046: --Derive sr_category_set_id.
16047: v_sql_stmt := 10;
16048: lv_sql_stmt :=
16049: ' UPDATE msc_st_category_sets'
16050: ||' SET sr_category_set_id = (SELECT local_id'
16051: ||' FROM msc_local_id_misc'
16052: ||' WHERE char1 = sr_instance_code'
16053: ||' AND NVL(char2, '||''''||NULL_CHAR||''''||')='

Line 16073: pEntityName => 'MSC_ST_CATEGORY_SETS',

16069: (ERRBUF => lv_error_text,
16070: RETCODE => lv_return,
16071: pBatchID => lv_batch_id,
16072: pInstanceCode => v_instance_code,
16073: pEntityName => 'MSC_ST_CATEGORY_SETS',
16074: pInstanceID => v_instance_id);
16075:
16076: IF NVL(lv_return,0) <> 0 THEN
16077: RAISE ex_logging_err;

Line 16086: UPDATE msc_st_category_sets

16082:
16083: IF c2%ROWCOUNT > 0 THEN
16084: v_sql_stmt := 11;
16085: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
16086: UPDATE msc_st_category_sets
16087: SET sr_category_set_id = msc_st_sr_category_set_id_s.NEXTVAL
16088: WHERE rowid = lb_rowid(j);
16089:
16090: v_sql_stmt := 12;

Line 16120: FROM msc_st_category_sets

16116: v_current_date,
16117: v_current_user,
16118: v_current_date,
16119: v_current_user
16120: FROM msc_st_category_sets
16121: WHERE rowid = lb_rowid(j);
16122:
16123: END IF;
16124: CLOSE c2 ;

Line 16127: (p_table_name => 'MSC_ST_CATEGORY_SETS',

16123: END IF;
16124: CLOSE c2 ;
16125:
16126: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
16127: (p_table_name => 'MSC_ST_CATEGORY_SETS',
16128: p_instance_id => v_instance_id,
16129: p_instance_code => v_instance_code,
16130: p_process_flag => G_VALID,
16131: p_error_text => lv_error_text,

Line 16140: (p_table_name => 'MSC_ST_CATEGORY_SETS',

16136: RAISE ex_logging_err;
16137: END IF;
16138:
16139: lv_return := MSC_ST_UTIL.LOG_ERROR
16140: (p_table_name => 'MSC_ST_CATEGORY_SETS',
16141: p_instance_code => v_instance_code,
16142: p_row => lv_column_names,
16143: p_severity => G_SEV_ERROR,
16144: p_message_text => NULL,

Line 24153: lv_default_category_set msc_st_category_sets.category_set_name%TYPE := NULL_CHAR ;

24149: lv_default_sourcing_rule msc_st_item_sourcing.sourcing_rule_name%TYPE
24150: := v_instance_code||':'||'SRULE' ;
24151: lv_default_assignment_set msc_st_item_sourcing.sourcing_rule_name%TYPE
24152: := 'ASET' ;
24153: lv_default_category_set msc_st_category_sets.category_set_name%TYPE := NULL_CHAR ;
24154: lv_batch_id msc_st_item_sourcing.batch_id%TYPE;
24155: lv_message_text msc_errors.error_text%TYPE;
24156:
24157: ex_logging_err EXCEPTION;

Line 24383: ||' FROM msc_st_category_sets '

24379:
24380: lv_sql_stmt := 13;
24381: lv_sql_stmt :=
24382: 'SELECT category_set_name '
24383: ||' FROM msc_st_category_sets '
24384: ||' WHERE sr_instance_id = :v_instance_id'
24385: ||' AND default_flag = 1'
24386: ||' AND deleted_flag = '||SYS_NO
24387: ||' AND process_flag ='|| G_VALID ;

Line 51081: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CATEGORY_SETS');

51077: End IF;
51078: END IF;
51079:
51080: IF v_ctg_enabled = SYS_YES THEN
51081: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CATEGORY_SETS');
51082: IF lv_count > 0 Then
51083: prec.item_flag:= SYS_YES;
51084: End IF;
51085: END IF;