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 FND_GLOBAL

Line 5: g_delimiter2 VARCHAR2(10) := fnd_global.local_chr(10);

1: PACKAGE BODY MSC_PQ_UTILS AS
2: /* $Header: MSCPQUTB.pls 120.18.12020000.2 2012/10/19 09:07:46 skathera ship $ */
3:
4: G_PQ_ERROR_MESSAGE VARCHAR2(2000);
5: g_delimiter2 VARCHAR2(10) := fnd_global.local_chr(10);
6: g_delimiter1 VARCHAR2(10) := fnd_global.local_chr(9);
7: g_delimiter VARCHAR2(10) := 'chr(9)';
8:
9: g_among_values among_values_tab;

Line 6: g_delimiter1 VARCHAR2(10) := fnd_global.local_chr(9);

2: /* $Header: MSCPQUTB.pls 120.18.12020000.2 2012/10/19 09:07:46 skathera ship $ */
3:
4: G_PQ_ERROR_MESSAGE VARCHAR2(2000);
5: g_delimiter2 VARCHAR2(10) := fnd_global.local_chr(10);
6: g_delimiter1 VARCHAR2(10) := fnd_global.local_chr(9);
7: g_delimiter VARCHAR2(10) := 'chr(9)';
8:
9: g_among_values among_values_tab;
10: g_CATEGORY_SET_ID NUMBER;

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

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

Line 753: SYSDATE, fnd_global.user_id,

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

Line 754: fnd_global.login_id);

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

Line 765: SYSDATE, fnd_global.user_id,

761: LAST_UPDATE_DATE, LAST_UPDATED_BY ,
762: CREATION_DATE, CREATED_BY,
763: LAST_UPDATE_LOGIN )
764: VALUES (g_query_id, g_obj_sequence_id, g_sequence_id, l_item_list(i),
765: SYSDATE, fnd_global.user_id,
766: SYSDATE, fnd_global.user_id,
767: fnd_global.login_id);
768: ELSE
769: g_items_list_exists := 0;

Line 766: SYSDATE, fnd_global.user_id,

762: CREATION_DATE, CREATED_BY,
763: LAST_UPDATE_LOGIN )
764: VALUES (g_query_id, g_obj_sequence_id, g_sequence_id, l_item_list(i),
765: SYSDATE, fnd_global.user_id,
766: SYSDATE, fnd_global.user_id,
767: fnd_global.login_id);
768: ELSE
769: g_items_list_exists := 0;
770: END IF;

Line 767: fnd_global.login_id);

763: LAST_UPDATE_LOGIN )
764: VALUES (g_query_id, g_obj_sequence_id, g_sequence_id, l_item_list(i),
765: SYSDATE, fnd_global.user_id,
766: SYSDATE, fnd_global.user_id,
767: fnd_global.login_id);
768: ELSE
769: g_items_list_exists := 0;
770: END IF;
771: END;

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

1622: */
1623: /*v_excp_str := ' SELECT DISTINCT '||p_query_id||', '||p_obj_sequence_id||', '||p_sequence_id ||
1624: ', med.TRANSACTION_ID, med.INVENTORY_ITEM_ID ' ||
1625: ', med.SR_INSTANCE_ID,med.ORGANIZATION_ID ' ||
1626: ', SYSDATE, fnd_global.user_id,SYSDATE, fnd_global.user_id, fnd_global.login_id'||
1627: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/
1628: /*v_excp_str := ' SELECT DISTINCT '||p_query_id||', '||p_obj_sequence_id||', '||p_sequence_id ||
1629: ', med.TRANSACTION_ID, med.INVENTORY_ITEM_ID ' ||
1630: ', SYSDATE, fnd_global.user_id,SYSDATE, fnd_global.user_id, fnd_global.login_id'||

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

1626: ', SYSDATE, fnd_global.user_id,SYSDATE, fnd_global.user_id, fnd_global.login_id'||
1627: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/
1628: /*v_excp_str := ' SELECT DISTINCT '||p_query_id||', '||p_obj_sequence_id||', '||p_sequence_id ||
1629: ', med.TRANSACTION_ID, med.INVENTORY_ITEM_ID ' ||
1630: ', SYSDATE, fnd_global.user_id,SYSDATE, fnd_global.user_id, fnd_global.login_id'||
1631: ' FROM MSC_EXCEPTION_DETAILS_V med ';*/
1632: /*v_excp_where := ' WHERE med.plan_id = '||p_plan_id ||
1633: ' AND NVL(med.category_set_id,2) = 2' ||
1634: ' AND ( med.ORDER_NUMBER IS NOT NULL '||

Line 3488: LAST_UPDATED_BY=fnd_global.user_id,

3484: If count_row1=1 then
3485: BEGIN
3486: update msc_plan_queries
3487: set file_id=NULL,
3488: LAST_UPDATED_BY=fnd_global.user_id,
3489: LAST_UPDATE_DATE =SYSDATE,
3490: LAST_UPDATE_LOGIN=fnd_global.user_id
3491: where plan_id=l_plan_id
3492: and query_id=l_query_id;

Line 3490: LAST_UPDATE_LOGIN=fnd_global.user_id

3486: update msc_plan_queries
3487: set file_id=NULL,
3488: LAST_UPDATED_BY=fnd_global.user_id,
3489: LAST_UPDATE_DATE =SYSDATE,
3490: LAST_UPDATE_LOGIN=fnd_global.user_id
3491: where plan_id=l_plan_id
3492: and query_id=l_query_id;
3493: EXCEPTION
3494: WHEN OTHERS THEN

Line 3569: LAST_UPDATED_BY=fnd_global.user_id,

3565: If count_row1=1 then
3566: BEGIN
3567: update msc_plan_queries
3568: set file_id=wsh_id,
3569: LAST_UPDATED_BY=fnd_global.user_id,
3570: LAST_UPDATE_DATE =SYSDATE,
3571: LAST_UPDATE_LOGIN=fnd_global.user_id
3572: where plan_id=l_plan_id
3573: and query_id=l_query_id;

Line 3571: LAST_UPDATE_LOGIN=fnd_global.user_id

3567: update msc_plan_queries
3568: set file_id=wsh_id,
3569: LAST_UPDATED_BY=fnd_global.user_id,
3570: LAST_UPDATE_DATE =SYSDATE,
3571: LAST_UPDATE_LOGIN=fnd_global.user_id
3572: where plan_id=l_plan_id
3573: and query_id=l_query_id;
3574: EXCEPTION
3575: WHEN OTHERS THEN

Line 3593: fnd_global.user_id,

3589: FILE_ID )
3590: VALUES (l_plan_id,
3591: l_query_id,
3592: SYSDATE,
3593: fnd_global.user_id,
3594: SYSDATE,
3595: fnd_global.user_id,
3596: fnd_global.login_id,
3597: wsh_id);

Line 3595: fnd_global.user_id,

3591: l_query_id,
3592: SYSDATE,
3593: fnd_global.user_id,
3594: SYSDATE,
3595: fnd_global.user_id,
3596: fnd_global.login_id,
3597: wsh_id);
3598: EXCEPTION
3599: WHEN OTHERS THEN

Line 3596: fnd_global.login_id,

3592: SYSDATE,
3593: fnd_global.user_id,
3594: SYSDATE,
3595: fnd_global.user_id,
3596: fnd_global.login_id,
3597: wsh_id);
3598: EXCEPTION
3599: WHEN OTHERS THEN
3600: wsh_id:=-123;