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_PQ_UTILS dependencies on MSC_GET_NAME

Line 48: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id,l_plan_type);

44: BEGIN
45: OPEN c_plan_type(p_plan_id);
46: FETCH c_plan_type INTO l_plan_type;
47: CLOSE c_plan_type;
48: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id,l_plan_type);
49: l_pref_value:= msc_get_name.get_preference(p_preference,l_def_pref_id, l_plan_type);
50: RETURN l_pref_value;
51:
52: END Get_Pref;

Line 49: l_pref_value:= msc_get_name.get_preference(p_preference,l_def_pref_id, l_plan_type);

45: OPEN c_plan_type(p_plan_id);
46: FETCH c_plan_type INTO l_plan_type;
47: CLOSE c_plan_type;
48: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id,l_plan_type);
49: l_pref_value:= msc_get_name.get_preference(p_preference,l_def_pref_id, l_plan_type);
50: RETURN l_pref_value;
51:
52: END Get_Pref;
53:

Line 1654: --msc_get_name.execute_dsql(v_delete_stmt);

1650: v_delete_stmt := 'DELETE MSC_FORM_QUERY WHERE QUERY_ID = :p_query_id'
1651: ||' AND NUMBER1 = :p_obj_sequence_id AND NUMBER2 = :p_sequence_id';
1652: --KSA_DEBUG(SYSDATE,'del STMT IS '||v_delete_stmt,'build_Excp_where');
1653: execute immediate v_delete_stmt using p_query_id, p_obj_sequence_id, p_sequence_id;
1654: --msc_get_name.execute_dsql(v_delete_stmt);
1655: --KSA_DEBUG(SYSDATE,'ex where is '||v_insert_stmt||v_excp_str||v_excp_where||' AND '||l_where_clause,'build_Excp_where');
1656: --msc_get_name.execute_dsql(v_insert_stmt||v_excp_str||v_excp_where||' AND '||l_where_clause);
1657: --KSA_DEBUG(SYSDATE,'where is '||l_where_clause,'build_Excp_where');
1658: Parse_exceptions(p_plan_id, l_where_clause);

Line 1656: --msc_get_name.execute_dsql(v_insert_stmt||v_excp_str||v_excp_where||' AND '||l_where_clause);

1652: --KSA_DEBUG(SYSDATE,'del STMT IS '||v_delete_stmt,'build_Excp_where');
1653: execute immediate v_delete_stmt using p_query_id, p_obj_sequence_id, p_sequence_id;
1654: --msc_get_name.execute_dsql(v_delete_stmt);
1655: --KSA_DEBUG(SYSDATE,'ex where is '||v_insert_stmt||v_excp_str||v_excp_where||' AND '||l_where_clause,'build_Excp_where');
1656: --msc_get_name.execute_dsql(v_insert_stmt||v_excp_str||v_excp_where||' AND '||l_where_clause);
1657: --KSA_DEBUG(SYSDATE,'where is '||l_where_clause,'build_Excp_where');
1658: Parse_exceptions(p_plan_id, l_where_clause);
1659: IF g_items_list_exists > 0 THEN
1660: p_excp_where_clause := '('||