APPS.PAY_US_WEB_W4 dependencies on HR_TRANSACTION_API

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

1280:
1281: hr_utility.trace('l_transaction_id is null INSERTING');
1282:
1283: /*
1284: hr_transaction_api.create_transaction( p_creator_person_id => ln_person_id ,
1285: p_transaction_privilege => 'PRIVATE',
1286: p_transaction_id => l_transaction_id);
1287: */
1288: If p_itemtype is not null and p_itemkey is not null then

Line 1312: hr_transaction_api.create_transaction(

1308: ,'PROCESS_NAME');
1309:
1310: /* create transaction */
1311:
1312: hr_transaction_api.create_transaction(
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

Line 1328: hr_transaction_api.create_transaction_step(

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,
1331: p_api_name => gv_package_name||'.update_w4_info',
1332: p_item_type => p_itemtype,

Line 1365: hr_transaction_api.set_varchar2_value (

1361: from fnd_common_lookups fcl
1362: where fcl.lookup_type = 'US_FIT_FILING_STATUS'
1363: and fcl.lookup_code = p_filing_status_code ;
1364:
1365: hr_transaction_api.set_varchar2_value (
1366: p_transaction_step_id => l_transaction_step_id
1367: ,p_person_id => ln_person_id
1368: ,p_name => 'P_FILING_STATUS'
1369: ,p_value => transaction_value_fs ) ;

Line 1372: hr_transaction_api.set_varchar2_value (

1368: ,p_name => 'P_FILING_STATUS'
1369: ,p_value => transaction_value_fs ) ;
1370:
1371: -- Filing Status Code
1372: hr_transaction_api.set_varchar2_value (
1373: p_transaction_step_id => l_transaction_step_id
1374: ,p_person_id => ln_person_id
1375: ,p_name => 'P_FS_CODE'
1376: ,p_value => p_filing_status_code ) ;

Line 1379: hr_transaction_api.set_varchar2_value (

1375: ,p_name => 'P_FS_CODE'
1376: ,p_value => p_filing_status_code ) ;
1377:
1378: -- Original Filing Status Code
1379: hr_transaction_api.set_varchar2_value (
1380: p_transaction_step_id => l_transaction_step_id
1381: ,p_person_id => ln_person_id
1382: ,p_name => 'P_ORG_FS_CODE'
1383: ,p_value => p_original_fs ) ;

Line 1390: hr_transaction_api.set_varchar2_value (

1386: from fnd_common_lookups fcl
1387: where fcl.lookup_type = 'US_FIT_FILING_STATUS'
1388: and fcl.lookup_code = p_original_fs ;
1389: hr_utility.trace('transaction_step_id = ' || l_transaction_step_id);
1390: hr_transaction_api.set_varchar2_value (
1391: p_transaction_step_id => l_transaction_step_id
1392: ,p_person_id => ln_person_id
1393: ,p_name => 'P_ORG_FILING_STATUS'
1394: ,p_value => transaction_value_fs ) ;

Line 1397: hr_transaction_api.set_number_value (

1393: ,p_name => 'P_ORG_FILING_STATUS'
1394: ,p_value => transaction_value_fs ) ;
1395:
1396: -- Allowances
1397: hr_transaction_api.set_number_value (
1398: p_transaction_step_id => l_transaction_step_id
1399: ,p_person_id => ln_person_id
1400: ,p_name => 'P_ALLOWANCES'
1401: ,p_value => l_allowances ) ;

Line 1404: hr_transaction_api.set_number_value (

1400: ,p_name => 'P_ALLOWANCES'
1401: ,p_value => l_allowances ) ;
1402:
1403: -- Original Allowances
1404: hr_transaction_api.set_number_value (
1405: p_transaction_step_id => l_transaction_step_id
1406: ,p_person_id => ln_person_id
1407: ,p_name => 'P_ORG_ALLOWANCES'
1408: ,p_value => p_original_wa ) ;

Line 1411: hr_transaction_api.set_number_value (

1407: ,p_name => 'P_ORG_ALLOWANCES'
1408: ,p_value => p_original_wa ) ;
1409:
1410: -- Additional Tax
1411: hr_transaction_api.set_number_value (
1412: p_transaction_step_id => l_transaction_step_id
1413: ,p_person_id => ln_person_id
1414: ,p_name => 'P_ADDITIONAL_TAX'
1415: ,p_value => ln_add_tax);

Line 1418: hr_transaction_api.set_number_value (

1414: ,p_name => 'P_ADDITIONAL_TAX'
1415: ,p_value => ln_add_tax);
1416:
1417: -- Original Additional Tax
1418: hr_transaction_api.set_number_value (
1419: p_transaction_step_id => l_transaction_step_id
1420: ,p_person_id => ln_person_id
1421: ,p_name => 'P_ORG_ADDITIONAL_TAX'
1422: ,p_value => p_original_aa);

Line 1426: hr_transaction_api.set_varchar2_value (

1422: ,p_value => p_original_aa);
1423:
1424:
1425: -- Exempt
1426: hr_transaction_api.set_varchar2_value (
1427: p_transaction_step_id => l_transaction_step_id
1428: ,p_person_id => ln_person_id
1429: ,p_name => 'P_EXEMPT'
1430: ,p_value => l_exempt_status_code ) ;

Line 1433: hr_transaction_api.set_varchar2_value (

1429: ,p_name => 'P_EXEMPT'
1430: ,p_value => l_exempt_status_code ) ;
1431:
1432: -- Original Exempt
1433: hr_transaction_api.set_varchar2_value (
1434: p_transaction_step_id => l_transaction_step_id
1435: ,p_person_id => ln_person_id
1436: ,p_name => 'P_ORG_EXEMPT'
1437: ,p_value => p_original_exempt ) ;

Line 1446: hr_transaction_api.set_varchar2_value (

1442: actid => p_activity_id,
1443: aname => 'HR_REVIEW_REGION_ITEM');
1444:
1445:
1446: hr_transaction_api.set_varchar2_value (
1447: p_transaction_step_id => l_transaction_step_id
1448: ,p_person_id => ln_person_id
1449: ,p_name => 'P_REVIEW_PROC_CALL'
1450: ,p_value => l_review_region ) ;

Line 1453: hr_transaction_api.set_varchar2_value (

1449: ,p_name => 'P_REVIEW_PROC_CALL'
1450: ,p_value => l_review_region ) ;
1451:
1452: -- P_REVIEW_ACTID
1453: hr_transaction_api.set_varchar2_value (
1454: p_transaction_step_id => l_transaction_step_id
1455: ,p_person_id => ln_person_id
1456: ,p_name => 'P_REVIEW_ACTID'
1457: ,p_value => p_activity_id ) ;

Line 1460: hr_transaction_api.set_varchar2_value (

1456: ,p_name => 'P_REVIEW_ACTID'
1457: ,p_value => p_activity_id ) ;
1458:
1459: -- P_LAST_NAME_DIFF
1460: hr_transaction_api.set_varchar2_value (
1461: p_transaction_step_id => l_transaction_step_id
1462: ,p_person_id => ln_person_id
1463: ,p_name => 'P_LAST_NAME_DIFF'
1464: ,p_value => l_last_name_diff_flag ) ;