APPS.CS_KB_CONC_PROG_PKG dependencies on FND_PROFILE

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

919: IF retcode <> 0 THEN
920: RAISE rebuild_cache_error;
921: END IF;
922: ELSE
923: fnd_profile.get('CS_KB_REINDEX_BATCH_SIZE', l_reindex_batch_size);
924: IF ( l_reindex_batch_size IS NULL ) THEN
925: l_reindex_batch_size := 300;
926: END IF;
927:

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

1092: IF l_return_status <> fnd_api.G_RET_STS_SUCCESS THEN
1093: RAISE create_index_error;
1094: END IF;
1095: ELSE
1096: fnd_profile.get('CS_KB_REINDEX_BATCH_SIZE', l_reindex_batch_size);
1097: IF ( l_reindex_batch_size IS NULL ) THEN
1098: l_reindex_batch_size := 300;
1099: END IF;
1100:

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

1426: set_record.set_id,
1427: list_of_def_id(i),
1428: v_used_count,
1429: current_date,
1430: x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1431: current_date,
1432: x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1433: x_login_id --to_number(FND_PROFILE.VALUE('LOGIN_ID'))
1434: );

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

1428: v_used_count,
1429: current_date,
1430: x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1431: current_date,
1432: x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1433: x_login_id --to_number(FND_PROFILE.VALUE('LOGIN_ID'))
1434: );
1435:
1436: ELSE

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

1429: current_date,
1430: x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1431: current_date,
1432: x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1433: x_login_id --to_number(FND_PROFILE.VALUE('LOGIN_ID'))
1434: );
1435:
1436: ELSE
1437:

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

1437:
1438: UPDATE CS_KB_SET_USED_SUMS SET
1439: USED_COUNT=v_used_count,
1440: LAST_UPDATE_DATE=current_date,
1441: LAST_UPDATED_BY=x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1442: LAST_UPDATE_LOGIN=x_login_id --to_number(FND_PROFILE.VALUE('LOGIN_ID'))
1443: WHERE set_id = set_record.set_id
1444: AND def_id = list_of_def_id(i);
1445: END IF;

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

1438: UPDATE CS_KB_SET_USED_SUMS SET
1439: USED_COUNT=v_used_count,
1440: LAST_UPDATE_DATE=current_date,
1441: LAST_UPDATED_BY=x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1442: LAST_UPDATE_LOGIN=x_login_id --to_number(FND_PROFILE.VALUE('LOGIN_ID'))
1443: WHERE set_id = set_record.set_id
1444: AND def_id = list_of_def_id(i);
1445: END IF;
1446:

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

1472: *
1473: */
1474: PROCEDURE Update_Magic_Word IS
1475: CURSOR Get_Magic_Word_Csr IS
1476: SELECT fnd_profile.value('CS_KB_SEARCH_NONEXIST_KEYWORD') FROM dual;
1477:
1478: CURSOR Test_Magic_Word_Csr(p_keyword VARCHAR2) IS
1479: SELECT NULL
1480: FROM cs_kb_sets_vl SetEO

Line 1537: IF Fnd_Profile.Save(

1533: END IF;
1534:
1535: IF l_magic_word <> l_old_magic_word THEN
1536: -- Update profile
1537: IF Fnd_Profile.Save(
1538: X_NAME => 'CS_KB_SEARCH_NONEXIST_KEYWORD', /* Profile name you are setting */
1539: X_VALUE => l_magic_word, /* Profile value you are setting */
1540: X_LEVEL_NAME => 'SITE' /* 'SITE', 'APPL', 'RESP', or 'USER' */
1541: ) THEN