15:
16: BEGIN
17:
18: -- If user has passed fnd_user_id then use that id else get
19: -- user_id from fnd_global
20:
21: l_user_id := nvl(x_fnd_user_id, fnd_global.user_id) ;
22:
23: -- If the Profile is not set, we use NVL to set X_approved to 'N'
17:
18: -- If user has passed fnd_user_id then use that id else get
19: -- user_id from fnd_global
20:
21: l_user_id := nvl(x_fnd_user_id, fnd_global.user_id) ;
22:
23: -- If the Profile is not set, we use NVL to set X_approved to 'N'
24:
25: -- Commenting the call to Value_specific API. Instead using standard
95: -- Shree 09/17/99
96: --
97: X_approved := FND_PROFILE.VALUE_SPECIFIC
98: (NAME => 'PA_PTE_AUTOAPPROVE_TS',
99: USER_ID => FND_GLOBAL.USER_ID,
100: RESPONSIBILITY_ID => FND_GLOBAL.RESP_ID,
101: APPLICATION_ID => FND_GLOBAL.RESP_APPL_ID);
102:
103: END IF;
96: --
97: X_approved := FND_PROFILE.VALUE_SPECIFIC
98: (NAME => 'PA_PTE_AUTOAPPROVE_TS',
99: USER_ID => FND_GLOBAL.USER_ID,
100: RESPONSIBILITY_ID => FND_GLOBAL.RESP_ID,
101: APPLICATION_ID => FND_GLOBAL.RESP_APPL_ID);
102:
103: END IF;
104: END IF;
97: X_approved := FND_PROFILE.VALUE_SPECIFIC
98: (NAME => 'PA_PTE_AUTOAPPROVE_TS',
99: USER_ID => FND_GLOBAL.USER_ID,
100: RESPONSIBILITY_ID => FND_GLOBAL.RESP_ID,
101: APPLICATION_ID => FND_GLOBAL.RESP_APPL_ID);
102:
103: END IF;
104: END IF;
105: