[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
667: ,p_process_name IN VARCHAR2
668: ,p_itemKey OUT NOCOPY VARCHAR2 )
669: IS
670: lv_item_key wf_items.item_key%type;
671: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
672: BEGIN
673: -- get the item key from sequence
674: -- Get the next item key from the sequence
675: select hr_workflow_item_key_s.nextval
698: wf_engine.setitemattrtext(p_itemType,p_itemKey,'HR_SFL_TRANS_REF_TABLE_ATTR',p_transaction_ref_table);
699: -- set the parent item type and item key ,if any for this SFL
700: begin
701: if(p_transaction_id is not null) then
702: select * into lr_hr_api_transaction_rec from hr_api_transactions
703: where transaction_id=p_transaction_id;
704:
705: wf_engine.setitemparent(p_itemType,p_itemKey,lr_hr_api_transaction_rec.item_type,lr_hr_api_transaction_rec.item_key,'SFL');
706: end if;
784: wf_engine.completeactivity(lv_item_type,lv_item_key,
785: wf_engine.getactivitylabel(ln_sfl_block_activity_id),
786: wf_engine.eng_trans_default);
787:
788: -- set the hr api transactions with the new notification id ??
789: p_notification_id := wf_engine.getitemattrnumber(lv_item_type,lv_item_key,'HR_LAST_SFL_NTF_ID_ATTR');
790:
791: else
792: -- raise exception.
811: ln_notification_id number;
812: begin
813: -- set the ntf id value to HR_LAST_SFL_NTF_ID_ATTR
814: wf_engine.setitemattrnumber(itemtype,itemkey,'HR_LAST_SFL_NTF_ID_ATTR',Wf_Engine.g_nid);
815: -- set the hr_api_transactions_table
816:
817: result := wf_engine.eng_trans_default;
818: EXCEPTION
819: WHEN others THEN
824: p_currentTxnStatus in varchar2,
825: p_proposedTxnStatus in varchar2) RETURN VARCHAR2
826: is
827: --local variables
828: c_updateStatus hr_api_transactions.status%type;
829: begin
830:
831: -- possible status of current transaction
832: -- RO Transactions returned to approver for correction
890: p_person_id in number) return boolean
891: is
892: -- local variables
893: l_returnStatus boolean;
894: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
895: ln_person_id number;
896: begin
897:
898: -- set the default value
900: ln_person_id := p_person_id;
901:
902: if(p_transaction_id is not null) then
903: -- derive the transaction details
904: select * into lr_hr_api_transaction_rec from hr_api_transactions
905: where transaction_id=p_transaction_id;
906: end if;
907:
908: --
920: procedure processApprovalSubmit(p_transaction_id in number)
921: is
922: -- local variables
923: c_proc constant varchar2(30) := 'processApprovalSubmit';
924: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
925: ln_activity_id wf_item_activity_statuses.process_activity%type;
926: lv_loginPersonDispName per_all_people_f.full_name%type;
927: lv_loginPersonUserName fnd_user.user_name%type;
928: ln_loginPersonId fnd_user.employee_id%type;
935: -- code logic
936: begin
937: if(p_transaction_id is not null) then
938: select * into lr_hr_api_transaction_rec
939: from hr_api_transactions
940: where transaction_id=p_transaction_id;
941:
942: if(lr_hr_api_transaction_rec.transaction_ref_table='PER_APPRAISALS') then
943: -- appraisal specfic