APPS.OKL_LEASE_APP_WF dependencies on FND_USER

Line 34: CURSOR fnd_user_csr IS

30: ---------------------------------------------------
31: -- Global Cursor definition
32: ---------------------------------------------------
33: -- Get the requester name
34: CURSOR fnd_user_csr IS
35: SELECT USER_NAME
36: FROM FND_USER
37: WHERE USER_ID = fnd_global.user_id;
38:

Line 36: FROM FND_USER

32: ---------------------------------------------------
33: -- Get the requester name
34: CURSOR fnd_user_csr IS
35: SELECT USER_NAME
36: FROM FND_USER
37: WHERE USER_ID = fnd_global.user_id;
38:
39: -- Get the valid application id from FND
40: CURSOR c_get_app_id_csr IS

Line 209: OPEN fnd_user_csr;

205: 'EFFECTIVE_TO',
206: l_lease_app_rec.effective_to);
207:
208: -- Set the attributes on the Approver, requestor
209: OPEN fnd_user_csr;
210: FETCH fnd_user_csr INTO l_user_name ;
211: CLOSE fnd_user_csr;
212:
213: -- get the application id

Line 210: FETCH fnd_user_csr INTO l_user_name ;

206: l_lease_app_rec.effective_to);
207:
208: -- Set the attributes on the Approver, requestor
209: OPEN fnd_user_csr;
210: FETCH fnd_user_csr INTO l_user_name ;
211: CLOSE fnd_user_csr;
212:
213: -- get the application id
214:

Line 211: CLOSE fnd_user_csr;

207:
208: -- Set the attributes on the Approver, requestor
209: OPEN fnd_user_csr;
210: FETCH fnd_user_csr INTO l_user_name ;
211: CLOSE fnd_user_csr;
212:
213: -- get the application id
214:
215: OPEN c_get_app_id_csr;

Line 502: OPEN fnd_user_csr;

498: 'EFFECTIVE_TO',
499: lp_lat_dtls_rec.effective_to);
500:
501: -- Set the attributes on the Approver, requestor
502: OPEN fnd_user_csr;
503: FETCH fnd_user_csr INTO l_user_name ;
504: CLOSE fnd_user_csr;
505:
506: -- get the application id

Line 503: FETCH fnd_user_csr INTO l_user_name ;

499: lp_lat_dtls_rec.effective_to);
500:
501: -- Set the attributes on the Approver, requestor
502: OPEN fnd_user_csr;
503: FETCH fnd_user_csr INTO l_user_name ;
504: CLOSE fnd_user_csr;
505:
506: -- get the application id
507:

Line 504: CLOSE fnd_user_csr;

500:
501: -- Set the attributes on the Approver, requestor
502: OPEN fnd_user_csr;
503: FETCH fnd_user_csr INTO l_user_name ;
504: CLOSE fnd_user_csr;
505:
506: -- get the application id
507:
508: OPEN c_get_app_id_csr;