APPS.BEN_PD_FORMULA_PKG dependencies on BEN_COPY_ENTITY_RESULTS

Line 97: from ben_copy_entity_results

93: information111 FORMULA_NAME,
94: information151 DESCRIPTION,
95: information325 FORMULA_TEXT,
96: information1 ff_formula_id
97: from ben_copy_entity_results
98: where copy_entity_result_id = p_copy_entity_result_id;
99: l_formula_id number(15);
100: l_rowid varchar2(255);
101: l_lastUpdateDate date;

Line 245: delete from ben_copy_entity_results

241: l_clob clob;
242:
243: begin
244:
245: delete from ben_copy_entity_results
246: where copy_entity_result_id = -999999;
247:
248: insert into ben_copy_entity_results (
249: COPY_ENTITY_RESULT_ID,

Line 248: insert into ben_copy_entity_results (

244:
245: delete from ben_copy_entity_results
246: where copy_entity_result_id = -999999;
247:
248: insert into ben_copy_entity_results (
249: COPY_ENTITY_RESULT_ID,
250: COPY_ENTITY_TXN_ID,
251: RESULT_TYPE_CD,
252: OBJECT_VERSION_NUMBER,

Line 259: select information325 into l_clob from ben_copy_entity_results

255: from ff_formulas_f
256: where formula_id = p_formula_id
257: and p_effective_start_date between effective_start_date and effective_end_date;
258:
259: select information325 into l_clob from ben_copy_entity_results
260: where copy_entity_result_id = -999999;
261:
262: -- rollback; can't use it, the formula text get's lost.
263: return l_clob;

Line 417: FROM ben_copy_entity_results

413: CURSOR c_copy_result IS
414: SELECT copy_entity_result_id
415: ,dml_operation
416: ,datetrack_mode
417: FROM ben_copy_entity_results
418: WHERE copy_entity_txn_id = p_copy_entity_txn_id
419: AND information1 = p_formula_id
420: AND ( information4 = p_business_group_id OR
421: ( p_business_group_id is null AND information4 is null))

Line 449: update ben_copy_entity_results

445: OPEN c_copy_result;
446: FETCH c_copy_result INTO l_copy_entity_result_id, l_dml_operation, l_datetrack_mode;
447: CLOSE c_copy_result;
448:
449: update ben_copy_entity_results
450: set number_of_copies = 0,
451: status = 'INVALID'
452: where copy_entity_result_id = l_copy_entity_result_id;
453: commit;