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_APPS_INSTANCES

Line 51127: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_APPS_INSTANCES', p_company_name_col => FALSE);

51123:
51124: -- Profile Values
51125:
51126: IF v_profile_enabled = SYS_YES THEN
51127: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_APPS_INSTANCES', p_company_name_col => FALSE);
51128: END IF;
51129:
51130: IF v_cal_assignment_enabled = SYS_YES THEN
51131: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS');

Line 52410: UPDATE msc_st_apps_instances mai1

52406: END IF;
52407:
52408: --Duplicate records check for the records whose source is XML
52409:
52410: UPDATE msc_st_apps_instances mai1
52411: SET process_flag = G_ERROR_FLG,
52412: error_text = lv_message_text
52413: WHERE message_id < (SELECT MAX(message_id)
52414: FROM msc_st_apps_instances mai2

Line 52414: FROM msc_st_apps_instances mai2

52410: UPDATE msc_st_apps_instances mai1
52411: SET process_flag = G_ERROR_FLG,
52412: error_text = lv_message_text
52413: WHERE message_id < (SELECT MAX(message_id)
52414: FROM msc_st_apps_instances mai2
52415: WHERE mai2.sr_instance_code = mai1.sr_instance_code
52416: AND mai2.process_flag = G_IN_PROCESS
52417: AND NVL(mai2.message_id,NULL_VALUE) <>NULL_VALUE)
52418: AND mai1.process_flag = G_IN_PROCESS

Line 52437: UPDATE msc_st_apps_instances mai1

52433: --Duplicate records check for the records whose source is other than XML
52434: --Different SQL is used because in XML we can identify the latest records
52435: --whereas in batch load we cannot.
52436:
52437: UPDATE msc_st_apps_instances mai1
52438: SET process_flag = G_ERROR_FLG,
52439: error_text = lv_message_text
52440: WHERE EXISTS( SELECT 1
52441: FROM msc_st_apps_instances mai2

Line 52441: FROM msc_st_apps_instances mai2

52437: UPDATE msc_st_apps_instances mai1
52438: SET process_flag = G_ERROR_FLG,
52439: error_text = lv_message_text
52440: WHERE EXISTS( SELECT 1
52441: FROM msc_st_apps_instances mai2
52442: WHERE mai2.sr_instance_code = mai1.sr_instance_code
52443: AND mai2.process_flag = G_IN_PROCESS
52444: AND NVL(mai2.message_id,NULL_VALUE) = NULL_VALUE
52445: GROUP BY sr_instance_code HAVING COUNT(*) > 1)

Line 52451: SELECT msc_st_apps_instances_s.NEXTVAL

52447: AND mai1.sr_instance_code = v_instance_code
52448: AND NVL(mai1.message_id,NULL_VALUE) = NULL_VALUE;
52449:
52450:
52451: SELECT msc_st_apps_instances_s.NEXTVAL
52452: INTO lv_transaction_id
52453: FROM dual;
52454:
52455:

Line 52462: 'UPDATE msc_st_apps_instances '

52458:
52459: --Update the transaction_id and the who columns
52460:
52461: lv_sql_stmt :=
52462: 'UPDATE msc_st_apps_instances '
52463: ||' SET st_transaction_id = :lv_transaction_id,'
52464: ||' refresh_id = '||v_refresh_id ||','
52465: ||' last_update_date = :v_current_date,'
52466: ||' last_updated_by = :v_current_user,'

Line 52484: 'UPDATE msc_st_apps_instances '

52480: v_instance_code;
52481:
52482:
52483: lv_sql_stmt :=
52484: 'UPDATE msc_st_apps_instances '
52485: ||' SET wsm_create_lbj_copy_routing = 2'
52486: ||' WHERE sr_instance_code = :v_instance_code'
52487: ||' AND process_flag = '||G_IN_PROCESS
52488: ||' AND wsm_create_lbj_copy_routing NOT IN (1,2)';

Line 52512: 'UPDATE msc_st_apps_instances mai'

52508:
52509: -- derive validation_org_id
52510:
52511: lv_sql_stmt :=
52512: 'UPDATE msc_st_apps_instances mai'
52513: ||' SET validation_org_id'
52514: ||' = (SELECT local_id'
52515: ||' FROM msc_local_id_setup '
52516: ||' WHERE char1 = sr_instance_code'

Line 52533: 'UPDATE msc_st_apps_instances mai'

52529:
52530: -- error out the record if validation_org_id is not a valid organization_id
52531:
52532: lv_sql_stmt :=
52533: 'UPDATE msc_st_apps_instances mai'
52534: ||' SET process_flag = '||G_ERROR_FLG||','
52535: ||' error_text = '||''''||lv_message_text||''''
52536: ||' WHERE NVL(validation_org_id,'||NULL_VALUE||') = '||NULL_VALUE
52537: ||' AND NVL(msc_org_for_bom_explosion,'||''''||NULL_CHAR||''''||')'

Line 52549: (p_table_name => 'MSC_ST_APPS_INSTANCES',

52545: EXECUTE IMMEDIATE lv_sql_stmt
52546: USING v_instance_code;
52547:
52548: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
52549: (p_table_name => 'MSC_ST_APPS_INSTANCES',
52550: p_instance_id => v_instance_id,
52551: p_instance_code => v_instance_code,
52552: p_process_flag => G_VALID,
52553: p_debug => v_debug,

Line 52564: ||' FROM msc_st_apps_instances msai'

52560:
52561: lv_sql_stmt :=
52562: 'UPDATE msc_apps_instances mai'
52563: ||' SET (validation_org_id, lbj_details) = (SELECT validation_org_id, wsm_create_lbj_copy_routing'
52564: ||' FROM msc_st_apps_instances msai'
52565: ||' WHERE msai.sr_instance_code = mai.instance_code'
52566: ||' AND msai.sr_instance_id = mai.instance_id'
52567: ||' AND msai.process_flag =' || G_VALID ||')'
52568: ||' WHERE instance_code = :v_instance_code';