APPS.MSC_PQ_UTILS dependencies on FND_GLOBAL

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 748: SYSDATE, fnd_global.user_id,

744: LAST_UPDATE_DATE, LAST_UPDATED_BY ,
745: CREATION_DATE, CREATED_BY,
746: LAST_UPDATE_LOGIN )
747: VALUES (g_query_id, g_obj_sequence_id, g_sequence_id, l_list(i),
748: SYSDATE, fnd_global.user_id,
749: SYSDATE, fnd_global.user_id,
750: fnd_global.login_id);
751:
752: IF l_item_list.count() > 0 THEN

Line 749: SYSDATE, fnd_global.user_id,

745: CREATION_DATE, CREATED_BY,
746: LAST_UPDATE_LOGIN )
747: VALUES (g_query_id, g_obj_sequence_id, g_sequence_id, l_list(i),
748: SYSDATE, fnd_global.user_id,
749: SYSDATE, fnd_global.user_id,
750: fnd_global.login_id);
751:
752: IF l_item_list.count() > 0 THEN
753: g_items_list_exists := l_item_list.count();

Line 750: fnd_global.login_id);

746: LAST_UPDATE_LOGIN )
747: VALUES (g_query_id, g_obj_sequence_id, g_sequence_id, l_list(i),
748: SYSDATE, fnd_global.user_id,
749: SYSDATE, fnd_global.user_id,
750: fnd_global.login_id);
751:
752: IF l_item_list.count() > 0 THEN
753: g_items_list_exists := l_item_list.count();
754: FORALL i IN 1..l_item_list.count()

Line 761: SYSDATE, fnd_global.user_id,

757: LAST_UPDATE_DATE, LAST_UPDATED_BY ,
758: CREATION_DATE, CREATED_BY,
759: LAST_UPDATE_LOGIN )
760: VALUES (g_query_id, g_obj_sequence_id, g_sequence_id, l_item_list(i),
761: SYSDATE, fnd_global.user_id,
762: SYSDATE, fnd_global.user_id,
763: fnd_global.login_id);
764: ELSE
765: g_items_list_exists := 0;

Line 762: SYSDATE, fnd_global.user_id,

758: CREATION_DATE, CREATED_BY,
759: LAST_UPDATE_LOGIN )
760: VALUES (g_query_id, g_obj_sequence_id, g_sequence_id, l_item_list(i),
761: SYSDATE, fnd_global.user_id,
762: SYSDATE, fnd_global.user_id,
763: fnd_global.login_id);
764: ELSE
765: g_items_list_exists := 0;
766: END IF;

Line 763: fnd_global.login_id);

759: LAST_UPDATE_LOGIN )
760: VALUES (g_query_id, g_obj_sequence_id, g_sequence_id, l_item_list(i),
761: SYSDATE, fnd_global.user_id,
762: SYSDATE, fnd_global.user_id,
763: fnd_global.login_id);
764: ELSE
765: g_items_list_exists := 0;
766: END IF;
767: END;

Line 1598: ', SYSDATE, fnd_global.user_id,SYSDATE, fnd_global.user_id, fnd_global.login_id'||

1594: l_where_clause := REPLACE(REPLACE(p_where_clause,'SOURCE_SR_INSTANCE_ID','SOURCE_ORG_INSTANCE_ID'),'VENDOR_ID','SUPPLIER_ID');
1595: /*v_excp_str := ' SELECT DISTINCT '||p_query_id||', '||p_obj_sequence_id||', '||p_sequence_id ||
1596: ', med.TRANSACTION_ID, med.INVENTORY_ITEM_ID ' ||
1597: ', med.SR_INSTANCE_ID,med.ORGANIZATION_ID ' ||
1598: ', SYSDATE, fnd_global.user_id,SYSDATE, fnd_global.user_id, fnd_global.login_id'||
1599: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/
1600: /*v_excp_str := ' SELECT DISTINCT '||p_query_id||', '||p_obj_sequence_id||', '||p_sequence_id ||
1601: ', med.TRANSACTION_ID, med.INVENTORY_ITEM_ID ' ||
1602: ', SYSDATE, fnd_global.user_id,SYSDATE, fnd_global.user_id, fnd_global.login_id'||

Line 1602: ', SYSDATE, fnd_global.user_id,SYSDATE, fnd_global.user_id, fnd_global.login_id'||

1598: ', SYSDATE, fnd_global.user_id,SYSDATE, fnd_global.user_id, fnd_global.login_id'||
1599: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/
1600: /*v_excp_str := ' SELECT DISTINCT '||p_query_id||', '||p_obj_sequence_id||', '||p_sequence_id ||
1601: ', med.TRANSACTION_ID, med.INVENTORY_ITEM_ID ' ||
1602: ', SYSDATE, fnd_global.user_id,SYSDATE, fnd_global.user_id, fnd_global.login_id'||
1603: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/
1604: /*v_excp_where := ' WHERE med.plan_id = '||p_plan_id ||
1605: ' AND NVL(med.category_set_id,2) = 2' ||
1606: ' AND ( med.ORDER_NUMBER IS NOT NULL '||