APPS.DPP_APPROVAL_PVT dependencies on FND_PROFILE

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

462: x_approvers.extend;
463: x_approvers(1).approver_type := 'USER';
464: -- get user from profile (default approver)
465: IF p_approval_rec.object_type = 'PRICE PROTECTION' THEN
466: x_approvers(1).approver_id := to_number(fnd_profile.value('DPP_TXN_DEFAULT_APPROVER'));
467: END IF;
468: x_approvers(1).approver_level := 0;
469: x_final_approval_flag := 'N';
470:

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

621: dpp_utility_pvt.debug_message( 'Get the default approver from the profile value');
622: END IF;
623: -- Get default approver from profile (default approver)
624: IF p_approval_rec.object_type = 'PRICE PROTECTION' THEN
625: l_approver_id := to_number(fnd_profile.value('DPP_TXN_DEFAULT_APPROVER'));
626: --Retrieve the first name and the last name of the approver from the per_persons_f table.
627: BEGIN
628: SELECT first_name,
629: last_name

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

1222: BEGIN
1223: l_rang := 0;
1224:
1225: IF l_user_id IS NULL THEN
1226: l_user_id := fnd_profile.value('USER_ID');
1227: END IF;
1228:
1229: l_param := WF_PARAMETER_T( NULL, NULL );
1230: -- fill the parameters list

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

1234: l_rang := l_rang + 1;
1235: x_list(l_rang) := l_param;
1236:
1237: IF l_resp_id IS NULL THEN
1238: l_resp_id := fnd_profile.value('RESP_ID');
1239: END IF;
1240:
1241: l_param := WF_PARAMETER_T( NULL, NULL );
1242: -- fill the parameters list

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

1246: l_rang := l_rang + 1;
1247: x_list(l_rang) := l_param;
1248:
1249: IF l_resp_appl_id IS NULL THEN
1250: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
1251: END IF;
1252:
1253: l_param := WF_PARAMETER_T( NULL, NULL );
1254: -- fill the parameters list

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

1258: l_rang := l_rang + 1;
1259: x_list(l_rang) := l_param;
1260:
1261: IF l_security_group_id IS NULL THEN
1262: l_security_group_id := fnd_profile.value('SECURITY_GROUP_ID');
1263: END IF;
1264: l_param := WF_PARAMETER_T( NULL, NULL );
1265: -- fill the parameters list
1266: x_list.extend;

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

1269: l_rang := l_rang + 1;
1270: x_list(l_rang) := l_param;
1271:
1272: IF l_org_id IS NULL THEN
1273: l_org_id := fnd_profile.value('ORG_ID');
1274: END IF;
1275:
1276: l_param := WF_PARAMETER_T( NULL, NULL );
1277: -- fill the parameters list

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

1727: l_org_id NUMBER;
1728: errbuff VARCHAR2(4000);
1729: retcode VARCHAR2(10);
1730: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
1731: l_user_id NUMBER := FND_PROFILE.VALUE('USER_ID');
1732:
1733: BEGIN
1734: -- Standard begin of API savepoint
1735: SAVEPOINT Process_User_Action_PVT;