eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_TRANSACTION_SS dependencies on HR_API

Line 464: from hr_api_transaction_steps

460: RETURN varchar2 IS
461:
462: cursor csr_item_type_key is
463: select item_type,item_key
464: from hr_api_transaction_steps
465: where transaction_step_id = p_transaction_step_id;
466:
467: l_item_type hr_api_transaction_steps.item_type%type;
468: l_item_key hr_api_transaction_steps.item_key%type;

Line 467: l_item_type hr_api_transaction_steps.item_type%type;

463: select item_type,item_key
464: from hr_api_transaction_steps
465: where transaction_step_id = p_transaction_step_id;
466:
467: l_item_type hr_api_transaction_steps.item_type%type;
468: l_item_key hr_api_transaction_steps.item_key%type;
469: l_effective_date varchar2(100);
470: l_proc constant varchar2(100) := g_package || ' get_wf_effective_date';
471: BEGIN

Line 468: l_item_key hr_api_transaction_steps.item_key%type;

464: from hr_api_transaction_steps
465: where transaction_step_id = p_transaction_step_id;
466:
467: l_item_type hr_api_transaction_steps.item_type%type;
468: l_item_key hr_api_transaction_steps.item_key%type;
469: l_effective_date varchar2(100);
470: l_proc constant varchar2(100) := g_package || ' get_wf_effective_date';
471: BEGIN
472: hr_utility.set_location('Entering: '|| l_proc,5);

Line 560: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

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

Line 613: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

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

Line 615: l_transaction_ref_table hr_api_transactions.transaction_ref_table%type;

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

Line 650: -- the hr_api_transactions.transaction_ref_table should be used for reference

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

Line 657: from hr_api_transactions

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

Line 692: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

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:

Line 735: select transaction_id into l_transaction_id from hr_api_transactions where item_type = p_item_type and item_key = p_item_key;

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;

Line 752: ,l_function_id in out nocopy hr_api_transactions.function_id%TYPE

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

Line 753: ,ln_selected_person_id in out nocopy hr_api_transactions.selected_person_id%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

Line 754: ,lv_process_name in out nocopy hr_api_transactions.process_name%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

Line 755: ,lv_status in out nocopy hr_api_transactions.status%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

Line 756: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%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: )

Line 757: ,ln_assignment_id in out nocopy hr_api_transactions.assignment_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: )
761: AS

Line 758: ,ld_trans_effec_date in out nocopy hr_api_transactions.transaction_effective_date%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
762: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE

Line 759: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_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

Line 762: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%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
764: select fff.function_id, fff.function_name from
765: fnd_form_functions_vl fff
766: where fff.function_name = ( select iav.text_value

Line 763: ,p_item_key HR_API_TRANSACTION_STEPS.item_key%TYPE ) is

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
764: select fff.function_id, fff.function_name from
765: fnd_form_functions_vl fff
766: where fff.function_name = ( select iav.text_value
767: from wf_item_attribute_values iav

Line 879: ,p_transaction_ref_table in varchar2 default 'HR_API_TRANSACTIONS'

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

Line 894: l_transaction_privilege hr_api_transactions.transaction_privilege%type;

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;

Line 895: l_transaction_id hr_api_transactions.transaction_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;

Line 897: l_function_id hr_api_transactions.function_id%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;

Line 898: ln_selected_person_id hr_api_transactions.selected_person_id%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;

Line 899: lv_process_name hr_api_transactions.process_name%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;

Line 900: lv_status hr_api_transactions.status%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;

Line 901: lv_section_display_name hr_api_transactions.section_display_name%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';

Line 902: ln_assignment_id hr_api_transactions.assignment_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';
906: --

Line 903: ld_trans_effec_date hr_api_transactions.transaction_effective_date%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: --
907: begin

Line 904: lv_transaction_type hr_api_transactions.transaction_type%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
908: hr_utility.set_location('Entering: '|| l_proc,5);

Line 1070: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;

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

Line 1085: select hr_api_transactions.transaction_ref_table

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

Line 1087: from hr_api_transactions

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

Line 1088: where hr_api_transactions.transaction_id=(get_transaction_id(itemtype,itemkey));

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 ,

Line 1099: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'||

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:

Line 1176: select nvl(varchar2_value, hr_api.g_varchar2) varchar2_value

1172: l_error varchar2(2000);
1173: l_proc constant varchar2(100) := g_package || ' process_web_api_call';
1174: --
1175: cursor csel is
1176: select nvl(varchar2_value, hr_api.g_varchar2) varchar2_value
1177: ,nvl(number_value, hr_api.g_number) number_value
1178: ,nvl(date_value, hr_api.g_date) date_value
1179: ,nvl(original_varchar2_value, hr_api.g_varchar2) original_varchar2_value
1180: ,nvl(original_number_value, hr_api.g_number) original_number_value

Line 1177: ,nvl(number_value, hr_api.g_number) number_value

1173: l_proc constant varchar2(100) := g_package || ' process_web_api_call';
1174: --
1175: cursor csel is
1176: select nvl(varchar2_value, hr_api.g_varchar2) varchar2_value
1177: ,nvl(number_value, hr_api.g_number) number_value
1178: ,nvl(date_value, hr_api.g_date) date_value
1179: ,nvl(original_varchar2_value, hr_api.g_varchar2) original_varchar2_value
1180: ,nvl(original_number_value, hr_api.g_number) original_number_value
1181: ,nvl(original_date_value, hr_api.g_date) original_date_value

Line 1178: ,nvl(date_value, hr_api.g_date) date_value

1174: --
1175: cursor csel is
1176: select nvl(varchar2_value, hr_api.g_varchar2) varchar2_value
1177: ,nvl(number_value, hr_api.g_number) number_value
1178: ,nvl(date_value, hr_api.g_date) date_value
1179: ,nvl(original_varchar2_value, hr_api.g_varchar2) original_varchar2_value
1180: ,nvl(original_number_value, hr_api.g_number) original_number_value
1181: ,nvl(original_date_value, hr_api.g_date) original_date_value
1182: from hr_api_transaction_values hatv

Line 1179: ,nvl(original_varchar2_value, hr_api.g_varchar2) original_varchar2_value

1175: cursor csel is
1176: select nvl(varchar2_value, hr_api.g_varchar2) varchar2_value
1177: ,nvl(number_value, hr_api.g_number) number_value
1178: ,nvl(date_value, hr_api.g_date) date_value
1179: ,nvl(original_varchar2_value, hr_api.g_varchar2) original_varchar2_value
1180: ,nvl(original_number_value, hr_api.g_number) original_number_value
1181: ,nvl(original_date_value, hr_api.g_date) original_date_value
1182: from hr_api_transaction_values hatv
1183: where hatv.transaction_step_id = p_transaction_step_id;

Line 1180: ,nvl(original_number_value, hr_api.g_number) original_number_value

1176: select nvl(varchar2_value, hr_api.g_varchar2) varchar2_value
1177: ,nvl(number_value, hr_api.g_number) number_value
1178: ,nvl(date_value, hr_api.g_date) date_value
1179: ,nvl(original_varchar2_value, hr_api.g_varchar2) original_varchar2_value
1180: ,nvl(original_number_value, hr_api.g_number) original_number_value
1181: ,nvl(original_date_value, hr_api.g_date) original_date_value
1182: from hr_api_transaction_values hatv
1183: where hatv.transaction_step_id = p_transaction_step_id;
1184: --

Line 1181: ,nvl(original_date_value, hr_api.g_date) original_date_value

1177: ,nvl(number_value, hr_api.g_number) number_value
1178: ,nvl(date_value, hr_api.g_date) date_value
1179: ,nvl(original_varchar2_value, hr_api.g_varchar2) original_varchar2_value
1180: ,nvl(original_number_value, hr_api.g_number) original_number_value
1181: ,nvl(original_date_value, hr_api.g_date) original_date_value
1182: from hr_api_transaction_values hatv
1183: where hatv.transaction_step_id = p_transaction_step_id;
1184: --
1185: begin

Line 1182: from hr_api_transaction_values hatv

1178: ,nvl(date_value, hr_api.g_date) date_value
1179: ,nvl(original_varchar2_value, hr_api.g_varchar2) original_varchar2_value
1180: ,nvl(original_number_value, hr_api.g_number) original_number_value
1181: ,nvl(original_date_value, hr_api.g_date) original_date_value
1182: from hr_api_transaction_values hatv
1183: where hatv.transaction_step_id = p_transaction_step_id;
1184: --
1185: begin
1186: /* this step has been commented out nocopy and should not be used until */

Line 1248: raise hr_api.validate_enabled;

1244: --
1245: -- when in validation only mode raise the Validate_Enabled exception
1246: --
1247: if p_validate then
1248: raise hr_api.validate_enabled;
1249: end if;
1250: end if;
1251: hr_utility.set_location('Leaving: '|| l_proc,15);
1252: exception

Line 1253: when hr_api.validate_enabled then

1249: end if;
1250: end if;
1251: hr_utility.set_location('Leaving: '|| l_proc,15);
1252: exception
1253: when hr_api.validate_enabled then
1254: --
1255: -- As the Validate_Enabled exception has been raised
1256: -- we must rollback to the savepoint
1257: --

Line 1315: l_transaction_id hr_api_transactions.transaction_id%type;

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;

Line 1332: from hr_api_transaction_steps trs

1328: ,trs.item_type
1329: ,trs.item_key
1330: ,trs.activity_id
1331: ,trs.creator_person_id
1332: from hr_api_transaction_steps trs
1333: where trs.transaction_id = l_transaction_id
1334: and trs.api_name <> 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API' --#4110654
1335: and object_type is null
1336: order by trs.processing_order,trs.transaction_step_id ; --#2313279

Line 1340: from fnd_form_functions fff, hr_api_transactions hat

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;

Line 1878: cursor get_trans_id ( p_trans_step_id HR_API_TRANSACTION_STEPS.transaction_step_id%TYPE) is

1874: ,p_effective_date_option in varchar2 default null
1875: ) AS
1876:
1877:
1878: cursor get_trans_id ( p_trans_step_id HR_API_TRANSACTION_STEPS.transaction_step_id%TYPE) is
1879: select transaction_id from hr_api_transaction_steps
1880: where transaction_step_id = p_trans_step_id;
1881:
1882: l_count INTEGER := 0;

Line 1879: select transaction_id from hr_api_transaction_steps

1875: ) AS
1876:
1877:
1878: cursor get_trans_id ( p_trans_step_id HR_API_TRANSACTION_STEPS.transaction_step_id%TYPE) is
1879: select transaction_id from hr_api_transaction_steps
1880: where transaction_step_id = p_trans_step_id;
1881:
1882: l_count INTEGER := 0;
1883: l_result VARCHAR2(100);

Line 1884: l_trs_ovn hr_api_transaction_steps.object_version_number%TYPE;

1880: where transaction_step_id = p_trans_step_id;
1881:
1882: l_count INTEGER := 0;
1883: l_result VARCHAR2(100);
1884: l_trs_ovn hr_api_transaction_steps.object_version_number%TYPE;
1885: l_original_date date; --ns
1886: l_original_number number; --ns
1887: l_transaction_state varchar2(10) := hr_api.g_varchar2; --ns
1888: l_date date;

Line 1887: l_transaction_state varchar2(10) := hr_api.g_varchar2; --ns

1883: l_result VARCHAR2(100);
1884: l_trs_ovn hr_api_transaction_steps.object_version_number%TYPE;
1885: l_original_date date; --ns
1886: l_original_number number; --ns
1887: l_transaction_state varchar2(10) := hr_api.g_varchar2; --ns
1888: l_date date;
1889: l_value_error BOOLEAN := false;
1890: l_proc constant varchar2(100) := g_package || ' save_transaction_step';
1891:

Line 1892: l_function_id hr_api_transactions.function_id%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;

Line 1893: ln_selected_person_id hr_api_transactions.selected_person_id%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;

Line 1894: lv_process_name hr_api_transactions.process_name%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;

Line 1895: lv_status hr_api_transactions.status%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;

Line 1896: lv_section_display_name hr_api_transactions.section_display_name%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;

Line 1897: ln_assignment_id hr_api_transactions.assignment_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:

Line 1898: ld_trans_effec_date hr_api_transactions.transaction_effective_date%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:
1902: BEGIN

Line 1899: lv_transaction_type hr_api_transactions.transaction_type%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
1903:

Line 1900: ln_transaction_id hr_api_transaction_steps.transaction_id%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:
1904: hr_utility.set_location('Entering: '|| l_proc,5);

Line 1948: ,p_transaction_ref_table => 'HR_API_TRANSACTIONS'

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

Line 2081: lv_status := hr_api.g_varchar2; -- so that the original value is picked from txn table;

2077: IF ln_transaction_id IS NOT NULL THEN
2078: hr_utility.trace('In ( I IF ln_transaction_id IS NOT NULL ) '|| l_proc);
2079: Begin
2080: if ( wf_engine.GetItemAttrText(p_item_type ,p_item_key ,'HR_APPROVAL_PRC_VERSION') = 'V5' ) then
2081: lv_status := hr_api.g_varchar2; -- so that the original value is picked from txn table;
2082: end if;
2083: Exception
2084: when Others then -- wf attribute not found
2085: hr_utility.set_location('EXCEPTION: '|| l_proc,570);

Line 2118: RETURN hr_api_transaction_steps.transaction_step_id%TYPE IS

2114: FUNCTION get_activity_trans_step_id
2115: (p_activity_name IN
2116: wf_item_activity_statuses_v.activity_name%TYPE
2117: ,p_trans_step_id_tbl IN hr_util_web.g_varchar2_tab_type)
2118: RETURN hr_api_transaction_steps.transaction_step_id%TYPE IS
2119: ln_transaction_step_id
2120: hr_api_transaction_steps.transaction_step_id%TYPE;
2121: li_step_count INTEGER;
2122: l_proc constant varchar2(100) := g_package || ' get_activity_trans_step_id';

Line 2120: hr_api_transaction_steps.transaction_step_id%TYPE;

2116: wf_item_activity_statuses_v.activity_name%TYPE
2117: ,p_trans_step_id_tbl IN hr_util_web.g_varchar2_tab_type)
2118: RETURN hr_api_transaction_steps.transaction_step_id%TYPE IS
2119: ln_transaction_step_id
2120: hr_api_transaction_steps.transaction_step_id%TYPE;
2121: li_step_count INTEGER;
2122: l_proc constant varchar2(100) := g_package || ' get_activity_trans_step_id';
2123: BEGIN
2124:

Line 2212: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

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 ;

Line 2388: from hr_api_transaction_steps hats

2384: return number is
2385:
2386: cursor csr_hats is
2387: select hats.object_version_number
2388: from hr_api_transaction_steps hats
2389: where hats.transaction_step_id = p_transaction_step_id;
2390:
2391: l_ovb number;
2392: l_proc constant varchar2(100) := g_package || ' get_transaction_step_ovn';

Line 2520: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

2516: ,p_status OUT NOCOPY VARCHAR2) IS
2517:
2518: l_tmp_proc_call varchar2(32000);
2519: l_tmp_proc_call1 varchar2(32000);
2520: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
2521: l_delimiter varchar2(3) := '|!|';
2522: l_start number;
2523: l_start1 number;
2524: l_pos number;

Line 2540: p_item_key in hr_api_transaction_steps.item_key%type

2536: -- csr_wf_active_item Returns the item key of any process which
2537: -- is currently active with the name of p_process and belonging to
2538: -- the given person id
2539: cursor csr_hatv (
2540: p_item_key in hr_api_transaction_steps.item_key%type
2541: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2542: ,p_name in hr_api_transaction_values.name%type
2543: ) is
2544: select val.varchar2_value, val.transaction_step_id

Line 2541: ,p_item_Type in hr_api_transaction_steps.item_Type%type

2537: -- is currently active with the name of p_process and belonging to
2538: -- the given person id
2539: cursor csr_hatv (
2540: p_item_key in hr_api_transaction_steps.item_key%type
2541: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2542: ,p_name in hr_api_transaction_values.name%type
2543: ) is
2544: select val.varchar2_value, val.transaction_step_id
2545: from hr_api_transaction_values val, hr_api_transaction_steps step

Line 2542: ,p_name in hr_api_transaction_values.name%type

2538: -- the given person id
2539: cursor csr_hatv (
2540: p_item_key in hr_api_transaction_steps.item_key%type
2541: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2542: ,p_name in hr_api_transaction_values.name%type
2543: ) is
2544: select val.varchar2_value, val.transaction_step_id
2545: from hr_api_transaction_values val, hr_api_transaction_steps step
2546: where step.item_type = p_item_type

Line 2545: from hr_api_transaction_values val, hr_api_transaction_steps step

2541: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2542: ,p_name in hr_api_transaction_values.name%type
2543: ) is
2544: select val.varchar2_value, val.transaction_step_id
2545: from hr_api_transaction_values val, hr_api_transaction_steps step
2546: where step.item_type = p_item_type
2547: and step.item_key = p_item_key
2548: and step.transaction_step_id = val.transaction_step_id
2549: and val.name = p_name

Line 2555: in hr_api_transaction_steps.transaction_step_id%type

2551: order by step.processing_order, step.transaction_step_id asc;
2552:
2553: cursor csr_act (
2554: p_transaction_step_id
2555: in hr_api_transaction_steps.transaction_step_id%type
2556: ,p_name in hr_api_transaction_values.name%type
2557: ) is
2558: select varchar2_value
2559: from hr_api_transaction_values

Line 2556: ,p_name in hr_api_transaction_values.name%type

2552:
2553: cursor csr_act (
2554: p_transaction_step_id
2555: in hr_api_transaction_steps.transaction_step_id%type
2556: ,p_name in hr_api_transaction_values.name%type
2557: ) is
2558: select varchar2_value
2559: from hr_api_transaction_values
2560: where transaction_step_id = p_transaction_step_id

Line 2559: from hr_api_transaction_values

2555: in hr_api_transaction_steps.transaction_step_id%type
2556: ,p_name in hr_api_transaction_values.name%type
2557: ) is
2558: select varchar2_value
2559: from hr_api_transaction_values
2560: where transaction_step_id = p_transaction_step_id
2561: and name = p_name
2562: and varchar2_value Is Not Null;
2563:

Line 2571: from hr_api_transaction_steps

2567: p_status := 'SUCCESS';
2568:
2569: select count(transaction_step_id)
2570: into l_tx_step_count
2571: from hr_api_transaction_steps
2572: where item_key = p_item_key
2573: and item_type = p_item_type;
2574:
2575: if l_tx_step_count <> 0 then -- user has changed data in one of the previous pages

Line 2676: from hr_api_transaction_values

2672: select NAME,
2673: VARCHAR2_VALUE,
2674: NUMBER_VALUE,
2675: DATE_VALUE
2676: from hr_api_transaction_values
2677: where transaction_step_id = p_transaction_step_id
2678: order by transaction_value_id;
2679:
2680: i integer := 0;