DBA Data[Home] [Help]

APPS.CS_KB_ELEMENTS_AUDIT_PKG dependencies on CS_KB_SYNC_INDEX_PKG

Line 1138: cs_kb_sync_index_pkg.MARK_IDXS_ON_GLOBAL_STMT_UPD(l_dup_id);

1134: 'A Duplicate Statement Exists for this update - UPD with Current CG');
1135: END IF;
1136:
1137: -- Bug 3576066 moved to above upd + delete
1138: cs_kb_sync_index_pkg.MARK_IDXS_ON_GLOBAL_STMT_UPD(l_dup_id);
1139: cs_kb_sync_index_pkg.MARK_IDXS_ON_GLOBAL_STMT_UPD(P_ELEMENT_ID);
1140:
1141: FOR solns IN Get_Curr_CG_Solns_Upd_Stmt (l_dup_id) LOOP
1142: -- This returns Solutions in the current Category Group

Line 1139: cs_kb_sync_index_pkg.MARK_IDXS_ON_GLOBAL_STMT_UPD(P_ELEMENT_ID);

1135: END IF;
1136:
1137: -- Bug 3576066 moved to above upd + delete
1138: cs_kb_sync_index_pkg.MARK_IDXS_ON_GLOBAL_STMT_UPD(l_dup_id);
1139: cs_kb_sync_index_pkg.MARK_IDXS_ON_GLOBAL_STMT_UPD(P_ELEMENT_ID);
1140:
1141: FOR solns IN Get_Curr_CG_Solns_Upd_Stmt (l_dup_id) LOOP
1142: -- This returns Solutions in the current Category Group
1143: -- to be updated. Only solutions that do not already

Line 1171: CS_KB_SYNC_INDEX_PKG.request_sync_km_indexes( l_request_id, l_return_status );

1167:
1168: fnd_profile.get('CS_KB_ENABLE_ASAP_INDEXING', l_asap_idx_enabled);
1169: IF ( l_asap_idx_enabled = 'Y' )
1170: THEN
1171: CS_KB_SYNC_INDEX_PKG.request_sync_km_indexes( l_request_id, l_return_status );
1172: END IF;
1173:
1174: X_RETURN_ELEMENT := l_dup_id;
1175: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 1261: cs_kb_sync_index_pkg.MARK_IDXS_ON_GLOBAL_STMT_UPD(P_ELEMENT_ID);

1257: X_MSG_COUNT := l_msg_count;
1258:
1259: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1260:
1261: cs_kb_sync_index_pkg.MARK_IDXS_ON_GLOBAL_STMT_UPD(P_ELEMENT_ID);
1262:
1263: fnd_profile.get('CS_KB_ENABLE_ASAP_INDEXING', l_asap_idx_enabled);
1264: IF ( l_asap_idx_enabled = 'Y' )
1265: THEN

Line 1266: CS_KB_SYNC_INDEX_PKG.request_sync_km_indexes( l_request_id, l_return_status );

1262:
1263: fnd_profile.get('CS_KB_ENABLE_ASAP_INDEXING', l_asap_idx_enabled);
1264: IF ( l_asap_idx_enabled = 'Y' )
1265: THEN
1266: CS_KB_SYNC_INDEX_PKG.request_sync_km_indexes( l_request_id, l_return_status );
1267: END IF;
1268:
1269: END IF;
1270:

Line 1339: CS_KB_SYNC_INDEX_PKG.Mark_Idxs_On_Global_Stmt_Upd(l_new_element_id);

1335:
1336: END LOOP;
1337:
1338: -- Reindex all Solutions effected
1339: CS_KB_SYNC_INDEX_PKG.Mark_Idxs_On_Global_Stmt_Upd(l_new_element_id);
1340: CS_KB_SYNC_INDEX_PKG.Mark_Idxs_On_Global_Stmt_Upd(P_ELEMENT_ID);
1341:
1342: fnd_profile.get('CS_KB_ENABLE_ASAP_INDEXING', l_asap_idx_enabled);
1343: IF ( l_asap_idx_enabled = 'Y' )

Line 1340: CS_KB_SYNC_INDEX_PKG.Mark_Idxs_On_Global_Stmt_Upd(P_ELEMENT_ID);

1336: END LOOP;
1337:
1338: -- Reindex all Solutions effected
1339: CS_KB_SYNC_INDEX_PKG.Mark_Idxs_On_Global_Stmt_Upd(l_new_element_id);
1340: CS_KB_SYNC_INDEX_PKG.Mark_Idxs_On_Global_Stmt_Upd(P_ELEMENT_ID);
1341:
1342: fnd_profile.get('CS_KB_ENABLE_ASAP_INDEXING', l_asap_idx_enabled);
1343: IF ( l_asap_idx_enabled = 'Y' )
1344: THEN

Line 1345: CS_KB_SYNC_INDEX_PKG.request_sync_km_indexes( l_request_id, l_return_status );

1341:
1342: fnd_profile.get('CS_KB_ENABLE_ASAP_INDEXING', l_asap_idx_enabled);
1343: IF ( l_asap_idx_enabled = 'Y' )
1344: THEN
1345: CS_KB_SYNC_INDEX_PKG.request_sync_km_indexes( l_request_id, l_return_status );
1346: END IF;
1347:
1348: X_RETURN_ELEMENT := l_new_element_id;
1349: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;