APPS.OKL_LEASE_QUOTE_WORKFLOW_PVT dependencies on FND_USER

Line 772: /* CURSOR fnd_user_csr IS

768: FROM okl_lease_quotes_b
769: WHERE id = p_quote_id;
770:
771: -- Commented by Venkatho as part of Bug : 15933691
772: /* CURSOR fnd_user_csr IS
773: SELECT USER_NAME
774: FROM FND_USER
775: WHERE USER_ID = fnd_global.user_id; */
776:

Line 774: FROM FND_USER

770:
771: -- Commented by Venkatho as part of Bug : 15933691
772: /* CURSOR fnd_user_csr IS
773: SELECT USER_NAME
774: FROM FND_USER
775: WHERE USER_ID = fnd_global.user_id; */
776:
777: -- Added by Venkatho as part of Bug : 15933691 Start
778: CURSOR fnd_user_csr(p_user_id NUMBER) IS

Line 778: CURSOR fnd_user_csr(p_user_id NUMBER) IS

774: FROM FND_USER
775: WHERE USER_ID = fnd_global.user_id; */
776:
777: -- Added by Venkatho as part of Bug : 15933691 Start
778: CURSOR fnd_user_csr(p_user_id NUMBER) IS
779: SELECT USER_NAME
780: FROM FND_USER
781: WHERE USER_ID = p_user_id;
782:

Line 780: FROM FND_USER

776:
777: -- Added by Venkatho as part of Bug : 15933691 Start
778: CURSOR fnd_user_csr(p_user_id NUMBER) IS
779: SELECT USER_NAME
780: FROM FND_USER
781: WHERE USER_ID = p_user_id;
782:
783: l_user_id NUMBER;
784: -- Added by Venkatho as part of Bug : 15933691 End

Line 911: -- OPEN fnd_user_csr; -- Commented by venkatho as part of Bug: 15933691

907: aname => G_WF_ITM_MESSAGE_DESCR,
908: avalue => get_quote_msg_body(itemtype, itemkey));
909:
910:
911: -- OPEN fnd_user_csr; -- Commented by venkatho as part of Bug: 15933691
912: OPEN fnd_user_csr(l_user_id); -- Added by venkatho as part of Bug: 15933691
913: FETCH fnd_user_csr INTO l_user_name ;
914: CLOSE fnd_user_csr;
915:

Line 912: OPEN fnd_user_csr(l_user_id); -- Added by venkatho as part of Bug: 15933691

908: avalue => get_quote_msg_body(itemtype, itemkey));
909:
910:
911: -- OPEN fnd_user_csr; -- Commented by venkatho as part of Bug: 15933691
912: OPEN fnd_user_csr(l_user_id); -- Added by venkatho as part of Bug: 15933691
913: FETCH fnd_user_csr INTO l_user_name ;
914: CLOSE fnd_user_csr;
915:
916: -- get the application id

Line 913: FETCH fnd_user_csr INTO l_user_name ;

909:
910:
911: -- OPEN fnd_user_csr; -- Commented by venkatho as part of Bug: 15933691
912: OPEN fnd_user_csr(l_user_id); -- Added by venkatho as part of Bug: 15933691
913: FETCH fnd_user_csr INTO l_user_name ;
914: CLOSE fnd_user_csr;
915:
916: -- get the application id
917:

Line 914: CLOSE fnd_user_csr;

910:
911: -- OPEN fnd_user_csr; -- Commented by venkatho as part of Bug: 15933691
912: OPEN fnd_user_csr(l_user_id); -- Added by venkatho as part of Bug: 15933691
913: FETCH fnd_user_csr INTO l_user_name ;
914: CLOSE fnd_user_csr;
915:
916: -- get the application id
917:
918: OPEN c_get_app_id_csr;