[Home] [Help]
6: g_package constant varchar2(14) := 'hr_sflutil_ss.';
7: g_debug boolean ;
8:
9: --5672792
10: function isCurrentTxnSFLClose ( p_transaction_id hr_api_transactions.transaction_id%type )
11: return varchar2
12: is
13: result varchar2(10) := null;
14: c_proc constant varchar2(50) :='isCurrentTxnSFLClose';
12: is
13: result varchar2(10) := null;
14: c_proc constant varchar2(50) :='isCurrentTxnSFLClose';
15: l_temp boolean;
16: p_item_type hr_api_transactions.item_type%type;
17: p_item_key hr_api_transactions.item_key%type;
18: begin
19: --hr_utility.trace_on(null,'Oracle');
20: hr_utility.set_location('p_transaction_id : ' || p_transaction_id , 0 );
13: result varchar2(10) := null;
14: c_proc constant varchar2(50) :='isCurrentTxnSFLClose';
15: l_temp boolean;
16: p_item_type hr_api_transactions.item_type%type;
17: p_item_key hr_api_transactions.item_key%type;
18: begin
19: --hr_utility.trace_on(null,'Oracle');
20: hr_utility.set_location('p_transaction_id : ' || p_transaction_id , 0 );
21: g_debug := hr_utility.debug_enabled;
310: document IN OUT NOCOPY varchar2,
311: document_type IN OUT NOCOPY Varchar2)
312: is
313: c_proc constant varchar2(30) := 'getSFLMsgSubject';
314: ln_transaction_id hr_api_transactions.transaction_id%type;
315: lv_parent_item_type wf_item_activity_statuses.item_type%type;
316: lv_parent_item_key wf_item_activity_statuses.item_key%type;
317: l_creator_person_id per_people_f.person_id%type;
318: l_creator_disp_name wf_users.display_name%type;
320: l_current_person_id per_people_f.person_id%type;
321: l_current_disp_name wf_users.display_name%type;
322: l_current_username wf_users.name%type;
323: lv_process_display_name wf_runnable_processes_v.display_name%type;
324: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
325: --ln_transaction_id hr_api_transactions.transaction_id%type;
326: lv_selected_func_prompt fnd_form_functions_vl.USER_FUNCTION_NAME%type;
327: lv_ntfSubMsg wf_item_attribute_values.text_value%type;
328: lv_TransCtx_xpath varchar2(20000) default 'Transaction/TransCtx';
321: l_current_disp_name wf_users.display_name%type;
322: l_current_username wf_users.name%type;
323: lv_process_display_name wf_runnable_processes_v.display_name%type;
324: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
325: --ln_transaction_id hr_api_transactions.transaction_id%type;
326: lv_selected_func_prompt fnd_form_functions_vl.USER_FUNCTION_NAME%type;
327: lv_ntfSubMsg wf_item_attribute_values.text_value%type;
328: lv_TransCtx_xpath varchar2(20000) default 'Transaction/TransCtx';
329:
348: document :=ln_transaction_id;
349:
350: if (ln_transaction_id is not null) then
351: begin
352: select * into lr_hr_api_transaction_rec from hr_api_transactions
353: where transaction_id=ln_transaction_id;
354: exception
355: when no_data_found then
356: if(hr_utility.debug_enabled) then
548:
549: function getActionSubject(p_transaction_id in number) return varchar2
550: is
551:
552: ln_function_id hr_api_transactions.function_id%type;
553: lv_section_display_name hr_api_transactions.section_display_name%type;
554: lv_subject varchar2(240);
555: begin
556: -- default value
549: function getActionSubject(p_transaction_id in number) return varchar2
550: is
551:
552: ln_function_id hr_api_transactions.function_id%type;
553: lv_section_display_name hr_api_transactions.section_display_name%type;
554: lv_subject varchar2(240);
555: begin
556: -- default value
557: lv_subject:=p_transaction_id;
560: begin
561:
562: select fffv.user_function_name,hat.section_display_name
563: into lv_subject,lv_section_display_name
564: from hr_api_transactions hat,fnd_form_functions_vl fffv
565: where hat.transaction_id=p_transaction_id
566: and hat.function_id=fffv.function_id;
567:
568: exception
668: ,p_process_name IN VARCHAR2
669: ,p_itemKey OUT NOCOPY VARCHAR2 )
670: IS
671: lv_item_key wf_items.item_key%type;
672: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
673: BEGIN
674: -- get the item key from sequence
675: -- Get the next item key from the sequence
676: select hr_workflow_item_key_s.nextval
699: wf_engine.setitemattrtext(p_itemType,p_itemKey,'HR_SFL_TRANS_REF_TABLE_ATTR',p_transaction_ref_table);
700: -- set the parent item type and item key ,if any for this SFL
701: begin
702: if(p_transaction_id is not null) then
703: select * into lr_hr_api_transaction_rec from hr_api_transactions
704: where transaction_id=p_transaction_id;
705:
706: wf_engine.setitemparent(p_itemType,p_itemKey,lr_hr_api_transaction_rec.item_type,lr_hr_api_transaction_rec.item_key,'SFL');
707: end if;
785: wf_engine.completeactivity(lv_item_type,lv_item_key,
786: wf_engine.getactivitylabel(ln_sfl_block_activity_id),
787: wf_engine.eng_trans_default);
788:
789: -- set the hr api transactions with the new notification id ??
790: p_notification_id := wf_engine.getitemattrnumber(lv_item_type,lv_item_key,'HR_LAST_SFL_NTF_ID_ATTR');
791:
792: else
793: -- raise exception.
812: ln_notification_id number;
813: begin
814: -- set the ntf id value to HR_LAST_SFL_NTF_ID_ATTR
815: wf_engine.setitemattrnumber(itemtype,itemkey,'HR_LAST_SFL_NTF_ID_ATTR',Wf_Engine.g_nid);
816: -- set the hr_api_transactions_table
817:
818: result := wf_engine.eng_trans_default;
819: EXCEPTION
820: WHEN others THEN
825: p_currentTxnStatus in varchar2,
826: p_proposedTxnStatus in varchar2) RETURN VARCHAR2
827: is
828: --local variables
829: c_updateStatus hr_api_transactions.status%type;
830: begin
831:
832: -- possible status of current transaction
833: -- RO Transactions returned to approver for correction
891: p_person_id in number) return boolean
892: is
893: -- local variables
894: l_returnStatus boolean;
895: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
896: ln_person_id number;
897: begin
898:
899: -- set the default value
901: ln_person_id := p_person_id;
902:
903: if(p_transaction_id is not null) then
904: -- derive the transaction details
905: select * into lr_hr_api_transaction_rec from hr_api_transactions
906: where transaction_id=p_transaction_id;
907: end if;
908:
909: --
921: procedure processApprovalSubmit(p_transaction_id in number)
922: is
923: -- local variables
924: c_proc constant varchar2(30) := 'processApprovalSubmit';
925: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
926: ln_activity_id wf_item_activity_statuses.process_activity%type;
927: lv_loginPersonDispName per_all_people_f.full_name%type;
928: lv_loginPersonUserName fnd_user.user_name%type;
929: ln_loginPersonId fnd_user.employee_id%type;
936: -- code logic
937: begin
938: if(p_transaction_id is not null) then
939: select * into lr_hr_api_transaction_rec
940: from hr_api_transactions
941: where transaction_id=p_transaction_id;
942:
943: if(lr_hr_api_transaction_rec.transaction_ref_table='PER_APPRAISALS') then
944: -- appraisal specfic