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_WORK_BREAKDOWN_STRUCT

Line 13364: FROM msc_st_work_breakdown_struct

13360: ex_logging_err EXCEPTION;
13361:
13362: CURSOR c1 IS
13363: SELECT rowid
13364: FROM msc_st_work_breakdown_struct
13365: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
13366: AND sr_instance_code = v_instance_code;
13367:
13368: BEGIN

Line 13381: --Validation check for the table msc_st_work_breakdown_struct

13377: IF lv_return <> 0 THEN
13378: RAISE ex_logging_err;
13379: END IF;
13380:
13381: --Validation check for the table msc_st_work_breakdown_struct
13382:
13383: --Duplicate records check for the records whose source is other than XML
13384: --Different SQL is used because in XML we can identify the latest records
13385: --whereas in batch load we cannot.

Line 13389: 'UPDATE msc_st_work_breakdown_struct mswbs1 '

13385: --whereas in batch load we cannot.
13386:
13387: v_sql_stmt := 01;
13388: lv_sql_stmt :=
13389: 'UPDATE msc_st_work_breakdown_struct mswbs1 '
13390: ||' SET process_flag = '||G_ERROR_FLG||','
13391: ||' error_text = '||''''||lv_message_text||''''
13392: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_work_breakdown_struct mswbs2 '
13393: ||' WHERE mswbs2.parameter_name = mswbs1.parameter_name'

Line 13392: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_work_breakdown_struct mswbs2 '

13388: lv_sql_stmt :=
13389: 'UPDATE msc_st_work_breakdown_struct mswbs1 '
13390: ||' SET process_flag = '||G_ERROR_FLG||','
13391: ||' error_text = '||''''||lv_message_text||''''
13392: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_work_breakdown_struct mswbs2 '
13393: ||' WHERE mswbs2.parameter_name = mswbs1.parameter_name'
13394: ||' AND mswbs2.organization_code = mswbs1.organization_code'
13395: ||' AND mswbs2.display_name = mswbs1.display_name'
13396: ||' AND mswbs2.sr_instance_code = mswbs1.sr_instance_code'

Line 13417: 'UPDATE msc_st_work_breakdown_struct mswbs1 '

13413:
13414: --Duplicate records check for the records whose source is XML
13415: v_sql_stmt := 02;
13416: lv_sql_stmt :=
13417: 'UPDATE msc_st_work_breakdown_struct mswbs1 '
13418: ||' SET process_flag = '||G_ERROR_FLG||','
13419: ||' error_text = '||''''||lv_message_text||''''
13420: ||' WHERE message_id < ( SELECT max(message_id) '
13421: ||' FROM msc_st_work_breakdown_struct mswbs2'

Line 13421: ||' FROM msc_st_work_breakdown_struct mswbs2'

13417: 'UPDATE msc_st_work_breakdown_struct mswbs1 '
13418: ||' SET process_flag = '||G_ERROR_FLG||','
13419: ||' error_text = '||''''||lv_message_text||''''
13420: ||' WHERE message_id < ( SELECT max(message_id) '
13421: ||' FROM msc_st_work_breakdown_struct mswbs2'
13422: ||' WHERE mswbs2.parameter_name = mswbs1.parameter_name'
13423: ||' AND mswbs2.display_name = mswbs1.display_name'
13424: ||' AND mswbs2.sr_instance_code = mswbs1.sr_instance_code'
13425: ||' AND mswbs2.process_flag = mswbs1.process_flag'

Line 13454: UPDATE msc_st_work_breakdown_struct

13450: FETCH c1 BULK COLLECT INTO lb_rowid;
13451: CLOSE c1;
13452:
13453: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
13454: UPDATE msc_st_work_breakdown_struct
13455: SET st_transaction_id = msc_st_work_breakdown_struct_s.nextval,
13456: refresh_id = v_refresh_id,
13457: last_update_date = v_current_date,
13458: last_updated_by = v_current_user,

Line 13455: SET st_transaction_id = msc_st_work_breakdown_struct_s.nextval,

13451: CLOSE c1;
13452:
13453: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
13454: UPDATE msc_st_work_breakdown_struct
13455: SET st_transaction_id = msc_st_work_breakdown_struct_s.nextval,
13456: refresh_id = v_refresh_id,
13457: last_update_date = v_current_date,
13458: last_updated_by = v_current_user,
13459: creation_date = v_current_date,

Line 13484: (p_table_name => 'MSC_ST_WORK_BREAKDOWN_STRUCT',

13480: ||' NOT IN(1,2)';
13481: --Log a warning for those records where the deleted_flag has a value other
13482: --than SYS_NO
13483: lv_return := MSC_ST_UTIL.LOG_ERROR
13484: (p_table_name => 'MSC_ST_WORK_BREAKDOWN_STRUCT',
13485: p_instance_code => v_instance_code,
13486: p_row => lv_column_names,
13487: p_severity => G_SEV_WARNING,
13488: p_message_text => lv_message_text,

Line 13515: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_WORK_BREAKDOWN_STRUCT',

13511:
13512: -- Populate organization id
13513:
13514: lv_return :=
13515: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_WORK_BREAKDOWN_STRUCT',
13516: p_org_partner_name => 'ORGANIZATION_CODE',
13517: p_org_partner_id => 'ORGANIZATION_ID',
13518: p_instance_code => v_instance_code,
13519: p_partner_type => G_ORGANIZATION,

Line 13536: pEntityName => 'MSC_ST_WORK_BREAKDOWN_STRUCT',

13532: (ERRBUF => lv_error_text,
13533: RETCODE => lv_return,
13534: pBatchID => NULL,
13535: pInstanceCode => v_instance_code,
13536: pEntityName => 'MSC_ST_WORK_BREAKDOWN_STRUCT',
13537: pInstanceID => v_instance_id);
13538:
13539: IF NVL(lv_return,0) <> 0 THEN
13540: RAISE ex_logging_err;

Line 13544: (p_table_name => 'MSC_ST_WORK_BREAKDOWN_STRUCT',

13540: RAISE ex_logging_err;
13541: END IF;
13542: -- Set the process flag as Valid and populate instance_id
13543: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
13544: (p_table_name => 'MSC_ST_WORK_BREAKDOWN_STRUCT',
13545: p_instance_id => v_instance_id,
13546: p_instance_code => v_instance_code,
13547: p_process_flag => G_VALID,
13548: p_error_text => lv_error_text,

Line 13559: (p_table_name => 'MSC_ST_WORK_BREAKDOWN_STRUCT',

13555: -- At the end calling the LOG_ERROR for logging all
13556: -- errored out records.
13557:
13558: lv_return := MSC_ST_UTIL.LOG_ERROR
13559: (p_table_name => 'MSC_ST_WORK_BREAKDOWN_STRUCT',
13560: p_instance_code => v_instance_code,
13561: p_row => lv_column_names,
13562: p_severity => G_SEV_ERROR,
13563: p_message_text => NULL,

Line 56089: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_WORK_BREAKDOWN_STRUCT', p_company_name_col => FALSE, p_erp_enabled => 'Y');

56085: IF lv_count > 0 Then
56086: prec.CMRO_flag:= SYS_YES;
56087: End IF;
56088:
56089: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_WORK_BREAKDOWN_STRUCT', p_company_name_col => FALSE, p_erp_enabled => 'Y');
56090: IF lv_count > 0 Then
56091: prec.CMRO_flag:= SYS_YES;
56092: End IF;
56093: