DBA Data[Home] [Help]

APPS.POR_AME_APPROVAL_LIST dependencies on FND_USER

Line 230: -- FND users cannot be set as first authority approver. So no need to check for the value 'FND'

226: -- then we need to find out the position id of the given approver and frame the new approver record.
227: -- We also set the columns first_position_id and first_approver_id in po_requisition_headers_all
228: -- If the first approver record is of emp supervisor action type,
229: -- then we simply frame the new approver record from the input parameters.
230: -- FND users cannot be set as first authority approver. So no need to check for the value 'FND'
231:
232: if currentFirstApprover.orig_system = ame_util.posOrigSystem then
233:
234: if g_fnd_debug = 'Y' then

Line 2026: -- FND = FND Users --> approverRecord.orig_system_id will be user_id

2022:
2023: -- approverRecord.orig_system can have 3 values like following.
2024: -- PER = Employee Supervisor action type --> approverRecord.orig_system_id will be person_id
2025: -- POS = Position Hierarchy --> approverRecord.orig_system_id will be position_id
2026: -- FND = FND Users --> approverRecord.orig_system_id will be user_id
2027:
2028: --Parameters:
2029: --IN:
2030: -- approversTableIn Approvers List

Line 3055: -- FND User Record.

3051: END;
3052:
3053: elsif (l_orig_system = ame_util.fndUserOrigSystem) then
3054:
3055: -- FND User Record.
3056: if g_fnd_debug = 'Y' then
3057: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3058: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'FND User Record ...');
3059: END IF;

Line 3058: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'FND User Record ...');

3054:
3055: -- FND User Record.
3056: if g_fnd_debug = 'Y' then
3057: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3058: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'FND User Record ...');
3059: END IF;
3060: end if;
3061: SELECT employee_id into l_person_id
3062: FROM fnd_user

Line 3062: FROM fnd_user

3058: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'FND User Record ...');
3059: END IF;
3060: end if;
3061: SELECT employee_id into l_person_id
3062: FROM fnd_user
3063: WHERE user_id = l_orig_system_id
3064: and trunc(sysdate) between start_date and nvl(end_date, sysdate+1);
3065:
3066: l_full_name := approverList(i).display_name;

Line 3408: -- FND User Record.

3404: end if;
3405:
3406: elsif (p_origSystem = ame_util.fndUserOrigSystem) then
3407:
3408: -- FND User Record.
3409: if p_logFlag = 'Y' then
3410: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3411: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' FND User Record ...');
3412: END IF;

Line 3411: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' FND User Record ...');

3407:
3408: -- FND User Record.
3409: if p_logFlag = 'Y' then
3410: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
3411: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' FND User Record ...');
3412: END IF;
3413: end if;
3414:
3415: SELECT employee_id

Line 3417: FROM fnd_user

3413: end if;
3414:
3415: SELECT employee_id
3416: into x_personId
3417: FROM fnd_user
3418: WHERE user_id = p_origSystemId
3419: and trunc(sysdate) between start_date and nvl(end_date, sysdate+1);
3420:
3421: x_fullName := p_displayName;