[Home] [Help]
1584: --
1585: ---------------------------delete_transaction-----------------------------
1586: --
1587: procedure delete_transaction
1588: (p_pqh_copy_entity_txn_id IN pqh_copy_entity_txns.copy_entity_txn_id%TYPE) IS
1589:
1590:
1591: begin
1592: del_gl_details_from_stage(p_pqh_copy_entity_txn_id);
1589:
1590:
1591: begin
1592: del_gl_details_from_stage(p_pqh_copy_entity_txn_id);
1593: delete from pqh_copy_entity_txns where copy_entity_txn_id = p_pqh_copy_entity_txn_id;
1594: end delete_transaction;
1595:
1596: --
1597: ---------------------------del_gl_details_from_stage-----------------------------
1596: --
1597: ---------------------------del_gl_details_from_stage-----------------------------
1598: --
1599: procedure del_gl_details_from_stage
1600: (p_pqh_copy_entity_txn_id IN pqh_copy_entity_txns.copy_entity_txn_id%TYPE) IS
1601:
1602: begin
1603: delete from pqh_copy_entity_attribs where copy_entity_txn_id = p_pqh_copy_entity_txn_id;
1604: delete from ben_copy_entity_results where copy_entity_txn_id = p_pqh_copy_entity_txn_id;
1614: Cursor pgm is
1615: select pgm_id, object_version_number from ben_pgm_f where pgm_id = p_ben_pgm_id and effective_end_date = hr_general.end_of_time;
1616:
1617: Cursor c2 is
1618: select copy_entity_txn_id from pqh_copy_entity_txns where copy_entity_txn_id in
1619: (select copy_entity_txn_id from ben_copy_entity_results
1620: where information1 = p_ben_pgm_id and table_alias = 'PGM' and information_category = 'GRADE_LADDER'
1621: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY')
1622: and status = 'SFL';
1866: ---------------------------gen_txn_display_name-----------------------------
1867: --
1868:
1869: Function gen_txn_display_name
1870: (p_program_name IN pqh_copy_entity_txns.display_name%TYPE,
1871: p_mode IN varchar2)
1872: Return Varchar2 is
1873: l_timestamp varchar2(30) := fnd_date.date_to_canonical(sysdate);
1874: l_display_name varchar2(300);
1911: --
1912: ---------------------------get_grade_ladder_name_from_txn-----------------------------
1913: --
1914: Function get_grade_ladder_name_from_txn
1915: (p_pqh_copy_entity_txn_id IN pqh_copy_entity_txns.copy_entity_txn_id%TYPE)
1916: Return Varchar2 is
1917: cursor c1 is
1918: select information5 grade_ladder_name from ben_copy_entity_results
1919: where copy_entity_txn_id = p_pqh_copy_entity_txn_id
4063: l_get_which_rates varchar2(20) := get_which_rates(p_copy_entity_txn_id);
4064: l_crrate_icon varchar2(50);
4065: l_effective_date date;
4066: begin
4067: select action_date into l_effective_date from pqh_copy_entity_txns
4068: where copy_entity_txn_id = p_copy_entity_txn_id;
4069: if g_debug then
4070: hr_utility.set_location('Entering '||l_proc,5);
4071: end if;
5004:
5005:
5006: select action_date
5007: into l_effdate
5008: from pqh_copy_entity_txns
5009: where copy_entity_txn_id = p_copy_entity_txn_id;
5010:
5011:
5012:
5085: between nvl(information2, hr_general.start_of_time) and nvl(information3, hr_general.end_of_time);
5086:
5087: Cursor Csr_Action_Dt is
5088: Select Action_Date
5089: From Pqh_Copy_Entity_txns
5090: Where Copy_Entity_Txn_id = p_copy_entity_txn_id;
5091:
5092: cursor point_cer is
5093: select information262 from ben_copy_entity_results
5420: AND NVL (information104, 'PPP') <> 'UNLINK';
5421:
5422: Cursor Csr_Action_Dt is
5423: Select Action_Date
5424: From Pqh_Copy_Entity_txns
5425: Where Copy_Entity_Txn_id = p_copy_entity_txn_id;
5426:
5427: l_Action_Date date;
5428: begin