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 56049: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_APPS_INSTANCES', p_company_name_col => FALSE);

56045:
56046: -- Profile Values
56047:
56048: IF v_profile_enabled = SYS_YES THEN
56049: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_APPS_INSTANCES', p_company_name_col => FALSE);
56050: END IF;
56051:
56052: IF v_cal_assignment_enabled = SYS_YES THEN
56053: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS');

Line 57441: UPDATE msc_st_apps_instances mai1

57437: END IF;
57438:
57439: --Duplicate records check for the records whose source is XML
57440:
57441: UPDATE msc_st_apps_instances mai1
57442: SET process_flag = G_ERROR_FLG,
57443: error_text = lv_message_text
57444: WHERE message_id < (SELECT MAX(message_id)
57445: FROM msc_st_apps_instances mai2

Line 57445: FROM msc_st_apps_instances mai2

57441: UPDATE msc_st_apps_instances mai1
57442: SET process_flag = G_ERROR_FLG,
57443: error_text = lv_message_text
57444: WHERE message_id < (SELECT MAX(message_id)
57445: FROM msc_st_apps_instances mai2
57446: WHERE mai2.sr_instance_code = mai1.sr_instance_code
57447: AND mai2.process_flag = G_IN_PROCESS
57448: AND NVL(mai2.message_id,NULL_VALUE) <>NULL_VALUE)
57449: AND mai1.process_flag = G_IN_PROCESS

Line 57468: UPDATE msc_st_apps_instances mai1

57464: --Duplicate records check for the records whose source is other than XML
57465: --Different SQL is used because in XML we can identify the latest records
57466: --whereas in batch load we cannot.
57467:
57468: UPDATE msc_st_apps_instances mai1
57469: SET process_flag = G_ERROR_FLG,
57470: error_text = lv_message_text
57471: WHERE EXISTS( SELECT 1
57472: FROM msc_st_apps_instances mai2

Line 57472: FROM msc_st_apps_instances mai2

57468: UPDATE msc_st_apps_instances mai1
57469: SET process_flag = G_ERROR_FLG,
57470: error_text = lv_message_text
57471: WHERE EXISTS( SELECT 1
57472: FROM msc_st_apps_instances mai2
57473: WHERE mai2.sr_instance_code = mai1.sr_instance_code
57474: AND mai2.process_flag = G_IN_PROCESS
57475: AND NVL(mai2.message_id,NULL_VALUE) = NULL_VALUE
57476: GROUP BY sr_instance_code HAVING COUNT(*) > 1)

Line 57482: SELECT msc_st_apps_instances_s.NEXTVAL

57478: AND mai1.sr_instance_code = v_instance_code
57479: AND NVL(mai1.message_id,NULL_VALUE) = NULL_VALUE;
57480:
57481:
57482: SELECT msc_st_apps_instances_s.NEXTVAL
57483: INTO lv_transaction_id
57484: FROM dual;
57485:
57486:

Line 57493: 'UPDATE msc_st_apps_instances '

57489:
57490: --Update the transaction_id and the who columns
57491:
57492: lv_sql_stmt :=
57493: 'UPDATE msc_st_apps_instances '
57494: ||' SET st_transaction_id = :lv_transaction_id,'
57495: ||' refresh_id = '||v_refresh_id ||','
57496: ||' last_update_date = :v_current_date,'
57497: ||' last_updated_by = :v_current_user,'

Line 57515: 'UPDATE msc_st_apps_instances '

57511: v_instance_code;
57512:
57513:
57514: lv_sql_stmt :=
57515: 'UPDATE msc_st_apps_instances '
57516: ||' SET wsm_create_lbj_copy_routing = 2'
57517: ||' WHERE sr_instance_code = :v_instance_code'
57518: ||' AND process_flag = '||G_IN_PROCESS
57519: ||' AND wsm_create_lbj_copy_routing NOT IN (1,2)';

Line 57543: 'UPDATE msc_st_apps_instances mai'

57539:
57540: -- derive validation_org_id
57541:
57542: lv_sql_stmt :=
57543: 'UPDATE msc_st_apps_instances mai'
57544: ||' SET validation_org_id'
57545: ||' = (SELECT local_id'
57546: ||' FROM msc_local_id_setup '
57547: ||' WHERE char1 = sr_instance_code'

Line 57564: 'UPDATE msc_st_apps_instances mai'

57560:
57561: -- error out the record if validation_org_id is not a valid organization_id
57562:
57563: lv_sql_stmt :=
57564: 'UPDATE msc_st_apps_instances mai'
57565: ||' SET process_flag = '||G_ERROR_FLG||','
57566: ||' error_text = '||''''||lv_message_text||''''
57567: ||' WHERE NVL(validation_org_id,'||NULL_VALUE||') = '||NULL_VALUE
57568: ||' AND NVL(msc_org_for_bom_explosion,'||''''||NULL_CHAR||''''||')'

Line 57580: (p_table_name => 'MSC_ST_APPS_INSTANCES',

57576: EXECUTE IMMEDIATE lv_sql_stmt
57577: USING v_instance_code;
57578:
57579: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
57580: (p_table_name => 'MSC_ST_APPS_INSTANCES',
57581: p_instance_id => v_instance_id,
57582: p_instance_code => v_instance_code,
57583: p_process_flag => G_VALID,
57584: p_debug => v_debug,

Line 57595: ||' FROM msc_st_apps_instances msai'

57591:
57592: lv_sql_stmt :=
57593: 'UPDATE msc_apps_instances mai'
57594: ||' SET (validation_org_id, lbj_details) = (SELECT validation_org_id, wsm_create_lbj_copy_routing'
57595: ||' FROM msc_st_apps_instances msai'
57596: ||' WHERE msai.sr_instance_code = mai.instance_code'
57597: ||' AND msai.sr_instance_id = mai.instance_id'
57598: ||' AND msai.process_flag =' || G_VALID ||')'
57599: ||' WHERE instance_code = :v_instance_code';