[Home] [Help]
441: l_owner_id OKC_REP_CONTRACTS_ALL.OWNER_ID%type;
442: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%type;
443: l_use_acl_flag OKC_REP_CONTRACTS_ALL.USE_ACL_FLAG%type;
444: l_result VARCHAR2(1);
445: l_user_id FND_USER.USER_ID%type;
446: l_user_name FND_USER.USER_NAME%type;
447: l_status_code OKC_REP_CONTRACTS_ALL.CONTRACT_STATUS_CODE%type;
448: l_sign_type OKC_REP_CONTRACTS_ALL.ESIGNATURE_REQUIRED%type;
449: l_approversOut ame_util.approversTable2;
442: l_contract_type OKC_REP_CONTRACTS_ALL.CONTRACT_TYPE%type;
443: l_use_acl_flag OKC_REP_CONTRACTS_ALL.USE_ACL_FLAG%type;
444: l_result VARCHAR2(1);
445: l_user_id FND_USER.USER_ID%type;
446: l_user_name FND_USER.USER_NAME%type;
447: l_status_code OKC_REP_CONTRACTS_ALL.CONTRACT_STATUS_CODE%type;
448: l_sign_type OKC_REP_CONTRACTS_ALL.ESIGNATURE_REQUIRED%type;
449: l_approversOut ame_util.approversTable2;
450: l_process_complete_yn varchar2(1);
478: WHERE contract_id = p_contract_id;
479:
480: CURSOR contract_signers_csr(p_contract_id in number) IS
481: SELECT usr.user_id
482: FROM okc_rep_party_contacts c, fnd_user usr
483: WHERE c.contract_id = p_contract_id
484: AND c.esignature_type = 'SELF'
485: AND usr.employee_id = c.contact_id;
486:
1038: x_msg_count OUT NOCOPY NUMBER,
1039: x_return_status OUT NOCOPY VARCHAR2) IS
1040:
1041: l_api_name VARCHAR2(30);
1042: l_user_id FND_USER.USER_ID%type;
1043:
1044: BEGIN
1045:
1046: l_api_name := 'change_contract_status';
1221: x_return_status OUT NOCOPY VARCHAR2,
1222: p_forward_user_id IN NUMBER:=NULL) IS
1223:
1224: l_api_name VARCHAR2(30);
1225: l_user_id FND_USER.USER_ID%type;
1226:
1227: BEGIN
1228:
1229: l_api_name := 'add_approval_hist_record';
1378: x_return_status OUT NOCOPY VARCHAR2,
1379: p_forward_user_id IN NUMBER:=NULL) IS
1380:
1381: l_api_name VARCHAR2(30);
1382: l_user_id FND_USER.USER_ID%type;
1383:
1384: BEGIN
1385:
1386: l_api_name := 'add_signature_hist_record';
4067: WHERE UPPER(NAME) = UPPER(p_org_name)
4068: AND mo_global.check_access(ORGANIZATION_ID) = 'Y';
4069:
4070: CURSOR OWNER_NAME_CSR (p_owner_name VARCHAR2) IS
4071: SELECT FND_USER.USER_ID
4072: FROM FND_USER,
4073: PER_PEOPLE_F
4074: WHERE FND_USER.EMPLOYEE_ID = PER_PEOPLE_F.PERSON_ID
4075: AND UPPER(FND_USER.USER_NAME) = UPPER(p_owner_name)
4068: AND mo_global.check_access(ORGANIZATION_ID) = 'Y';
4069:
4070: CURSOR OWNER_NAME_CSR (p_owner_name VARCHAR2) IS
4071: SELECT FND_USER.USER_ID
4072: FROM FND_USER,
4073: PER_PEOPLE_F
4074: WHERE FND_USER.EMPLOYEE_ID = PER_PEOPLE_F.PERSON_ID
4075: AND UPPER(FND_USER.USER_NAME) = UPPER(p_owner_name)
4076: AND SYSDATE >= EFFECTIVE_START_DATE
4070: CURSOR OWNER_NAME_CSR (p_owner_name VARCHAR2) IS
4071: SELECT FND_USER.USER_ID
4072: FROM FND_USER,
4073: PER_PEOPLE_F
4074: WHERE FND_USER.EMPLOYEE_ID = PER_PEOPLE_F.PERSON_ID
4075: AND UPPER(FND_USER.USER_NAME) = UPPER(p_owner_name)
4076: AND SYSDATE >= EFFECTIVE_START_DATE
4077: AND SYSDATE <= EFFECTIVE_END_DATE;
4078:
4071: SELECT FND_USER.USER_ID
4072: FROM FND_USER,
4073: PER_PEOPLE_F
4074: WHERE FND_USER.EMPLOYEE_ID = PER_PEOPLE_F.PERSON_ID
4075: AND UPPER(FND_USER.USER_NAME) = UPPER(p_owner_name)
4076: AND SYSDATE >= EFFECTIVE_START_DATE
4077: AND SYSDATE <= EFFECTIVE_END_DATE;
4078:
4079: CURSOR CURRENCY_CSR (p_currency_code VARCHAR2) IS
4785: END IF;
4786: END IF;
4787:
4788: --If l_valid_flag is already set to 'N', we do not perform any more checks
4789: --Owner User Name should resolve to a valid FND User ID
4790: --Also, the owner needs to be an employee
4791: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4792: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4793: 'Checking if owner user name is valid');