APPS.OKC_WF_K_APPROVE dependencies on FND_PROFILE

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

1: package body OKC_WF_K_APPROVE as
2: /* $Header: OKCWCAPB.pls 120.2.12000000.3 2007/05/25 18:01:19 skkoppul ship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6:
7: -- Start of comments
8: --

Line 85: FND_PROFILE.VALUE('OKC_K_APPROVER') role,

81:
82: Due to performance reasons we decided to refuse from
83:
84: (select 1 num,
85: FND_PROFILE.VALUE('OKC_K_APPROVER') role,
86: DISPLAY_NAME name
87: from wf_roles
88: where name=FND_PROFILE.VALUE('OKC_K_APPROVER'))
89:

Line 88: where name=FND_PROFILE.VALUE('OKC_K_APPROVER'))

84: (select 1 num,
85: FND_PROFILE.VALUE('OKC_K_APPROVER') role,
86: DISPLAY_NAME name
87: from wf_roles
88: where name=FND_PROFILE.VALUE('OKC_K_APPROVER'))
89:
90: and restrict select to fnd_user data only
91:
92: might be customisation problem

Line 102: FND_PROFILE.VALUE('OKC_K_APPROVER') role,

98: from -- here should be your view of structure (num,role,name)
99: ------------------------------------------------------
100: (
101: select 1 num,
102: FND_PROFILE.VALUE('OKC_K_APPROVER') role,
103: FND_PROFILE.VALUE('OKC_K_APPROVER') name
104: from dual
105: where not exists
106: ( select '!'

Line 103: FND_PROFILE.VALUE('OKC_K_APPROVER') name

99: ------------------------------------------------------
100: (
101: select 1 num,
102: FND_PROFILE.VALUE('OKC_K_APPROVER') role,
103: FND_PROFILE.VALUE('OKC_K_APPROVER') name
104: from dual
105: where not exists
106: ( select '!'
107: from FND_USER USR, PER_PEOPLE_F PER

Line 108: where USR.USER_NAME=FND_PROFILE.VALUE('OKC_K_APPROVER')

104: from dual
105: where not exists
106: ( select '!'
107: from FND_USER USR, PER_PEOPLE_F PER
108: where USR.USER_NAME=FND_PROFILE.VALUE('OKC_K_APPROVER')
109: and USR.EMPLOYEE_ID = PER.PERSON_ID
110: )
111: union all
112: select 1 num,

Line 113: FND_PROFILE.VALUE('OKC_K_APPROVER') role,

109: and USR.EMPLOYEE_ID = PER.PERSON_ID
110: )
111: union all
112: select 1 num,
113: FND_PROFILE.VALUE('OKC_K_APPROVER') role,
114: NVL(PER.FULL_NAME,FND_PROFILE.VALUE('OKC_K_APPROVER')) name
115: from FND_USER USR, PER_PEOPLE_F PER
116: where USR.USER_NAME=FND_PROFILE.VALUE('OKC_K_APPROVER')
117: and USR.EMPLOYEE_ID = PER.PERSON_ID

Line 114: NVL(PER.FULL_NAME,FND_PROFILE.VALUE('OKC_K_APPROVER')) name

110: )
111: union all
112: select 1 num,
113: FND_PROFILE.VALUE('OKC_K_APPROVER') role,
114: NVL(PER.FULL_NAME,FND_PROFILE.VALUE('OKC_K_APPROVER')) name
115: from FND_USER USR, PER_PEOPLE_F PER
116: where USR.USER_NAME=FND_PROFILE.VALUE('OKC_K_APPROVER')
117: and USR.EMPLOYEE_ID = PER.PERSON_ID
118: )

Line 116: where USR.USER_NAME=FND_PROFILE.VALUE('OKC_K_APPROVER')

112: select 1 num,
113: FND_PROFILE.VALUE('OKC_K_APPROVER') role,
114: NVL(PER.FULL_NAME,FND_PROFILE.VALUE('OKC_K_APPROVER')) name
115: from FND_USER USR, PER_PEOPLE_F PER
116: where USR.USER_NAME=FND_PROFILE.VALUE('OKC_K_APPROVER')
117: and USR.EMPLOYEE_ID = PER.PERSON_ID
118: )
119: ------------------------------------------------------
120: where p_current is NULL

Line 568: AND Nvl(Fnd_Profile.Value('OKC_CREATE_ORDER_FROM_K'),'Y')='N');

564: and JTOT_OBJECT1_CODE = G_OBJECT_CODE
565: ---and RTY_CODE = G_TERMSFORQUOTE ;
566: -- and RTY_CODE in (G_TERMSFORQUOTE, G_NEGOTIATESQUOTE);
567: and (RTY_CODE=G_TERMSFORQUOTE OR RTY_CODE=G_NEGOTIATESQUOTE
568: AND Nvl(Fnd_Profile.Value('OKC_CREATE_ORDER_FROM_K'),'Y')='N');
569: --taking BOTH into account as per Bug 2050306 abkumar
570: BEGIN
571: mo_global.init('OKC');
572: --