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 43: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);

39: BEGIN
40: OPEN c_plan_type(p_plan_id);
41: FETCH c_plan_type INTO l_plan_type;
42: CLOSE c_plan_type;
43: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);
44: --l_pref_value:= msc_get_name.get_preference('CATEGORY_SET_ID',l_def_pref_id, l_plan_type);
45: l_pref_value:= msc_get_name.get_preference(p_preference,l_def_pref_id, l_plan_type);
46: RETURN l_pref_value;
47:

Line 44: --l_pref_value:= msc_get_name.get_preference('CATEGORY_SET_ID',l_def_pref_id, l_plan_type);

40: OPEN c_plan_type(p_plan_id);
41: FETCH c_plan_type INTO l_plan_type;
42: CLOSE c_plan_type;
43: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);
44: --l_pref_value:= msc_get_name.get_preference('CATEGORY_SET_ID',l_def_pref_id, l_plan_type);
45: l_pref_value:= msc_get_name.get_preference(p_preference,l_def_pref_id, l_plan_type);
46: RETURN l_pref_value;
47:
48: END Get_Pref;

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

41: FETCH c_plan_type INTO l_plan_type;
42: CLOSE c_plan_type;
43: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);
44: --l_pref_value:= msc_get_name.get_preference('CATEGORY_SET_ID',l_def_pref_id, l_plan_type);
45: l_pref_value:= msc_get_name.get_preference(p_preference,l_def_pref_id, l_plan_type);
46: RETURN l_pref_value;
47:
48: END Get_Pref;
49:

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

1622: v_delete_stmt := 'DELETE MSC_FORM_QUERY WHERE QUERY_ID = :p_query_id'
1623: ||' AND NUMBER1 = :p_obj_sequence_id AND NUMBER2 = :p_sequence_id';
1624: --KSA_DEBUG(SYSDATE,'del STMT IS '||v_delete_stmt,'build_Excp_where');
1625: execute immediate v_delete_stmt using p_query_id, p_obj_sequence_id, p_sequence_id;
1626: --msc_get_name.execute_dsql(v_delete_stmt);
1627: --KSA_DEBUG(SYSDATE,'ex where is '||v_insert_stmt||v_excp_str||v_excp_where||' AND '||l_where_clause,'build_Excp_where');
1628: --msc_get_name.execute_dsql(v_insert_stmt||v_excp_str||v_excp_where||' AND '||l_where_clause);
1629: --KSA_DEBUG(SYSDATE,'where is '||l_where_clause,'build_Excp_where');
1630: Parse_exceptions(p_plan_id, l_where_clause);

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

1624: --KSA_DEBUG(SYSDATE,'del STMT IS '||v_delete_stmt,'build_Excp_where');
1625: execute immediate v_delete_stmt using p_query_id, p_obj_sequence_id, p_sequence_id;
1626: --msc_get_name.execute_dsql(v_delete_stmt);
1627: --KSA_DEBUG(SYSDATE,'ex where is '||v_insert_stmt||v_excp_str||v_excp_where||' AND '||l_where_clause,'build_Excp_where');
1628: --msc_get_name.execute_dsql(v_insert_stmt||v_excp_str||v_excp_where||' AND '||l_where_clause);
1629: --KSA_DEBUG(SYSDATE,'where is '||l_where_clause,'build_Excp_where');
1630: Parse_exceptions(p_plan_id, l_where_clause);
1631: IF g_items_list_exists > 0 THEN
1632: p_excp_where_clause := '('||