The following lines contain the word 'select', 'insert', 'update' or 'delete':
,P_SELECTED_PERSON_ID IN NUMBER DEFAULT NULL
,P_ITEM_TYPE IN VARCHAR2 DEFAULT NULL
,P_ITEM_KEY IN VARCHAR2 DEFAULT NULL
,P_TRANSACTION_EFFECTIVE_DATE IN DATE DEFAULT NULL
,P_PROCESS_NAME IN VARCHAR2 DEFAULT NULL
,P_TRANSACTION_STATE IN VARCHAR2 DEFAULT NULL
,P_EFFECTIVE_DATE_OPTION IN VARCHAR2 DEFAULT NULL
,P_RPTG_GRP_ID IN NUMBER DEFAULT NULL
,P_PLAN_ID IN NUMBER DEFAULT NULL
,P_CREATOR_ROLE IN VARCHAR2 DEFAULT NULL
,P_LAST_UPDATE_ROLE IN VARCHAR2 DEFAULT NULL
,P_PARENT_TRANSACTION_ID IN NUMBER DEFAULT NULL
,P_RELAUNCH_FUNCTION IN VARCHAR2 DEFAULT NULL
,P_TRANSACTION_GROUP IN VARCHAR2 DEFAULT NULL
,P_TRANSACTION_IDENTIFIER IN VARCHAR2 DEFAULT NULL
,P_TRANSACTION_DOCUMENT IN CLOB DEFAULT NULL
,P_VALIDATE IN NUMBER default hr_api.g_false_num
)
is
l_TRANSACTION_ID hr_api_transactions.TRANSACTION_ID%type;
l_last_update_role hr_api_transactions.last_update_role%type;
l_last_update_role := nvl(P_LAST_UPDATE_ROLE, 'PER:' || fnd_global.employee_id);
,p_selected_person_id=>P_SELECTED_PERSON_ID
,p_item_type=>P_ITEM_TYPE
,p_item_key=>P_ITEM_KEY
,p_transaction_effective_date=>P_TRANSACTION_EFFECTIVE_DATE
,p_process_name=>P_PROCESS_NAME
,p_plan_id=>p_plan_id
,p_rptg_grp_id=>p_rptg_grp_id
,p_effective_date_option=>p_effective_date_option
,p_api_addtnl_info=>p_api_addtnl_info
,p_creator_role =>l_creator_role
,p_last_update_role =>l_last_update_role
,p_parent_transaction_id => p_parent_transaction_id
,p_relaunch_function => p_relaunch_function
,p_transaction_group => p_transaction_group
,p_transaction_identifier => p_transaction_identifier
,p_transaction_document => p_transaction_document
);
,P_UPDATE_PERSON_ID IN NUMBER DEFAULT NULL
,P_OBJECT_TYPE IN VARCHAR2 DEFAULT NULL
,P_OBJECT_NAME IN VARCHAR2 DEFAULT NULL
,P_OBJECT_IDENTIFIER IN VARCHAR2 DEFAULT NULL
,P_OBJECT_STATE IN VARCHAR2 DEFAULT NULL
,P_PK1 IN VARCHAR2 DEFAULT NULL
,P_PK2 IN VARCHAR2 DEFAULT NULL
,P_PK3 IN VARCHAR2 DEFAULT NULL
,P_PK4 IN VARCHAR2 DEFAULT NULL
,P_PK5 IN VARCHAR2 DEFAULT NULL
,P_VALIDATE IN NUMBER DEFAULT hr_api.g_false_num
,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER
,P_TRANSACTION_ID IN NUMBER
,P_TRANSACTION_STEP_ID IN NUMBER
,p_information_category in VARCHAR2 default null
,p_information1 in VARCHAR2 default null
,p_information2 in VARCHAR2 default null
,p_information3 in VARCHAR2 default null
,p_information4 in VARCHAR2 default null
,p_information5 in VARCHAR2 default null
,p_information6 in VARCHAR2 default null
,p_information7 in VARCHAR2 default null
,p_information8 in VARCHAR2 default null
,p_information9 in VARCHAR2 default null
,p_information10 in VARCHAR2 default null
,p_information11 in VARCHAR2 default null
,p_information12 in VARCHAR2 default null
,p_information13 in VARCHAR2 default null
,p_information14 in VARCHAR2 default null
,p_information15 in VARCHAR2 default null
,p_information16 in VARCHAR2 default null
,p_information17 in VARCHAR2 default null
,p_information18 in VARCHAR2 default null
,p_information19 in VARCHAR2 default null
,p_information20 in VARCHAR2 default null
,p_information21 in VARCHAR2 default null
,p_information22 in VARCHAR2 default null
,p_information23 in VARCHAR2 default null
,p_information24 in VARCHAR2 default null
,p_information25 in VARCHAR2 default null
,p_information26 in VARCHAR2 default null
,p_information27 in VARCHAR2 default null
,p_information28 in VARCHAR2 default null
,p_information29 in VARCHAR2 default null
,p_information30 in VARCHAR2 default null
)
is
l_proc varchar2(72) := g_package || 'create_transaction_step';
p_update_person_id => p_update_person_id,
p_object_version_number => p_object_version_number ,
p_OBJECT_TYPE => p_OBJECT_TYPE,
p_OBJECT_NAME => p_OBJECT_NAME,
p_OBJECT_IDENTIFIER => p_OBJECT_IDENTIFIER,
p_OBJECT_STATE => p_OBJECT_STATE,
p_PK1 => p_PK1,
p_PK2 => p_PK2,
p_PK3 => p_PK3,
p_PK4 => p_PK4,
p_PK5 => p_PK5,
p_information_category => p_information_category,
p_information1 => p_information1,
p_information2 => p_information2,
p_information3 => p_information3,
p_information4 => p_information4,
p_information5 => p_information5,
p_information6 => p_information6,
p_information7 => p_information7,
p_information8 => p_information8,
p_information9 => p_information9,
p_information10 => p_information10,
p_information11 => p_information11,
p_information12 => p_information12,
p_information13 => p_information13,
p_information14 => p_information14,
p_information15 => p_information15,
p_information16 => p_information16,
p_information17 => p_information17,
p_information18 => p_information18,
p_information19 => p_information19,
p_information20 => p_information20,
p_information21 => p_information21,
p_information22 => p_information22,
p_information23 => p_information23,
p_information24 => p_information24,
p_information25 => p_information25,
p_information26 => p_information26,
p_information27 => p_information27,
p_information28 => p_information28,
p_information29 => p_information29,
p_information30 => p_information30,
p_validate => false
);
procedure update_transaction
(
P_TRANSACTION_ID IN NUMBER
,P_CREATOR_PERSON_ID IN NUMBER
,P_TRANSACTION_PRIVILEGE IN VARCHAR2
,P_PRODUCT_CODE IN VARCHAR2 DEFAULT NULL
,P_URL IN LONG DEFAULT NULL
,P_STATUS IN VARCHAR2 DEFAULT NULL
,P_SECTION_DISPLAY_NAME IN VARCHAR2 DEFAULT NULL
,P_FUNCTION_ID IN NUMBER DEFAULT NULL
,P_TRANSACTION_REF_TABLE IN VARCHAR2 DEFAULT NULL
,P_TRANSACTION_REF_ID IN NUMBER DEFAULT NULL
,P_TRANSACTION_TYPE IN VARCHAR2 DEFAULT NULL
,P_ASSIGNMENT_ID IN NUMBER DEFAULT NULL
,P_API_ADDTNL_INFO IN VARCHAR2 DEFAULT NULL
,P_SELECTED_PERSON_ID IN NUMBER DEFAULT NULL
,P_ITEM_TYPE IN VARCHAR2 DEFAULT NULL
,P_ITEM_KEY IN VARCHAR2 DEFAULT NULL
,P_TRANSACTION_EFFECTIVE_DATE IN DATE DEFAULT NULL
,P_PROCESS_NAME IN VARCHAR2 DEFAULT NULL
,P_TRANSACTION_STATE IN VARCHAR2 DEFAULT NULL
,P_EFFECTIVE_DATE_OPTION IN VARCHAR2 DEFAULT NULL
,P_RPTG_GRP_ID IN NUMBER DEFAULT NULL
,P_PLAN_ID IN NUMBER DEFAULT NULL
,P_CREATOR_ROLE IN VARCHAR2 DEFAULT NULL
,P_LAST_UPDATE_ROLE IN VARCHAR2 DEFAULT NULL
,P_PARENT_TRANSACTION_ID IN NUMBER DEFAULT NULL
,P_RELAUNCH_FUNCTION IN VARCHAR2 DEFAULT NULL
,P_TRANSACTION_GROUP IN VARCHAR2 DEFAULT NULL
,P_TRANSACTION_IDENTIFIER IN VARCHAR2 DEFAULT NULL
,P_TRANSACTION_DOCUMENT IN CLOB DEFAULT NULL
,P_VALIDATE IN NUMBER default hr_api.g_false_num
)
is
l_proc varchar2(72) := 'update_transaction';
l_last_update_role hr_api_transactions.last_update_role%type;
l_last_update_role := nvl(P_LAST_UPDATE_ROLE, 'PER:' || fnd_global.employee_id);
,p_selected_person_id=>P_SELECTED_PERSON_ID
,p_item_type=>P_ITEM_TYPE
,p_item_key=>P_ITEM_KEY
,p_transaction_effective_date=>P_TRANSACTION_EFFECTIVE_DATE
,p_process_name=>P_PROCESS_NAME
,p_plan_id=>p_plan_id
,p_rptg_grp_id=>p_rptg_grp_id
,p_effective_date_option=>p_effective_date_option
,p_api_addtnl_info=>p_api_addtnl_info
,p_creator_role =>p_creator_role
,p_last_update_role =>l_last_update_role
,p_parent_transaction_id => p_parent_transaction_id
,p_relaunch_function => p_relaunch_function
,p_transaction_group => p_transaction_group
,p_transaction_identifier => p_transaction_identifier
,p_transaction_document => p_transaction_document
,p_transaction_state => p_transaction_state -- Heena
);
rollback ;--to update_transaction;
end update_transaction;
procedure update_transaction_step
(
P_API_NAME IN VARCHAR2
,P_API_DISPLAY_NAME IN VARCHAR2 DEFAULT NULL
,P_PROCESSING_ORDER IN NUMBER
,P_ITEM_TYPE IN VARCHAR2 DEFAULT NULL
,P_ITEM_KEY IN VARCHAR2 DEFAULT NULL
,P_ACTIVITY_ID IN NUMBER DEFAULT NULL
,P_CREATOR_PERSON_ID IN NUMBER
,P_UPDATE_PERSON_ID IN NUMBER DEFAULT NULL
,P_OBJECT_TYPE IN VARCHAR2 DEFAULT NULL
,P_OBJECT_NAME IN VARCHAR2 DEFAULT NULL
,P_OBJECT_IDENTIFIER IN VARCHAR2 DEFAULT NULL
,P_OBJECT_STATE IN VARCHAR2 DEFAULT NULL
,P_PK1 IN VARCHAR2 DEFAULT NULL
,P_PK2 IN VARCHAR2 DEFAULT NULL
,P_PK3 IN VARCHAR2 DEFAULT NULL
,P_PK4 IN VARCHAR2 DEFAULT NULL
,P_PK5 IN VARCHAR2 DEFAULT NULL
,P_VALIDATE IN NUMBER default hr_api.g_false_num
,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER
,P_TRANSACTION_ID IN NUMBER
,P_TRANSACTION_STEP_ID IN NUMBER
,p_information_category in VARCHAR2 default hr_api.g_varchar2
,p_information1 in VARCHAR2 default hr_api.g_varchar2
,p_information2 in VARCHAR2 default hr_api.g_varchar2
,p_information3 in VARCHAR2 default hr_api.g_varchar2
,p_information4 in VARCHAR2 default hr_api.g_varchar2
,p_information5 in VARCHAR2 default hr_api.g_varchar2
,p_information6 in VARCHAR2 default hr_api.g_varchar2
,p_information7 in VARCHAR2 default hr_api.g_varchar2
,p_information8 in VARCHAR2 default hr_api.g_varchar2
,p_information9 in VARCHAR2 default hr_api.g_varchar2
,p_information10 in VARCHAR2 default hr_api.g_varchar2
,p_information11 in VARCHAR2 default hr_api.g_varchar2
,p_information12 in VARCHAR2 default hr_api.g_varchar2
,p_information13 in VARCHAR2 default hr_api.g_varchar2
,p_information14 in VARCHAR2 default hr_api.g_varchar2
,p_information15 in VARCHAR2 default hr_api.g_varchar2
,p_information16 in VARCHAR2 default hr_api.g_varchar2
,p_information17 in VARCHAR2 default hr_api.g_varchar2
,p_information18 in VARCHAR2 default hr_api.g_varchar2
,p_information19 in VARCHAR2 default hr_api.g_varchar2
,p_information20 in VARCHAR2 default hr_api.g_varchar2
,p_information21 in VARCHAR2 default hr_api.g_varchar2
,p_information22 in VARCHAR2 default hr_api.g_varchar2
,p_information23 in VARCHAR2 default hr_api.g_varchar2
,p_information24 in VARCHAR2 default hr_api.g_varchar2
,p_information25 in VARCHAR2 default hr_api.g_varchar2
,p_information26 in VARCHAR2 default hr_api.g_varchar2
,p_information27 in VARCHAR2 default hr_api.g_varchar2
,p_information28 in VARCHAR2 default hr_api.g_varchar2
,p_information29 in VARCHAR2 default hr_api.g_varchar2
,p_information30 in VARCHAR2 default hr_api.g_varchar2
)
is
l_proc varchar2(72) := 'update_transaction_step';
p_update_person_id => p_update_person_id,
p_object_version_number => p_object_version_number ,
p_OBJECT_TYPE => p_OBJECT_TYPE,
p_OBJECT_NAME => p_OBJECT_NAME,
p_OBJECT_IDENTIFIER => p_OBJECT_IDENTIFIER,
p_OBJECT_STATE => p_OBJECT_STATE,
p_PK1 => p_PK1,
p_PK2 => p_PK2,
p_PK3 => p_PK3,
p_PK4 => p_PK4,
p_PK5 => p_PK5,
p_information_category => p_information_category,
p_information1 => p_information1,
p_information2 => p_information2,
p_information3 => p_information3,
p_information4 => p_information4,
p_information5 => p_information5,
p_information6 => p_information6,
p_information7 => p_information7,
p_information8 => p_information8,
p_information9 => p_information9,
p_information10 => p_information10,
p_information11 => p_information11,
p_information12 => p_information12,
p_information13 => p_information13,
p_information14 => p_information14,
p_information15 => p_information15,
p_information16 => p_information16,
p_information17 => p_information17,
p_information18 => p_information18,
p_information19 => p_information19,
p_information20 => p_information20,
p_information21 => p_information21,
p_information22 => p_information22,
p_information23 => p_information23,
p_information24 => p_information24,
p_information25 => p_information25,
p_information26 => p_information26,
p_information27 => p_information27,
p_information28 => p_information28,
p_information29 => p_information29,
p_information30 => p_information30,
p_validate => false
);
rollback ;--to update_transaction_step;
end update_transaction_step;
procedure delete_transaction_step
( p_transaction_step_id in number
,p_person_id in number
,p_object_version_number in number
,p_validate in number default hr_api.g_false_num
) is
--
l_proc constant varchar2(100) := g_package || ' delete_transaction_step';
hr_transaction_api.delete_transaction_step
(
p_validate => false
,p_transaction_step_id => p_transaction_step_id
,p_person_id => p_person_id
,p_object_version_number => p_object_version_number
);
rollback ;--to update_transaction_step;
end delete_transaction_step;
select *
from hr_api_transaction_steps
where transaction_id=p_transaction_id
and API_NAME = p_Api_Name
and OBJECT_TYPE is null;
select hat.transaction_id,
hat.creator_person_id,
hat.status,
hat.function_id,
hat.transaction_ref_table,
hat.transaction_ref_id,
hat.transaction_type,
hat.assignment_id,
hat.selected_person_id,
hat.item_type,
hat.item_key,
hat.transaction_effective_date,
hat.process_name,
hat.transaction_state,
hat.effective_date_option
from hr_api_transactions hat
where hat.transaction_id =p_transaction_id;
g_txn_ctx.SELECTED_PERSON_ID :=step_row.SELECTED_PERSON_ID;
p_selected_person_id in number,
p_selected_assignment_id in number,
p_effective_date in DATE)
IS
cursor csr_person_details is
select ppf.full_name,
ppf.person_id,
ppf.employee_number,
ppf.npw_number,
decode(ppf.current_employee_flag, 'Y', 'Y',decode(ppf.current_npw_flag,'Y','Y'),'N') active,
paf.assignment_id,
paf.assignment_number,
paf.assignment_type,
paf.primary_flag,
paf.supervisor_id,
sup.full_name supervisor_name,
ppf.business_group_id,
paf.organization_id,
bustl.name business_group_name,
orgtl.name organization_name,
paf.job_id,
jtl.name job_name,
paf.position_id,
postl.name position_name,
oi.org_information10 currency_code,
oi.org_information2 employee_number_generation,
oi.org_information3 applicant_number_generation,
oi.org_information16 npw_number_generation,
oi.org_information9 legislation_code,
fs.id_flex_structure_code people_grp_f_struct_code,
oi.org_information14 security_group_id,
paf.location_id,
paf.payroll_id
from per_all_people_f ppf,
per_all_assignments_f paf,
hr_all_organization_units_tl bustl,
hr_all_organization_units_tl orgtl,
per_jobs_tl jtl,
hr_all_positions_f_tl postl,
per_all_people_f sup,
hr_organization_information oi,
fnd_id_flex_structures fs
where ppf.person_id = p_selected_person_id
and ppf.person_id = paf.person_id
and paf.assignment_id = nvl(p_selected_assignment_id, paf.assignment_id)
and paf.assignment_type in ('E','C','A')
and paf.primary_flag = decode (nvl(p_selected_assignment_id, -1),-1,'Y', paf.primary_flag)
and paf.supervisor_id = sup.person_id(+)
and ppf.business_group_id = oi.organization_id
and oi.org_information_context = 'Business Group Information'
and oi.org_information5 = fs.id_flex_num(+)
and fs.id_flex_code(+) = 'GRP'
and fs.application_id(+) = 801
and ppf.business_group_id = bustl.organization_id
and bustl.language = userenv('LANG')
and paf.organization_id = orgtl.organization_id
and orgtl.language = userenv('LANG')
and paf.job_id = jtl.job_id(+)
and jtl.language(+) = userenv('LANG')
and paf.position_id = postl.position_id(+)
and postl.language(+) = userenv('LANG')
and p_effective_date between ppf.effective_start_date and ppf.effective_end_date
and p_effective_date between paf.effective_start_date and paf.effective_end_date
and p_effective_date between sup.effective_start_date(+) and sup.effective_end_date(+);
if p_selected_person_id is not null AND p_selected_assignment_id is not null AND p_effective_date is not null then
open csr_person_details;
select * into lr_hr_api_transaction_rec
from hr_api_transactions
where transaction_id= p_transaction_id;
select 'x'
into dummy
from per_people_f
where person_id = p_selected_person_id
and p_effective_date between effective_start_date and effective_end_date;
select *
from hr_api_transactions
where transaction_id = p_transaction_id;
select 'x'
into dummy
from per_people_f
where person_id = p_selected_person_id
and p_effective_date between effective_start_date and effective_end_date;
procedure delete_transaction(
p_transaction_id in NUMBER,
p_validate in NUMBER default hr_api.g_false_num)
is
l_proc varchar2(72) := g_package || 'delete_transaction';
delete_transaction_children(p_transaction_id, p_validate);
end delete_transaction;
c_updateStatus hr_api_transactions.status%type;
select 'Y' into l_exists
from dual
where exists (select 'e'
from wf_notifications wn, wf_message_attributes mat
where wn.notification_id = p_ntfId
and wn.message_name = mat.message_name
and wn.message_type = mat.message_type
and mat.name = 'RESULT');
SELECT * FROM per_appraisals WHERE appraisal_id = p_appraisal_id;
select * into lr_hr_api_transaction_rec
from hr_api_transactions
where transaction_id=p_transaction_id;
function isDeleteAllowed(p_transaction_id in number,
p_transaction_status in varchar2,
p_notification_id in number,
p_authenticateNtf in number,
p_propagateMessagePub in number)
return varchar2
is
-- local variables
deleteAllowed varchar2(1);
deleteAllowed :='N';
deleteAllowed :='E';
return deleteAllowed;
deleteAllowed :='E';
return deleteAllowed;
select * into lr_hr_api_transaction_rec
from hr_api_transactions
where transaction_id=p_transaction_id;
deleteAllowed :='N';
deleteAllowed := 'N';
deleteAllowed := 'Y';
deleteAllowed :='N';
return deleteAllowed;
deleteAllowed :='N';
return deleteAllowed;
end isDeleteAllowed;
procedure ownerDeleteAction(p_transaction_id in number,
p_currentTxnStatus in varchar2,
p_transaction_type in varchar2,
p_item_type in varchar2,
p_item_key in varchar2)
is
lv_result varchar2(100);
select ias.notification_id,ias.process_activity
into ln_notification_id,ln_activity_id
from wf_item_activity_statuses ias
where ias.item_type = p_item_type
and ias.item_key = p_item_key
and ias.activity_status = 'NOTIFIED'
and notification_id is not null
and rownum < 2;
hr_transaction_api.update_transaction(
p_transaction_id => p_transaction_id,
p_status => 'D');
end ownerDeleteAction;
procedure othersDeleteAction(p_transaction_id in number,
p_currentTxnStatus in varchar2,
p_transaction_type in varchar2,
p_item_type in varchar2,
p_item_key in varchar2)
is
lr_hr_api_transaction_rec hr_api_transactions%rowtype;
select ias.notification_id,ias.process_activity
into ln_notification_id,ln_activity_id
from wf_item_activity_statuses ias
where ias.item_type = p_item_type
and ias.item_key = p_item_key
and ias.activity_status = 'NOTIFIED'
and notification_id is not null
and rownum < 2;
end othersDeleteAction;
procedure deleteAction(p_transaction_id in number)
is
lr_hr_api_transaction_rec hr_api_transactions%rowtype;
W Soft delete N/A
set status
to 'D'
others no impl Reject txn
in phase I
Phase II we need the txn data rollback and
WF page navigation state reset.
*/
if(p_transaction_id is not null) then
begin
select * into lr_hr_api_transaction_rec
from hr_api_transactions
where transaction_id=p_transaction_id;
ownerDeleteAction(p_transaction_id ,
lr_hr_api_transaction_rec.status,
lr_hr_api_transaction_rec.transaction_type,
lr_hr_api_transaction_rec.item_type,
lr_hr_api_transaction_rec.item_key);
othersDeleteAction(p_transaction_id ,
lr_hr_api_transaction_rec.status,
lr_hr_api_transaction_rec.transaction_type,
lr_hr_api_transaction_rec.item_type,
lr_hr_api_transaction_rec.item_key);
end deleteAction;
procedure initiatorDeleteAction(p_transaction_id in number)
is
lv_result varchar2(100);
select * into lr_hr_api_transaction_rec
from hr_api_transactions
where transaction_id=p_transaction_id;
hr_transaction_api.update_transaction(
p_transaction_id => p_transaction_id,
p_status => 'D');
end initiatorDeleteAction;
select * into lr_hr_api_transaction_rec
from hr_api_transactions
where transaction_id=p_transaction_id;
deleteAction(p_transaction_id);
select hr_api_transactions.creator_person_id
into ln_person_id
from hr_api_transactions
where transaction_id=p_transaction_id;
procedure delete_transaction_children(
p_transaction_id in NUMBER,
p_validate in NUMBER default hr_api.g_false_num)
is
cursor csr_trn is
select trn.transaction_id
from hr_api_transactions trn
where trn.parent_transaction_id = p_transaction_id;
delete_transaction(csr_row.transaction_id);
end delete_transaction_children;
select *
into lr_transaction_rec
from hr_api_transactions
where transaction_id=p_transaction_id;
c_updateStatus hr_api_transactions.status%type;
c_updateStatus:='Y';
select status into lv_currentTxnStatus
from hr_api_transactions
where transaction_id=p_transaction_id;
c_updateStatus:= hr_sflutil_ss.getSFLStatusForUpdate(
nvl(p_currentTxnStatus,lv_currentTxnStatus),
p_proposedTxnStatus);
select *
into lr_hr_api_transaction_rec
from hr_api_transactions
where transaction_id=p_transaction_id;
hr_transaction_api.update_transaction(
p_transaction_id => p_transaction_id,
p_status => c_updateStatus,
p_transaction_state => null);
select *
into lr_hr_api_transaction_rec
from hr_api_transactions
where transaction_id=p_transaction_id;
hr_transaction_api.update_transaction(
p_transaction_id => p_transaction_id,
p_item_key => lv_item_key);
c_updateStatus hr_api_transactions.status%type;
c_updateStatus:='Y';
select status into lv_currentTxnStatus
from hr_api_transactions
where transaction_id=p_transaction_id;
c_updateStatus:= hr_sflutil_ss.getSFLStatusForUpdate(
nvl(p_currentTxnStatus,lv_currentTxnStatus),
p_proposedTxnStatus);
select *
into lr_hr_api_transaction_rec
from hr_api_transactions
where transaction_id=p_transaction_id;
hr_transaction_api.update_transaction(
p_transaction_id => p_transaction_id,
p_status => c_updateStatus,
p_transaction_state => null);
select *
into lr_hr_api_transaction_rec
from hr_api_transactions
where transaction_id=p_transaction_id;
-- update the transaction with the item key
hr_transaction_api.update_transaction(
p_transaction_id => p_transaction_id,
p_item_key => lv_item_key);
SELECT v$nls_parameters.value INTO charset FROM v$nls_parameters
WHERE v$nls_parameters.parameter='NLS_CHARACTERSET';
SELECT transaction_document
FROM hr_api_transactions
WHERE transaction_id = p_transaction_id;
SELECT item_type,item_key
FROM hr_api_transactions
WHERE transaction_id = p_transaction_id;
set_person_context( p_selected_person_id => g_txn_ctx.SELECTED_PERSON_ID,
p_selected_assignment_id => g_txn_ctx.ASSIGNMENT_ID,
p_effective_date => g_txn_ctx.EFFECTIVE_DATE);