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_TRANSACTIONS

Line 951: l_transaction_id hr_api_transactions.transaction_id%type;

947: l_review_region VARCHAR2(80);
948: common_exception EXCEPTION;
949:
950: lv_update_method VARCHAR2(30) := 'PRIMARY' ;
951: l_transaction_id hr_api_transactions.transaction_id%type;
952: l_transaction_step_id hr_api_transaction_steps.transaction_step_id%type;
953: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;
954: l_step_obj_version_number hr_api_transaction_steps.object_version_number%type;
955: transaction_value_fs VARCHAR2(80);

Line 975: lv_process_name hr_api_transactions.process_name%TYPE;

971: where iav.item_type = p_item_type
972: and iav.item_key = p_item_key
973: and iav.name = 'P_CALLED_FROM') ;
974:
975: lv_process_name hr_api_transactions.process_name%TYPE;
976: l_function_id hr_api_transactions.function_id%TYPE;
977: l_function_name fnd_form_functions_vl.function_name%TYPE default null;
978: lv_transaction_type varchar2(20);
979:

Line 976: l_function_id hr_api_transactions.function_id%TYPE;

972: and iav.item_key = p_item_key
973: and iav.name = 'P_CALLED_FROM') ;
974:
975: lv_process_name hr_api_transactions.process_name%TYPE;
976: l_function_id hr_api_transactions.function_id%TYPE;
977: l_function_name fnd_form_functions_vl.function_name%TYPE default null;
978: lv_transaction_type varchar2(20);
979:
980: --added by vaprakas 11/21/06 Bug 5607135

Line 1412: into hr_api_transactions, hr_api_transaction_steps and hr_api_transaction_values.

1408: hr_utility.trace('The global state exempt list is : '|| g_state_exempt_list);
1409:
1410:
1411: /* If we have come so far that means we have no errors. So insert data
1412: into hr_api_transactions, hr_api_transaction_steps and hr_api_transaction_values.
1413: Need to insert data into these tables to store OLD and NEW values for W4. These
1414: OLD and NEW values are used in the review page. */
1415:
1416: -- First the hr_api_transactions table

Line 1416: -- First the hr_api_transactions table

1412: into hr_api_transactions, hr_api_transaction_steps and hr_api_transaction_values.
1413: Need to insert data into these tables to store OLD and NEW values for W4. These
1414: OLD and NEW values are used in the review page. */
1415:
1416: -- First the hr_api_transactions table
1417:
1418: l_transaction_id := hr_transaction_ss.get_transaction_id(p_itemtype, p_itemkey);
1419:
1420: if l_transaction_id is null then /* transaction does not exists */

Line 1458: ,p_transaction_ref_table => 'HR_API_TRANSACTIONS'

1454: p_creator_person_id => ln_person_id
1455: ,p_transaction_privilege => 'PRIVATE'
1456: ,p_transaction_id => l_transaction_id
1457: ,p_function_id =>l_function_id
1458: ,p_transaction_ref_table => 'HR_API_TRANSACTIONS'
1459: ,p_transaction_type =>lv_transaction_type
1460: ,p_selected_person_id =>ln_person_id
1461: ,p_item_type =>p_itemtype
1462: ,p_item_key =>p_itemkey

Line 1842: ,p_transaction_id hr_api_transactions.transaction_id%type

1838: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1839: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
1840: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1841: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1842: ,p_transaction_id hr_api_transactions.transaction_id%type
1843: ,p_person_id VARCHAR2
1844: ,p_transaction_type VARCHAR2
1845: ,p_source_name VARCHAR2
1846: --,p_update_method VARCHAR2