APPS.PAY_US_WEB_W4 dependencies on HR_TRANSACTION_API

Line 1425: hr_transaction_api.create_transaction( p_creator_person_id => ln_person_id ,

1421:
1422: hr_utility.trace('l_transaction_id is null INSERTING');
1423:
1424: /*
1425: hr_transaction_api.create_transaction( p_creator_person_id => ln_person_id ,
1426: p_transaction_privilege => 'PRIVATE',
1427: p_transaction_id => l_transaction_id);
1428: */
1429: If p_itemtype is not null and p_itemkey is not null then

Line 1453: hr_transaction_api.create_transaction(

1449: ,'PROCESS_NAME');
1450:
1451: /* create transaction */
1452:
1453: hr_transaction_api.create_transaction(
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

Line 1469: hr_transaction_api.create_transaction_step(

1465: );
1466:
1467: -- hr_api_transaction_steps
1468:
1469: hr_transaction_api.create_transaction_step(
1470: p_creator_person_id => ln_person_id,
1471: p_transaction_id => l_transaction_id,
1472: p_api_name => gv_package_name||'.update_w4_info',
1473: p_item_type => p_itemtype,

Line 1506: hr_transaction_api.set_varchar2_value (

1502: from fnd_common_lookups fcl
1503: where fcl.lookup_type = 'US_FIT_FILING_STATUS'
1504: and fcl.lookup_code = p_filing_status_code ;
1505:
1506: hr_transaction_api.set_varchar2_value (
1507: p_transaction_step_id => l_transaction_step_id
1508: ,p_person_id => ln_person_id
1509: ,p_name => 'P_FILING_STATUS'
1510: ,p_value => transaction_value_fs ) ;

Line 1513: hr_transaction_api.set_varchar2_value (

1509: ,p_name => 'P_FILING_STATUS'
1510: ,p_value => transaction_value_fs ) ;
1511:
1512: -- Filing Status Code
1513: hr_transaction_api.set_varchar2_value (
1514: p_transaction_step_id => l_transaction_step_id
1515: ,p_person_id => ln_person_id
1516: ,p_name => 'P_FS_CODE'
1517: ,p_value => p_filing_status_code ) ;

Line 1520: hr_transaction_api.set_varchar2_value (

1516: ,p_name => 'P_FS_CODE'
1517: ,p_value => p_filing_status_code ) ;
1518:
1519: -- Original Filing Status Code
1520: hr_transaction_api.set_varchar2_value (
1521: p_transaction_step_id => l_transaction_step_id
1522: ,p_person_id => ln_person_id
1523: ,p_name => 'P_ORG_FS_CODE'
1524: ,p_value => p_original_fs ) ;

Line 1531: hr_transaction_api.set_varchar2_value (

1527: from fnd_common_lookups fcl
1528: where fcl.lookup_type = 'US_FIT_FILING_STATUS'
1529: and fcl.lookup_code = p_original_fs ;
1530: hr_utility.trace('transaction_step_id = ' || l_transaction_step_id);
1531: hr_transaction_api.set_varchar2_value (
1532: p_transaction_step_id => l_transaction_step_id
1533: ,p_person_id => ln_person_id
1534: ,p_name => 'P_ORG_FILING_STATUS'
1535: ,p_value => transaction_value_fs ) ;

Line 1538: hr_transaction_api.set_number_value (

1534: ,p_name => 'P_ORG_FILING_STATUS'
1535: ,p_value => transaction_value_fs ) ;
1536:
1537: -- Allowances
1538: hr_transaction_api.set_number_value (
1539: p_transaction_step_id => l_transaction_step_id
1540: ,p_person_id => ln_person_id
1541: ,p_name => 'P_ALLOWANCES'
1542: ,p_value => l_allowances ) ;

Line 1545: hr_transaction_api.set_number_value (

1541: ,p_name => 'P_ALLOWANCES'
1542: ,p_value => l_allowances ) ;
1543:
1544: -- Original Allowances
1545: hr_transaction_api.set_number_value (
1546: p_transaction_step_id => l_transaction_step_id
1547: ,p_person_id => ln_person_id
1548: ,p_name => 'P_ORG_ALLOWANCES'
1549: ,p_value => p_original_wa ) ;

Line 1552: hr_transaction_api.set_number_value (

1548: ,p_name => 'P_ORG_ALLOWANCES'
1549: ,p_value => p_original_wa ) ;
1550:
1551: -- Additional Tax
1552: hr_transaction_api.set_number_value (
1553: p_transaction_step_id => l_transaction_step_id
1554: ,p_person_id => ln_person_id
1555: ,p_name => 'P_ADDITIONAL_TAX'
1556: ,p_value => ln_add_tax);

Line 1559: hr_transaction_api.set_number_value (

1555: ,p_name => 'P_ADDITIONAL_TAX'
1556: ,p_value => ln_add_tax);
1557:
1558: -- Original Additional Tax
1559: hr_transaction_api.set_number_value (
1560: p_transaction_step_id => l_transaction_step_id
1561: ,p_person_id => ln_person_id
1562: ,p_name => 'P_ORG_ADDITIONAL_TAX'
1563: ,p_value => p_original_aa);

Line 1567: hr_transaction_api.set_varchar2_value (

1563: ,p_value => p_original_aa);
1564:
1565:
1566: -- Exempt
1567: hr_transaction_api.set_varchar2_value (
1568: p_transaction_step_id => l_transaction_step_id
1569: ,p_person_id => ln_person_id
1570: ,p_name => 'P_EXEMPT'
1571: ,p_value => l_exempt_status_code ) ;

Line 1574: hr_transaction_api.set_varchar2_value (

1570: ,p_name => 'P_EXEMPT'
1571: ,p_value => l_exempt_status_code ) ;
1572:
1573: -- Original Exempt
1574: hr_transaction_api.set_varchar2_value (
1575: p_transaction_step_id => l_transaction_step_id
1576: ,p_person_id => ln_person_id
1577: ,p_name => 'P_ORG_EXEMPT'
1578: ,p_value => p_original_exempt ) ;

Line 1587: hr_transaction_api.set_varchar2_value (

1583: actid => p_activity_id,
1584: aname => 'HR_REVIEW_REGION_ITEM');
1585:
1586:
1587: hr_transaction_api.set_varchar2_value (
1588: p_transaction_step_id => l_transaction_step_id
1589: ,p_person_id => ln_person_id
1590: ,p_name => 'P_REVIEW_PROC_CALL'
1591: ,p_value => l_review_region ) ;

Line 1594: hr_transaction_api.set_varchar2_value (

1590: ,p_name => 'P_REVIEW_PROC_CALL'
1591: ,p_value => l_review_region ) ;
1592:
1593: -- P_REVIEW_ACTID
1594: hr_transaction_api.set_varchar2_value (
1595: p_transaction_step_id => l_transaction_step_id
1596: ,p_person_id => ln_person_id
1597: ,p_name => 'P_REVIEW_ACTID'
1598: ,p_value => p_activity_id ) ;

Line 1601: hr_transaction_api.set_varchar2_value (

1597: ,p_name => 'P_REVIEW_ACTID'
1598: ,p_value => p_activity_id ) ;
1599:
1600: -- P_LAST_NAME_DIFF
1601: hr_transaction_api.set_varchar2_value (
1602: p_transaction_step_id => l_transaction_step_id
1603: ,p_person_id => ln_person_id
1604: ,p_name => 'P_LAST_NAME_DIFF'
1605: ,p_value => l_last_name_diff_flag ) ;