APPS.PJI_PJI_EXTRACTION_UTILS dependencies on FND_PROFILE

Line 1160: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');

1156: l_sqlerrm varchar2(240);
1157:
1158: begin
1159:
1160: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');
1161:
1162: FND_MESSAGE.SET_NAME('PJI', 'PJI_SUM_CLEANALL_FAILED');
1163:
1164: if (upper(nvl(l_profile_check, 'N')) <> 'Y') then

Line 1178: update FND_PROFILE_OPTION_VALUES

1174: retcode := 1;
1175: return;
1176: end if;
1177:
1178: update FND_PROFILE_OPTION_VALUES
1179: set PROFILE_OPTION_VALUE = 'N'
1180: where APPLICATION_ID = 1292 and
1181: -- LEVEL_ID = 10001 and
1182: PROFILE_OPTION_ID in

Line 1184: from FND_PROFILE_OPTIONS

1180: where APPLICATION_ID = 1292 and
1181: -- LEVEL_ID = 10001 and
1182: PROFILE_OPTION_ID in
1183: (select PROFILE_OPTION_ID
1184: from FND_PROFILE_OPTIONS
1185: where APPLICATION_ID = 1292 and
1186: PROFILE_OPTION_NAME = 'PJI_SUM_CLEANALL');
1187:
1188: commit;