556: itemkey in varchar2,
557: actid in number,
558: funmode in varchar2,
559: result out nocopy varchar2 ) is
560: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
561: l_proc constant varchar2(100) := g_package || ' set_delete_save_for_later';
562: begin
563: hr_utility.set_location('Entering: '|| l_proc,5);
564: if ( funmode = 'RUN' ) then
609: itemkey in varchar2,
610: actid in number,
611: funmode in varchar2,
612: result out nocopy varchar2 ) is
613: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
614: l_result varchar2(2000); --ns
615: l_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
616: l_proc constant varchar2(100) := g_package || ' set_return_for_correction';
617: begin
611: funmode in varchar2,
612: result out nocopy varchar2 ) is
613: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
614: l_result varchar2(2000); --ns
615: l_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
616: l_proc constant varchar2(100) := g_package || ' set_return_for_correction';
617: begin
618: hr_utility.set_location('Entering: '|| l_proc,5);
619: if ( funmode = 'RUN' ) then
646: -- as per the appraisals new build sshr5.1 check if we need call the appraisals routine
647: -- in RFC
648: begin
649: -- check if this is a appraisal transaction
650: -- the hr_api_transactions.transaction_ref_table should be used for reference
651: -- get the transaction id
652: ln_transaction_id := get_transaction_id(itemtype, itemkey);
653:
654: -- get the transaction_ref_table
653:
654: -- get the transaction_ref_table
655: select transaction_ref_table
656: into l_transaction_ref_table
657: from hr_api_transactions
658: where transaction_id=ln_transaction_id;
659:
660: if(upper(l_transaction_ref_table)='PER_APPRAISALS') then
661: hr_appraisal_workflow_ss.set_appraisal_rfc_status(p_itemtype=>itemType
688: itemkey in varchar2,
689: actid in number,
690: funmode in varchar2,
691: result out nocopy varchar2 ) is
692: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
693: l_proc constant varchar2(100) := g_package || ' set_submit_for_approval';
694: begin
695: hr_utility.set_location('Entering: '|| l_proc,5);
696:
731: exception
732: when others then
733: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
734: -- the TRANSACTION_ID doesn't exist as an item so return null
735: select transaction_id into l_transaction_id from hr_api_transactions where item_type = p_item_type and item_key = p_item_key;
736: hr_utility.set_location('l_transaction_id: '|| l_transaction_id,10);
737: return(l_transaction_id);
738:
739: end get_transaction_id;
748: ,p_section_display_name in varchar2
749: ,p_assignment_id in number
750: ,p_transaction_effective_date in date
751: ,p_transaction_type in varchar2
752: ,l_function_id in out nocopy hr_api_transactions.function_id%TYPE
753: ,ln_selected_person_id in out nocopy hr_api_transactions.selected_person_id%TYPE
754: ,lv_process_name in out nocopy hr_api_transactions.process_name%TYPE
755: ,lv_status in out nocopy hr_api_transactions.status%TYPE
756: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%TYPE
749: ,p_assignment_id in number
750: ,p_transaction_effective_date in date
751: ,p_transaction_type in varchar2
752: ,l_function_id in out nocopy hr_api_transactions.function_id%TYPE
753: ,ln_selected_person_id in out nocopy hr_api_transactions.selected_person_id%TYPE
754: ,lv_process_name in out nocopy hr_api_transactions.process_name%TYPE
755: ,lv_status in out nocopy hr_api_transactions.status%TYPE
756: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%TYPE
757: ,ln_assignment_id in out nocopy hr_api_transactions.assignment_id%TYPE
750: ,p_transaction_effective_date in date
751: ,p_transaction_type in varchar2
752: ,l_function_id in out nocopy hr_api_transactions.function_id%TYPE
753: ,ln_selected_person_id in out nocopy hr_api_transactions.selected_person_id%TYPE
754: ,lv_process_name in out nocopy hr_api_transactions.process_name%TYPE
755: ,lv_status in out nocopy hr_api_transactions.status%TYPE
756: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%TYPE
757: ,ln_assignment_id in out nocopy hr_api_transactions.assignment_id%TYPE
758: ,ld_trans_effec_date in out nocopy hr_api_transactions.transaction_effective_date%TYPE
751: ,p_transaction_type in varchar2
752: ,l_function_id in out nocopy hr_api_transactions.function_id%TYPE
753: ,ln_selected_person_id in out nocopy hr_api_transactions.selected_person_id%TYPE
754: ,lv_process_name in out nocopy hr_api_transactions.process_name%TYPE
755: ,lv_status in out nocopy hr_api_transactions.status%TYPE
756: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%TYPE
757: ,ln_assignment_id in out nocopy hr_api_transactions.assignment_id%TYPE
758: ,ld_trans_effec_date in out nocopy hr_api_transactions.transaction_effective_date%TYPE
759: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_type%TYPE
752: ,l_function_id in out nocopy hr_api_transactions.function_id%TYPE
753: ,ln_selected_person_id in out nocopy hr_api_transactions.selected_person_id%TYPE
754: ,lv_process_name in out nocopy hr_api_transactions.process_name%TYPE
755: ,lv_status in out nocopy hr_api_transactions.status%TYPE
756: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%TYPE
757: ,ln_assignment_id in out nocopy hr_api_transactions.assignment_id%TYPE
758: ,ld_trans_effec_date in out nocopy hr_api_transactions.transaction_effective_date%TYPE
759: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_type%TYPE
760: )
753: ,ln_selected_person_id in out nocopy hr_api_transactions.selected_person_id%TYPE
754: ,lv_process_name in out nocopy hr_api_transactions.process_name%TYPE
755: ,lv_status in out nocopy hr_api_transactions.status%TYPE
756: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%TYPE
757: ,ln_assignment_id in out nocopy hr_api_transactions.assignment_id%TYPE
758: ,ld_trans_effec_date in out nocopy hr_api_transactions.transaction_effective_date%TYPE
759: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_type%TYPE
760: )
761: AS
754: ,lv_process_name in out nocopy hr_api_transactions.process_name%TYPE
755: ,lv_status in out nocopy hr_api_transactions.status%TYPE
756: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%TYPE
757: ,ln_assignment_id in out nocopy hr_api_transactions.assignment_id%TYPE
758: ,ld_trans_effec_date in out nocopy hr_api_transactions.transaction_effective_date%TYPE
759: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_type%TYPE
760: )
761: AS
762: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE
755: ,lv_status in out nocopy hr_api_transactions.status%TYPE
756: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%TYPE
757: ,ln_assignment_id in out nocopy hr_api_transactions.assignment_id%TYPE
758: ,ld_trans_effec_date in out nocopy hr_api_transactions.transaction_effective_date%TYPE
759: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_type%TYPE
760: )
761: AS
762: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE
763: ,p_item_key HR_API_TRANSACTION_STEPS.item_key%TYPE ) is
875: ,p_url in varchar2 default null
876: ,p_status in varchar2 default null
877: ,p_section_display_name in varchar2 default null
878: ,p_function_id in number default null
879: ,p_transaction_ref_table in varchar2 default 'HR_API_TRANSACTIONS'
880: ,p_transaction_ref_id in number default null
881: ,p_transaction_type in varchar2 default null
882: ,p_assignment_id in number default null
883: ,p_api_addtnl_info in varchar2 default null
890: ,result out nocopy varchar2) is
891: -- --------------------------------------------------------------------------
892: -- declare local variables
893: -- --------------------------------------------------------------------------
894: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
895: l_transaction_id hr_api_transactions.transaction_id%type;
896:
897: l_function_id hr_api_transactions.function_id%TYPE;
898: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
891: -- --------------------------------------------------------------------------
892: -- declare local variables
893: -- --------------------------------------------------------------------------
894: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
895: l_transaction_id hr_api_transactions.transaction_id%type;
896:
897: l_function_id hr_api_transactions.function_id%TYPE;
898: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
899: lv_process_name hr_api_transactions.process_name%TYPE;
893: -- --------------------------------------------------------------------------
894: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
895: l_transaction_id hr_api_transactions.transaction_id%type;
896:
897: l_function_id hr_api_transactions.function_id%TYPE;
898: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
899: lv_process_name hr_api_transactions.process_name%TYPE;
900: lv_status hr_api_transactions.status%TYPE;
901: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
894: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
895: l_transaction_id hr_api_transactions.transaction_id%type;
896:
897: l_function_id hr_api_transactions.function_id%TYPE;
898: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
899: lv_process_name hr_api_transactions.process_name%TYPE;
900: lv_status hr_api_transactions.status%TYPE;
901: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
902: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
895: l_transaction_id hr_api_transactions.transaction_id%type;
896:
897: l_function_id hr_api_transactions.function_id%TYPE;
898: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
899: lv_process_name hr_api_transactions.process_name%TYPE;
900: lv_status hr_api_transactions.status%TYPE;
901: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
902: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
903: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
896:
897: l_function_id hr_api_transactions.function_id%TYPE;
898: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
899: lv_process_name hr_api_transactions.process_name%TYPE;
900: lv_status hr_api_transactions.status%TYPE;
901: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
902: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
903: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
904: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
897: l_function_id hr_api_transactions.function_id%TYPE;
898: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
899: lv_process_name hr_api_transactions.process_name%TYPE;
900: lv_status hr_api_transactions.status%TYPE;
901: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
902: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
903: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
904: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
905: l_proc constant varchar2(100) := g_package || ' start_transaction';
898: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
899: lv_process_name hr_api_transactions.process_name%TYPE;
900: lv_status hr_api_transactions.status%TYPE;
901: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
902: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
903: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
904: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
905: l_proc constant varchar2(100) := g_package || ' start_transaction';
906: --
899: lv_process_name hr_api_transactions.process_name%TYPE;
900: lv_status hr_api_transactions.status%TYPE;
901: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
902: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
903: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
904: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
905: l_proc constant varchar2(100) := g_package || ' start_transaction';
906: --
907: begin
900: lv_status hr_api_transactions.status%TYPE;
901: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
902: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
903: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
904: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
905: l_proc constant varchar2(100) := g_package || ' start_transaction';
906: --
907: begin
908: hr_utility.set_location('Entering: '|| l_proc,5);
1066: ,result out nocopy varchar2) is
1067: -- --------------------------------------------------------------------------
1068: -- declare local variables
1069: -- --------------------------------------------------------------------------
1070: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
1071: l_proc constant varchar2(100) := g_package || ' rollback_transaction';
1072: begin
1073: hr_utility.set_location('Entering: '|| l_proc,5);
1074: if funmode = 'RUN' then
1081: savepoint rollback_transaction;
1082: -- check if this is appraisal transaction
1083: -- we need to call the custom call to update the appraisal status
1084: begin
1085: select hr_api_transactions.transaction_ref_table
1086: into lv_transaction_ref_table
1087: from hr_api_transactions
1088: where hr_api_transactions.transaction_id=(get_transaction_id(itemtype,itemkey));
1089: /* BUG FIX 3112230
1083: -- we need to call the custom call to update the appraisal status
1084: begin
1085: select hr_api_transactions.transaction_ref_table
1086: into lv_transaction_ref_table
1087: from hr_api_transactions
1088: where hr_api_transactions.transaction_id=(get_transaction_id(itemtype,itemkey));
1089: /* BUG FIX 3112230
1090: if(lv_transaction_ref_table='PER_APPRAISALS') then
1091: -- call the custom call to update the status
1084: begin
1085: select hr_api_transactions.transaction_ref_table
1086: into lv_transaction_ref_table
1087: from hr_api_transactions
1088: where hr_api_transactions.transaction_id=(get_transaction_id(itemtype,itemkey));
1089: /* BUG FIX 3112230
1090: if(lv_transaction_ref_table='PER_APPRAISALS') then
1091: -- call the custom call to update the status
1092: hr_appraisal_workflow_ss.set_appraisal_reject_status(itemtype,itemkey, actid ,
1095: */
1096: exception
1097: when others then
1098: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1099: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'||
1100: 'rollback_transaction'||' : ' || sqlerrm);
1101: -- just log the message no need to raise it
1102: end;
1103:
1311: ,p_effective_date in varchar2 default null) is
1312: -- --------------------------------------------------------------------------
1313: -- declare local variables
1314: -- --------------------------------------------------------------------------
1315: l_transaction_id hr_api_transactions.transaction_id%type;
1316: l_application_error boolean := false;
1317: l_object_version_error boolean := false;
1318: l_obj_fatal_error boolean := false;
1319: l_warning_error boolean := false;
1336: order by trs.processing_order,trs.transaction_step_id ; --#2313279
1337: --
1338: cursor cur_fn is
1339: select fff.parameters
1340: from fnd_form_functions fff, hr_api_transactions hat
1341: where fff.function_id = hat.function_id
1342: and hat.transaction_id = l_transaction_id;
1343: --
1344: l_parameter fnd_form_functions.parameters%TYPE;
1888: l_date date;
1889: l_value_error BOOLEAN := false;
1890: l_proc constant varchar2(100) := g_package || ' save_transaction_step';
1891:
1892: l_function_id hr_api_transactions.function_id%TYPE;
1893: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
1894: lv_process_name hr_api_transactions.process_name%TYPE;
1895: lv_status hr_api_transactions.status%TYPE;
1896: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
1889: l_value_error BOOLEAN := false;
1890: l_proc constant varchar2(100) := g_package || ' save_transaction_step';
1891:
1892: l_function_id hr_api_transactions.function_id%TYPE;
1893: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
1894: lv_process_name hr_api_transactions.process_name%TYPE;
1895: lv_status hr_api_transactions.status%TYPE;
1896: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
1897: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
1890: l_proc constant varchar2(100) := g_package || ' save_transaction_step';
1891:
1892: l_function_id hr_api_transactions.function_id%TYPE;
1893: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
1894: lv_process_name hr_api_transactions.process_name%TYPE;
1895: lv_status hr_api_transactions.status%TYPE;
1896: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
1897: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
1898: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
1891:
1892: l_function_id hr_api_transactions.function_id%TYPE;
1893: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
1894: lv_process_name hr_api_transactions.process_name%TYPE;
1895: lv_status hr_api_transactions.status%TYPE;
1896: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
1897: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
1898: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
1899: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
1892: l_function_id hr_api_transactions.function_id%TYPE;
1893: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
1894: lv_process_name hr_api_transactions.process_name%TYPE;
1895: lv_status hr_api_transactions.status%TYPE;
1896: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
1897: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
1898: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
1899: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
1900: ln_transaction_id hr_api_transaction_steps.transaction_id%TYPE;
1893: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
1894: lv_process_name hr_api_transactions.process_name%TYPE;
1895: lv_status hr_api_transactions.status%TYPE;
1896: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
1897: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
1898: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
1899: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
1900: ln_transaction_id hr_api_transaction_steps.transaction_id%TYPE;
1901:
1894: lv_process_name hr_api_transactions.process_name%TYPE;
1895: lv_status hr_api_transactions.status%TYPE;
1896: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
1897: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
1898: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
1899: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
1900: ln_transaction_id hr_api_transaction_steps.transaction_id%TYPE;
1901:
1902: BEGIN
1895: lv_status hr_api_transactions.status%TYPE;
1896: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
1897: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
1898: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
1899: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
1900: ln_transaction_id hr_api_transaction_steps.transaction_id%TYPE;
1901:
1902: BEGIN
1903:
1944: ,p_url => p_url
1945: ,p_status => lv_status
1946: ,p_section_display_name => lv_section_display_name
1947: ,p_function_id => l_function_id
1948: ,p_transaction_ref_table => 'HR_API_TRANSACTIONS'
1949: ,p_transaction_ref_id => p_transaction_ref_id
1950: ,p_transaction_type => lv_transaction_type
1951: ,p_assignment_id => ln_assignment_id
1952: ,p_api_addtnl_info => p_api_addtnl_info
2208: p_login_person_id IN varchar2 )
2209: IS
2210: ln_ovn NUMBER ;
2211: ln_transaction_step_id NUMBER;
2212: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2213: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2214: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2215: ln_trans_step_rows NUMBER ;
2216: ln_value_id NUMBER ;