APPS.OKC_REP_UTIL_PVT dependencies on FND_USER

Line 443: l_user_id FND_USER.USER_ID%type;

439: l_owner_id OKC_REP_CONTRACTS_ALL.OWNER_ID%type;
440: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%type;
441: l_use_acl_flag OKC_REP_CONTRACTS_ALL.USE_ACL_FLAG%type;
442: l_result VARCHAR2(1);
443: l_user_id FND_USER.USER_ID%type;
444: l_user_name FND_USER.USER_NAME%type;
445:
446: CURSOR intents_csr(p_contract_type IN VARCHAR2) IS
447: SELECT NULL

Line 444: l_user_name FND_USER.USER_NAME%type;

440: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%type;
441: l_use_acl_flag OKC_REP_CONTRACTS_ALL.USE_ACL_FLAG%type;
442: l_result VARCHAR2(1);
443: l_user_id FND_USER.USER_ID%type;
444: l_user_name FND_USER.USER_NAME%type;
445:
446: CURSOR intents_csr(p_contract_type IN VARCHAR2) IS
447: SELECT NULL
448: FROM okc_bus_doc_types_b

Line 961: l_user_id FND_USER.USER_ID%type;

957: x_msg_count OUT NOCOPY NUMBER,
958: x_return_status OUT NOCOPY VARCHAR2) IS
959:
960: l_api_name VARCHAR2(30);
961: l_user_id FND_USER.USER_ID%type;
962:
963: BEGIN
964:
965: l_api_name := 'change_contract_status';

Line 1141: l_user_id FND_USER.USER_ID%type;

1137: x_msg_count OUT NOCOPY NUMBER,
1138: x_return_status OUT NOCOPY VARCHAR2) IS
1139:
1140: l_api_name VARCHAR2(30);
1141: l_user_id FND_USER.USER_ID%type;
1142:
1143: BEGIN
1144:
1145: l_api_name := 'add_approval_hist_record';

Line 3732: SELECT FND_USER.USER_ID

3728: WHERE UPPER(NAME) = UPPER(p_org_name)
3729: AND mo_global.check_access(ORGANIZATION_ID) = 'Y';
3730:
3731: CURSOR OWNER_NAME_CSR (p_owner_name VARCHAR2) IS
3732: SELECT FND_USER.USER_ID
3733: FROM FND_USER,
3734: PER_PEOPLE_F
3735: WHERE FND_USER.EMPLOYEE_ID = PER_PEOPLE_F.PERSON_ID
3736: AND UPPER(FND_USER.USER_NAME) = UPPER(p_owner_name);

Line 3733: FROM FND_USER,

3729: AND mo_global.check_access(ORGANIZATION_ID) = 'Y';
3730:
3731: CURSOR OWNER_NAME_CSR (p_owner_name VARCHAR2) IS
3732: SELECT FND_USER.USER_ID
3733: FROM FND_USER,
3734: PER_PEOPLE_F
3735: WHERE FND_USER.EMPLOYEE_ID = PER_PEOPLE_F.PERSON_ID
3736: AND UPPER(FND_USER.USER_NAME) = UPPER(p_owner_name);
3737:

Line 3735: WHERE FND_USER.EMPLOYEE_ID = PER_PEOPLE_F.PERSON_ID

3731: CURSOR OWNER_NAME_CSR (p_owner_name VARCHAR2) IS
3732: SELECT FND_USER.USER_ID
3733: FROM FND_USER,
3734: PER_PEOPLE_F
3735: WHERE FND_USER.EMPLOYEE_ID = PER_PEOPLE_F.PERSON_ID
3736: AND UPPER(FND_USER.USER_NAME) = UPPER(p_owner_name);
3737:
3738: CURSOR CURRENCY_CSR (p_currency_code VARCHAR2) IS
3739: SELECT CURRENCY_CODE

Line 3736: AND UPPER(FND_USER.USER_NAME) = UPPER(p_owner_name);

3732: SELECT FND_USER.USER_ID
3733: FROM FND_USER,
3734: PER_PEOPLE_F
3735: WHERE FND_USER.EMPLOYEE_ID = PER_PEOPLE_F.PERSON_ID
3736: AND UPPER(FND_USER.USER_NAME) = UPPER(p_owner_name);
3737:
3738: CURSOR CURRENCY_CSR (p_currency_code VARCHAR2) IS
3739: SELECT CURRENCY_CODE
3740: FROM FND_CURRENCIES

Line 4296: --Owner User Name should resolve to a valid FND User ID

4292: END IF;
4293: END IF;
4294:
4295: --If l_valid_flag is already set to 'N', we do not perform any more checks
4296: --Owner User Name should resolve to a valid FND User ID
4297: --Also, the owner needs to be an employee
4298: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4299: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4300: 'Checking if owner user name is valid');