DBA Data[Home] [Help]

APPS.OZF_CLAIM_APPROVAL_PVT dependencies on FND_GLOBAL

Line 515: -- l_fyi_notification := l_subject || FND_GLOBAL.LOCAL_CHR(10) || l_body;

511: ,itemkey => l_item_key
512: ,aname => 'OZF_FORWARD_FROM_USERNAME');
513: */
514: -- IF (display_type = 'text/plain') THEN
515: -- l_fyi_notification := l_subject || FND_GLOBAL.LOCAL_CHR(10) || l_body;
516: l_fyi_notification := l_body;
517: document := document || l_fyi_notification;
518: document_type := 'text/plain';
519: RETURN;

Line 524: FND_GLOBAL.LOCAL_CHR(10) ||

520: -- END IF;
521: /*
522: IF (display_type = 'text/html') THEN
523: l_fyi_notification := l_string ||
524: FND_GLOBAL.LOCAL_CHR(10) ||
525: l_string1 ||
526: FND_GLOBAL.LOCAL_CHR(10) ||
527: l_string2;
528: document := document||l_appreq_notification;

Line 526: FND_GLOBAL.LOCAL_CHR(10) ||

522: IF (display_type = 'text/html') THEN
523: l_fyi_notification := l_string ||
524: FND_GLOBAL.LOCAL_CHR(10) ||
525: l_string1 ||
526: FND_GLOBAL.LOCAL_CHR(10) ||
527: l_string2;
528: document := document||l_appreq_notification;
529: document_type := 'text/html';
530: RETURN;

Line 815: -- l_appreq_notification := l_subject || FND_GLOBAL.LOCAL_CHR(10) || l_body;

811: -- ,aname => 'AMS_FORWARD_FROM_USERNAME');
812: */
813:
814: -- IF (display_type = 'text/plain') THEN
815: -- l_appreq_notification := l_subject || FND_GLOBAL.LOCAL_CHR(10) || l_body;
816:
817: l_appreq_notification := l_body;
818: document := document || l_appreq_notification;
819: document_type := 'text/plain';

Line 827: -- FND_GLOBAL.LOCAL_CHR(10) ||

823:
824: /*
825: -- IF (display_type = 'text/html') THEN
826: -- l_appreq_notification := l_string ||
827: -- FND_GLOBAL.LOCAL_CHR(10) ||
828: -- l_string1 ||
829: -- FND_GLOBAL.LOCAL_CHR(10) ||
830: -- l_string2;
831: -- document := document||l_appreq_notification;

Line 829: -- FND_GLOBAL.LOCAL_CHR(10) ||

825: -- IF (display_type = 'text/html') THEN
826: -- l_appreq_notification := l_string ||
827: -- FND_GLOBAL.LOCAL_CHR(10) ||
828: -- l_string1 ||
829: -- FND_GLOBAL.LOCAL_CHR(10) ||
830: -- l_string2;
831: -- document := document||l_appreq_notification;
832: -- document_type := 'text/html';
833: -- RETURN;

Line 1072: -- l_apprem_notification := l_subject || FND_GLOBAL.LOCAL_CHR(10) || l_body;

1068: ,itemkey => l_item_key
1069: ,aname => 'OZF_FORWARD_FROM_USERNAME');
1070: */
1071: -- IF (display_type = 'text/plain') THEN
1072: -- l_apprem_notification := l_subject || FND_GLOBAL.LOCAL_CHR(10) || l_body;
1073: l_apprem_notification := l_body;
1074: document := document || l_apprem_notification;
1075: document_type := 'text/plain';
1076: RETURN;

Line 1082: FND_GLOBAL.LOCAL_CHR(10) ||

1078:
1079: /*
1080: IF (display_type = 'text/html') THEN
1081: l_appreq_notification := l_string ||
1082: FND_GLOBAL.LOCAL_CHR(10) ||
1083: l_string1 ||
1084: FND_GLOBAL.LOCAL_CHR(10) ||
1085: l_string2;
1086: document := document||l_appreq_notification;

Line 1084: FND_GLOBAL.LOCAL_CHR(10) ||

1080: IF (display_type = 'text/html') THEN
1081: l_appreq_notification := l_string ||
1082: FND_GLOBAL.LOCAL_CHR(10) ||
1083: l_string1 ||
1084: FND_GLOBAL.LOCAL_CHR(10) ||
1085: l_string2;
1086: document := document||l_appreq_notification;
1087: document_type := 'text/html';
1088: RETURN;

Line 1329: -- l_appr_notification := l_subject || FND_GLOBAL.LOCAL_CHR(10) || l_body;

1325: ,itemkey => l_item_key
1326: ,aname => 'OZF_FORWARD_FROM_USERNAME');
1327: */
1328: -- IF (display_type = 'text/plain') THEN
1329: -- l_appr_notification := l_subject || FND_GLOBAL.LOCAL_CHR(10) || l_body;
1330: l_appr_notification := l_body;
1331: document := document || l_appr_notification;
1332: document_type := 'text/plain';
1333: RETURN;

Line 1339: FND_GLOBAL.LOCAL_CHR(10) ||

1335:
1336: /*
1337: IF (display_type = 'text/html') THEN
1338: l_appreq_notification := l_string ||
1339: FND_GLOBAL.LOCAL_CHR(10) ||
1340: l_string1 ||
1341: FND_GLOBAL.LOCAL_CHR(10) ||
1342: l_string2;
1343: document := document||l_appreq_notification;

Line 1341: FND_GLOBAL.LOCAL_CHR(10) ||

1337: IF (display_type = 'text/html') THEN
1338: l_appreq_notification := l_string ||
1339: FND_GLOBAL.LOCAL_CHR(10) ||
1340: l_string1 ||
1341: FND_GLOBAL.LOCAL_CHR(10) ||
1342: l_string2;
1343: document := document||l_appreq_notification;
1344: document_type := 'text/html';
1345: RETURN;

Line 1585: -- l_rej_notification := l_subject || FND_GLOBAL.LOCAL_CHR(10) || l_body;

1581: ,itemkey => l_item_key
1582: ,aname => 'AMS_FORWARD_FROM_USERNAME');
1583: */
1584: -- IF (display_type = 'text/plain') THEN
1585: -- l_rej_notification := l_subject || FND_GLOBAL.LOCAL_CHR(10) || l_body;
1586: l_rej_notification := l_body;
1587: document := document || l_rej_notification;
1588: document_type := 'text/plain';
1589: RETURN;

Line 1595: FND_GLOBAL.LOCAL_CHR(10) ||

1591:
1592: /*
1593: IF (display_type = 'text/html') THEN
1594: l_appreq_notification := l_string ||
1595: FND_GLOBAL.LOCAL_CHR(10) ||
1596: l_string1 ||
1597: FND_GLOBAL.LOCAL_CHR(10) ||
1598: l_string2;
1599: document := document||l_appreq_notification;

Line 1597: FND_GLOBAL.LOCAL_CHR(10) ||

1593: IF (display_type = 'text/html') THEN
1594: l_appreq_notification := l_string ||
1595: FND_GLOBAL.LOCAL_CHR(10) ||
1596: l_string1 ||
1597: FND_GLOBAL.LOCAL_CHR(10) ||
1598: l_string2;
1599: document := document||l_appreq_notification;
1600: document_type := 'text/html';
1601: RETURN;

Line 2319: FND_GLOBAL.apps_initialize( user_id => l_user_id

2315: );
2316: resultout := 'COMPLETE:ERROR';
2317: RETURN;
2318: ELSIF l_update_status IN ('APPROVED', 'REJECTED') THEN
2319: FND_GLOBAL.apps_initialize( user_id => l_user_id
2320: , resp_id => l_resp_id
2321: , resp_appl_id => l_appl_id
2322: --, security_group_id => l_security_group_id
2323: );

Line 2595: settled_by = NVL(FND_GLOBAL.user_id,-1), --//Bugfix : 8202109

2591: SET amount_settled = l_amt_settled,
2592: amount_remaining = l_amt -(l_amt_adjusted + l_amt_settled),
2593: acctd_amount_settled = l_act_amt_settled,
2594: acctd_amount_remaining = l_act_amt - (l_act_amt_adjusted + l_act_amt_settled),
2595: settled_by = NVL(FND_GLOBAL.user_id,-1), --//Bugfix : 8202109
2596: settled_date = TRUNC(SYSDATE)
2597: WHERE claim_id = l_claim_id1;
2598: EXIT WHEN p_acctd_claim_amts%NOTFOUND;
2599: END LOOP;