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_OPERATION_REL

Line 14770: lv_batch_id msc_st_wo_operation_rel.batch_id%TYPE;

14766: lv_error_text VARCHAR2(250);
14767: lv_where_str VARCHAR2(5000);
14768: lv_sql_stmt VARCHAR2(5000);
14769: lv_column_names VARCHAR2(5000); --stores concatenated column names
14770: lv_batch_id msc_st_wo_operation_rel.batch_id%TYPE;
14771: lv_message_text msc_errors.error_text%TYPE;
14772:
14773: ex_logging_err EXCEPTION;
14774:

Line 14777: FROM msc_st_wo_operation_rel

14773: ex_logging_err EXCEPTION;
14774:
14775: CURSOR c1(p_batch_id NUMBER) IS
14776: SELECT rowid
14777: FROM msc_st_wo_operation_rel
14778: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
14779: AND batch_id = p_batch_id
14780: AND sr_instance_code = v_instance_code;
14781:

Line 14795: --Validation check for the table msc_st_wo_operation_rel

14791: IF lv_return <> 0 THEN
14792: RAISE ex_logging_err;
14793: END IF;
14794:
14795: --Validation check for the table msc_st_wo_operation_rel
14796:
14797: --Duplicate records check for the records whose source is other than XML
14798: --Different SQL is used because in XML we can identify the latest records
14799: --whereas in batch load we cannot.

Line 14803: 'UPDATE msc_st_wo_operation_rel mswor1 '

14799: --whereas in batch load we cannot.
14800:
14801: v_sql_stmt := 01;
14802: lv_sql_stmt :=
14803: 'UPDATE msc_st_wo_operation_rel mswor1 '
14804: ||' SET process_flag = '||G_ERROR_FLG||','
14805: ||' error_text = '||''''||lv_message_text||''''
14806: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_wo_operation_rel mswor2 '
14807: ||' WHERE mswor2.sr_instance_code = mswor1.sr_instance_code'

Line 14806: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_wo_operation_rel mswor2 '

14802: lv_sql_stmt :=
14803: 'UPDATE msc_st_wo_operation_rel mswor1 '
14804: ||' SET process_flag = '||G_ERROR_FLG||','
14805: ||' error_text = '||''''||lv_message_text||''''
14806: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_wo_operation_rel mswor2 '
14807: ||' WHERE mswor2.sr_instance_code = mswor1.sr_instance_code'
14808: ||' AND mswor2.organization_code = mswor1.organization_code'
14809: ||' AND mswor2.wip_entity_code = mswor1.wip_entity_code'
14810: ||' AND mswor2.from_op_seq_num = mswor1.from_op_seq_num'

Line 14834: 'UPDATE msc_st_wo_operation_rel mswor1 '

14830:
14831: --Duplicate records check for the records whose source is XML
14832: v_sql_stmt := 02;
14833: lv_sql_stmt :=
14834: 'UPDATE msc_st_wo_operation_rel mswor1 '
14835: ||' SET process_flag = '||G_ERROR_FLG||','
14836: ||' error_text = '||''''||lv_message_text||''''
14837: ||' WHERE message_id < ( SELECT max(message_id) '
14838: ||' FROM msc_st_wo_operation_rel mswor2'

Line 14838: ||' FROM msc_st_wo_operation_rel mswor2'

14834: 'UPDATE msc_st_wo_operation_rel mswor1 '
14835: ||' SET process_flag = '||G_ERROR_FLG||','
14836: ||' error_text = '||''''||lv_message_text||''''
14837: ||' WHERE message_id < ( SELECT max(message_id) '
14838: ||' FROM msc_st_wo_operation_rel mswor2'
14839: ||' WHERE mswor2.sr_instance_code = mswor1.sr_instance_code'
14840: ||' AND mswor2.wip_entity_code = mswor1.wip_entity_code'
14841: ||' AND mswor2.from_op_seq_num = mswor1.from_op_seq_num'
14842: ||' AND mswor2.from_op_res_seq_num = mswor1.from_op_res_seq_num'

Line 14885: 'UPDATE msc_st_wo_operation_rel '

14881: FROM dual;
14882:
14883: v_sql_stmt := 04;
14884: lv_sql_stmt :=
14885: 'UPDATE msc_st_wo_operation_rel '
14886: ||' SET batch_id = :lv_batch_id'
14887: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
14888: ||' AND sr_instance_code = :v_instance_code'
14889: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 14905: UPDATE msc_st_wo_operation_rel

14901: FETCH c1 BULK COLLECT INTO lb_rowid;
14902: CLOSE c1;
14903:
14904: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
14905: UPDATE msc_st_wo_operation_rel
14906: SET st_transaction_id = msc_st_wo_operation_rel_s.nextval,
14907: refresh_id = v_refresh_id,
14908: last_update_date = v_current_date,
14909: last_updated_by = v_current_user,

Line 14906: SET st_transaction_id = msc_st_wo_operation_rel_s.nextval,

14902: CLOSE c1;
14903:
14904: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
14905: UPDATE msc_st_wo_operation_rel
14906: SET st_transaction_id = msc_st_wo_operation_rel_s.nextval,
14907: refresh_id = v_refresh_id,
14908: last_update_date = v_current_date,
14909: last_updated_by = v_current_user,
14910: creation_date = v_current_date,

Line 14935: (p_table_name => 'MSC_ST_WO_OPERATION_REL',

14931: ||' NOT IN(1,2)';
14932: --Log a warning for those records where the deleted_flag has a value other
14933: --than SYS_NO
14934: lv_return := MSC_ST_UTIL.LOG_ERROR
14935: (p_table_name => 'MSC_ST_WO_OPERATION_REL',
14936: p_instance_code => v_instance_code,
14937: p_row => lv_column_names,
14938: p_severity => G_SEV_WARNING,
14939: p_message_text => lv_message_text,

Line 14966: 'UPDATE msc_st_wo_operation_rel'

14962:
14963: -- Error out records where wip_entity_code is NULL
14964: v_sql_stmt := 06;
14965: lv_sql_stmt :=
14966: 'UPDATE msc_st_wo_operation_rel'
14967: ||' SET process_flag = '||G_ERROR_FLG||','
14968: ||' error_text = '||''''||lv_message_text||''''
14969: ||' WHERE ( WIP_ENTITY_CODE IS NULL )'
14970: ||' AND process_flag = '||G_IN_PROCESS

Line 14999: 'UPDATE msc_st_wo_operation_rel'

14995: -- validate time unit
14996:
14997: v_sql_stmt := 07;
14998: lv_sql_stmt :=
14999: 'UPDATE msc_st_wo_operation_rel'
15000: ||' SET process_flag = '||G_ERROR_FLG||','
15001: ||' error_text = '||''''||lv_message_text||''''
15002: ||' WHERE upper(MIN_SEP_TIME_UNIT) NOT IN (''S'',''M'',''H'',''D'',''W'') '
15003: ||' AND process_flag = '||G_IN_PROCESS

Line 15015: 'UPDATE msc_st_wo_operation_rel'

15011: USING lv_batch_id,v_instance_code;
15012:
15013: v_sql_stmt := 08;
15014: lv_sql_stmt :=
15015: 'UPDATE msc_st_wo_operation_rel'
15016: ||' SET MIN_SEP_TIME_UNIT = (select meaning from fnd_lookup_values lv'
15017: ||' WHERE LV.LANGUAGE = userenv(''lang'') '
15018: ||' AND LV.ENABLED_FLAG = ''Y'''
15019: ||' and lookup_type = ''MSC_TIME_UNIT'''

Line 15049: 'UPDATE msc_st_wo_operation_rel'

15045:
15046:
15047: v_sql_stmt := 09;
15048: lv_sql_stmt :=
15049: 'UPDATE msc_st_wo_operation_rel'
15050: ||' SET process_flag = '||G_ERROR_FLG||','
15051: ||' error_text = '||''''||lv_message_text||''''
15052: ||' WHERE upper(MAX_SEP_TIME_UNIT) NOT IN (''S'',''M'',''H'',''D'',''W'') '
15053: ||' AND process_flag = '||G_IN_PROCESS

Line 15064: 'UPDATE msc_st_wo_operation_rel'

15060: EXECUTE IMMEDIATE lv_sql_stmt
15061: USING lv_batch_id,v_instance_code;
15062: v_sql_stmt := 10;
15063: lv_sql_stmt :=
15064: 'UPDATE msc_st_wo_operation_rel'
15065: ||' SET MAX_SEP_TIME_UNIT = (select meaning from fnd_lookup_values lv'
15066: ||' WHERE LV.LANGUAGE = userenv(''lang'') '
15067: ||' AND LV.ENABLED_FLAG = ''Y'''
15068: ||' and lookup_type = ''MSC_TIME_UNIT'''

Line 15104: (p_table_name => 'MSC_ST_WO_OPERATION_REL',

15100: lv_where_str := ' AND NVL(PRECEDENCE_CONSTRAINT,'||NULL_VALUE||') '
15101: ||' NOT IN(1,2,3)';
15102:
15103: lv_return := MSC_ST_UTIL.LOG_ERROR
15104: (p_table_name => 'MSC_ST_WO_OPERATION_REL',
15105: p_instance_code => v_instance_code,
15106: p_row => lv_column_names,
15107: p_severity => G_SEV_WARNING,
15108: p_message_text => lv_message_text,

Line 15122: 'UPDATE msc_st_wo_operation_rel'

15118: END IF;
15119:
15120: v_sql_stmt := 11;
15121: lv_sql_stmt :=
15122: 'UPDATE msc_st_wo_operation_rel'
15123: ||' SET PRECEDENCE_CONSTRAINT = (select meaning from fnd_lookup_values lv'
15124: ||' WHERE LV.LANGUAGE = userenv(''lang'') '
15125: ||' AND LV.ENABLED_FLAG = ''Y'''
15126: ||' and lookup_type = ''MSC_PRECEDENCE_CONSTRAINT'''

Line 15155: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_WO_OPERATION_REL',

15151:
15152: -- Populate organization id
15153:
15154: lv_return :=
15155: MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(p_table_name => 'MSC_ST_WO_OPERATION_REL',
15156: p_org_partner_name => 'ORGANIZATION_CODE',
15157: p_org_partner_id => 'ORGANIZATION_ID',
15158: p_instance_code => v_instance_code,
15159: p_partner_type => G_ORGANIZATION,

Line 15174: 'UPDATE msc_st_wo_operation_rel mswth'

15170:
15171: --Deriving supply_id
15172: v_sql_stmt := 12;
15173: lv_sql_stmt :=
15174: 'UPDATE msc_st_wo_operation_rel mswth'
15175: ||' SET supply_id = (SELECT transaction_id'
15176: ||' FROM msc_supplies ms'
15177: ||' WHERE ms.sr_instance_id = :v_instance_id'
15178: ||' AND ms.organization_id = mswth.organization_id'

Line 15203: 'UPDATE msc_st_wo_operation_rel '

15199: p_token_value1 => 'WIP_ENTITY_CODE');
15200:
15201: v_sql_stmt := 13;
15202: lv_sql_stmt :=
15203: 'UPDATE msc_st_wo_operation_rel '
15204: ||' SET process_flag = '||G_ERROR_FLG||','
15205: ||' error_text = '||''''||lv_message_text||''''
15206: ||' WHERE SUPPLY_ID IS NULL'
15207: ||' AND process_flag = '||G_IN_PROCESS

Line 15238: 'UPDATE msc_st_wo_operation_rel mswth'

15234: -- validate from_op_seq_num
15235:
15236: v_sql_stmt := 14;
15237: lv_sql_stmt :=
15238: 'UPDATE msc_st_wo_operation_rel mswth'
15239: ||' SET process_flag = '||G_ERROR_FLG||','
15240: ||' error_text = '||''''||lv_message_text||''''
15241: ||' WHERE NOT EXISTS ( SELECT 1 '
15242: ||' FROM msc_resource_requirements mrr'

Line 15275: 'UPDATE msc_st_wo_operation_rel mswth'

15271: -- validate from_op_res_seq_num
15272:
15273: v_sql_stmt := 15;
15274: lv_sql_stmt :=
15275: 'UPDATE msc_st_wo_operation_rel mswth'
15276: ||' SET process_flag = '||G_ERROR_FLG||','
15277: ||' error_text = '||''''||lv_message_text||''''
15278: ||' WHERE NOT EXISTS ( SELECT 1 '
15279: ||' FROM msc_resource_requirements mrr'

Line 15313: 'UPDATE msc_st_wo_operation_rel mswth'

15309: -- validate to_op_seq_num
15310:
15311: v_sql_stmt := 16;
15312: lv_sql_stmt :=
15313: 'UPDATE msc_st_wo_operation_rel mswth'
15314: ||' SET process_flag = '||G_ERROR_FLG||','
15315: ||' error_text = '||''''||lv_message_text||''''
15316: ||' WHERE NOT EXISTS ( SELECT 1 '
15317: ||' FROM msc_resource_requirements mrr'

Line 15350: 'UPDATE msc_st_wo_operation_rel mswth'

15346: -- validate to_op_res_seq_num
15347:
15348: v_sql_stmt := 17;
15349: lv_sql_stmt :=
15350: 'UPDATE msc_st_wo_operation_rel mswth'
15351: ||' SET process_flag = '||G_ERROR_FLG||','
15352: ||' error_text = '||''''||lv_message_text||''''
15353: ||' WHERE NOT EXISTS ( SELECT 1 '
15354: ||' FROM msc_resource_requirements mrr'

Line 15376: pEntityName => 'MSC_ST_WO_OPERATION_REL',

15372: (ERRBUF => lv_error_text,
15373: RETCODE => lv_return,
15374: pBatchID => NULL,
15375: pInstanceCode => v_instance_code,
15376: pEntityName => 'MSC_ST_WO_OPERATION_REL',
15377: pInstanceID => v_instance_id);
15378:
15379: IF NVL(lv_return,0) <> 0 THEN
15380: RAISE ex_logging_err;

Line 15384: (p_table_name => 'MSC_ST_WO_OPERATION_REL',

15380: RAISE ex_logging_err;
15381: END IF;
15382: -- Set the process flag as Valid and populate instance_id
15383: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
15384: (p_table_name => 'MSC_ST_WO_OPERATION_REL',
15385: p_instance_id => v_instance_id,
15386: p_instance_code => v_instance_code,
15387: p_process_flag => G_VALID,
15388: p_error_text => lv_error_text,

Line 15399: (p_table_name => 'MSC_ST_WO_OPERATION_REL',

15395: -- At the end calling the LOG_ERROR for logging all
15396: -- errored out records.
15397:
15398: lv_return := MSC_ST_UTIL.LOG_ERROR
15399: (p_table_name => 'MSC_ST_WO_OPERATION_REL',
15400: p_instance_code => v_instance_code,
15401: p_row => lv_column_names,
15402: p_severity => G_SEV_ERROR,
15403: p_message_text => NULL,

Line 56094: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_WO_OPERATION_REL', 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:
56094: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_WO_OPERATION_REL', p_company_name_col => FALSE, p_erp_enabled => 'Y');
56095: IF lv_count > 0 Then
56096: prec.CMRO_flag:= SYS_YES;
56097: End IF;
56098: