APPS.OZF_APPROVAL_PVT dependencies on FND_PROFILE

Line 566: x_approvers(1).approver_id := to_number(fnd_profile.value('OZF_SP_DEFAULT_APPROVER'));

562: x_approvers.extend;
563: x_approvers(1).approver_type := 'USER';
564: -- get user from profile (defaulat approver)
565: IF p_approval_rec.object_type = 'SPECIAL_PRICE' THEN
566: x_approvers(1).approver_id := to_number(fnd_profile.value('OZF_SP_DEFAULT_APPROVER'));
567: ELSIF p_approval_rec.object_type = 'SOFT_FUND' THEN
568: x_approvers(1).approver_id := to_number(fnd_profile.value('OZF_SF_DEFAULT_APPROVER'));
569: END IF;
570:

Line 568: x_approvers(1).approver_id := to_number(fnd_profile.value('OZF_SF_DEFAULT_APPROVER'));

564: -- get user from profile (defaulat approver)
565: IF p_approval_rec.object_type = 'SPECIAL_PRICE' THEN
566: x_approvers(1).approver_id := to_number(fnd_profile.value('OZF_SP_DEFAULT_APPROVER'));
567: ELSIF p_approval_rec.object_type = 'SOFT_FUND' THEN
568: x_approvers(1).approver_id := to_number(fnd_profile.value('OZF_SF_DEFAULT_APPROVER'));
569: END IF;
570:
571:
572: x_approvers(1).approver_level := 0;

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

1045: BEGIN
1046: l_rang := 0;
1047:
1048: IF l_user_id IS NULL THEN
1049: l_user_id := fnd_profile.value('USER_ID');
1050: END IF;
1051:
1052: l_param := WF_PARAMETER_T( NULL, NULL );
1053: -- fill the parameters list

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

1057: l_rang := l_rang + 1;
1058: x_list(l_rang) := l_param;
1059:
1060: IF l_resp_id IS NULL THEN
1061: l_resp_id := fnd_profile.value('RESP_ID');
1062: END IF;
1063:
1064: l_param := WF_PARAMETER_T( NULL, NULL );
1065: -- fill the parameters list

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

1069: l_rang := l_rang + 1;
1070: x_list(l_rang) := l_param;
1071:
1072: IF l_resp_appl_id IS NULL THEN
1073: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
1074: END IF;
1075:
1076: l_param := WF_PARAMETER_T( NULL, NULL );
1077: -- fill the parameters list

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

1081: l_rang := l_rang + 1;
1082: x_list(l_rang) := l_param;
1083:
1084: IF l_security_group_id IS NULL THEN
1085: l_security_group_id := fnd_profile.value('SECURITY_GROUP_ID');
1086: END IF;
1087: l_param := WF_PARAMETER_T( NULL, NULL );
1088: -- fill the parameters list
1089: x_list.extend;

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

1092: l_rang := l_rang + 1;
1093: x_list(l_rang) := l_param;
1094:
1095: IF l_org_id IS NULL THEN
1096: l_org_id := fnd_profile.value('ORG_ID');
1097: END IF;
1098:
1099: l_param := WF_PARAMETER_T( NULL, NULL );
1100: -- fill the parameters list

Line 2157: l_user_id := to_number(fnd_profile.value('OZF_SD_DEFAULT_APPROVER'));

2153: OPEN csr_get_approver_count(p_object_id);
2154: FETCH csr_get_approver_count INTO l_approver_count;
2155: CLOSE csr_get_approver_count;
2156: IF (l_approver_count = 0) THEN
2157: l_user_id := to_number(fnd_profile.value('OZF_SD_DEFAULT_APPROVER'));
2158: OPEN csr_user_info(l_user_id);
2159: FETCH csr_user_info INTO l_resource_id;
2160: CLOSE csr_user_info;
2161: IF l_resource_id IS NOT NULL THEN