APPS.CS_KB_CONC_PROG_PKG dependencies on FND_PROFILE

Line 791: fnd_profile.get('CS_KB_REINDEX_BATCH_SIZE', l_reindex_batch_size);

787: IF retcode <> 0 THEN
788: RAISE rebuild_cache_error;
789: END IF;
790: ELSE
791: fnd_profile.get('CS_KB_REINDEX_BATCH_SIZE', l_reindex_batch_size);
792: IF ( l_reindex_batch_size IS NULL ) THEN
793: l_reindex_batch_size := 300;
794: END IF;
795:

Line 947: fnd_profile.get('CS_KB_REINDEX_BATCH_SIZE', l_reindex_batch_size);

943: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
944: RAISE create_index_error;
945: END IF;
946: ELSE
947: fnd_profile.get('CS_KB_REINDEX_BATCH_SIZE', l_reindex_batch_size);
948: IF ( l_reindex_batch_size IS NULL ) THEN
949: l_reindex_batch_size := 300;
950: END IF;
951:

Line 1281: x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),

1277: set_record.set_id,
1278: list_of_def_id(i),
1279: v_used_count,
1280: current_date,
1281: x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1282: current_date,
1283: x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1284: x_login_id --to_number(FND_PROFILE.VALUE('LOGIN_ID'))
1285: );

Line 1283: x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),

1279: v_used_count,
1280: current_date,
1281: x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1282: current_date,
1283: x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1284: x_login_id --to_number(FND_PROFILE.VALUE('LOGIN_ID'))
1285: );
1286:
1287: ELSE

Line 1284: x_login_id --to_number(FND_PROFILE.VALUE('LOGIN_ID'))

1280: current_date,
1281: x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1282: current_date,
1283: x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1284: x_login_id --to_number(FND_PROFILE.VALUE('LOGIN_ID'))
1285: );
1286:
1287: ELSE
1288:

Line 1292: LAST_UPDATED_BY=x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),

1288:
1289: UPDATE CS_KB_SET_USED_SUMS SET
1290: USED_COUNT=v_used_count,
1291: LAST_UPDATE_DATE=current_date,
1292: LAST_UPDATED_BY=x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1293: LAST_UPDATE_LOGIN=x_login_id --to_number(FND_PROFILE.VALUE('LOGIN_ID'))
1294: WHERE set_id = set_record.set_id
1295: AND def_id = list_of_def_id(i);
1296: END IF;

Line 1293: LAST_UPDATE_LOGIN=x_login_id --to_number(FND_PROFILE.VALUE('LOGIN_ID'))

1289: UPDATE CS_KB_SET_USED_SUMS SET
1290: USED_COUNT=v_used_count,
1291: LAST_UPDATE_DATE=current_date,
1292: LAST_UPDATED_BY=x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1293: LAST_UPDATE_LOGIN=x_login_id --to_number(FND_PROFILE.VALUE('LOGIN_ID'))
1294: WHERE set_id = set_record.set_id
1295: AND def_id = list_of_def_id(i);
1296: END IF;
1297:

Line 1327: SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;

1323: *
1324: */
1325: PROCEDURE Update_Magic_Word IS
1326: CURSOR Get_Magic_Word_Csr IS
1327: SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;
1328:
1329: CURSOR Test_Magic_Word_Csr(p_keyword VARCHAR2) IS
1330: SELECT NULL
1331: FROM cs_kb_sets_vl SetEO

Line 1388: IF Fnd_Profile.Save(

1384: END IF;
1385:
1386: IF l_magic_word <> l_old_magic_word THEN
1387: -- Update profile
1388: IF Fnd_Profile.Save(
1389: X_NAME => 'CS_KB_SEARCH_NONEXIST_KEYWORD', /* Profile name you are setting */
1390: X_VALUE => l_magic_word, /* Profile value you are setting */
1391: X_LEVEL_NAME => 'SITE' /* 'SITE', 'APPL', 'RESP', or 'USER' */
1392: ) THEN