[Home] [Help]
90: ff_typ.formula_type_name formula_type_name,
91: cpe.information2 effective_start_date,
92: cpe.information3 effective_end_date
93: from ben_copy_entity_results cpe,
94: pqh_copy_entity_txns cet,
95: ff_formula_types ff_typ
96: where cet.copy_entity_txn_id = p_copy_entity_txn_id
97: and cet.copy_entity_txn_id = cpe.copy_entity_txn_id
98: and ff_typ.formula_type_id = cpe.information160
192: l_proc VARCHAR2 (80) := g_package || '.process';
193: l_cet_object_version_number NUMBER (15);
194: l_target_typ_cd VARCHAR2(30);
195: l_row_typ_cd PQH_COPY_ENTITY_ATTRIBS.ROW_TYPE_CD%TYPE;
196: l_start_with PQH_COPY_ENTITY_TXNS.START_WITH%TYPE;
197: l_effective_date DATE;
198: l_effective_date_to_copy DATE;
199: l_exception VARCHAR2(3000);
200: l_delete_failed VARCHAR2(30);
212: cea.row_type_cd,
213: cea.information3 target_typ_cd,
214: cea.information4 reuse_object_flag,
215: cea.information1 prefix_suffix_text
216: FROM pqh_copy_entity_txns cet, pqh_copy_entity_attribs cea
217: WHERE cet.copy_entity_txn_id = cea.copy_entity_txn_id
218: AND cet.copy_entity_txn_id = p_copy_entity_txn_id;
219: --
220:
378: --
379: create_process_log (p_copy_entity_txn_id => p_copy_entity_txn_id,
380: p_row_type_cd => l_row_typ_cd );
381: --
382: pqh_copy_entity_txns_api.update_copy_entity_txn (p_copy_entity_txn_id => p_copy_entity_txn_id,
383: p_datetrack_mode => hr_api.g_correction,
384: p_status => 'COMPLETE', /* To enable View Log Icon */
385: p_start_with => l_start_with,
386: p_object_version_number => l_cet_object_version_number,
424: l_start_with := 'BEN_PDW_PLN_OVVW_FUNC';
425: --
426: END IF;
427: --
428: pqh_copy_entity_txns_api.update_copy_entity_txn (p_copy_entity_txn_id => p_copy_entity_txn_id,
429: p_datetrack_mode => hr_api.g_correction,
430: p_status => 'ERROR', /* To disable View Log Icon */
431: p_start_with => l_start_with, /* Bug 4415568 Enable Continue*/
432: p_object_version_number => l_cet_object_version_number,