[Home] [Help]
16: c_proc constant varchar2(30) := 'getRoleOrigSysInfo';
17: lv_disp_name wf_users.display_name%type;
18: lt_userRoles wf_directory.wf_local_roles_tbl_type;
19: begin
20: g_debug := hr_utility.debug_enabled;
21:
22: if g_debug then
23: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
24: end if;
19: begin
20: g_debug := hr_utility.debug_enabled;
21:
22: if g_debug then
23: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
24: end if;
25:
26: if(p_wf_ref_attr is not null) then
27: if(p_wf_ref_type='VARCHAR') then
79:
80: end if;
81:
82: if (g_debug ) then
83: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
84: end if;
85: exception
86: when others then
87: if g_debug then
84: end if;
85: exception
86: when others then
87: if g_debug then
88: hr_utility.set_location('Error in getRoleOrigSysInfo SQLERRM' ||' '||to_char(SQLCODE),20);
89: end if;
90:
91: raise;
92:
979: tn c_vt_txn%ROWTYPE;
980: --
981: BEGIN
982: --
983: hr_utility.set_location('Entering: copy_value to history -'||p_txnId, 5);
984: --
985: delete from pqh_ss_value_history
986: where approval_history_id = -1
987: and step_history_id in (
988: select step_history_id from pqh_ss_step_history
989: where transaction_history_id = p_txnId
990: and approval_history_id = -1);
991: --
992: hr_utility.set_location('delete value history done', 45);
993: delete from pqh_ss_step_history
994: where transaction_history_id = p_txnId
995: and approval_history_id = -1;
996:
995: and approval_history_id = -1;
996:
997: for r_supStep in c_vt_sup_step(p_txnId) loop
998:
999: hr_utility.set_location('step_id'||r_supStep.transaction_step_id, 10);
1000: --
1001: --Check to see if transaction history record already exists
1002: if c_vt_txn_h%ISOPEN then
1003: close c_vt_txn_h ;
1007: FETCH c_vt_txn_h INTO dummy;
1008:
1009: -- Create a new record if txn history does not exist
1010: IF c_vt_txn_h%NOTFOUND THEN
1011: hr_utility.set_location('Transaction history not found', 15);
1012: if c_vt_txn%ISOPEN then
1013: close c_vt_txn ;
1014: end if; --ISOPEN
1015: open c_vt_txn (p_txnId);
1015: open c_vt_txn (p_txnId);
1016: fetch c_vt_txn into tn;
1017: close c_vt_txn;
1018:
1019: hr_utility.set_location('Calling insert', 15);
1020: -- create approval history if it does not exist.
1021: insert_transaction_history (
1022: p_transaction_history_id => tn.transaction_id,
1023: p_creator_person_id => tn.creator_person_id,
1034: p_last_update_date => tn.last_update_date,
1035: p_last_updated_by => tn.last_updated_by,
1036: p_last_update_login => tn.last_update_login);
1037:
1038: hr_utility.set_location('Insert history complete', 20);
1039:
1040: END IF;
1041: CLOSE c_vt_txn_h;
1042: --
1039:
1040: END IF;
1041: CLOSE c_vt_txn_h;
1042: --
1043: hr_utility.set_location('delete step history done', 55);
1044:
1045: insert_step_history
1046: (p_step_history_id => r_supStep.transaction_step_id,
1047: p_approval_history_id => -1,
1057: p_last_update_date => r_supStep.last_update_date,
1058: p_last_updated_by => r_supStep.last_updated_by,
1059: p_last_update_login => r_supStep.last_update_login);
1060:
1061: hr_utility.set_location('insert step history done', 65);
1062:
1063: insert into pqh_ss_value_history (
1064: transaction_value_id ,
1065: step_history_id ,
1091: last_update_login
1092: from hr_api_transaction_values
1093: where transaction_step_id = r_supStep.transaction_step_id ;
1094: --
1095: hr_utility.set_location('Leaving: copy_value to history', 75);
1096: end loop ; --c_vt_sup_step
1097:
1098: END copy_value_to_history;
1099: