DBA Data[Home] [Help]

APPS.OKS_RENEW_CONTRACT_PVT dependencies on FND_USER

Line 4827: p_hdesk_user_id : fnd user id of the help desk user id setup in GCD. Optional,

4823: Procedure for getting the user id and name of the contact on whose behalf the
4824: contract workflow is launched during renewal
4825: Parameters
4826: p_chr_id : id of the contract for which the workflow is launched
4827: p_hdesk_user_id : fnd user id of the help desk user id setup in GCD. Optional,
4828: if not passed will be derived from GCD.
4829:
4830: If no vendor/merchant contact bases on jtf object 'OKX_SALEPERS' can be found for the contract
4831: header, the help desk user is used. This behaviour is from R12 onwards, prior to this if a

Line 4865: fnd.user_id, fnd.user_name

4861:
4862: CURSOR c_k_srep_user(cp_chr_id IN NUMBER, cp_cpl_id IN NUMBER, cp_org_id IN NUMBER) IS
4863: SELECT
4864: --rsc.resource_id, srp.salesrep_id, srp.org_id, ctc.cro_code,
4865: fnd.user_id, fnd.user_name
4866: FROM okc_contacts ctc, fnd_user fnd,
4867: jtf_rs_resource_extns rsc, jtf_rs_salesreps srp
4868: WHERE ctc.dnz_chr_id = cp_chr_id
4869: AND ctc.cpl_id = cp_cpl_id

Line 4866: FROM okc_contacts ctc, fnd_user fnd,

4862: CURSOR c_k_srep_user(cp_chr_id IN NUMBER, cp_cpl_id IN NUMBER, cp_org_id IN NUMBER) IS
4863: SELECT
4864: --rsc.resource_id, srp.salesrep_id, srp.org_id, ctc.cro_code,
4865: fnd.user_id, fnd.user_name
4866: FROM okc_contacts ctc, fnd_user fnd,
4867: jtf_rs_resource_extns rsc, jtf_rs_salesreps srp
4868: WHERE ctc.dnz_chr_id = cp_chr_id
4869: AND ctc.cpl_id = cp_cpl_id
4870: AND ctc.cro_code IN (SELECT src.cro_code FROM okc_contact_sources src

Line 4877: AND rsc.user_id = fnd.user_id;

4873: AND src.buy_or_sell = 'S')
4874: AND srp.salesrep_id = to_number(ctc.object1_id1)
4875: AND nvl(srp.org_id, -99) = cp_org_id
4876: AND srp.resource_id = rsc.resource_id
4877: AND rsc.user_id = fnd.user_id;
4878:
4879: CURSOR c_fnd_user(cp_user_id IN NUMBER) IS
4880: SELECT user_name
4881: FROM fnd_user

Line 4879: CURSOR c_fnd_user(cp_user_id IN NUMBER) IS

4875: AND nvl(srp.org_id, -99) = cp_org_id
4876: AND srp.resource_id = rsc.resource_id
4877: AND rsc.user_id = fnd.user_id;
4878:
4879: CURSOR c_fnd_user(cp_user_id IN NUMBER) IS
4880: SELECT user_name
4881: FROM fnd_user
4882: WHERE user_id = cp_user_id;
4883:

Line 4881: FROM fnd_user

4877: AND rsc.user_id = fnd.user_id;
4878:
4879: CURSOR c_fnd_user(cp_user_id IN NUMBER) IS
4880: SELECT user_name
4881: FROM fnd_user
4882: WHERE user_id = cp_user_id;
4883:
4884: l_org_id NUMBER;
4885: l_cpl_id NUMBER;

Line 4927: --now get the fnd user id/name for the contact of type 'OKX_SALEPERS', if a vendor/merchant party

4923: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4924: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_org_cpl', 'l_org_id=' || l_org_id||' ,l_cpl_id='||l_cpl_id);
4925: END IF;
4926:
4927: --now get the fnd user id/name for the contact of type 'OKX_SALEPERS', if a vendor/merchant party
4928: --is found
4929: IF (l_cpl_id IS NOT NULL) THEN
4930:
4931: OPEN c_k_srep_user(p_chr_id, l_cpl_id, l_org_id);

Line 4998: OPEN c_fnd_user(l_user_id);

4994: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
4995: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_helpdesk_user', 'getting user name for user id='||l_user_id);
4996: END IF;
4997:
4998: OPEN c_fnd_user(l_user_id);
4999: FETCH c_fnd_user INTO l_user_name;
5000: CLOSE c_fnd_user;
5001: END IF;
5002: x_user_id := l_user_id;

Line 4999: FETCH c_fnd_user INTO l_user_name;

4995: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.get_helpdesk_user', 'getting user name for user id='||l_user_id);
4996: END IF;
4997:
4998: OPEN c_fnd_user(l_user_id);
4999: FETCH c_fnd_user INTO l_user_name;
5000: CLOSE c_fnd_user;
5001: END IF;
5002: x_user_id := l_user_id;
5003: x_user_name := l_user_name;

Line 5000: CLOSE c_fnd_user;

4996: END IF;
4997:
4998: OPEN c_fnd_user(l_user_id);
4999: FETCH c_fnd_user INTO l_user_name;
5000: CLOSE c_fnd_user;
5001: END IF;
5002: x_user_id := l_user_id;
5003: x_user_name := l_user_name;
5004:

Line 5024: IF (c_fnd_user%isopen) THEN

5020: END IF;
5021: IF (c_k_srep_user%isopen) THEN
5022: CLOSE c_k_srep_user;
5023: END IF;
5024: IF (c_fnd_user%isopen) THEN
5025: CLOSE c_fnd_user;
5026: END IF;
5027: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5028:

Line 5025: CLOSE c_fnd_user;

5021: IF (c_k_srep_user%isopen) THEN
5022: CLOSE c_k_srep_user;
5023: END IF;
5024: IF (c_fnd_user%isopen) THEN
5025: CLOSE c_fnd_user;
5026: END IF;
5027: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5028:
5029: WHEN FND_API.g_exc_unexpected_error THEN

Line 5041: IF (c_fnd_user%isopen) THEN

5037: END IF;
5038: IF (c_k_srep_user%isopen) THEN
5039: CLOSE c_k_srep_user;
5040: END IF;
5041: IF (c_fnd_user%isopen) THEN
5042: CLOSE c_fnd_user;
5043: END IF;
5044: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5045:

Line 5042: CLOSE c_fnd_user;

5038: IF (c_k_srep_user%isopen) THEN
5039: CLOSE c_k_srep_user;
5040: END IF;
5041: IF (c_fnd_user%isopen) THEN
5042: CLOSE c_fnd_user;
5043: END IF;
5044: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5045:
5046: WHEN OTHERS THEN

Line 5062: IF (c_fnd_user%isopen) THEN

5058: END IF;
5059: IF (c_k_srep_user%isopen) THEN
5060: CLOSE c_k_srep_user;
5061: END IF;
5062: IF (c_fnd_user%isopen) THEN
5063: CLOSE c_fnd_user;
5064: END IF;
5065: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5066:

Line 5063: CLOSE c_fnd_user;

5059: IF (c_k_srep_user%isopen) THEN
5060: CLOSE c_k_srep_user;
5061: END IF;
5062: IF (c_fnd_user%isopen) THEN
5063: CLOSE c_fnd_user;
5064: END IF;
5065: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
5066:
5067: END GET_USER_NAME;