[Home] [Help]
1022:
1023: end GET_HR_TRANSACTION_ID;
1024:
1025: procedure process_transaction_row
1026: (p_transaction_row in ben_icd_transaction%rowtype
1027: ,p_validate in number
1028: ,p_icd_effective_date in date)
1029: is
1030: l_warning number;
1323:
1324: end create_person_action_items;
1325:
1326:
1327: --This procedure will delete the row from ben_icd_transaction table
1328: procedure delete_transaction_row(p_icd_transaction_id number)
1329: is
1330: begin
1331: delete from ben_icd_transaction where icd_transaction_id = p_icd_transaction_id ;
1327: --This procedure will delete the row from ben_icd_transaction table
1328: procedure delete_transaction_row(p_icd_transaction_id number)
1329: is
1330: begin
1331: delete from ben_icd_transaction where icd_transaction_id = p_icd_transaction_id ;
1332: end delete_transaction_row;
1333:
1334: procedure suspend_enrollment(p_icd_transaction_id number)
1335: is
1333:
1334: procedure suspend_enrollment(p_icd_transaction_id number)
1335: is
1336: begin
1337: update ben_icd_transaction
1338: set status = 'SP'
1339: where icd_transaction_id = p_icd_transaction_id;
1340: end suspend_enrollment;
1341:
1348: p_effective_date in varchar2 default null) is
1349: --
1350: cursor c_icd_transaction is
1351: select *
1352: from ben_icd_transaction
1353: where transaction_id = (select transaction_id from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
1354: order by dml_operation;
1355:
1356: l_proc varchar2(61) := 'process_api' ;
1399:
1400:
1401: procedure unsuspend_enrollment(p_icd_transaction_id in number, p_effective_Date in date)
1402: is
1403: cursor c_transaction_row is select * from ben_icd_transaction where
1404: icd_transaction_id = p_icd_transaction_id
1405: order by dml_operation,element_entry_id,effective_start_date desc;
1406: l_validate number := 0;
1407: begin