APPS.DPP_APPROVAL_PVT dependencies on FND_PROFILE

Line 484: x_approvers(1).approver_id := to_number(fnd_profile.value('DPP_TXN_DEFAULT_APPROVER'));

480: x_approvers.extend;
481: x_approvers(1).approver_type := 'USER';
482: -- get user from profile (default approver)
483: IF p_approval_rec.object_type = 'PRICE PROTECTION' THEN
484: x_approvers(1).approver_id := to_number(fnd_profile.value('DPP_TXN_DEFAULT_APPROVER'));
485: END IF;
486: x_approvers(1).approver_level := 0;
487: x_final_approval_flag := 'N';
488:

Line 665: l_approver_id := to_number(fnd_profile.value('DPP_TXN_DEFAULT_APPROVER'));

661: dpp_utility_pvt.debug_message(FND_LOG.LEVEL_STATEMENT, l_module, 'Get the default approver from the profile value');
662:
663: -- Get default approver from profile (default approver)
664: IF p_approval_rec.object_type = 'PRICE PROTECTION' THEN
665: l_approver_id := to_number(fnd_profile.value('DPP_TXN_DEFAULT_APPROVER'));
666: --Retrieve the first name and the last name of the approver from the per_persons_f table.
667: BEGIN
668: SELECT first_name,
669: last_name

Line 1388: l_user_id := fnd_profile.value('USER_ID');

1384: BEGIN
1385: l_rang := 0;
1386:
1387: IF l_user_id IS NULL THEN
1388: l_user_id := fnd_profile.value('USER_ID');
1389: END IF;
1390:
1391: l_param := WF_PARAMETER_T( NULL, NULL );
1392: -- fill the parameters list

Line 1400: l_resp_id := fnd_profile.value('RESP_ID');

1396: l_rang := l_rang + 1;
1397: x_list(l_rang) := l_param;
1398:
1399: IF l_resp_id IS NULL THEN
1400: l_resp_id := fnd_profile.value('RESP_ID');
1401: END IF;
1402:
1403: l_param := WF_PARAMETER_T( NULL, NULL );
1404: -- fill the parameters list

Line 1412: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');

1408: l_rang := l_rang + 1;
1409: x_list(l_rang) := l_param;
1410:
1411: IF l_resp_appl_id IS NULL THEN
1412: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
1413: END IF;
1414:
1415: l_param := WF_PARAMETER_T( NULL, NULL );
1416: -- fill the parameters list

Line 1424: l_security_group_id := fnd_profile.value('SECURITY_GROUP_ID');

1420: l_rang := l_rang + 1;
1421: x_list(l_rang) := l_param;
1422:
1423: IF l_security_group_id IS NULL THEN
1424: l_security_group_id := fnd_profile.value('SECURITY_GROUP_ID');
1425: END IF;
1426: l_param := WF_PARAMETER_T( NULL, NULL );
1427: -- fill the parameters list
1428: x_list.extend;

Line 1435: l_org_id := fnd_profile.value('ORG_ID');

1431: l_rang := l_rang + 1;
1432: x_list(l_rang) := l_param;
1433:
1434: IF l_org_id IS NULL THEN
1435: l_org_id := fnd_profile.value('ORG_ID');
1436: END IF;
1437:
1438: l_param := WF_PARAMETER_T( NULL, NULL );
1439: -- fill the parameters list

Line 1881: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');

1877: l_org_id NUMBER;
1878: errbuff VARCHAR2(4000);
1879: retcode VARCHAR2(10);
1880: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1881: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
1882: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_APPROVAL_PVT.PROCESS_USER_ACTION';
1883:
1884: BEGIN
1885: -- Standard begin of API savepoint