APPS.OKC_WF_CHK_APPROVE dependencies on FND_PROFILE

Line 4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1: package body OKC_WF_CHK_APPROVE as
2: /* $Header: OKCWCHKB.pls 120.0 2005/05/26 09:57:10 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: ----------------------------------------------------------------------------
7: --
8: -- C U S T O M I Z E select_next

Line 37: (select 1 num, FND_PROFILE.VALUE('OKC_CR_APPROVER') role,

33: cursor Next_Approver_csr is
34: select role, name
35: from -- here should be your view of structure (num,role,name)
36: ------------------------------------------------------
37: (select 1 num, FND_PROFILE.VALUE('OKC_CR_APPROVER') role,
38: NVL(PER.FULL_NAME, USR.USER_NAME) name
39: from FND_USER USR, PER_PEOPLE_F PER
40: where USR.USER_NAME = FND_PROFILE.VALUE('OKC_CR_APPROVER')
41: and USR.EMPLOYEE_ID = PER.PERSON_ID(+)

Line 40: where USR.USER_NAME = FND_PROFILE.VALUE('OKC_CR_APPROVER')

36: ------------------------------------------------------
37: (select 1 num, FND_PROFILE.VALUE('OKC_CR_APPROVER') role,
38: NVL(PER.FULL_NAME, USR.USER_NAME) name
39: from FND_USER USR, PER_PEOPLE_F PER
40: where USR.USER_NAME = FND_PROFILE.VALUE('OKC_CR_APPROVER')
41: and USR.EMPLOYEE_ID = PER.PERSON_ID(+)
42: and trunc(sysdate) between nvl(per.effective_start_date, trunc(sysdate)) and
43: nvl(per.effective_end_date, trunc(sysdate))
44: )

Line 55: (select 1 num, FND_PROFILE.VALUE('OKC_CR_APPROVER') role,

51: cursor Next_Informed_csr is
52: select role, name
53: from -- here should be your view of structure (num,role,name)
54: ------------------------------------------------------
55: (select 1 num, FND_PROFILE.VALUE('OKC_CR_APPROVER') role,
56: NVL(PER.FULL_NAME, USR.USER_NAME) name
57: from FND_USER USR, PER_PEOPLE_F PER
58: where USR.USER_NAME = FND_PROFILE.VALUE('OKC_CR_APPROVER')
59: and USR.EMPLOYEE_ID = PER.PERSON_ID(+)

Line 58: where USR.USER_NAME = FND_PROFILE.VALUE('OKC_CR_APPROVER')

54: ------------------------------------------------------
55: (select 1 num, FND_PROFILE.VALUE('OKC_CR_APPROVER') role,
56: NVL(PER.FULL_NAME, USR.USER_NAME) name
57: from FND_USER USR, PER_PEOPLE_F PER
58: where USR.USER_NAME = FND_PROFILE.VALUE('OKC_CR_APPROVER')
59: and USR.EMPLOYEE_ID = PER.PERSON_ID(+)
60: and trunc(sysdate) between nvl(per.effective_start_date, trunc(sysdate)) and
61: nvl(per.effective_end_date, trunc(sysdate))
62: )