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 1900: NL VARCHAR2(1) := fnd_global.newline;

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

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

2113: approverList ame_util.approversTable;
2114: upperLimit integer;
2115: fullName varchar2(240);
2116:
2117: NL VARCHAR2(1) := fnd_global.newline;
2118:
2119: --SQL What: Select NULL to the last two columns of pending_csr
2120: --SQL Why: Be consistent to the change of history_record without changing
2121: -- the existing functionality of get_pending_action_html

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

2269: l_document VARCHAR2(32000) := '';
2270:
2271: l_history history_record;
2272:
2273: NL VARCHAR2(1) := fnd_global.newline;
2274:
2275: --SQL What: Query action history which is updated by both buyer and vendor
2276: --SQL Why: Since vendor doesn't have employee id, added outer join;
2277: CURSOR history_csr(v_document_id NUMBER, v_object_type VARCHAR2) IS

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

2330: l_notification_id in number) return varchar2 is
2331:
2332: l_document VARCHAR2(32000) := '';
2333:
2334: NL VARCHAR2(1) := fnd_global.newline;
2335:
2336: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
2337: l_type WF_MESSAGE_ATTRIBUTES.TYPE%TYPE;
2338: l_subtype WF_MESSAGE_ATTRIBUTES.SUBTYPE%TYPE;

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

2427: function print_heading(l_text in varchar2) return varchar2 is
2428:
2429: l_document varchar2(1000) := '';
2430:
2431: NL VARCHAR2(1) := fnd_global.newline;
2432: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
2433:
2434: begin
2435:

Line 2520: last_updated_by = fnd_global.user_id,

2516:
2517:
2518: UPDATE PO_ACTION_HISTORY
2519: SET last_update_date = sysdate,
2520: last_updated_by = fnd_global.user_id,
2521: last_update_login = fnd_global.login_id ,
2522: action_date = sysdate,
2523: action_code = p_action_code,
2524: note = p_note,

Line 2521: last_update_login = fnd_global.login_id ,

2517:
2518: UPDATE PO_ACTION_HISTORY
2519: SET last_update_date = sysdate,
2520: last_updated_by = fnd_global.user_id,
2521: last_update_login = fnd_global.login_id ,
2522: action_date = sysdate,
2523: action_code = p_action_code,
2524: note = p_note,
2525: offline_code = decode(offline_code,

Line 2554: fnd_global.user_id,

2550: l_request_id,
2551: l_program_application_id,
2552: l_program_id,
2553: l_program_date,
2554: fnd_global.user_id,
2555: fnd_global.login_id,
2556: l_approval_group_id);
2557:
2558: l_progress := '030';

Line 2555: fnd_global.login_id,

2551: l_program_application_id,
2552: l_program_id,
2553: l_program_date,
2554: fnd_global.user_id,
2555: fnd_global.login_id,
2556: l_approval_group_id);
2557:
2558: l_progress := '030';
2559:

Line 2725: l_session_user_id := fnd_global.user_id;

2721: --Bug 5389914
2722: --Fnd_Profile.Get('USER_ID',l_session_user_id);
2723: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
2724: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
2725: l_session_user_id := fnd_global.user_id;
2726: l_session_resp_id := fnd_global.resp_id;
2727: l_session_appl_id := fnd_global.resp_appl_id;
2728:
2729: IF (l_session_user_id = -1) THEN

Line 2726: l_session_resp_id := fnd_global.resp_id;

2722: --Fnd_Profile.Get('USER_ID',l_session_user_id);
2723: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
2724: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
2725: l_session_user_id := fnd_global.user_id;
2726: l_session_resp_id := fnd_global.resp_id;
2727: l_session_appl_id := fnd_global.resp_appl_id;
2728:
2729: IF (l_session_user_id = -1) THEN
2730: l_session_user_id := NULL;

Line 2727: l_session_appl_id := fnd_global.resp_appl_id;

2723: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
2724: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
2725: l_session_user_id := fnd_global.user_id;
2726: l_session_resp_id := fnd_global.resp_id;
2727: l_session_appl_id := fnd_global.resp_appl_id;
2728:
2729: IF (l_session_user_id = -1) THEN
2730: l_session_user_id := NULL;
2731: END IF;

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

3028: and flv.LANGUAGE = fl.language_code
3029: and flv.lookup_type='REQUISITION TYPE'
3030: and flv.lookup_code = p_doc_subtype
3031: and VIEW_APPLICATION_ID = 201
3032: and SECURITY_GROUP_ID = fnd_global.lookup_security_group('REQUISITION TYPE',201);
3033: */
3034:
3035: BEGIN
3036: l_progress := 'GetDisplayValue: 001, user name: ' || username;