DBA Data[Home] [Help]

APPS.OZF_FUND_APPROVAL_PVT dependencies on FND_GLOBAL

Line 206: || fnd_global.local_chr (10)

202: ,aname => 'AMS_FORWARD_FROM_USERNAME');
203: */
204: -- IF (display_type = 'text/plain') THEN
205: l_fyi_notification := SUBSTR(l_string
206: || fnd_global.local_chr (10)
207: || l_string1
208: || fnd_global.local_chr (10)
209: || l_string2,1,10000);
210: document := document

Line 208: || fnd_global.local_chr (10)

204: -- IF (display_type = 'text/plain') THEN
205: l_fyi_notification := SUBSTR(l_string
206: || fnd_global.local_chr (10)
207: || l_string1
208: || fnd_global.local_chr (10)
209: || l_string2,1,10000);
210: document := document
211: || l_fyi_notification;
212: document_type := 'text/plain';

Line 218: FND_GLOBAL.LOCAL_CHR(10) ||

214: -- END IF;
215: /* IF (display_type = 'text/html') THEN
216: l_fyi_notification :=
217: l_string ||
218: FND_GLOBAL.LOCAL_CHR(10) ||
219: l_string1 ||
220: FND_GLOBAL.LOCAL_CHR(10) ||
221: l_string2;
222: document := document||l_appreq_notification;

Line 220: FND_GLOBAL.LOCAL_CHR(10) ||

216: l_fyi_notification :=
217: l_string ||
218: FND_GLOBAL.LOCAL_CHR(10) ||
219: l_string1 ||
220: FND_GLOBAL.LOCAL_CHR(10) ||
221: l_string2;
222: document := document||l_appreq_notification;
223: document_type := 'text/html';
224: RETURN;

Line 432: || fnd_global.local_chr (10)

428: l_string2 := fnd_message.get;
429: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL */
430: -- IF (display_type = 'text/plain') THEN
431: l_appr_notification := SUBSTR(l_string
432: || fnd_global.local_chr (10)
433: || l_string1
434: || fnd_global.local_chr (10)
435: || l_string2,1,10000);
436: document := document

Line 434: || fnd_global.local_chr (10)

430: -- IF (display_type = 'text/plain') THEN
431: l_appr_notification := SUBSTR(l_string
432: || fnd_global.local_chr (10)
433: || l_string1
434: || fnd_global.local_chr (10)
435: || l_string2,1,10000);
436: document := document
437: || l_appr_notification;
438: document_type := 'text/plain';

Line 444: FND_GLOBAL.LOCAL_CHR(10) ||

440: -- END IF;
441: /* IF (display_type = 'text/html') THEN
442: l_appreq_notification :=
443: l_string ||
444: FND_GLOBAL.LOCAL_CHR(10) ||
445: l_string1 ||
446: FND_GLOBAL.LOCAL_CHR(10) ||
447: l_string2;
448: document := document||l_appreq_notification;

Line 446: FND_GLOBAL.LOCAL_CHR(10) ||

442: l_appreq_notification :=
443: l_string ||
444: FND_GLOBAL.LOCAL_CHR(10) ||
445: l_string1 ||
446: FND_GLOBAL.LOCAL_CHR(10) ||
447: l_string2;
448: document := document||l_appreq_notification;
449: document_type := 'text/html';
450: RETURN;

Line 643: || fnd_global.local_chr (10)

639: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
640: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
641: -- IF (display_type = 'text/plain') THEN
642: l_rej_notification := SUBSTR(l_string
643: || fnd_global.local_chr (10)
644: || l_string1
645: || fnd_global.local_chr (10)
646: || l_string2,1,10000);
647: document := document

Line 645: || fnd_global.local_chr (10)

641: -- IF (display_type = 'text/plain') THEN
642: l_rej_notification := SUBSTR(l_string
643: || fnd_global.local_chr (10)
644: || l_string1
645: || fnd_global.local_chr (10)
646: || l_string2,1,10000);
647: document := document
648: || l_rej_notification;
649: document_type := 'text/plain';

Line 861: || fnd_global.local_chr (10)

857: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
858: l_string2 := SUBSTR(fnd_message.get,1,2500);
859: -- IF (display_type = 'text/plain') THEN
860: l_appreq_notification := l_string
861: || fnd_global.local_chr (10)
862: || l_string1
863: || fnd_global.local_chr (10)
864: || l_string2;
865: document := document

Line 863: || fnd_global.local_chr (10)

859: -- IF (display_type = 'text/plain') THEN
860: l_appreq_notification := l_string
861: || fnd_global.local_chr (10)
862: || l_string1
863: || fnd_global.local_chr (10)
864: || l_string2;
865: document := document
866: || l_appreq_notification;
867: document_type := 'text/plain';

Line 873: FND_GLOBAL.LOCAL_CHR(10) ||

869: -- END IF;
870: /* IF (display_type = 'text/html') THEN
871: l_appreq_notification :=
872: l_string ||
873: FND_GLOBAL.LOCAL_CHR(10) ||
874: l_string1 ||
875: FND_GLOBAL.LOCAL_CHR(10) ||
876: l_string2;
877: document := document||l_appreq_notification;

Line 875: FND_GLOBAL.LOCAL_CHR(10) ||

871: l_appreq_notification :=
872: l_string ||
873: FND_GLOBAL.LOCAL_CHR(10) ||
874: l_string1 ||
875: FND_GLOBAL.LOCAL_CHR(10) ||
876: l_string2;
877: document := document||l_appreq_notification;
878: document_type := 'text/html';
879: RETURN;

Line 1087: || fnd_global.local_chr (10)

1083: ,aname => 'AMS_FORWARD_FROM_USERNAME');
1084: */
1085: -- IF (display_type = 'text/plain') THEN
1086: l_apprem_notification := l_string
1087: || fnd_global.local_chr (10)
1088: || l_string1
1089: || fnd_global.local_chr (10)
1090: || l_string2;
1091: document := document

Line 1089: || fnd_global.local_chr (10)

1085: -- IF (display_type = 'text/plain') THEN
1086: l_apprem_notification := l_string
1087: || fnd_global.local_chr (10)
1088: || l_string1
1089: || fnd_global.local_chr (10)
1090: || l_string2;
1091: document := document
1092: || l_apprem_notification;
1093: document_type := 'text/plain';

Line 1099: FND_GLOBAL.LOCAL_CHR(10) ||

1095: -- END IF;
1096: /* IF (display_type = 'text/html') THEN
1097: l_appreq_notification :=
1098: l_string ||
1099: FND_GLOBAL.LOCAL_CHR(10) ||
1100: l_string1 ||
1101: FND_GLOBAL.LOCAL_CHR(10) ||
1102: l_string2;
1103: document := document||l_appreq_notification;

Line 1101: FND_GLOBAL.LOCAL_CHR(10) ||

1097: l_appreq_notification :=
1098: l_string ||
1099: FND_GLOBAL.LOCAL_CHR(10) ||
1100: l_string1 ||
1101: FND_GLOBAL.LOCAL_CHR(10) ||
1102: l_string2;
1103: document := document||l_appreq_notification;
1104: document_type := 'text/html';
1105: RETURN;

Line 1587: l_user_id := FND_GLOBAL.user_id;

1583: );
1584: -- [BEGIN OF BUG 2916480 FIXING by yzhao 23-APR-2003]
1585: -- yzhao: initialized PL/SQL security context(especially application_id)
1586: -- since self service workflow didn't set application_id when approver approves.
1587: l_user_id := FND_GLOBAL.user_id;
1588: l_resp_id := FND_GLOBAL.resp_id;
1589: l_appl_id := FND_GLOBAL.resp_appl_id;
1590: l_security_group_id := FND_GLOBAL.security_group_id;
1591: IF (l_appl_id IS NULL OR l_appl_id = 0) THEN

Line 1588: l_resp_id := FND_GLOBAL.resp_id;

1584: -- [BEGIN OF BUG 2916480 FIXING by yzhao 23-APR-2003]
1585: -- yzhao: initialized PL/SQL security context(especially application_id)
1586: -- since self service workflow didn't set application_id when approver approves.
1587: l_user_id := FND_GLOBAL.user_id;
1588: l_resp_id := FND_GLOBAL.resp_id;
1589: l_appl_id := FND_GLOBAL.resp_appl_id;
1590: l_security_group_id := FND_GLOBAL.security_group_id;
1591: IF (l_appl_id IS NULL OR l_appl_id = 0) THEN
1592: l_appl_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype

Line 1589: l_appl_id := FND_GLOBAL.resp_appl_id;

1585: -- yzhao: initialized PL/SQL security context(especially application_id)
1586: -- since self service workflow didn't set application_id when approver approves.
1587: l_user_id := FND_GLOBAL.user_id;
1588: l_resp_id := FND_GLOBAL.resp_id;
1589: l_appl_id := FND_GLOBAL.resp_appl_id;
1590: l_security_group_id := FND_GLOBAL.security_group_id;
1591: IF (l_appl_id IS NULL OR l_appl_id = 0) THEN
1592: l_appl_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1593: , itemkey => itemkey

Line 1590: l_security_group_id := FND_GLOBAL.security_group_id;

1586: -- since self service workflow didn't set application_id when approver approves.
1587: l_user_id := FND_GLOBAL.user_id;
1588: l_resp_id := FND_GLOBAL.resp_id;
1589: l_appl_id := FND_GLOBAL.resp_appl_id;
1590: l_security_group_id := FND_GLOBAL.security_group_id;
1591: IF (l_appl_id IS NULL OR l_appl_id = 0) THEN
1592: l_appl_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1593: , itemkey => itemkey
1594: , aname => 'APPLICATION_ID'

Line 1596: FND_GLOBAL.apps_initialize( user_id => l_user_id

1592: l_appl_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1593: , itemkey => itemkey
1594: , aname => 'APPLICATION_ID'
1595: );
1596: FND_GLOBAL.apps_initialize( user_id => l_user_id
1597: , resp_id => l_resp_id
1598: , resp_appl_id => l_appl_id
1599: --, security_group_id => l_security_group_id
1600: );