[Home] [Help]
1465: --
1466: ---------------------------delete_transaction-----------------------------
1467: --
1468: procedure delete_transaction
1469: (p_pqh_copy_entity_txn_id IN pqh_copy_entity_txns.copy_entity_txn_id%TYPE) IS
1470:
1471:
1472: begin
1473: del_gl_details_from_stage(p_pqh_copy_entity_txn_id);
1470:
1471:
1472: begin
1473: del_gl_details_from_stage(p_pqh_copy_entity_txn_id);
1474: delete from pqh_copy_entity_txns where copy_entity_txn_id = p_pqh_copy_entity_txn_id;
1475: end delete_transaction;
1476:
1477: --
1478: ---------------------------del_gl_details_from_stage-----------------------------
1477: --
1478: ---------------------------del_gl_details_from_stage-----------------------------
1479: --
1480: procedure del_gl_details_from_stage
1481: (p_pqh_copy_entity_txn_id IN pqh_copy_entity_txns.copy_entity_txn_id%TYPE) IS
1482:
1483: begin
1484: delete from pqh_copy_entity_attribs where copy_entity_txn_id = p_pqh_copy_entity_txn_id;
1485: delete from ben_copy_entity_results where copy_entity_txn_id = p_pqh_copy_entity_txn_id;
1495: Cursor pgm is
1496: 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;
1497:
1498: Cursor c2 is
1499: select copy_entity_txn_id from pqh_copy_entity_txns where copy_entity_txn_id in
1500: (select copy_entity_txn_id from ben_copy_entity_results
1501: where information1 = p_ben_pgm_id and table_alias = 'PGM' and information_category = 'GRADE_LADDER'
1502: AND nvl(result_type_cd,'DISPLAY') = 'DISPLAY')
1503: and status = 'SFL';
1747: ---------------------------gen_txn_display_name-----------------------------
1748: --
1749:
1750: Function gen_txn_display_name
1751: (p_program_name IN pqh_copy_entity_txns.display_name%TYPE,
1752: p_mode IN varchar2)
1753: Return Varchar2 is
1754: l_timestamp varchar2(30) := fnd_date.date_to_canonical(sysdate);
1755: l_display_name varchar2(300);
1792: --
1793: ---------------------------get_grade_ladder_name_from_txn-----------------------------
1794: --
1795: Function get_grade_ladder_name_from_txn
1796: (p_pqh_copy_entity_txn_id IN pqh_copy_entity_txns.copy_entity_txn_id%TYPE)
1797: Return Varchar2 is
1798: cursor c1 is
1799: select information5 grade_ladder_name from ben_copy_entity_results
1800: where copy_entity_txn_id = p_pqh_copy_entity_txn_id
3944: l_get_which_rates varchar2(20) := get_which_rates(p_copy_entity_txn_id);
3945: l_crrate_icon varchar2(50);
3946: l_effective_date date;
3947: begin
3948: select action_date into l_effective_date from pqh_copy_entity_txns
3949: where copy_entity_txn_id = p_copy_entity_txn_id;
3950: if g_debug then
3951: hr_utility.set_location('Entering '||l_proc,5);
3952: end if;
4885:
4886:
4887: select action_date
4888: into l_effdate
4889: from pqh_copy_entity_txns
4890: where copy_entity_txn_id = p_copy_entity_txn_id;
4891:
4892:
4893:
4966: between nvl(information2, hr_general.start_of_time) and nvl(information3, hr_general.end_of_time);
4967:
4968: Cursor Csr_Action_Dt is
4969: Select Action_Date
4970: From Pqh_Copy_Entity_txns
4971: Where Copy_Entity_Txn_id = p_copy_entity_txn_id;
4972:
4973: cursor point_cer is
4974: select information262 from ben_copy_entity_results
5301: AND NVL (information104, 'PPP') <> 'UNLINK';
5302:
5303: Cursor Csr_Action_Dt is
5304: Select Action_Date
5305: From Pqh_Copy_Entity_txns
5306: Where Copy_Entity_Txn_id = p_copy_entity_txn_id;
5307:
5308: l_Action_Date date;
5309: begin