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.PAY_US_WEB_W4 dependencies on HR_API_TRANSACTION_STEPS

Line 820: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;

816: common_exception EXCEPTION;
817:
818: lv_update_method VARCHAR2(30) := 'PRIMARY' ;
819: l_transaction_id hr_api_transactions.transaction_id%type;
820: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
821: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
822: l_step_obj_version_number hr_api_transaction_steps.object_version_number%type;
823: transaction_value_fs VARCHAR2(80);
824:

Line 822: l_step_obj_version_number hr_api_transaction_steps.object_version_number%type;

818: lv_update_method VARCHAR2(30) := 'PRIMARY' ;
819: l_transaction_id hr_api_transactions.transaction_id%type;
820: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
821: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
822: l_step_obj_version_number hr_api_transaction_steps.object_version_number%type;
823: transaction_value_fs VARCHAR2(80);
824:
825: CURSOR c_fed_allowance_limit is
826: select fed_information1

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

829: and trunc(sysdate) between effective_start_date and effective_end_date;
830:
831: l_fed_allowance_limit pay_us_federal_tax_info_f.fed_information1%type;
832:
833: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE
834: ,p_item_key HR_API_TRANSACTION_STEPS.item_key%TYPE ) is
835: select fff.function_id, fff.function_name
836: from fnd_form_functions_vl fff
837: where fff.function_name = ( select iav.text_value

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

830:
831: l_fed_allowance_limit pay_us_federal_tax_info_f.fed_information1%type;
832:
833: cursor get_function_info ( p_item_type HR_API_TRANSACTION_STEPS.item_type%TYPE
834: ,p_item_key HR_API_TRANSACTION_STEPS.item_key%TYPE ) is
835: select fff.function_id, fff.function_name
836: from fnd_form_functions_vl fff
837: where fff.function_name = ( select iav.text_value
838: from wf_item_attribute_values iav

Line 1271: into hr_api_transactions, hr_api_transaction_steps and hr_api_transaction_values.

1267: hr_utility.trace('The global state exempt list is : '|| g_state_exempt_list);
1268:
1269:
1270: /* If we have come so far that means we have no errors. So insert data
1271: into hr_api_transactions, hr_api_transaction_steps and hr_api_transaction_values.
1272: Need to insert data into these tables to store OLD and NEW values for W4. These
1273: OLD and NEW values are used in the review page. */
1274:
1275: -- First the hr_api_transactions table

Line 1326: -- hr_api_transaction_steps

1322: ,p_transaction_effective_date=>sysdate
1323: ,p_process_name =>lv_process_name
1324: );
1325:
1326: -- hr_api_transaction_steps
1327:
1328: hr_transaction_api.create_transaction_step(
1329: p_creator_person_id => ln_person_id,
1330: p_transaction_id => l_transaction_id,

Line 1348: from HR_API_TRANSACTION_STEPS

1344: else /* transaction exists */
1345:
1346: hr_utility.trace('l_transaction_id : '|| l_transaction_id);
1347: select transaction_step_id into l_transaction_step_id
1348: from HR_API_TRANSACTION_STEPS
1349: where transaction_id = l_transaction_id;
1350:
1351: end if;
1352:

Line 1512: l_step_id hr_api_transaction_steps.transaction_step_id%type;

1508: p_trans_id IN VARCHAR2 Default null,
1509: p_step_id IN VARCHAR2 Default null,
1510: p_out_values OUT nocopy VARCHAR2 ) IS
1511:
1512: l_step_id hr_api_transaction_steps.transaction_step_id%type;
1513:
1514: CURSOR c_trans_values IS
1515:
1516: select v.datatype,v.name,v.varchar2_value,number_value

Line 1540: from hr_api_transaction_steps

1536:
1537: if (p_trans_id is not null and p_step_id is null) then
1538:
1539: select transaction_step_id into l_step_id
1540: from hr_api_transaction_steps
1541: where transaction_id = to_number(p_trans_id);
1542:
1543: else
1544: l_step_id := to_number(p_step_id);

Line 2615: from hr_api_transaction_steps

2611:
2612: Cursor c_trans_step is
2613:
2614: select transaction_id, creator_person_id
2615: from hr_api_transaction_steps
2616: where transaction_step_id = p_transaction_step_id;
2617:
2618: l_datatype hr_api_transaction_values.datatype%type;
2619: l_name hr_api_transaction_values.name%type;

Line 2636: l_item_type hr_api_transaction_steps.item_type%type;

2632: l_org_allowances hr_api_transaction_values.number_value%type;
2633: l_org_exempt hr_api_transaction_values.varchar2_value%type;
2634: l_last_name_diff hr_api_transaction_values.varchar2_value%TYPE;
2635:
2636: l_item_type hr_api_transaction_steps.item_type%type;
2637: l_item_key hr_api_transaction_steps.item_key%type;
2638: l_activity_id hr_api_transaction_steps.activity_id%type;
2639: l_person_id hr_api_transaction_steps.creator_person_id%type;
2640:

Line 2637: l_item_key hr_api_transaction_steps.item_key%type;

2633: l_org_exempt hr_api_transaction_values.varchar2_value%type;
2634: l_last_name_diff hr_api_transaction_values.varchar2_value%TYPE;
2635:
2636: l_item_type hr_api_transaction_steps.item_type%type;
2637: l_item_key hr_api_transaction_steps.item_key%type;
2638: l_activity_id hr_api_transaction_steps.activity_id%type;
2639: l_person_id hr_api_transaction_steps.creator_person_id%type;
2640:
2641: l_transaction_id hr_api_transaction_steps.transaction_id%type;

Line 2638: l_activity_id hr_api_transaction_steps.activity_id%type;

2634: l_last_name_diff hr_api_transaction_values.varchar2_value%TYPE;
2635:
2636: l_item_type hr_api_transaction_steps.item_type%type;
2637: l_item_key hr_api_transaction_steps.item_key%type;
2638: l_activity_id hr_api_transaction_steps.activity_id%type;
2639: l_person_id hr_api_transaction_steps.creator_person_id%type;
2640:
2641: l_transaction_id hr_api_transaction_steps.transaction_id%type;
2642:

Line 2639: l_person_id hr_api_transaction_steps.creator_person_id%type;

2635:
2636: l_item_type hr_api_transaction_steps.item_type%type;
2637: l_item_key hr_api_transaction_steps.item_key%type;
2638: l_activity_id hr_api_transaction_steps.activity_id%type;
2639: l_person_id hr_api_transaction_steps.creator_person_id%type;
2640:
2641: l_transaction_id hr_api_transaction_steps.transaction_id%type;
2642:
2643: lv_trans_type VARCHAR2(50);

Line 2641: l_transaction_id hr_api_transaction_steps.transaction_id%type;

2637: l_item_key hr_api_transaction_steps.item_key%type;
2638: l_activity_id hr_api_transaction_steps.activity_id%type;
2639: l_person_id hr_api_transaction_steps.creator_person_id%type;
2640:
2641: l_transaction_id hr_api_transaction_steps.transaction_id%type;
2642:
2643: lv_trans_type VARCHAR2(50);
2644: lv_source_name VARCHAR2(50);
2645: