[Home] [Help]
1: PACKAGE BODY HR_CCMGR_SS AS
2: /* $Header: hrccmwrs.pkb 120.1 2006/02/07 14:56:50 snachuri noship $ */
3:
4: -- Global Variables
5: l_trans_tbl hr_transaction_ss.transaction_table;
6: g_package Varchar2(30):='HR_CCMGR_SS';
7: g_api_name Varchar2(30):='HR_CCMGR_SS.PROCESS_API';
8: g_date_format Varchar2(10):='RRRR-MM-DD';
9: g_data_error Exception;
412: l_eff_date := trunc(sysdate);
413: hr_utility.set_location(l_proc,555);
414: End;
415: hr_utility.set_location(l_proc,15);
416: l_transaction_id := hr_transaction_ss.get_transaction_id(p_item_type ,p_item_key);
417: dt_fndate.set_effective_date(l_eff_date);
418:
419: If l_transaction_id is Null Then
420: hr_utility.set_location(l_proc,20);
417: dt_fndate.set_effective_date(l_eff_date);
418:
419: If l_transaction_id is Null Then
420: hr_utility.set_location(l_proc,20);
421: hr_transaction_ss.start_transaction
422: (itemtype => p_item_type
423: ,itemkey => p_item_key
424: ,actid => p_activity_id
425: ,funmode => 'RUN'
424: ,actid => p_activity_id
425: ,funmode => 'RUN'
426: ,p_login_person_id => p_login_person_id
427: ,result => l_result);
428: l_transaction_id := hr_transaction_ss.get_transaction_id(p_item_type ,p_item_key);
429: End If;
430: hr_utility.set_location(l_proc,25);
431: For I in 1 .. p_ccmgr_tbl.count Loop
432: Begin
615: l_trans_tbl(l_count).param_name := 'P_REVIEW_ACTID';
616: l_trans_tbl(l_count).param_value := p_activity_id;
617: l_trans_tbl(l_count).param_data_type := 'VARCHAR2';
618: hr_utility.set_location(l_proc ,110);
619: hr_transaction_ss.save_transaction_step
620: (p_item_type => p_item_type
621: ,p_item_key => p_item_key
622: ,p_actid => p_activity_id
623: ,p_login_person_id => p_login_person_id