APPS.PAY_US_WEB_W4 dependencies on HR_API_TRANSACTIONS

Line 819: l_transaction_id hr_api_transactions.transaction_id%type;

815: l_review_region VARCHAR2(80);
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);

Line 843: lv_process_name hr_api_transactions.process_name%TYPE;

839: where iav.item_type = p_item_type
840: and iav.item_key = p_item_key
841: and iav.name = 'P_CALLED_FROM') ;
842:
843: lv_process_name hr_api_transactions.process_name%TYPE;
844: l_function_id hr_api_transactions.function_id%TYPE;
845: l_function_name fnd_form_functions_vl.function_name%TYPE default null;
846: lv_transaction_type varchar2(20);
847:

Line 844: l_function_id hr_api_transactions.function_id%TYPE;

840: and iav.item_key = p_item_key
841: and iav.name = 'P_CALLED_FROM') ;
842:
843: lv_process_name hr_api_transactions.process_name%TYPE;
844: l_function_id hr_api_transactions.function_id%TYPE;
845: l_function_name fnd_form_functions_vl.function_name%TYPE default null;
846: lv_transaction_type varchar2(20);
847:
848: --added by vaprakas 11/21/06 Bug 5607135

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 1275: -- First the hr_api_transactions table

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
1276:
1277: l_transaction_id := hr_transaction_ss.get_transaction_id(p_itemtype, p_itemkey);
1278:
1279: if l_transaction_id is null then /* transaction does not exists */

Line 1317: ,p_transaction_ref_table => 'HR_API_TRANSACTIONS'

1313: p_creator_person_id => ln_person_id
1314: ,p_transaction_privilege => 'PRIVATE'
1315: ,p_transaction_id => l_transaction_id
1316: ,p_function_id =>l_function_id
1317: ,p_transaction_ref_table => 'HR_API_TRANSACTIONS'
1318: ,p_transaction_type =>lv_transaction_type
1319: ,p_selected_person_id =>ln_person_id
1320: ,p_item_type =>p_itemtype
1321: ,p_item_key =>p_itemkey

Line 1701: ,p_transaction_id hr_api_transactions.transaction_id%type

1697: ,p_additional_amount pay_us_emp_fed_tax_rules_f.fit_additional_tax%TYPE
1698: ,p_last_name_diff VARCHAR2 DEFAULT 'N'
1699: ,p_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1700: ,p_org_exempt_status_code pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE
1701: ,p_transaction_id hr_api_transactions.transaction_id%type
1702: ,p_person_id VARCHAR2
1703: ,p_transaction_type VARCHAR2
1704: ,p_source_name VARCHAR2
1705: --,p_update_method VARCHAR2