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 527: from hr_api_transaction_steps

523: RETURN varchar2 IS
524:
525: cursor csr_item_type_key is
526: select item_type,item_key
527: from hr_api_transaction_steps
528: where transaction_step_id = p_transaction_step_id;
529:
530: l_item_type hr_api_transaction_steps.item_type%type;
531: l_item_key hr_api_transaction_steps.item_key%type;

Line 530: l_item_type hr_api_transaction_steps.item_type%type;

526: select item_type,item_key
527: from hr_api_transaction_steps
528: where transaction_step_id = p_transaction_step_id;
529:
530: l_item_type hr_api_transaction_steps.item_type%type;
531: l_item_key hr_api_transaction_steps.item_key%type;
532: l_effective_date varchar2(100);
533: l_proc constant varchar2(100) := g_package || ' get_wf_effective_date';
534: BEGIN

Line 531: l_item_key hr_api_transaction_steps.item_key%type;

527: from hr_api_transaction_steps
528: where transaction_step_id = p_transaction_step_id;
529:
530: l_item_type hr_api_transaction_steps.item_type%type;
531: l_item_key hr_api_transaction_steps.item_key%type;
532: l_effective_date varchar2(100);
533: l_proc constant varchar2(100) := g_package || ' get_wf_effective_date';
534: BEGIN
535: hr_utility.set_location('Entering: '|| l_proc,5);

Line 623: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

619: itemkey in varchar2,
620: actid in number,
621: funmode in varchar2,
622: result out nocopy varchar2 ) is
623: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
624: l_proc constant varchar2(100) := g_package || ' set_delete_save_for_later';
625: begin
626: hr_utility.set_location('Entering: '|| l_proc,5);
627: if ( funmode = 'RUN' ) then

Line 676: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

672: itemkey in varchar2,
673: actid in number,
674: funmode in varchar2,
675: result out nocopy varchar2 ) is
676: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
677: l_result varchar2(2000); --ns
678: l_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
679: l_proc constant varchar2(100) := g_package || ' set_return_for_correction';
680: begin

Line 678: l_transaction_ref_table hr_api_transactions.transaction_ref_table%type;

674: funmode in varchar2,
675: result out nocopy varchar2 ) is
676: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
677: l_result varchar2(2000); --ns
678: l_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
679: l_proc constant varchar2(100) := g_package || ' set_return_for_correction';
680: begin
681: hr_utility.set_location('Entering: '|| l_proc,5);
682: if ( funmode = 'RUN' ) then

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

709: -- as per the appraisals new build sshr5.1 check if we need call the appraisals routine
710: -- in RFC
711: begin
712: -- check if this is a appraisal transaction
713: -- the hr_api_transactions.transaction_ref_table should be used for reference
714: -- get the transaction id
715: ln_transaction_id := get_transaction_id(itemtype, itemkey);
716:
717: -- get the transaction_ref_table

Line 720: from hr_api_transactions

716:
717: -- get the transaction_ref_table
718: select transaction_ref_table
719: into l_transaction_ref_table
720: from hr_api_transactions
721: where transaction_id=ln_transaction_id;
722:
723: if(upper(l_transaction_ref_table)='PER_APPRAISALS') then
724: hr_appraisal_workflow_ss.set_appraisal_rfc_status(p_itemtype=>itemType

Line 755: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

751: itemkey in varchar2,
752: actid in number,
753: funmode in varchar2,
754: result out nocopy varchar2 ) is
755: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
756: l_proc constant varchar2(100) := g_package || ' set_submit_for_approval';
757: begin
758: hr_utility.set_location('Entering: '|| l_proc,5);
759:

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

794: exception
795: when others then
796: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
797: -- the TRANSACTION_ID doesn't exist as an item so return null
798: select transaction_id into l_transaction_id from hr_api_transactions where item_type = p_item_type and item_key = p_item_key;
799: hr_utility.set_location('l_transaction_id: '|| l_transaction_id,10);
800: return(l_transaction_id);
801:
802: end get_transaction_id;

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

811: ,p_section_display_name in varchar2
812: ,p_assignment_id in number
813: ,p_transaction_effective_date in date
814: ,p_transaction_type in varchar2
815: ,l_function_id in out nocopy hr_api_transactions.function_id%TYPE
816: ,ln_selected_person_id in out nocopy hr_api_transactions.selected_person_id%TYPE
817: ,lv_process_name in out nocopy hr_api_transactions.process_name%TYPE
818: ,lv_status in out nocopy hr_api_transactions.status%TYPE
819: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%TYPE

Line 816: ,ln_selected_person_id in out nocopy hr_api_transactions.selected_person_id%TYPE

812: ,p_assignment_id in number
813: ,p_transaction_effective_date in date
814: ,p_transaction_type in varchar2
815: ,l_function_id in out nocopy hr_api_transactions.function_id%TYPE
816: ,ln_selected_person_id in out nocopy hr_api_transactions.selected_person_id%TYPE
817: ,lv_process_name in out nocopy hr_api_transactions.process_name%TYPE
818: ,lv_status in out nocopy hr_api_transactions.status%TYPE
819: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%TYPE
820: ,ln_assignment_id in out nocopy hr_api_transactions.assignment_id%TYPE

Line 817: ,lv_process_name in out nocopy hr_api_transactions.process_name%TYPE

813: ,p_transaction_effective_date in date
814: ,p_transaction_type in varchar2
815: ,l_function_id in out nocopy hr_api_transactions.function_id%TYPE
816: ,ln_selected_person_id in out nocopy hr_api_transactions.selected_person_id%TYPE
817: ,lv_process_name in out nocopy hr_api_transactions.process_name%TYPE
818: ,lv_status in out nocopy hr_api_transactions.status%TYPE
819: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%TYPE
820: ,ln_assignment_id in out nocopy hr_api_transactions.assignment_id%TYPE
821: ,ld_trans_effec_date in out nocopy hr_api_transactions.transaction_effective_date%TYPE

Line 818: ,lv_status in out nocopy hr_api_transactions.status%TYPE

814: ,p_transaction_type in varchar2
815: ,l_function_id in out nocopy hr_api_transactions.function_id%TYPE
816: ,ln_selected_person_id in out nocopy hr_api_transactions.selected_person_id%TYPE
817: ,lv_process_name in out nocopy hr_api_transactions.process_name%TYPE
818: ,lv_status in out nocopy hr_api_transactions.status%TYPE
819: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%TYPE
820: ,ln_assignment_id in out nocopy hr_api_transactions.assignment_id%TYPE
821: ,ld_trans_effec_date in out nocopy hr_api_transactions.transaction_effective_date%TYPE
822: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_type%TYPE

Line 819: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%TYPE

815: ,l_function_id in out nocopy hr_api_transactions.function_id%TYPE
816: ,ln_selected_person_id in out nocopy hr_api_transactions.selected_person_id%TYPE
817: ,lv_process_name in out nocopy hr_api_transactions.process_name%TYPE
818: ,lv_status in out nocopy hr_api_transactions.status%TYPE
819: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%TYPE
820: ,ln_assignment_id in out nocopy hr_api_transactions.assignment_id%TYPE
821: ,ld_trans_effec_date in out nocopy hr_api_transactions.transaction_effective_date%TYPE
822: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_type%TYPE
823: )

Line 820: ,ln_assignment_id in out nocopy hr_api_transactions.assignment_id%TYPE

816: ,ln_selected_person_id in out nocopy hr_api_transactions.selected_person_id%TYPE
817: ,lv_process_name in out nocopy hr_api_transactions.process_name%TYPE
818: ,lv_status in out nocopy hr_api_transactions.status%TYPE
819: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%TYPE
820: ,ln_assignment_id in out nocopy hr_api_transactions.assignment_id%TYPE
821: ,ld_trans_effec_date in out nocopy hr_api_transactions.transaction_effective_date%TYPE
822: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_type%TYPE
823: )
824: AS

Line 821: ,ld_trans_effec_date in out nocopy hr_api_transactions.transaction_effective_date%TYPE

817: ,lv_process_name in out nocopy hr_api_transactions.process_name%TYPE
818: ,lv_status in out nocopy hr_api_transactions.status%TYPE
819: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%TYPE
820: ,ln_assignment_id in out nocopy hr_api_transactions.assignment_id%TYPE
821: ,ld_trans_effec_date in out nocopy hr_api_transactions.transaction_effective_date%TYPE
822: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_type%TYPE
823: )
824: AS
825: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE

Line 822: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_type%TYPE

818: ,lv_status in out nocopy hr_api_transactions.status%TYPE
819: ,lv_section_display_name in out nocopy hr_api_transactions.section_display_name%TYPE
820: ,ln_assignment_id in out nocopy hr_api_transactions.assignment_id%TYPE
821: ,ld_trans_effec_date in out nocopy hr_api_transactions.transaction_effective_date%TYPE
822: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_type%TYPE
823: )
824: AS
825: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE
826: ,p_item_key HR_API_TRANSACTION_STEPS.item_key%TYPE ) is

Line 825: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE

821: ,ld_trans_effec_date in out nocopy hr_api_transactions.transaction_effective_date%TYPE
822: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_type%TYPE
823: )
824: AS
825: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE
826: ,p_item_key HR_API_TRANSACTION_STEPS.item_key%TYPE ) is
827: select fff.function_id, fff.function_name from
828: fnd_form_functions_vl fff
829: where fff.function_name = ( select iav.text_value

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

822: ,lv_transaction_type in out nocopy hr_api_transactions.transaction_type%TYPE
823: )
824: AS
825: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE
826: ,p_item_key HR_API_TRANSACTION_STEPS.item_key%TYPE ) is
827: select fff.function_id, fff.function_name from
828: fnd_form_functions_vl fff
829: where fff.function_name = ( select iav.text_value
830: from wf_item_attribute_values iav

Line 942: ,p_transaction_ref_table in varchar2 default 'HR_API_TRANSACTIONS'

938: ,p_url in varchar2 default null
939: ,p_status in varchar2 default null
940: ,p_section_display_name in varchar2 default null
941: ,p_function_id in number default null
942: ,p_transaction_ref_table in varchar2 default 'HR_API_TRANSACTIONS'
943: ,p_transaction_ref_id in number default null
944: ,p_transaction_type in varchar2 default null
945: ,p_assignment_id in number default null
946: ,p_api_addtnl_info in varchar2 default null

Line 957: l_transaction_privilege hr_api_transactions.transaction_privilege%type;

953: ,result out nocopy varchar2) is
954: -- --------------------------------------------------------------------------
955: -- declare local variables
956: -- --------------------------------------------------------------------------
957: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
958: l_transaction_id hr_api_transactions.transaction_id%type;
959:
960: l_function_id hr_api_transactions.function_id%TYPE;
961: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;

Line 958: l_transaction_id hr_api_transactions.transaction_id%type;

954: -- --------------------------------------------------------------------------
955: -- declare local variables
956: -- --------------------------------------------------------------------------
957: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
958: l_transaction_id hr_api_transactions.transaction_id%type;
959:
960: l_function_id hr_api_transactions.function_id%TYPE;
961: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
962: lv_process_name hr_api_transactions.process_name%TYPE;

Line 960: l_function_id hr_api_transactions.function_id%TYPE;

956: -- --------------------------------------------------------------------------
957: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
958: l_transaction_id hr_api_transactions.transaction_id%type;
959:
960: l_function_id hr_api_transactions.function_id%TYPE;
961: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
962: lv_process_name hr_api_transactions.process_name%TYPE;
963: lv_status hr_api_transactions.status%TYPE;
964: lv_section_display_name hr_api_transactions.section_display_name%TYPE;

Line 961: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;

957: l_transaction_privilege hr_api_transactions.transaction_privilege%type;
958: l_transaction_id hr_api_transactions.transaction_id%type;
959:
960: l_function_id hr_api_transactions.function_id%TYPE;
961: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
962: lv_process_name hr_api_transactions.process_name%TYPE;
963: lv_status hr_api_transactions.status%TYPE;
964: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
965: ln_assignment_id hr_api_transactions.assignment_id%TYPE;

Line 962: lv_process_name hr_api_transactions.process_name%TYPE;

958: l_transaction_id hr_api_transactions.transaction_id%type;
959:
960: l_function_id hr_api_transactions.function_id%TYPE;
961: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
962: lv_process_name hr_api_transactions.process_name%TYPE;
963: lv_status hr_api_transactions.status%TYPE;
964: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
965: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
966: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;

Line 963: lv_status hr_api_transactions.status%TYPE;

959:
960: l_function_id hr_api_transactions.function_id%TYPE;
961: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
962: lv_process_name hr_api_transactions.process_name%TYPE;
963: lv_status hr_api_transactions.status%TYPE;
964: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
965: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
966: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
967: lv_transaction_type hr_api_transactions.transaction_type%TYPE;

Line 964: lv_section_display_name hr_api_transactions.section_display_name%TYPE;

960: l_function_id hr_api_transactions.function_id%TYPE;
961: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
962: lv_process_name hr_api_transactions.process_name%TYPE;
963: lv_status hr_api_transactions.status%TYPE;
964: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
965: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
966: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
967: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
968: l_proc constant varchar2(100) := g_package || ' start_transaction';

Line 965: ln_assignment_id hr_api_transactions.assignment_id%TYPE;

961: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
962: lv_process_name hr_api_transactions.process_name%TYPE;
963: lv_status hr_api_transactions.status%TYPE;
964: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
965: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
966: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
967: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
968: l_proc constant varchar2(100) := g_package || ' start_transaction';
969: --

Line 966: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;

962: lv_process_name hr_api_transactions.process_name%TYPE;
963: lv_status hr_api_transactions.status%TYPE;
964: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
965: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
966: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
967: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
968: l_proc constant varchar2(100) := g_package || ' start_transaction';
969: --
970: begin

Line 967: lv_transaction_type hr_api_transactions.transaction_type%TYPE;

963: lv_status hr_api_transactions.status%TYPE;
964: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
965: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
966: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
967: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
968: l_proc constant varchar2(100) := g_package || ' start_transaction';
969: --
970: begin
971: hr_utility.set_location('Entering: '|| l_proc,5);

Line 1133: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;

1129: ,result out nocopy varchar2) is
1130: -- --------------------------------------------------------------------------
1131: -- declare local variables
1132: -- --------------------------------------------------------------------------
1133: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
1134: --- Code added for bug10407680
1135: CURSOR csr_appr_dtls(p_transaction_id IN NUMBER) IS
1136: SELECT pa.appraisal_system_status
1137: FROM per_appraisals pa,

Line 1138: hr_api_transactions txn

1134: --- Code added for bug10407680
1135: CURSOR csr_appr_dtls(p_transaction_id IN NUMBER) IS
1136: SELECT pa.appraisal_system_status
1137: FROM per_appraisals pa,
1138: hr_api_transactions txn
1139: WHERE txn.transaction_id = p_transaction_id
1140: AND txn.transaction_ref_table = 'PER_APPRAISALS'
1141: AND txn.transaction_ref_id = pa.appraisal_id;
1142: l_appr_status VARCHAR2(60);

Line 1159: select hr_api_transactions.transaction_ref_table

1155: savepoint rollback_transaction;
1156: -- check if this is appraisal transaction
1157: -- we need to call the custom call to update the appraisal status
1158: begin
1159: select hr_api_transactions.transaction_ref_table
1160: into lv_transaction_ref_table
1161: from hr_api_transactions
1162: where hr_api_transactions.transaction_id=(get_transaction_id(itemtype,itemkey));
1163: --- Code added for bug10407680

Line 1161: from hr_api_transactions

1157: -- we need to call the custom call to update the appraisal status
1158: begin
1159: select hr_api_transactions.transaction_ref_table
1160: into lv_transaction_ref_table
1161: from hr_api_transactions
1162: where hr_api_transactions.transaction_id=(get_transaction_id(itemtype,itemkey));
1163: --- Code added for bug10407680
1164: IF lv_transaction_ref_table = 'PER_APPRAISALS' THEN
1165: OPEN csr_appr_dtls(get_transaction_id(itemtype,itemkey));

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

1158: begin
1159: select hr_api_transactions.transaction_ref_table
1160: into lv_transaction_ref_table
1161: from hr_api_transactions
1162: where hr_api_transactions.transaction_id=(get_transaction_id(itemtype,itemkey));
1163: --- Code added for bug10407680
1164: IF lv_transaction_ref_table = 'PER_APPRAISALS' THEN
1165: OPEN csr_appr_dtls(get_transaction_id(itemtype,itemkey));
1166: FETCH csr_appr_dtls INTO l_appr_status;

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

1179: */
1180: exception
1181: when others then
1182: hr_utility.set_location('EXCEPTION: '|| l_proc,555);
1183: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'||
1184: 'rollback_transaction'||' : ' || sqlerrm);
1185: -- just log the message no need to raise it
1186: end;
1187: --- Added If Condition for bug#10407680

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

1258: l_error varchar2(2000);
1259: l_proc constant varchar2(100) := g_package || ' process_web_api_call';
1260: --
1261: cursor csel is
1262: select nvl(varchar2_value, hr_api.g_varchar2) varchar2_value
1263: ,nvl(number_value, hr_api.g_number) number_value
1264: ,nvl(date_value, hr_api.g_date) date_value
1265: ,nvl(original_varchar2_value, hr_api.g_varchar2) original_varchar2_value
1266: ,nvl(original_number_value, hr_api.g_number) original_number_value

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

1259: l_proc constant varchar2(100) := g_package || ' process_web_api_call';
1260: --
1261: cursor csel is
1262: select nvl(varchar2_value, hr_api.g_varchar2) varchar2_value
1263: ,nvl(number_value, hr_api.g_number) number_value
1264: ,nvl(date_value, hr_api.g_date) date_value
1265: ,nvl(original_varchar2_value, hr_api.g_varchar2) original_varchar2_value
1266: ,nvl(original_number_value, hr_api.g_number) original_number_value
1267: ,nvl(original_date_value, hr_api.g_date) original_date_value

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

1260: --
1261: cursor csel is
1262: select nvl(varchar2_value, hr_api.g_varchar2) varchar2_value
1263: ,nvl(number_value, hr_api.g_number) number_value
1264: ,nvl(date_value, hr_api.g_date) date_value
1265: ,nvl(original_varchar2_value, hr_api.g_varchar2) original_varchar2_value
1266: ,nvl(original_number_value, hr_api.g_number) original_number_value
1267: ,nvl(original_date_value, hr_api.g_date) original_date_value
1268: from hr_api_transaction_values hatv

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

1261: cursor csel is
1262: select nvl(varchar2_value, hr_api.g_varchar2) varchar2_value
1263: ,nvl(number_value, hr_api.g_number) number_value
1264: ,nvl(date_value, hr_api.g_date) date_value
1265: ,nvl(original_varchar2_value, hr_api.g_varchar2) original_varchar2_value
1266: ,nvl(original_number_value, hr_api.g_number) original_number_value
1267: ,nvl(original_date_value, hr_api.g_date) original_date_value
1268: from hr_api_transaction_values hatv
1269: where hatv.transaction_step_id = p_transaction_step_id;

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

1262: select nvl(varchar2_value, hr_api.g_varchar2) varchar2_value
1263: ,nvl(number_value, hr_api.g_number) number_value
1264: ,nvl(date_value, hr_api.g_date) date_value
1265: ,nvl(original_varchar2_value, hr_api.g_varchar2) original_varchar2_value
1266: ,nvl(original_number_value, hr_api.g_number) original_number_value
1267: ,nvl(original_date_value, hr_api.g_date) original_date_value
1268: from hr_api_transaction_values hatv
1269: where hatv.transaction_step_id = p_transaction_step_id;
1270: --

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

1263: ,nvl(number_value, hr_api.g_number) number_value
1264: ,nvl(date_value, hr_api.g_date) date_value
1265: ,nvl(original_varchar2_value, hr_api.g_varchar2) original_varchar2_value
1266: ,nvl(original_number_value, hr_api.g_number) original_number_value
1267: ,nvl(original_date_value, hr_api.g_date) original_date_value
1268: from hr_api_transaction_values hatv
1269: where hatv.transaction_step_id = p_transaction_step_id;
1270: --
1271: begin

Line 1268: from hr_api_transaction_values hatv

1264: ,nvl(date_value, hr_api.g_date) date_value
1265: ,nvl(original_varchar2_value, hr_api.g_varchar2) original_varchar2_value
1266: ,nvl(original_number_value, hr_api.g_number) original_number_value
1267: ,nvl(original_date_value, hr_api.g_date) original_date_value
1268: from hr_api_transaction_values hatv
1269: where hatv.transaction_step_id = p_transaction_step_id;
1270: --
1271: begin
1272: /* this step has been commented out nocopy and should not be used until */

Line 1334: raise hr_api.validate_enabled;

1330: --
1331: -- when in validation only mode raise the Validate_Enabled exception
1332: --
1333: if p_validate then
1334: raise hr_api.validate_enabled;
1335: end if;
1336: end if;
1337: hr_utility.set_location('Leaving: '|| l_proc,15);
1338: exception

Line 1339: when hr_api.validate_enabled then

1335: end if;
1336: end if;
1337: hr_utility.set_location('Leaving: '|| l_proc,15);
1338: exception
1339: when hr_api.validate_enabled then
1340: --
1341: -- As the Validate_Enabled exception has been raised
1342: -- we must rollback to the savepoint
1343: --

Line 1401: l_transaction_id hr_api_transactions.transaction_id%type;

1397: ,p_effective_date in varchar2 default null) is
1398: -- --------------------------------------------------------------------------
1399: -- declare local variables
1400: -- --------------------------------------------------------------------------
1401: l_transaction_id hr_api_transactions.transaction_id%type;
1402: l_application_error boolean := false;
1403: l_object_version_error boolean := false;
1404: l_obj_fatal_error boolean := false;
1405: l_warning_error boolean := false;

Line 1418: from hr_api_transaction_steps trs

1414: ,trs.item_type
1415: ,trs.item_key
1416: ,trs.activity_id
1417: ,trs.creator_person_id
1418: from hr_api_transaction_steps trs
1419: where trs.transaction_id = l_transaction_id
1420: and trs.api_name <> 'HR_COMP_OUTCOME_PROFILE_SS.PROCESS_API' --#4110654
1421: and object_type is null
1422: order by trs.processing_order,trs.transaction_step_id ; --#2313279

Line 1426: from fnd_form_functions fff, hr_api_transactions hat

1422: order by trs.processing_order,trs.transaction_step_id ; --#2313279
1423: --
1424: cursor cur_fn is
1425: select fff.parameters
1426: from fnd_form_functions fff, hr_api_transactions hat
1427: where fff.function_id = hat.function_id
1428: and hat.transaction_id = l_transaction_id;
1429: --
1430: l_parameter fnd_form_functions.parameters%TYPE;

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

2031: ,p_effective_date_option in varchar2 default null
2032: ) AS
2033:
2034:
2035: cursor get_trans_id ( p_trans_step_id HR_API_TRANSACTION_STEPS.transaction_step_id%TYPE) is
2036: select transaction_id from hr_api_transaction_steps
2037: where transaction_step_id = p_trans_step_id;
2038:
2039: l_count INTEGER := 0;

Line 2036: select transaction_id from hr_api_transaction_steps

2032: ) AS
2033:
2034:
2035: cursor get_trans_id ( p_trans_step_id HR_API_TRANSACTION_STEPS.transaction_step_id%TYPE) is
2036: select transaction_id from hr_api_transaction_steps
2037: where transaction_step_id = p_trans_step_id;
2038:
2039: l_count INTEGER := 0;
2040: l_result VARCHAR2(100);

Line 2041: l_trs_ovn hr_api_transaction_steps.object_version_number%TYPE;

2037: where transaction_step_id = p_trans_step_id;
2038:
2039: l_count INTEGER := 0;
2040: l_result VARCHAR2(100);
2041: l_trs_ovn hr_api_transaction_steps.object_version_number%TYPE;
2042: l_original_date date; --ns
2043: l_original_number number; --ns
2044: l_transaction_state varchar2(10) := hr_api.g_varchar2; --ns
2045: l_date date;

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

2040: l_result VARCHAR2(100);
2041: l_trs_ovn hr_api_transaction_steps.object_version_number%TYPE;
2042: l_original_date date; --ns
2043: l_original_number number; --ns
2044: l_transaction_state varchar2(10) := hr_api.g_varchar2; --ns
2045: l_date date;
2046: l_value_error BOOLEAN := false;
2047: l_proc constant varchar2(100) := g_package || ' save_transaction_step';
2048:

Line 2049: l_function_id hr_api_transactions.function_id%TYPE;

2045: l_date date;
2046: l_value_error BOOLEAN := false;
2047: l_proc constant varchar2(100) := g_package || ' save_transaction_step';
2048:
2049: l_function_id hr_api_transactions.function_id%TYPE;
2050: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
2051: lv_process_name hr_api_transactions.process_name%TYPE;
2052: lv_status hr_api_transactions.status%TYPE;
2053: lv_section_display_name hr_api_transactions.section_display_name%TYPE;

Line 2050: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;

2046: l_value_error BOOLEAN := false;
2047: l_proc constant varchar2(100) := g_package || ' save_transaction_step';
2048:
2049: l_function_id hr_api_transactions.function_id%TYPE;
2050: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
2051: lv_process_name hr_api_transactions.process_name%TYPE;
2052: lv_status hr_api_transactions.status%TYPE;
2053: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
2054: ln_assignment_id hr_api_transactions.assignment_id%TYPE;

Line 2051: lv_process_name hr_api_transactions.process_name%TYPE;

2047: l_proc constant varchar2(100) := g_package || ' save_transaction_step';
2048:
2049: l_function_id hr_api_transactions.function_id%TYPE;
2050: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
2051: lv_process_name hr_api_transactions.process_name%TYPE;
2052: lv_status hr_api_transactions.status%TYPE;
2053: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
2054: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
2055: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;

Line 2052: lv_status hr_api_transactions.status%TYPE;

2048:
2049: l_function_id hr_api_transactions.function_id%TYPE;
2050: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
2051: lv_process_name hr_api_transactions.process_name%TYPE;
2052: lv_status hr_api_transactions.status%TYPE;
2053: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
2054: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
2055: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
2056: lv_transaction_type hr_api_transactions.transaction_type%TYPE;

Line 2053: lv_section_display_name hr_api_transactions.section_display_name%TYPE;

2049: l_function_id hr_api_transactions.function_id%TYPE;
2050: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
2051: lv_process_name hr_api_transactions.process_name%TYPE;
2052: lv_status hr_api_transactions.status%TYPE;
2053: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
2054: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
2055: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
2056: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
2057: ln_transaction_id hr_api_transaction_steps.transaction_id%TYPE;

Line 2054: ln_assignment_id hr_api_transactions.assignment_id%TYPE;

2050: ln_selected_person_id hr_api_transactions.selected_person_id%TYPE;
2051: lv_process_name hr_api_transactions.process_name%TYPE;
2052: lv_status hr_api_transactions.status%TYPE;
2053: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
2054: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
2055: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
2056: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
2057: ln_transaction_id hr_api_transaction_steps.transaction_id%TYPE;
2058:

Line 2055: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;

2051: lv_process_name hr_api_transactions.process_name%TYPE;
2052: lv_status hr_api_transactions.status%TYPE;
2053: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
2054: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
2055: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
2056: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
2057: ln_transaction_id hr_api_transaction_steps.transaction_id%TYPE;
2058:
2059: BEGIN

Line 2056: lv_transaction_type hr_api_transactions.transaction_type%TYPE;

2052: lv_status hr_api_transactions.status%TYPE;
2053: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
2054: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
2055: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
2056: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
2057: ln_transaction_id hr_api_transaction_steps.transaction_id%TYPE;
2058:
2059: BEGIN
2060:

Line 2057: ln_transaction_id hr_api_transaction_steps.transaction_id%TYPE;

2053: lv_section_display_name hr_api_transactions.section_display_name%TYPE;
2054: ln_assignment_id hr_api_transactions.assignment_id%TYPE;
2055: ld_trans_effec_date hr_api_transactions.transaction_effective_date%TYPE;
2056: lv_transaction_type hr_api_transactions.transaction_type%TYPE;
2057: ln_transaction_id hr_api_transaction_steps.transaction_id%TYPE;
2058:
2059: BEGIN
2060:
2061: hr_utility.set_location('Entering: '|| l_proc,5);

Line 2105: ,p_transaction_ref_table => 'HR_API_TRANSACTIONS'

2101: ,p_url => p_url
2102: ,p_status => lv_status
2103: ,p_section_display_name => lv_section_display_name
2104: ,p_function_id => l_function_id
2105: ,p_transaction_ref_table => 'HR_API_TRANSACTIONS'
2106: ,p_transaction_ref_id => p_transaction_ref_id
2107: ,p_transaction_type => lv_transaction_type
2108: ,p_assignment_id => ln_assignment_id
2109: ,p_api_addtnl_info => p_api_addtnl_info

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

2234: IF ln_transaction_id IS NOT NULL THEN
2235: hr_utility.trace('In ( I IF ln_transaction_id IS NOT NULL ) '|| l_proc);
2236: Begin
2237: if ( wf_engine.GetItemAttrText(p_item_type ,p_item_key ,'HR_APPROVAL_PRC_VERSION') = 'V5' ) then
2238: lv_status := hr_api.g_varchar2; -- so that the original value is picked from txn table;
2239: end if;
2240: Exception
2241: when Others then -- wf attribute not found
2242: hr_utility.set_location('EXCEPTION: '|| l_proc,570);

Line 2275: RETURN hr_api_transaction_steps.transaction_step_id%TYPE IS

2271: FUNCTION get_activity_trans_step_id
2272: (p_activity_name IN
2273: wf_item_activity_statuses_v.activity_name%TYPE
2274: ,p_trans_step_id_tbl IN hr_util_web.g_varchar2_tab_type)
2275: RETURN hr_api_transaction_steps.transaction_step_id%TYPE IS
2276: ln_transaction_step_id
2277: hr_api_transaction_steps.transaction_step_id%TYPE;
2278: li_step_count INTEGER;
2279: l_proc constant varchar2(100) := g_package || ' get_activity_trans_step_id';

Line 2277: hr_api_transaction_steps.transaction_step_id%TYPE;

2273: wf_item_activity_statuses_v.activity_name%TYPE
2274: ,p_trans_step_id_tbl IN hr_util_web.g_varchar2_tab_type)
2275: RETURN hr_api_transaction_steps.transaction_step_id%TYPE IS
2276: ln_transaction_step_id
2277: hr_api_transaction_steps.transaction_step_id%TYPE;
2278: li_step_count INTEGER;
2279: l_proc constant varchar2(100) := g_package || ' get_activity_trans_step_id';
2280: BEGIN
2281:

Line 2369: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

2365: p_login_person_id IN varchar2 )
2366: IS
2367: ln_ovn NUMBER ;
2368: ln_transaction_step_id NUMBER;
2369: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2370: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
2371: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
2372: ln_trans_step_rows NUMBER ;
2373: ln_value_id NUMBER ;

Line 2545: from hr_api_transaction_steps hats

2541: return number is
2542:
2543: cursor csr_hats is
2544: select hats.object_version_number
2545: from hr_api_transaction_steps hats
2546: where hats.transaction_step_id = p_transaction_step_id;
2547:
2548: l_ovb number;
2549: l_proc constant varchar2(100) := g_package || ' get_transaction_step_ovn';

Line 2677: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

2673: ,p_status OUT NOCOPY VARCHAR2) IS
2674:
2675: l_tmp_proc_call varchar2(32000);
2676: l_tmp_proc_call1 varchar2(32000);
2677: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
2678: l_delimiter varchar2(3) := '|!|';
2679: l_start number;
2680: l_start1 number;
2681: l_pos number;

Line 2697: p_item_key in hr_api_transaction_steps.item_key%type

2693: -- csr_wf_active_item Returns the item key of any process which
2694: -- is currently active with the name of p_process and belonging to
2695: -- the given person id
2696: cursor csr_hatv (
2697: p_item_key in hr_api_transaction_steps.item_key%type
2698: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2699: ,p_name in hr_api_transaction_values.name%type
2700: ) is
2701: select val.varchar2_value, val.transaction_step_id

Line 2698: ,p_item_Type in hr_api_transaction_steps.item_Type%type

2694: -- is currently active with the name of p_process and belonging to
2695: -- the given person id
2696: cursor csr_hatv (
2697: p_item_key in hr_api_transaction_steps.item_key%type
2698: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2699: ,p_name in hr_api_transaction_values.name%type
2700: ) is
2701: select val.varchar2_value, val.transaction_step_id
2702: from hr_api_transaction_values val, hr_api_transaction_steps step

Line 2699: ,p_name in hr_api_transaction_values.name%type

2695: -- the given person id
2696: cursor csr_hatv (
2697: p_item_key in hr_api_transaction_steps.item_key%type
2698: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2699: ,p_name in hr_api_transaction_values.name%type
2700: ) is
2701: select val.varchar2_value, val.transaction_step_id
2702: from hr_api_transaction_values val, hr_api_transaction_steps step
2703: where step.item_type = p_item_type

Line 2702: from hr_api_transaction_values val, hr_api_transaction_steps step

2698: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2699: ,p_name in hr_api_transaction_values.name%type
2700: ) is
2701: select val.varchar2_value, val.transaction_step_id
2702: from hr_api_transaction_values val, hr_api_transaction_steps step
2703: where step.item_type = p_item_type
2704: and step.item_key = p_item_key
2705: and step.transaction_step_id = val.transaction_step_id
2706: and val.name = p_name

Line 2712: in hr_api_transaction_steps.transaction_step_id%type

2708: order by step.processing_order, step.transaction_step_id asc;
2709:
2710: cursor csr_act (
2711: p_transaction_step_id
2712: in hr_api_transaction_steps.transaction_step_id%type
2713: ,p_name in hr_api_transaction_values.name%type
2714: ) is
2715: select varchar2_value
2716: from hr_api_transaction_values

Line 2713: ,p_name in hr_api_transaction_values.name%type

2709:
2710: cursor csr_act (
2711: p_transaction_step_id
2712: in hr_api_transaction_steps.transaction_step_id%type
2713: ,p_name in hr_api_transaction_values.name%type
2714: ) is
2715: select varchar2_value
2716: from hr_api_transaction_values
2717: where transaction_step_id = p_transaction_step_id

Line 2716: from hr_api_transaction_values

2712: in hr_api_transaction_steps.transaction_step_id%type
2713: ,p_name in hr_api_transaction_values.name%type
2714: ) is
2715: select varchar2_value
2716: from hr_api_transaction_values
2717: where transaction_step_id = p_transaction_step_id
2718: and name = p_name
2719: and varchar2_value Is Not Null;
2720:

Line 2728: from hr_api_transaction_steps

2724: p_status := 'SUCCESS';
2725:
2726: select count(transaction_step_id)
2727: into l_tx_step_count
2728: from hr_api_transaction_steps
2729: where item_key = p_item_key
2730: and item_type = p_item_type;
2731:
2732: if l_tx_step_count <> 0 then -- user has changed data in one of the previous pages

Line 2833: from hr_api_transaction_values

2829: select NAME,
2830: VARCHAR2_VALUE,
2831: NUMBER_VALUE,
2832: DATE_VALUE
2833: from hr_api_transaction_values
2834: where transaction_step_id = p_transaction_step_id
2835: order by transaction_value_id;
2836:
2837: i integer := 0;

Line 2877: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

2873: itemkey in varchar2,
2874: actid in number,
2875: funmode in varchar2,
2876: result out nocopy varchar2 ) is
2877: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
2878: l_proc constant varchar2(100) := g_package || ' set_transaction_approved';
2879: begin
2880: hr_utility.set_location('Entering: '|| l_proc,5);
2881: