DBA Data[Home] [Help]

APPS.POS_SPM_WF_PKG1 dependencies on FND_GLOBAL

Line 58: REPLACE(p_text, fnd_global.newline || fnd_global.newline, '

'),

54: -- Avoid using local variables to save space.
55: --
56: RETURN
57: REPLACE(
58: REPLACE(p_text, fnd_global.newline || fnd_global.newline, '

'),
59: fnd_global.newline,
60: '
');
61: END to_html;
62: --

Line 59: fnd_global.newline,

55: --
56: RETURN
57: REPLACE(
58: REPLACE(p_text, fnd_global.newline || fnd_global.newline, '

'),
59: fnd_global.newline,
60: '
');
61: END to_html;
62: --
63: -- End Supplier Hub: OSN Integration

Line 277: get_user_name(fnd_global.user_id, x_first_name, x_last_name);

273: (x_first_name OUT nocopy VARCHAR2,
274: x_last_name OUT nocopy VARCHAR2)
275: IS
276: BEGIN
277: get_user_name(fnd_global.user_id, x_first_name, x_last_name);
278: END get_current_user_name;
279:
280: PROCEDURE get_user_company_name
281: (p_username IN VARCHAR2,

Line 314: get_user_company_name(fnd_global.user_name, x_company_name);

310: PROCEDURE get_current_user_company_name
311: (x_company_name OUT nocopy VARCHAR2)
312: IS
313: BEGIN
314: get_user_company_name(fnd_global.user_name, x_company_name);
315: END get_current_user_company_name;
316:
317: -- This is a private procedure for setting up the
318: -- value for the , of

Line 1589: l_user_id := fnd_global.user_id;

1585: l_name_rec l_name_cur%ROWTYPE;
1586: l_found_email BOOLEAN;
1587: l_found_name BOOLEAN;
1588: BEGIN
1589: l_user_id := fnd_global.user_id;
1590: l_found_email := FALSE;
1591: l_found_name := FALSE;
1592: OPEN l_email_cur;
1593: FETCH l_email_cur INTO l_email_rec;

Line 3181: SELECT USER_NAME INTO L_FROM_NAME FROM FND_USER WHERE USER_ID=FND_GLOBAL.USER_ID;

3177: -- Assigning ADHOC User to ADHOC Role
3178: ADDUSERTOADHOCROLE(l_receiver,L_ADHOC_USER);
3179:
3180: -- GET THE CURRENT USER NAME
3181: SELECT USER_NAME INTO L_FROM_NAME FROM FND_USER WHERE USER_ID=FND_GLOBAL.USER_ID;
3182:
3183: -- GENERATING THE PROCESS KEY
3184: GET_WF_ITEM_KEY (l_process,To_char(p_supplier_reg_id),L_ITEMKEY);
3185:

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

3812: document IN OUT NOCOPY CLOB,
3813: document_type IN OUT NOCOPY VARCHAR2)
3814: IS
3815:
3816: NL VARCHAR2(1) := fnd_global.newline;
3817: l_document VARCHAR2(32000) := '';
3818: l_note VARCHAR2(32000) := '';
3819: l_enterprisename VARCHAR2(1000) := '';
3820: l_url VARCHAR2(3000) := '';