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_WO_MILESTONES

Line 13015: lv_batch_id msc_st_wo_milestones.batch_id%TYPE;

13011: lv_error_text VARCHAR2(250);
13012: lv_where_str VARCHAR2(5000);
13013: lv_sql_stmt VARCHAR2(5000);
13014: lv_column_names VARCHAR2(5000); --stores concatenated column names
13015: lv_batch_id msc_st_wo_milestones.batch_id%TYPE;
13016: lv_message_text msc_errors.error_text%TYPE;
13017:
13018: ex_logging_err EXCEPTION;
13019:

Line 13022: FROM msc_st_wo_milestones

13018: ex_logging_err EXCEPTION;
13019:
13020: CURSOR c1(p_batch_id NUMBER) IS
13021: SELECT rowid
13022: FROM msc_st_wo_milestones
13023: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
13024: AND batch_id = p_batch_id
13025: AND sr_instance_code = v_instance_code;
13026:

Line 13040: --Validation check for the table msc_st_wo_milestones

13036: IF lv_return <> 0 THEN
13037: RAISE ex_logging_err;
13038: END IF;
13039:
13040: --Validation check for the table msc_st_wo_milestones
13041:
13042: --Duplicate records check for the records whose source is other than XML
13043: --Different SQL is used because in XML we can identify the latest records
13044: --whereas in batch load we cannot.

Line 13048: 'UPDATE msc_st_wo_milestones mswm1 '

13044: --whereas in batch load we cannot.
13045:
13046: v_sql_stmt := 01;
13047: lv_sql_stmt :=
13048: 'UPDATE msc_st_wo_milestones mswm1 '
13049: ||' SET process_flag = '||G_ERROR_FLG||','
13050: ||' error_text = '||''''||lv_message_text||''''
13051: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_wo_milestones mswm2 '
13052: ||' WHERE mswm2.sr_instance_code = mswm1.sr_instance_code'

Line 13051: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_wo_milestones mswm2 '

13047: lv_sql_stmt :=
13048: 'UPDATE msc_st_wo_milestones mswm1 '
13049: ||' SET process_flag = '||G_ERROR_FLG||','
13050: ||' error_text = '||''''||lv_message_text||''''
13051: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_wo_milestones mswm2 '
13052: ||' WHERE mswm2.sr_instance_code = mswm1.sr_instance_code'
13053: ||' AND mswm2.visit_name = mswm1.visit_name'
13054: ||' AND mswm2.milestone = mswm1.milestone'
13055: ||' AND mswm2.process_flag = mswm1.process_flag'

Line 13075: 'UPDATE msc_st_wo_milestones mswm1 '

13071:
13072: --Duplicate records check for the records whose source is XML
13073: v_sql_stmt := 02;
13074: lv_sql_stmt :=
13075: 'UPDATE msc_st_wo_milestones mswm1 '
13076: ||' SET process_flag = '||G_ERROR_FLG||','
13077: ||' error_text = '||''''||lv_message_text||''''
13078: ||' WHERE message_id < ( SELECT max(message_id) '
13079: ||' FROM msc_st_wo_milestones mswm2'

Line 13079: ||' FROM msc_st_wo_milestones mswm2'

13075: 'UPDATE msc_st_wo_milestones mswm1 '
13076: ||' SET process_flag = '||G_ERROR_FLG||','
13077: ||' error_text = '||''''||lv_message_text||''''
13078: ||' WHERE message_id < ( SELECT max(message_id) '
13079: ||' FROM msc_st_wo_milestones mswm2'
13080: ||' WHERE mswm2.sr_instance_code = mswm1.sr_instance_code'
13081: ||' AND mswm2.visit_name = mswm1.visit_name'
13082: ||' AND mswm2.milestone = mswm1.milestone'
13083: ||' AND mswm2.process_flag = mswm1.process_flag'

Line 13114: 'UPDATE msc_st_wo_milestones '

13110: FROM dual;
13111:
13112: v_sql_stmt := 04;
13113: lv_sql_stmt :=
13114: 'UPDATE msc_st_wo_milestones '
13115: ||' SET batch_id = :lv_batch_id'
13116: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
13117: ||' AND sr_instance_code = :v_instance_code'
13118: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 13134: UPDATE msc_st_wo_milestones

13130: FETCH c1 BULK COLLECT INTO lb_rowid;
13131: CLOSE c1;
13132:
13133: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
13134: UPDATE msc_st_wo_milestones
13135: SET st_transaction_id = msc_st_wo_milestone_s.nextval,
13136: refresh_id = v_refresh_id,
13137: last_update_date = v_current_date,
13138: last_updated_by = v_current_user,

Line 13164: (p_table_name => 'MSC_ST_WO_MILESTONES',

13160: ||' NOT IN(1,2)';
13161: --Log a warning for those records where the deleted_flag has a value other
13162: --than SYS_NO
13163: lv_return := MSC_ST_UTIL.LOG_ERROR
13164: (p_table_name => 'MSC_ST_WO_MILESTONES',
13165: p_instance_code => v_instance_code,
13166: p_row => lv_column_names,
13167: p_severity => G_SEV_WARNING,
13168: p_message_text => lv_message_text,

Line 13196: 'UPDATE msc_st_wo_milestones'

13192:
13193: -- Error out records where milestone or visit_name is NULL
13194: v_sql_stmt := 06;
13195: lv_sql_stmt :=
13196: 'UPDATE msc_st_wo_milestones'
13197: ||' SET process_flag = '||G_ERROR_FLG||','
13198: ||' error_text = '||''''||lv_message_text||''''
13199: ||' WHERE ( VISIT_NAME IS NULL'
13200: ||' OR MILESTONE IS NULL)'

Line 13229: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_WO_MILESTONES',

13225:
13226: -- Populate organization id
13227:
13228: lv_return :=
13229: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_WO_MILESTONES',
13230: p_org_partner_name => 'ORGANIZATION_CODE',
13231: p_org_partner_id => 'ORGANIZATION_ID',
13232: p_instance_code => v_instance_code,
13233: p_partner_type => G_ORGANIZATION,

Line 13248: 'UPDATE msc_st_wo_milestones msv'

13244:
13245: --Deriving visit_id
13246: v_sql_stmt := 07;
13247: lv_sql_stmt :=
13248: 'UPDATE msc_st_wo_milestones msv'
13249: ||' SET visit_id = (SELECT local_id'
13250: ||' FROM msc_local_id_setup mls'
13251: ||' WHERE mls.char1 = msv.sr_instance_code'
13252: ||' AND mls.char4 = msv.visit_name'

Line 13277: 'UPDATE msc_st_wo_milestones '

13273:
13274: -- Validate the visit name with data in msc_local_id_setup
13275: v_sql_stmt := 08;
13276: lv_sql_stmt :=
13277: 'UPDATE msc_st_wo_milestones '
13278: ||' SET process_flag = '||G_ERROR_FLG||','
13279: ||' error_text = '||''''||lv_message_text||''''
13280: ||' WHERE VISIT_ID IS NULL'
13281: ||' AND process_flag = '||G_IN_PROCESS

Line 13299: pEntityName => 'MSC_ST_WO_MILESTONES',

13295: (ERRBUF => lv_error_text,
13296: RETCODE => lv_return,
13297: pBatchID => NULL,
13298: pInstanceCode => v_instance_code,
13299: pEntityName => 'MSC_ST_WO_MILESTONES',
13300: pInstanceID => v_instance_id);
13301:
13302: IF NVL(lv_return,0) <> 0 THEN
13303: RAISE ex_logging_err;

Line 13307: (p_table_name => 'MSC_ST_WO_MILESTONES',

13303: RAISE ex_logging_err;
13304: END IF;
13305: -- Set the process flag as Valid and populate instance_id
13306: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
13307: (p_table_name => 'MSC_ST_WO_MILESTONES',
13308: p_instance_id => v_instance_id,
13309: p_instance_code => v_instance_code,
13310: p_process_flag => G_VALID,
13311: p_error_text => lv_error_text,

Line 13322: (p_table_name => 'MSC_ST_WO_MILESTONES',

13318: -- At the end calling the LOG_ERROR for logging all
13319: -- errored out records.
13320:
13321: lv_return := MSC_ST_UTIL.LOG_ERROR
13322: (p_table_name => 'MSC_ST_WO_MILESTONES',
13323: p_instance_code => v_instance_code,
13324: p_row => lv_column_names,
13325: p_severity => G_SEV_ERROR,
13326: p_message_text => NULL,

Line 13990: ||' SELECT 1 FROM msc_st_wo_milestones mswm'

13986: ||' NVL(mswa.prev_milestone,'||''''||NULL_CHAR||''''||')'
13987: ||' AND mwm.organization_id = mswa.organization_id'
13988: ||' AND mwm.visit_id = mswa.visit_id'
13989: ||' UNION '
13990: ||' SELECT 1 FROM msc_st_wo_milestones mswm'
13991: ||' WHERE NVL(mswm.milestone, '||''''||NULL_CHAR||''''||') = '
13992: ||' NVL(mswa.prev_milestone,'||''''||NULL_CHAR||''''||')'
13993: ||' AND mswm.organization_id = mswa.organization_id'
13994: ||' AND mswm.visit_id = mswa.visit_id'

Line 14055: ||' SELECT 1 FROM msc_st_wo_milestones mswm'

14051: ||' NVL(mswa.next_milestone,'||''''||NULL_CHAR||''''||')'
14052: ||' AND mwm.organization_id = mswa.organization_id'
14053: ||' AND mwm.visit_id = mswa.visit_id'
14054: ||' UNION '
14055: ||' SELECT 1 FROM msc_st_wo_milestones mswm'
14056: ||' WHERE NVL(mswm.milestone, '||''''||NULL_CHAR||''''||') = '
14057: ||' NVL(mswa.next_milestone,'||''''||NULL_CHAR||''''||')'
14058: ||' AND mswm.organization_id = mswa.organization_id'
14059: ||' AND mswm.visit_id = mswa.visit_id'

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

56075: IF lv_count > 0 Then
56076: prec.CMRO_flag:= SYS_YES;
56077: End IF;
56078:
56079: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_WO_MILESTONES', p_company_name_col => FALSE, p_erp_enabled => 'Y');
56080: IF lv_count > 0 Then
56081: prec.CMRO_flag:= SYS_YES;
56082: End IF;
56083: