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_VALUES

Line 821: l_transaction_value_id hr_api_transaction_values.transaction_value_id%type;

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:
825: CURSOR c_fed_allowance_limit is

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 1353: -- hr_api_transaction_values

1349: where transaction_id = l_transaction_id;
1350:
1351: end if;
1352:
1353: -- hr_api_transaction_values
1354:
1355: -- Filing Status Meaning
1356: -- get the filing status meaning to store in the transaction_value table
1357:

Line 1517: from hr_api_transaction_values v

1513:
1514: CURSOR c_trans_values IS
1515:
1516: select v.datatype,v.name,v.varchar2_value,number_value
1517: from hr_api_transaction_values v
1518: where v.transaction_step_id = l_step_id
1519: order by transaction_value_id;
1520:
1521: l_datatype hr_api_transaction_values.datatype%type;

Line 1521: l_datatype hr_api_transaction_values.datatype%type;

1517: from hr_api_transaction_values v
1518: where v.transaction_step_id = l_step_id
1519: order by transaction_value_id;
1520:
1521: l_datatype hr_api_transaction_values.datatype%type;
1522: l_name hr_api_transaction_values.name%type;
1523: l_varchar2_value hr_api_transaction_values.varchar2_value%type;
1524: l_number_value hr_api_transaction_values.number_value%type;
1525:

Line 1522: l_name hr_api_transaction_values.name%type;

1518: where v.transaction_step_id = l_step_id
1519: order by transaction_value_id;
1520:
1521: l_datatype hr_api_transaction_values.datatype%type;
1522: l_name hr_api_transaction_values.name%type;
1523: l_varchar2_value hr_api_transaction_values.varchar2_value%type;
1524: l_number_value hr_api_transaction_values.number_value%type;
1525:
1526: common_exception EXCEPTION;

Line 1523: l_varchar2_value hr_api_transaction_values.varchar2_value%type;

1519: order by transaction_value_id;
1520:
1521: l_datatype hr_api_transaction_values.datatype%type;
1522: l_name hr_api_transaction_values.name%type;
1523: l_varchar2_value hr_api_transaction_values.varchar2_value%type;
1524: l_number_value hr_api_transaction_values.number_value%type;
1525:
1526: common_exception EXCEPTION;
1527: BEGIN

Line 1524: l_number_value hr_api_transaction_values.number_value%type;

1520:
1521: l_datatype hr_api_transaction_values.datatype%type;
1522: l_name hr_api_transaction_values.name%type;
1523: l_varchar2_value hr_api_transaction_values.varchar2_value%type;
1524: l_number_value hr_api_transaction_values.number_value%type;
1525:
1526: common_exception EXCEPTION;
1527: BEGIN
1528:

Line 2608: from hr_api_transaction_values

2604:
2605: Cursor c_trans_value is
2606:
2607: select datatype,name,varchar2_value,number_value
2608: from hr_api_transaction_values
2609: where transaction_step_id = p_transaction_step_id
2610: order by transaction_value_id;
2611:
2612: Cursor c_trans_step is

Line 2618: l_datatype hr_api_transaction_values.datatype%type;

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;
2620: l_varchar2_value hr_api_transaction_values.varchar2_value%type;
2621: l_number_value hr_api_transaction_values.number_value%type;
2622:

Line 2619: l_name hr_api_transaction_values.name%type;

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;
2620: l_varchar2_value hr_api_transaction_values.varchar2_value%type;
2621: l_number_value hr_api_transaction_values.number_value%type;
2622:
2623: l_filing_status hr_api_transaction_values.varchar2_value%type;

Line 2620: l_varchar2_value hr_api_transaction_values.varchar2_value%type;

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;
2620: l_varchar2_value hr_api_transaction_values.varchar2_value%type;
2621: l_number_value hr_api_transaction_values.number_value%type;
2622:
2623: l_filing_status hr_api_transaction_values.varchar2_value%type;
2624:

Line 2621: l_number_value hr_api_transaction_values.number_value%type;

2617:
2618: l_datatype hr_api_transaction_values.datatype%type;
2619: l_name hr_api_transaction_values.name%type;
2620: l_varchar2_value hr_api_transaction_values.varchar2_value%type;
2621: l_number_value hr_api_transaction_values.number_value%type;
2622:
2623: l_filing_status hr_api_transaction_values.varchar2_value%type;
2624:
2625: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

Line 2623: l_filing_status hr_api_transaction_values.varchar2_value%type;

2619: l_name hr_api_transaction_values.name%type;
2620: l_varchar2_value hr_api_transaction_values.varchar2_value%type;
2621: l_number_value hr_api_transaction_values.number_value%type;
2622:
2623: l_filing_status hr_api_transaction_values.varchar2_value%type;
2624:
2625: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
2626:
2627: l_allowances hr_api_transaction_values.number_value%type;

Line 2627: l_allowances hr_api_transaction_values.number_value%type;

2623: l_filing_status hr_api_transaction_values.varchar2_value%type;
2624:
2625: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
2626:
2627: l_allowances hr_api_transaction_values.number_value%type;
2628: l_add_tax hr_api_transaction_values.number_value%type;
2629: l_exempt hr_api_transaction_values.varchar2_value%type;
2630:
2631: l_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;

Line 2628: l_add_tax hr_api_transaction_values.number_value%type;

2624:
2625: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
2626:
2627: l_allowances hr_api_transaction_values.number_value%type;
2628: l_add_tax hr_api_transaction_values.number_value%type;
2629: l_exempt hr_api_transaction_values.varchar2_value%type;
2630:
2631: l_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
2632: l_org_allowances hr_api_transaction_values.number_value%type;

Line 2629: l_exempt hr_api_transaction_values.varchar2_value%type;

2625: l_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
2626:
2627: l_allowances hr_api_transaction_values.number_value%type;
2628: l_add_tax hr_api_transaction_values.number_value%type;
2629: l_exempt hr_api_transaction_values.varchar2_value%type;
2630:
2631: l_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%TYPE;
2632: l_org_allowances hr_api_transaction_values.number_value%type;
2633: l_org_exempt hr_api_transaction_values.varchar2_value%type;

Line 2632: l_org_allowances hr_api_transaction_values.number_value%type;

2628: l_add_tax hr_api_transaction_values.number_value%type;
2629: l_exempt hr_api_transaction_values.varchar2_value%type;
2630:
2631: l_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%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;

Line 2633: l_org_exempt hr_api_transaction_values.varchar2_value%type;

2629: l_exempt hr_api_transaction_values.varchar2_value%type;
2630:
2631: l_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%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;

Line 2634: l_last_name_diff hr_api_transaction_values.varchar2_value%TYPE;

2630:
2631: l_org_filing_status_code pay_us_emp_fed_tax_rules_f.filing_status_code%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;