DBA Data[Home] [Help]

APPS.OKL_SSC_WF dependencies on FND_GLOBAL

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

226: l_itemtype varchar2(100);
227: l_itemkey varchar2(100);
228:
229: l_document varchar2(32000);
230: NL VARCHAR2(1) := fnd_global.newline;
231:
232:
233: BEGIN
234:

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

435: l_itemtype varchar2(100);
436: l_itemkey varchar2(100);
437:
438: l_document varchar2(32000);
439: NL VARCHAR2(1) := fnd_global.newline;
440:
441: BEGIN
442:
443: --the document_id is in the form of

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

719: l_itemtype varchar2(100);
720: l_itemkey varchar2(100);
721:
722: l_document varchar2(32000);
723: NL VARCHAR2(1) := fnd_global.newline;
724:
725: -- Bug#4274575 - smadhava - 28-Sep-2005 - Added - Start
726: l_old_location_id1 VARCHAR2(100);
727: l_new_location_id1 VARCHAR2(100);

Line 757: WHERE User_Name = FND_GLOBAL.user_name;

753: -- Added for Bug 7538507
754: CURSOR get_user_id_csr IS
755: SELECT user_id
756: FROM FND_USER
757: WHERE User_Name = FND_GLOBAL.user_name;
758:
759: disptype VARCHAR2(30); -- Bug 8974540
760:
761: BEGIN

Line 3593: open email_address_cur(FND_GLOBAL.USER_ID);

3589: open cpl_id_cur(p_khrid);
3590: fetch cpl_id_cur into x_cpl_id;
3591: close cpl_id_cur;
3592:
3593: open email_address_cur(FND_GLOBAL.USER_ID);
3594: fetch email_address_cur into x_email_address;
3595: close email_address_cur;
3596: END IF;
3597: