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.PO_WF_REQ_NOTIFICATION dependencies on FND_GLOBAL

Line 228: NL VARCHAR2(1) := fnd_global.newline;

224: l_document_2 VARCHAR2(32000) := '';
225: l_document_3 VARCHAR2(32000) := '';
226:
227:
228: NL VARCHAR2(1) := fnd_global.newline;
229:
230: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
231:
232: l_notification_id number;

Line 475: NL VARCHAR2(1) := fnd_global.newline;

471:
472: l_document_2 VARCHAR2(32000) := '';
473: l_document_3 VARCHAR2(32000) := '';
474:
475: NL VARCHAR2(1) := fnd_global.newline;
476:
477: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
478: l_notification_id number;
479:

Line 742: NL VARCHAR2(1) := fnd_global.newline;

738:
739: l_document_2 VARCHAR2(32000) := '';
740: l_document_3 VARCHAR2(32000) := '';
741:
742: NL VARCHAR2(1) := fnd_global.newline;
743:
744: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
745: l_notification_id number;
746:

Line 967: NL VARCHAR2(1) := fnd_global.newline;

963:
964: l_document_2 VARCHAR2(32000) := '';
965: l_document_3 VARCHAR2(32000) := '';
966:
967: NL VARCHAR2(1) := fnd_global.newline;
968:
969: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
970: l_notification_id number;
971:

Line 1180: NL VARCHAR2(1) := fnd_global.newline;

1176: l_document VARCHAR2(32000) := '';
1177:
1178: l_currency_code fnd_currencies.currency_code%TYPE;
1179:
1180: NL VARCHAR2(1) := fnd_global.newline;
1181:
1182: i number := 0;
1183:
1184: display_txn_curr VARCHAR2(30);

Line 1265: l_user_id := fnd_global.user_id;

1261:
1262: --FND_PROFILE.GET('USER_ID', l_user_id);
1263: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);
1264: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
1265: l_user_id := fnd_global.user_id;
1266: l_responsibility_id := fnd_global.resp_id;
1267: l_application_id := fnd_global.resp_appl_id;
1268:
1269: IF (l_user_id = -1) THEN

Line 1266: l_responsibility_id := fnd_global.resp_id;

1262: --FND_PROFILE.GET('USER_ID', l_user_id);
1263: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);
1264: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
1265: l_user_id := fnd_global.user_id;
1266: l_responsibility_id := fnd_global.resp_id;
1267: l_application_id := fnd_global.resp_appl_id;
1268:
1269: IF (l_user_id = -1) THEN
1270: l_user_id := NULL;

Line 1267: l_application_id := fnd_global.resp_appl_id;

1263: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);
1264: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
1265: l_user_id := fnd_global.user_id;
1266: l_responsibility_id := fnd_global.resp_id;
1267: l_application_id := fnd_global.resp_appl_id;
1268:
1269: IF (l_user_id = -1) THEN
1270: l_user_id := NULL;
1271: END IF;

Line 1425: NL VARCHAR2(1) := fnd_global.newline;

1421: l_document_Summary VARCHAR2(32000) := '';
1422:
1423: l_currency_code fnd_currencies.currency_code%TYPE;
1424:
1425: NL VARCHAR2(1) := fnd_global.newline;
1426:
1427: i number := 0;
1428:
1429: display_txn_curr VARCHAR2(30);

Line 1543: l_user_id := fnd_global.user_id;

1539: */
1540: --FND_PROFILE.GET('USER_ID', l_user_id);
1541: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);
1542: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
1543: l_user_id := fnd_global.user_id;
1544: l_responsibility_id := fnd_global.resp_id;
1545: l_application_id := fnd_global.resp_appl_id;
1546:
1547: IF (l_user_id = -1) THEN

Line 1544: l_responsibility_id := fnd_global.resp_id;

1540: --FND_PROFILE.GET('USER_ID', l_user_id);
1541: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);
1542: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
1543: l_user_id := fnd_global.user_id;
1544: l_responsibility_id := fnd_global.resp_id;
1545: l_application_id := fnd_global.resp_appl_id;
1546:
1547: IF (l_user_id = -1) THEN
1548: l_user_id := NULL;

Line 1545: l_application_id := fnd_global.resp_appl_id;

1541: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);
1542: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
1543: l_user_id := fnd_global.user_id;
1544: l_responsibility_id := fnd_global.resp_id;
1545: l_application_id := fnd_global.resp_appl_id;
1546:
1547: IF (l_user_id = -1) THEN
1548: l_user_id := NULL;
1549: END IF;

Line 1901: NL VARCHAR2(1) := fnd_global.newline;

1897: l_history_seq number;
1898:
1899: MAX_SEQNO number := 0;
1900: l_rcount number := 0;
1901: NL VARCHAR2(1) := fnd_global.newline;
1902:
1903: --SQL What: Query action history which is updated by both buyer and vendor
1904: --SQL Why: Since vendor doesn't have employee id, added outer join;
1905: CURSOR history_csr(v_document_id NUMBER, v_object_type VARCHAR2) IS

Line 2045: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

2041: /*Modified as part of bug 7554321 changing date format*/
2042: if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
2043: or (FND_RELEASE.MAJOR_VERSION > 12) then
2044: l_date_text := nvl(to_char(l_history.action_date,
2045: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2046: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),' ') ;
2047: else
2048: l_date_text := nvl(to_char(l_history.action_date), ' ') ;
2049: end if;

Line 2046: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),' ') ;

2042: if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
2043: or (FND_RELEASE.MAJOR_VERSION > 12) then
2044: l_date_text := nvl(to_char(l_history.action_date,
2045: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2046: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),' ') ;
2047: else
2048: l_date_text := nvl(to_char(l_history.action_date), ' ') ;
2049: end if;
2050:

Line 2097: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),

2093: /*Modified as part of bug 7554321 changing date format*/
2094: if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
2095: or (FND_RELEASE.MAJOR_VERSION > 12) then
2096: l_date_text := nvl(to_char(l_history.action_date,
2097: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2098: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),' ') ;
2099: else
2100: l_date_text := nvl(to_char(l_history.action_date), ' ') ;
2101: end if;

Line 2098: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),' ') ;

2094: if (FND_RELEASE.MAJOR_VERSION = 12 and FND_RELEASE.minor_version >= 1 and FND_RELEASE.POINT_VERSION >= 1 )
2095: or (FND_RELEASE.MAJOR_VERSION > 12) then
2096: l_date_text := nvl(to_char(l_history.action_date,
2097: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', fnd_global.user_id),
2098: 'NLS_CALENDAR = ''' || NVL( FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', fnd_global.user_id) ,'GREGORIAN' ) || ''''),' ') ;
2099: else
2100: l_date_text := nvl(to_char(l_history.action_date), ' ') ;
2101: end if;
2102:

Line 2156: NL VARCHAR2(1) := fnd_global.newline;

2152: approverList ame_util.approversTable;
2153: upperLimit integer;
2154: fullName varchar2(240);
2155:
2156: NL VARCHAR2(1) := fnd_global.newline;
2157:
2158: --SQL What: Select NULL to the last two columns of pending_csr
2159: --SQL Why: Be consistent to the change of history_record without changing
2160: -- the existing functionality of get_pending_action_html

Line 2332: NL VARCHAR2(1) := fnd_global.newline;

2328: l_document VARCHAR2(32000) := '';
2329:
2330: l_history history_record;
2331:
2332: NL VARCHAR2(1) := fnd_global.newline;
2333:
2334: --SQL What: Query action history which is updated by both buyer and vendor
2335: --SQL Why: Since vendor doesn't have employee id, added outer join;
2336: CURSOR history_csr(v_document_id NUMBER, v_object_type VARCHAR2) IS

Line 2393: NL VARCHAR2(1) := fnd_global.newline;

2389: l_notification_id in number) return varchar2 is
2390:
2391: l_document VARCHAR2(32000) := '';
2392:
2393: NL VARCHAR2(1) := fnd_global.newline;
2394:
2395: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
2396: l_type WF_MESSAGE_ATTRIBUTES.TYPE%TYPE;
2397: l_subtype WF_MESSAGE_ATTRIBUTES.SUBTYPE%TYPE;

Line 2490: NL VARCHAR2(1) := fnd_global.newline;

2486: function print_heading(l_text in varchar2) return varchar2 is
2487:
2488: l_document varchar2(1000) := '';
2489:
2490: NL VARCHAR2(1) := fnd_global.newline;
2491: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
2492:
2493: begin
2494:

Line 2597: last_updated_by = fnd_global.user_id,

2593:
2594:
2595: UPDATE PO_ACTION_HISTORY
2596: SET last_update_date = sysdate,
2597: last_updated_by = fnd_global.user_id,
2598: last_update_login = fnd_global.login_id ,
2599: action_date = sysdate,
2600: action_code = p_action_code,
2601: note = p_note,

Line 2598: last_update_login = fnd_global.login_id ,

2594:
2595: UPDATE PO_ACTION_HISTORY
2596: SET last_update_date = sysdate,
2597: last_updated_by = fnd_global.user_id,
2598: last_update_login = fnd_global.login_id ,
2599: action_date = sysdate,
2600: action_code = p_action_code,
2601: note = p_note,
2602: offline_code = decode(offline_code,

Line 2631: fnd_global.user_id,

2627: l_request_id,
2628: l_program_application_id,
2629: l_program_id,
2630: l_program_date,
2631: fnd_global.user_id,
2632: fnd_global.login_id,
2633: l_approval_group_id);
2634:
2635: l_progress := '030';

Line 2632: fnd_global.login_id,

2628: l_program_application_id,
2629: l_program_id,
2630: l_program_date,
2631: fnd_global.user_id,
2632: fnd_global.login_id,
2633: l_approval_group_id);
2634:
2635: l_progress := '030';
2636:

Line 2877: l_session_user_id := fnd_global.user_id;

2873: --Bug 5389914
2874: --Fnd_Profile.Get('USER_ID',l_session_user_id);
2875: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
2876: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
2877: l_session_user_id := fnd_global.user_id;
2878: l_session_resp_id := fnd_global.resp_id;
2879: l_session_appl_id := fnd_global.resp_appl_id;
2880:
2881: select PARENT_ITEM_TYPE, PARENT_ITEM_KEY

Line 2878: l_session_resp_id := fnd_global.resp_id;

2874: --Fnd_Profile.Get('USER_ID',l_session_user_id);
2875: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
2876: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
2877: l_session_user_id := fnd_global.user_id;
2878: l_session_resp_id := fnd_global.resp_id;
2879: l_session_appl_id := fnd_global.resp_appl_id;
2880:
2881: select PARENT_ITEM_TYPE, PARENT_ITEM_KEY
2882: into p_itemtype,p_itemkey

Line 2879: l_session_appl_id := fnd_global.resp_appl_id;

2875: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
2876: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
2877: l_session_user_id := fnd_global.user_id;
2878: l_session_resp_id := fnd_global.resp_id;
2879: l_session_appl_id := fnd_global.resp_appl_id;
2880:
2881: select PARENT_ITEM_TYPE, PARENT_ITEM_KEY
2882: into p_itemtype,p_itemkey
2883: from wf_items

Line 3322: and SECURITY_GROUP_ID = fnd_global.lookup_security_group('REQUISITION TYPE',201);

3318: and flv.LANGUAGE = fl.language_code
3319: and flv.lookup_type='REQUISITION TYPE'
3320: and flv.lookup_code = p_doc_subtype
3321: and VIEW_APPLICATION_ID = 201
3322: and SECURITY_GROUP_ID = fnd_global.lookup_security_group('REQUISITION TYPE',201);
3323: */
3324:
3325: -- MIPR Changes
3326: CURSOR mipr_csr(p_doc_id NUMBER, p_language varchar2) IS