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_SR_LOOKUPS

Line 12081: FROM msc_st_sr_lookups

12077: ex_logging_err EXCEPTION;
12078:
12079: CURSOR c1 IS
12080: SELECT rowid
12081: FROM msc_st_sr_lookups
12082: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
12083: AND sr_instance_code = v_instance_code;
12084:
12085: BEGIN

Line 12097: --Validation check for the table msc_st_sr_lookups

12093: IF lv_return <> 0 THEN
12094: RAISE ex_logging_err;
12095: END IF;
12096:
12097: --Validation check for the table msc_st_sr_lookups
12098:
12099: --Duplicate records check for the records whose source is other than XML
12100: --Different SQL is used because in XML we can identify the latest records
12101: --whereas in batch load we cannot.

Line 12105: 'UPDATE msc_st_sr_lookups mssc1 '

12101: --whereas in batch load we cannot.
12102:
12103: v_sql_stmt := 01;
12104: lv_sql_stmt :=
12105: 'UPDATE msc_st_sr_lookups mssc1 '
12106: ||' SET process_flag = '||G_ERROR_FLG||','
12107: ||' error_text = '||''''||lv_message_text||''''
12108: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_sr_lookups mssc2 '
12109: ||' WHERE mssc2.sr_instance_code = mssc1.sr_instance_code'

Line 12108: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_sr_lookups mssc2 '

12104: lv_sql_stmt :=
12105: 'UPDATE msc_st_sr_lookups mssc1 '
12106: ||' SET process_flag = '||G_ERROR_FLG||','
12107: ||' error_text = '||''''||lv_message_text||''''
12108: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_sr_lookups mssc2 '
12109: ||' WHERE mssc2.sr_instance_code = mssc1.sr_instance_code'
12110: ||' AND mssc2.lookup_code = mssc1.lookup_code'
12111: ||' AND NVL(mssc2.company_name, '||''''||NULL_CHAR||''''||') = '
12112: ||' NVL(mssc1.company_name, '||''''||NULL_CHAR||''''||')'

Line 12133: 'UPDATE msc_st_sr_lookups mssc1 '

12129:
12130: --Duplicate records check for the records whose source is XML
12131: v_sql_stmt := 02;
12132: lv_sql_stmt :=
12133: 'UPDATE msc_st_sr_lookups mssc1 '
12134: ||' SET process_flag = '||G_ERROR_FLG||','
12135: ||' error_text = '||''''||lv_message_text||''''
12136: ||' WHERE message_id < ( SELECT max(message_id) '
12137: ||' FROM msc_st_sr_lookups mssc2'

Line 12137: ||' FROM msc_st_sr_lookups mssc2'

12133: 'UPDATE msc_st_sr_lookups mssc1 '
12134: ||' SET process_flag = '||G_ERROR_FLG||','
12135: ||' error_text = '||''''||lv_message_text||''''
12136: ||' WHERE message_id < ( SELECT max(message_id) '
12137: ||' FROM msc_st_sr_lookups mssc2'
12138: ||' WHERE mssc2.sr_instance_code = mssc1.sr_instance_code'
12139: ||' AND mssc2.lookup_code = mssc1.lookup_code'
12140: ||' AND NVL(mssc2.company_name, '||''''||NULL_CHAR||''''||') = '
12141: ||' NVL(mssc1.company_name, '||''''||NULL_CHAR||''''||')'

Line 12175: UPDATE msc_st_sr_lookups

12171: FETCH c1 BULK COLLECT INTO lb_rowid;
12172: CLOSE c1;
12173:
12174: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
12175: UPDATE msc_st_sr_lookups
12176: SET st_transaction_id = MSC_ST_SALES_CHANNEL_S.nextval,
12177: refresh_id = v_refresh_id,
12178: last_update_date = v_current_date,
12179: last_updated_by = v_current_user,

Line 12192: p_token_value1 => 'MSC_ST_SR_LOOKUPS');

12188: p_error_code => 'MSC_PP_NO_DELETION',
12189: p_message_text => lv_message_text,
12190: p_error_text => lv_error_text,
12191: p_token1 => 'TABLE_NAME',
12192: p_token_value1 => 'MSC_ST_SR_LOOKUPS');
12193:
12194: -- Deletion is not allowed for this table
12195: v_sql_stmt := 05;
12196: lv_sql_stmt :=

Line 12197: 'UPDATE msc_st_sr_lookups '

12193:
12194: -- Deletion is not allowed for this table
12195: v_sql_stmt := 05;
12196: lv_sql_stmt :=
12197: 'UPDATE msc_st_sr_lookups '
12198: ||' SET process_flag = '||G_ERROR_FLG||','
12199: ||' error_text = '||''''||lv_message_text||''''
12200: ||' WHERE deleted_flag = '||SYS_YES
12201: ||' AND process_flag = '||G_IN_PROCESS

Line 12227: 'UPDATE msc_st_sr_lookups'

12223: -- Error out records where sales_channel or meaning is NULL
12224:
12225: v_sql_stmt := 06;
12226: lv_sql_stmt :=
12227: 'UPDATE msc_st_sr_lookups'
12228: ||' SET process_flag = '||G_ERROR_FLG||','
12229: ||' error_text = '||''''||lv_message_text||''''
12230: ||' WHERE (NVL(lookup_code,NULL) IS NULL '
12231: ||' OR NVL(meaning,NULL) IS NULL) '

Line 12248: p_token_value1 => 'MSC_ST_SR_LOOKUPS');

12244: p_error_code => 'MSC_PP_NO_UPDATION',
12245: p_message_text => lv_message_text,
12246: p_error_text => lv_error_text,
12247: p_token1 => 'TABLE_NAME',
12248: p_token_value1 => 'MSC_ST_SR_LOOKUPS');
12249:
12250:
12251: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
12252: (p_app_short_name => 'MSC',

Line 12272: (p_table_name => 'MSC_ST_SR_LOOKUPS',

12268: lv_where_str := ' AND NVL(enabled_flag,'||NULL_VALUE||') '
12269: ||' NOT IN(1,2)';
12270:
12271: lv_return := MSC_ST_UTIL.LOG_ERROR
12272: (p_table_name => 'MSC_ST_SR_LOOKUPS',
12273: p_instance_code => v_instance_code,
12274: p_row => lv_column_names,
12275: p_severity => G_SEV_WARNING,
12276: p_message_text => lv_message_text,

Line 12305: 'UPDATE msc_st_sr_lookups'

12301: -- Validate that from_date is greater than to_date
12302:
12303: v_sql_stmt := 07;
12304: lv_sql_stmt :=
12305: 'UPDATE msc_st_sr_lookups'
12306: ||' SET process_flag = '||G_ERROR_FLG||','
12307: ||' error_text = '||''''||lv_message_text||''''
12308: ||' WHERE NVL(from_date,SYSDATE-365000 ) '
12309: ||' > NVL(to_date, SYSDATE+365000) '

Line 12325: pEntityName => 'MSC_ST_SR_LOOKUPS',

12321: (ERRBUF => lv_error_text,
12322: RETCODE => lv_return,
12323: pBatchID => NULL,
12324: pInstanceCode => v_instance_code,
12325: pEntityName => 'MSC_ST_SR_LOOKUPS',
12326: pInstanceID => v_instance_id);
12327:
12328: IF NVL(lv_return,0) <> 0 THEN
12329: RAISE ex_logging_err;

Line 12333: (p_table_name => 'MSC_ST_SR_LOOKUPS',

12329: RAISE ex_logging_err;
12330: END IF;
12331: -- Set the process flag as Valid and populate instance_id
12332: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
12333: (p_table_name => 'MSC_ST_SR_LOOKUPS',
12334: p_instance_id => v_instance_id,
12335: p_instance_code => v_instance_code,
12336: p_process_flag => G_VALID,
12337: p_error_text => lv_error_text,

Line 12348: (p_table_name => 'MSC_ST_SR_LOOKUPS',

12344: -- At the end calling the LOG_ERROR for logging all
12345: -- errored out records.
12346:
12347: lv_return := MSC_ST_UTIL.LOG_ERROR
12348: (p_table_name => 'MSC_ST_SR_LOOKUPS',
12349: p_instance_code => v_instance_code,
12350: p_row => lv_column_names,
12351: p_severity => G_SEV_ERROR,
12352: p_message_text => NULL,

Line 56060: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SR_LOOKUPS');

56056: End IF;
56057: END IF;
56058:
56059: IF v_sales_channel_enabled = SYS_YES THEN
56060: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SR_LOOKUPS');
56061: IF lv_count > 0 Then
56062: prec.sales_channel_flag:= SYS_YES;
56063: End IF;
56064: END IF;