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.HR_PERSON_DEPLOYMENT_SWI dependencies on HR_API_TRANSACTION_STEPS

Line 479: hr_api_transaction_steps hats

475: cursor c_del_trans is
476: select hat.transaction_id transaction_id,
477: hats.transaction_step_id transaction_step_id
478: from hr_api_transactions hat,
479: hr_api_transaction_steps hats
480: where hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
481: and hat.transaction_id = hats.transaction_id
482: and hats.information1 = to_char(p_person_deployment_id);
483:

Line 1347: from hr_api_transactions hat,hr_api_transaction_steps hats

1343: l_person_deployment_id := hr_transaction_swi.getvarchar2value(l_commitnode,'PersonDeploymentId',null);
1344: begin
1345: select max(hat.transaction_id)
1346: into l_transaction_id
1347: from hr_api_transactions hat,hr_api_transaction_steps hats
1348: where hat.transaction_id = hats.transaction_id
1349: and hats.information1 = l_person_deployment_id
1350: and hats.information12 = 'CreateMode';
1351: exception

Line 1475: lv_permanent hr_api_transaction_steps.Information8%type;

1471: p_person_deployment_id in number) return varchar2
1472:
1473: IS
1474: c_proc constant varchar2(30) := 'getDeploymentType';
1475: lv_permanent hr_api_transaction_steps.Information8%type;
1476: begin
1477: g_debug := hr_utility.debug_enabled;
1478: if g_debug then
1479: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 1486: from hr_api_transaction_steps

1482: if(p_transaction_id is not null) then
1483: begin
1484: select Information8
1485: into lv_permanent
1486: from hr_api_transaction_steps
1487: where transaction_id=p_transaction_id;
1488: exception
1489: when others then
1490: lv_permanent:=null;

Line 1527: lv_deployment_id hr_api_transaction_steps.Information1%type;

1523: p_person_deployment_id in number) return number
1524:
1525: IS
1526: c_proc constant varchar2(30) := 'getPersonDeploymentId';
1527: lv_deployment_id hr_api_transaction_steps.Information1%type;
1528: begin
1529: g_debug := hr_utility.debug_enabled;
1530: if g_debug then
1531: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 1538: from hr_api_transaction_steps

1534: if(p_transaction_id is not null) then
1535: begin
1536: select Information1
1537: into lv_deployment_id
1538: from hr_api_transaction_steps
1539: where transaction_id=p_transaction_id;
1540: exception
1541: when others then
1542: lv_deployment_id:=null;

Line 1572: lv_from_person_id hr_api_transaction_steps.Information2%type;

1568: p_person_deployment_id in number) return number
1569:
1570: IS
1571: c_proc constant varchar2(30) := 'getFromPersonId';
1572: lv_from_person_id hr_api_transaction_steps.Information2%type;
1573: begin
1574: g_debug := hr_utility.debug_enabled;
1575: if g_debug then
1576: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 1583: from hr_api_transaction_steps

1579: if(p_transaction_id is not null) then
1580: begin
1581: select Information2
1582: into lv_from_person_id
1583: from hr_api_transaction_steps
1584: where transaction_id=p_transaction_id;
1585: exception
1586: when others then
1587: lv_from_person_id:=null;

Line 1614: lv_to_bg_id hr_api_transaction_steps.Information3%type;

1610: p_person_deployment_id in number) return number
1611:
1612: IS
1613: c_proc constant varchar2(30) := 'getToBgId';
1614: lv_to_bg_id hr_api_transaction_steps.Information3%type;
1615: begin
1616: g_debug := hr_utility.debug_enabled;
1617: if g_debug then
1618: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 1625: from hr_api_transaction_steps

1621: if(p_transaction_id is not null) then
1622: begin
1623: select Information3
1624: into lv_to_bg_id
1625: from hr_api_transaction_steps
1626: where transaction_id=p_transaction_id;
1627: exception
1628: when others then
1629: lv_to_bg_id:=null;

Line 1656: lv_person_type_id hr_api_transaction_steps.Information4%type;

1652: p_person_deployment_id in number) return number
1653:
1654: IS
1655: c_proc constant varchar2(30) := 'getPersonTypeId';
1656: lv_person_type_id hr_api_transaction_steps.Information4%type;
1657: begin
1658: g_debug := hr_utility.debug_enabled;
1659: if g_debug then
1660: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 1667: from hr_api_transaction_steps

1663: if(p_transaction_id is not null) then
1664: begin
1665: select Information4
1666: into lv_person_type_id
1667: from hr_api_transaction_steps
1668: where transaction_id=p_transaction_id;
1669: exception
1670: when others then
1671: lv_person_type_id:=null;

Line 1700: lv_start_date hr_api_transaction_steps.Information5%type;

1696: p_person_deployment_id in number) return date
1697:
1698: IS
1699: c_proc constant varchar2(30) := 'getStartDate';
1700: lv_start_date hr_api_transaction_steps.Information5%type;
1701: begin
1702: g_debug := hr_utility.debug_enabled;
1703: if g_debug then
1704: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 1711: from hr_api_transaction_steps

1707: if(p_transaction_id is not null) then
1708: begin
1709: select to_date(Information5,'YYYY-MM-DD')
1710: into lv_start_date
1711: from hr_api_transaction_steps
1712: where transaction_id=p_transaction_id;
1713: exception
1714: when others then
1715: lv_start_date:=null;

Line 1743: lv_end_date hr_api_transaction_steps.Information6%type;

1739: p_person_deployment_id in number) return date
1740:
1741: IS
1742: c_proc constant varchar2(30) := 'getEndDate';
1743: lv_end_date hr_api_transaction_steps.Information6%type;
1744:
1745: begin
1746: g_debug := hr_utility.debug_enabled;
1747: if g_debug then

Line 1755: from hr_api_transaction_steps

1751: if(p_transaction_id is not null) then
1752: begin
1753: select to_date(Information6,'YYYY-MM-DD')
1754: into lv_end_date
1755: from hr_api_transaction_steps
1756: where transaction_id=p_transaction_id;
1757: exception
1758: when others then
1759: lv_end_date:=null;

Line 1789: lv_employee_number hr_api_transaction_steps.Information7%type;

1785: p_person_deployment_id in number) return varchar2
1786:
1787: IS
1788: c_proc constant varchar2(30) := 'getEmployeeNumber';
1789: lv_employee_number hr_api_transaction_steps.Information7%type;
1790:
1791: begin
1792: g_debug := hr_utility.debug_enabled;
1793: if g_debug then

Line 1801: from hr_api_transaction_steps

1797: if(p_transaction_id is not null) then
1798: begin
1799: select Information7
1800: into lv_employee_number
1801: from hr_api_transaction_steps
1802: where transaction_id=p_transaction_id;
1803: exception
1804: when others then
1805: lv_employee_number:=null;

Line 1834: lv_to_bg_id hr_api_transaction_steps.Information9%type;

1830: p_person_deployment_id in number) return number
1831:
1832: IS
1833: c_proc constant varchar2(30) := 'getFromBgId';
1834: lv_to_bg_id hr_api_transaction_steps.Information9%type;
1835:
1836: begin
1837: g_debug := hr_utility.debug_enabled;
1838: if g_debug then

Line 1846: from hr_api_transaction_steps

1842: if(p_transaction_id is not null) then
1843: begin
1844: select Information9
1845: into lv_to_bg_id
1846: from hr_api_transaction_steps
1847: where transaction_id=p_transaction_id;
1848: exception
1849: when others then
1850: lv_to_bg_id:=null;

Line 1879: lv_organization_id hr_api_transaction_steps.Information10%type;

1875: p_person_deployment_id in number) return number
1876:
1877: IS
1878: c_proc constant varchar2(30) := 'getOrganizationId';
1879: lv_organization_id hr_api_transaction_steps.Information10%type;
1880:
1881: begin
1882: g_debug := hr_utility.debug_enabled;
1883: if g_debug then

Line 1891: from hr_api_transaction_steps

1887: if(p_transaction_id is not null) then
1888: begin
1889: select Information10
1890: into lv_organization_id
1891: from hr_api_transaction_steps
1892: where transaction_id=p_transaction_id;
1893: exception
1894: when others then
1895: lv_organization_id:=null;

Line 1922: lv_job_id hr_api_transaction_steps.Information11%type;

1918: p_person_deployment_id in number) return number
1919:
1920: IS
1921: c_proc constant varchar2(30) := 'getJobId';
1922: lv_job_id hr_api_transaction_steps.Information11%type;
1923:
1924: begin
1925: g_debug := hr_utility.debug_enabled;
1926: if g_debug then

Line 1934: from hr_api_transaction_steps

1930: if(p_transaction_id is not null) then
1931: begin
1932: select Information11
1933: into lv_job_id
1934: from hr_api_transaction_steps
1935: where transaction_id=p_transaction_id;
1936: exception
1937: when others then
1938: lv_job_id:=null;

Line 2214: lv_action_mode hr_api_transaction_steps.Information12%type;

2210: p_person_deployment_id in number) return varchar2
2211:
2212: IS
2213: c_proc constant varchar2(30) := 'getActionMode';
2214: lv_action_mode hr_api_transaction_steps.Information12%type;
2215: begin
2216: g_debug := hr_utility.debug_enabled;
2217: if g_debug then
2218: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 2225: from hr_api_transaction_steps

2221: if(p_transaction_id is not null) then
2222: begin
2223: select Information12
2224: into lv_action_mode
2225: from hr_api_transaction_steps
2226: where transaction_id=p_transaction_id;
2227: exception
2228: when others then
2229: lv_action_mode:=null;

Line 2257: lv_action_mode hr_api_transaction_steps.Information12%type;

2253: p_transaction_status in varchar2) return varchar2
2254:
2255: IS
2256: c_proc constant varchar2(30) := 'getStatus';
2257: lv_action_mode hr_api_transaction_steps.Information12%type;
2258: lv_status Varchar2(40);
2259: begin
2260: -- hr_utility.trace_on (null,'ORAC');
2261: g_debug := hr_utility.debug_enabled;

Line 2273: from hr_api_transaction_steps

2269: if(p_transaction_id is not null) then
2270: begin
2271: select Information12
2272: into lv_action_mode
2273: from hr_api_transaction_steps
2274: where transaction_id=p_transaction_id;
2275: exception
2276: when others then
2277: lv_action_mode:=null;

Line 2331: lv_from_person_id hr_api_transaction_steps.Information13%type;

2327: p_person_deployment_id in number) return number
2328:
2329: IS
2330: c_proc constant varchar2(30) := 'getToPersonId';
2331: lv_from_person_id hr_api_transaction_steps.Information13%type;
2332: begin
2333: g_debug := hr_utility.debug_enabled;
2334: if g_debug then
2335: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 2342: from hr_api_transaction_steps

2338: if(p_transaction_id is not null) then
2339: begin
2340: select Information13
2341: into lv_from_person_id
2342: from hr_api_transaction_steps
2343: where transaction_id=p_transaction_id;
2344: exception
2345: when others then
2346: lv_from_person_id:=null;

Line 2374: lv_ovn hr_api_transaction_steps.Information14%type;

2370: p_person_deployment_id in number) return number
2371:
2372: IS
2373: c_proc constant varchar2(30) := 'getOvn';
2374: lv_ovn hr_api_transaction_steps.Information14%type;
2375: begin
2376: g_debug := hr_utility.debug_enabled;
2377: if g_debug then
2378: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 2385: from hr_api_transaction_steps

2381: if(p_transaction_id is not null) then
2382: begin
2383: select Information14
2384: into lv_ovn
2385: from hr_api_transaction_steps
2386: where transaction_id=p_transaction_id;
2387: exception
2388: when others then
2389: lv_ovn:=null;

Line 2436: hr_api_transaction_steps hats

2432: then
2433: select count(hat.transaction_id)
2434: into lv_transaction_count
2435: from hr_api_transactions hat,
2436: hr_api_transaction_steps hats
2437: where hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2438: and hats.transaction_id = hat.transaction_id
2439: and hats.information1 = to_char(p_deployment_id)
2440: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')

Line 2444: hr_api_transaction_steps hat

2440: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')
2441: and hat.status in ('AC')
2442: and not exists ( select 'e'
2443: from hr_api_transactions t,
2444: hr_api_transaction_steps hat
2445: WHERE t.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2446: and hat.transaction_id = t.transaction_id
2447: and hat.information1 = to_char(p_deployment_id)
2448: and not(hr_person_deployment_swi.getDeploymentType(t.transaction_id,NULL) IS NULL and t.status = 'W')

Line 2460: from hr_api_transactions hat, hr_api_transaction_steps hats

2456: select ACTION
2457: into lv_action
2458: from PQH_SS_APPROVAL_HISTORY
2459: where transaction_history_id in (select hat.transaction_id
2460: from hr_api_transactions hat, hr_api_transaction_steps hats
2461: where hat.transaction_id = hats.transaction_id
2462: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2463: and hats.information1 = to_char(p_deployment_id)
2464: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )

Line 2468: from hr_api_transactions hat, hr_api_transaction_steps hats

2464: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )
2465: and creation_date = (select max(CREATION_DATE)
2466: from PQH_SS_APPROVAL_HISTORY
2467: where transaction_history_id in (select hat.transaction_id
2468: from hr_api_transactions hat, hr_api_transaction_steps hats
2469: where hat.transaction_id = hats.transaction_id
2470: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2471: and hats.information1 = to_char(p_deployment_id)
2472: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )

Line 2498: hr_api_transaction_steps hats

2494:
2495: select count(hat.transaction_id)
2496: into lv_transaction_count
2497: from hr_api_transactions hat,
2498: hr_api_transaction_steps hats
2499: where hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2500: and hats.transaction_id = hat.transaction_id
2501: and hats.information1 = to_char(p_deployment_id)
2502: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')

Line 2506: hr_api_transaction_steps hat

2502: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')
2503: and hat.status in ('AC')
2504: and not exists ( select 'e'
2505: from hr_api_transactions t,
2506: hr_api_transaction_steps hat
2507: WHERE t.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2508: and hat.transaction_id = t.transaction_id
2509: and hat.information1 = to_char(p_deployment_id)
2510: and not(hr_person_deployment_swi.getDeploymentType(t.transaction_id,NULL) IS NULL and t.status = 'W')

Line 2524: from hr_api_transactions hat, hr_api_transaction_steps hats

2520: select ACTION
2521: into lv_action
2522: from PQH_SS_APPROVAL_HISTORY
2523: where transaction_history_id in (select hat.transaction_id
2524: from hr_api_transactions hat, hr_api_transaction_steps hats
2525: where hat.transaction_id = hats.transaction_id
2526: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2527: and hats.information1 = to_char(p_deployment_id)
2528: and upper(hats.information12) in ('RETURNMODE','ACTUPDATEMODE')

Line 2533: from hr_api_transactions hat, hr_api_transaction_steps hats

2529: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )
2530: and creation_date = (select max(CREATION_DATE)
2531: from PQH_SS_APPROVAL_HISTORY
2532: where transaction_history_id in (select hat.transaction_id
2533: from hr_api_transactions hat, hr_api_transaction_steps hats
2534: where hat.transaction_id = hats.transaction_id
2535: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2536: and hats.information1 = to_char(p_deployment_id)
2537: and upper(hats.information12) in ('RETURNMODE','ACTUPDATEMODE')

Line 2566: hr_api_transaction_steps hats

2562:
2563: select count(hat.transaction_id)
2564: into lv_transaction_count
2565: from hr_api_transactions hat,
2566: hr_api_transaction_steps hats
2567: where hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2568: and hats.transaction_id = hat.transaction_id
2569: and hats.information1 = to_char(p_deployment_id)
2570: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')

Line 2574: hr_api_transaction_steps hat

2570: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W')
2571: and hat.status in ('AC')
2572: and not exists ( select 'e'
2573: from hr_api_transactions t,
2574: hr_api_transaction_steps hat
2575: WHERE t.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2576: and hat.transaction_id = t.transaction_id
2577: and hat.information1 = to_char(p_deployment_id)
2578: and not(hr_person_deployment_swi.getDeploymentType(t.transaction_id,NULL) IS NULL and t.status = 'W')

Line 2592: from hr_api_transactions hat, hr_api_transaction_steps hats

2588: select ACTION
2589: into lv_action
2590: from PQH_SS_APPROVAL_HISTORY
2591: where transaction_history_id in (select hat.transaction_id
2592: from hr_api_transactions hat, hr_api_transaction_steps hats
2593: where hat.transaction_id = hats.transaction_id
2594: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2595: and hats.information1 = to_char(p_deployment_id)
2596: and upper(hats.information12) = 'RETURNMODE'

Line 2601: from hr_api_transactions hat, hr_api_transaction_steps hats

2597: and not(hr_person_deployment_swi.getDeploymentType(hat.transaction_id,NULL) IS NULL and hat.status = 'W') )
2598: and creation_date = (select max(CREATION_DATE)
2599: from PQH_SS_APPROVAL_HISTORY
2600: where transaction_history_id in (select hat.transaction_id
2601: from hr_api_transactions hat, hr_api_transaction_steps hats
2602: where hat.transaction_id = hats.transaction_id
2603: and hat.transaction_ref_table='HR_PERSON_DEPLOYMENT'
2604: and hats.information1 = to_char(p_deployment_id)
2605: and upper(hats.information12) = 'RETURNMODE'

Line 2672: -- and upper('ACTUPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)

2668: where transaction_history_id = p_transaction_id
2669: and creation_date = (select max(CREATION_DATE)
2670: from PQH_SS_APPROVAL_HISTORY
2671: where transaction_history_id = p_transaction_id)
2672: -- and upper('ACTUPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2673: -- and upper('RETURNMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2674: -- and upper('UPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2675: and (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id) not in ('ACTUPDATEMODE','RETURNMODE','UPDATEMODE');
2676:

Line 2673: -- and upper('RETURNMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)

2669: and creation_date = (select max(CREATION_DATE)
2670: from PQH_SS_APPROVAL_HISTORY
2671: where transaction_history_id = p_transaction_id)
2672: -- and upper('ACTUPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2673: -- and upper('RETURNMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2674: -- and upper('UPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2675: and (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id) not in ('ACTUPDATEMODE','RETURNMODE','UPDATEMODE');
2676:
2677: exception

Line 2674: -- and upper('UPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)

2670: from PQH_SS_APPROVAL_HISTORY
2671: where transaction_history_id = p_transaction_id)
2672: -- and upper('ACTUPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2673: -- and upper('RETURNMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2674: -- and upper('UPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2675: and (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id) not in ('ACTUPDATEMODE','RETURNMODE','UPDATEMODE');
2676:
2677: exception
2678: when others then lv_action := null;

Line 2675: and (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id) not in ('ACTUPDATEMODE','RETURNMODE','UPDATEMODE');

2671: where transaction_history_id = p_transaction_id)
2672: -- and upper('ACTUPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2673: -- and upper('RETURNMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2674: -- and upper('UPDATEMODE') NOT IN (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id)
2675: and (SELECT UPPER(information12) from hr_api_transaction_steps where transaction_step_id = p_transaction_step_id) not in ('ACTUPDATEMODE','RETURNMODE','UPDATEMODE');
2676:
2677: exception
2678: when others then lv_action := null;
2679: end;