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_TERMINATION_SS dependencies on HR_TRANSACTION_API

Line 38: hr_transaction_api.get_number_value

34: l_proc constant varchar2(100) := g_package || ' update_object_version';
35: BEGIN
36: hr_utility.set_location('Entering: '|| l_proc,5);
37: ln_period_of_service_id :=
38: hr_transaction_api.get_number_value
39: (p_transaction_step_id => p_transaction_step_id
40: ,p_name => 'P_PERIOD_OF_SERVICE_ID');
41:
42:

Line 48: hr_transaction_api.get_number_value

44: FETCH csr_new_object_number into ln_new_object_number;
45: CLOSE csr_new_object_number;
46:
47: ln_old_object_number :=
48: hr_transaction_api.get_number_value
49: (p_transaction_step_id => p_transaction_step_id
50: ,p_name => 'P_OBJECT_VERSION_NUMBER');
51:
52: IF ln_old_object_number <> ln_new_object_number then

Line 53: hr_transaction_api.set_number_value

49: (p_transaction_step_id => p_transaction_step_id
50: ,p_name => 'P_OBJECT_VERSION_NUMBER');
51:
52: IF ln_old_object_number <> ln_new_object_number then
53: hr_transaction_api.set_number_value
54: (p_transaction_step_id => p_transaction_step_id
55: ,p_person_id => p_login_person_id
56: ,p_name => 'P_OBJECT_VERSION_NUMBER'
57: ,p_value => ln_new_object_number);

Line 1632: hr_transaction_api.get_transaction_step_info (

1628: -- Retieve the transaction step for this current
1629: -- activity. We will update this transaction step with
1630: -- the new information.
1631: ---------------------------------------------------------------------
1632: hr_transaction_api.get_transaction_step_info (
1633: p_Item_Type => p_item_type,
1634: p_Item_Key => p_item_key,
1635: p_activity_id => to_number(p_actid),
1636: p_transaction_step_id => ltt_trans_step_ids,

Line 1648: hr_transaction_api.create_transaction_step (

1644: --------------------------------------------------------------------
1645: -- There is no transaction step for this transaction.
1646: -- Create a step within this new transaction
1647: --------------------------------------------------------------------
1648: hr_transaction_api.create_transaction_step (
1649: p_validate => false,
1650: p_creator_person_id => p_login_person_id,
1651: p_transaction_id => ln_transaction_id,
1652: p_api_name => g_package || '.PROCESS_API',

Line 1803: hr_transaction_api.get_number_value (

1799: -----------------------------------------------------------------------
1800: -- get common data for APIs from transaction table
1801: -----------------------------------------------------------------------
1802: ln_period_of_service_id :=
1803: hr_transaction_api.get_number_value (
1804: p_transaction_step_id => p_transaction_step_id,
1805: p_name => 'P_PERIOD_OF_SERVICE_ID'
1806: );
1807:

Line 1809: hr_transaction_api.get_number_value (

1805: p_name => 'P_PERIOD_OF_SERVICE_ID'
1806: );
1807:
1808: ln_object_version_number :=
1809: hr_transaction_api.get_number_value (
1810: p_transaction_step_id => p_transaction_step_id,
1811: p_name => 'P_OBJECT_VERSION_NUMBER'
1812: );
1813:

Line 1850: hr_transaction_api.get_varchar2_value (

1846: p_transaction_step_id => p_transaction_step_id
1847: );
1848:
1849: lv_attribute_category :=
1850: hr_transaction_api.get_varchar2_value (
1851: p_transaction_step_id => p_transaction_step_id,
1852: p_name => 'P_ATTRIBUTE_CATEGORY'
1853: );
1854:

Line 1857: hr_transaction_api.get_varchar2_value (

1853: );
1854:
1855: -- DDF Enhancement : Get PDS_INFORMATION_CATEGORY
1856: lv_pds_information_category :=
1857: hr_transaction_api.get_varchar2_value (
1858: p_transaction_step_id => p_transaction_step_id,
1859: p_name => 'P_PDS_INFORMATION_CATEGORY'
1860: );
1861:

Line 2059: hr_transaction_api.get_date_value (

2055: l_proc constant varchar2(100) := g_package || ' get_termination_details';
2056: BEGIN
2057: hr_utility.set_location('Entering: '|| l_proc,5);
2058: lrt_termination.notified_termination_date :=
2059: hr_transaction_api.get_date_value (
2060: p_transaction_step_id => p_transaction_step_id,
2061: p_name => 'P_NOTIFIED_TERMINATION_DATE'
2062: );
2063:

Line 2065: hr_transaction_api.get_date_value (

2061: p_name => 'P_NOTIFIED_TERMINATION_DATE'
2062: );
2063:
2064: lrt_termination.last_standard_process_date :=
2065: hr_transaction_api.get_date_value (
2066: p_transaction_step_id => p_transaction_step_id,
2067: p_name => 'P_LAST_STANDARD_PROCESS_DATE'
2068: );
2069:

Line 2071: hr_transaction_api.get_date_value (

2067: p_name => 'P_LAST_STANDARD_PROCESS_DATE'
2068: );
2069:
2070: lrt_termination.projected_termination_date :=
2071: hr_transaction_api.get_date_value (
2072: p_transaction_step_id => p_transaction_step_id,
2073: p_name => 'P_PROJECTED_TERMINATION_DATE'
2074: );
2075:

Line 2077: hr_transaction_api.get_date_value (

2073: p_name => 'P_PROJECTED_TERMINATION_DATE'
2074: );
2075:
2076: lrt_termination.final_process_date :=
2077: hr_transaction_api.get_date_value (
2078: p_transaction_step_id => p_transaction_step_id,
2079: p_name => 'P_FINAL_PROCESS_DATE'
2080: );
2081:

Line 2083: hr_transaction_api.get_date_value (

2079: p_name => 'P_FINAL_PROCESS_DATE'
2080: );
2081:
2082: lrt_termination.actual_termination_date :=
2083: hr_transaction_api.get_date_value (
2084: p_transaction_step_id => p_transaction_step_id,
2085: p_name => 'P_ACTUAL_TERMINATION_DATE'
2086: );
2087:

Line 2089: hr_transaction_api.get_varchar2_value (

2085: p_name => 'P_ACTUAL_TERMINATION_DATE'
2086: );
2087:
2088: lrt_termination.leaving_reason :=
2089: hr_transaction_api.get_varchar2_value (
2090: p_transaction_step_id => p_transaction_step_id,
2091: p_name => 'P_LEAVING_REASON'
2092: );
2093:

Line 2095: hr_transaction_api.get_number_value (

2091: p_name => 'P_LEAVING_REASON'
2092: );
2093:
2094: lrt_termination.person_type_id :=
2095: hr_transaction_api.get_number_value (
2096: p_transaction_step_id => p_transaction_step_id,
2097: p_name => 'P_PERSON_TYPE_ID'
2098: );
2099:

Line 2101: hr_transaction_api.get_number_value (

2097: p_name => 'P_PERSON_TYPE_ID'
2098: );
2099:
2100: lrt_termination.assignment_status_type_id :=
2101: hr_transaction_api.get_number_value (
2102: p_transaction_step_id => p_transaction_step_id,
2103: p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID'
2104: );
2105:

Line 2107: hr_transaction_api.get_varchar2_value (

2103: p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID'
2104: );
2105:
2106: lrt_termination.comments :=
2107: hr_transaction_api.get_varchar2_value (
2108: p_transaction_step_id => p_transaction_step_id,
2109: p_name => 'P_COMMENTS'
2110: );
2111:

Line 2113: hr_transaction_api.get_number_value (

2109: p_name => 'P_COMMENTS'
2110: );
2111:
2112: lrt_termination.period_of_service_id :=
2113: hr_transaction_api.get_number_value (
2114: p_transaction_step_id => p_transaction_step_id,
2115: p_name => 'P_PERIOD_OF_SERVICE_ID'
2116: );
2117:

Line 2119: hr_transaction_api.get_number_value (

2115: p_name => 'P_PERIOD_OF_SERVICE_ID'
2116: );
2117:
2118: lrt_termination.object_version_number :=
2119: hr_transaction_api.get_number_value (
2120: p_transaction_step_id => p_transaction_step_id,
2121: p_name => 'P_OBJECT_VERSION_NUMBER'
2122: );
2123:

Line 2125: hr_transaction_api.get_varchar2_value (

2121: p_name => 'P_OBJECT_VERSION_NUMBER'
2122: );
2123:
2124: lrt_termination.rehire_recommendation :=
2125: hr_transaction_api.get_varchar2_value (
2126: p_transaction_step_id => p_transaction_step_id,
2127: p_name => 'P_REHIRE_RECOMMENDATION'
2128: );
2129:

Line 2131: hr_transaction_api.get_varchar2_value (

2127: p_name => 'P_REHIRE_RECOMMENDATION'
2128: );
2129:
2130: lrt_termination.rehire_reason :=
2131: hr_transaction_api.get_varchar2_value (
2132: p_transaction_step_id => p_transaction_step_id,
2133: p_name => 'P_REHIRE_REASON'
2134: );
2135: hr_utility.set_location('Leaving: '|| l_proc,10);

Line 2167: hr_transaction_api.get_varchar2_value (

2163: lt_term_flex(ln_counter) := NULL;
2164: END LOOP;
2165: FOR ln_counter IN 1..20 LOOP
2166: lt_term_flex(ln_counter) :=
2167: hr_transaction_api.get_varchar2_value (
2168: p_transaction_step_id => p_transaction_step_id,
2169: p_name => 'P_ATTRIBUTE' || to_char(ln_counter)
2170: );
2171: END LOOP;

Line 2181: hr_transaction_api.get_varchar2_value (

2177: lt_term_flex(ln_counter) := NULL;
2178: END LOOP;
2179: FOR ln_counter IN 21..50 LOOP
2180: lt_term_flex(ln_counter) :=
2181: hr_transaction_api.get_varchar2_value (
2182: p_transaction_step_id => p_transaction_step_id,
2183: p_name => 'P_PDS_INFORMATION' ||
2184: to_char(ln_counter - 20)
2185: );

Line 2300: hr_transaction_api.get_number_value

2296: BEGIN
2297: hr_utility.set_location('Entering: '|| l_proc,5);
2298: --
2299: p_period_of_service_id:=
2300: hr_transaction_api.get_number_value
2301: (p_transaction_step_id => p_transaction_step_id
2302: ,p_name => 'P_PERIOD_OF_SERVICE_ID');
2303: --
2304: p_object_version_number:=

Line 2305: hr_transaction_api.get_number_value

2301: (p_transaction_step_id => p_transaction_step_id
2302: ,p_name => 'P_PERIOD_OF_SERVICE_ID');
2303: --
2304: p_object_version_number:=
2305: hr_transaction_api.get_number_value
2306: (p_transaction_step_id => p_transaction_step_id
2307: ,p_name => 'P_OBJECT_VERSION_NUMBER');
2308: --
2309: -- Bug 2086516 Fix Begins - 11/15/2001

Line 2323: hr_transaction_api.get_date_value

2319: --
2320: -- Bug 2086516 Fix Ends - 11/15/2001
2321: --
2322: p_notified_termination_date:= to_char(
2323: hr_transaction_api.get_date_value
2324: (p_transaction_step_id => p_transaction_step_id
2325: ,p_name => 'P_NOTIFIED_TERMINATION_DATE')
2326: ,g_date_format);
2327: --

Line 2329: hr_transaction_api.get_date_value

2325: ,p_name => 'P_NOTIFIED_TERMINATION_DATE')
2326: ,g_date_format);
2327: --
2328: p_last_standard_process_date := to_char(
2329: hr_transaction_api.get_date_value
2330: (p_transaction_step_id => p_transaction_step_id
2331: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE')
2332: ,g_date_format);
2333: --

Line 2335: hr_transaction_api.get_date_value

2331: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE')
2332: ,g_date_format);
2333: --
2334: p_projected_termination_date := to_char(
2335: hr_transaction_api.get_date_value
2336: (p_transaction_step_id => p_transaction_step_id
2337: ,p_name => 'P_PROJECTED_TERMINATION_DATE')
2338: ,g_date_format);
2339: --

Line 2341: hr_transaction_api.get_date_value

2337: ,p_name => 'P_PROJECTED_TERMINATION_DATE')
2338: ,g_date_format);
2339: --
2340: p_final_process_date := to_char(
2341: hr_transaction_api.get_date_value
2342: (p_transaction_step_id => p_transaction_step_id
2343: ,p_name => 'P_FINAL_PROCESS_DATE')
2344: ,g_date_format);
2345: --

Line 2347: hr_transaction_api.get_varchar2_value

2343: ,p_name => 'P_FINAL_PROCESS_DATE')
2344: ,g_date_format);
2345: --
2346: p_leaving_reason:=
2347: hr_transaction_api.get_varchar2_value
2348: (p_transaction_step_id => p_transaction_step_id
2349: ,p_name => 'P_LEAVING_REASON');
2350: --
2351: p_person_type_id:=

Line 2352: hr_transaction_api.get_number_value

2348: (p_transaction_step_id => p_transaction_step_id
2349: ,p_name => 'P_LEAVING_REASON');
2350: --
2351: p_person_type_id:=
2352: hr_transaction_api.get_number_value
2353: (p_transaction_step_id => p_transaction_step_id
2354: ,p_name => 'P_PERSON_TYPE_ID');
2355: --
2356: p_assignment_status_type_id:=

Line 2357: hr_transaction_api.get_number_value

2353: (p_transaction_step_id => p_transaction_step_id
2354: ,p_name => 'P_PERSON_TYPE_ID');
2355: --
2356: p_assignment_status_type_id:=
2357: hr_transaction_api.get_number_value
2358: (p_transaction_step_id => p_transaction_step_id
2359: ,p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID');
2360: --
2361: p_comments:=

Line 2362: hr_transaction_api.get_varchar2_value

2358: (p_transaction_step_id => p_transaction_step_id
2359: ,p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID');
2360: --
2361: p_comments:=
2362: hr_transaction_api.get_varchar2_value
2363: (p_transaction_step_id => p_transaction_step_id
2364: ,p_name => 'P_COMMENTS');
2365: --
2366: p_rehire_recommendation:=

Line 2367: hr_transaction_api.get_varchar2_value

2363: (p_transaction_step_id => p_transaction_step_id
2364: ,p_name => 'P_COMMENTS');
2365: --
2366: p_rehire_recommendation:=
2367: hr_transaction_api.get_varchar2_value
2368: (p_transaction_step_id => p_transaction_step_id
2369: ,p_name => 'P_REHIRE_RECOMMENDATION');
2370: --
2371: p_rehire_reason:=

Line 2372: hr_transaction_api.get_varchar2_value

2368: (p_transaction_step_id => p_transaction_step_id
2369: ,p_name => 'P_REHIRE_RECOMMENDATION');
2370: --
2371: p_rehire_reason:=
2372: hr_transaction_api.get_varchar2_value
2373: (p_transaction_step_id => p_transaction_step_id
2374: ,p_name => 'P_REHIRE_REASON');
2375:
2376: --

Line 2378: hr_transaction_api.get_varchar2_value

2374: ,p_name => 'P_REHIRE_REASON');
2375:
2376: --
2377: p_attribute_category:=
2378: hr_transaction_api.get_varchar2_value
2379: (p_transaction_step_id => p_transaction_step_id
2380: ,p_name => 'P_ATTRIBUTE_CATEGORY');
2381: --
2382: p_attribute1:=

Line 2383: hr_transaction_api.get_varchar2_value

2379: (p_transaction_step_id => p_transaction_step_id
2380: ,p_name => 'P_ATTRIBUTE_CATEGORY');
2381: --
2382: p_attribute1:=
2383: hr_transaction_api.get_varchar2_value
2384: (p_transaction_step_id => p_transaction_step_id
2385: ,p_name => 'P_ATTRIBUTE1');
2386: --
2387: p_attribute2:=

Line 2388: hr_transaction_api.get_varchar2_value

2384: (p_transaction_step_id => p_transaction_step_id
2385: ,p_name => 'P_ATTRIBUTE1');
2386: --
2387: p_attribute2:=
2388: hr_transaction_api.get_varchar2_value
2389: (p_transaction_step_id => p_transaction_step_id
2390: ,p_name => 'P_ATTRIBUTE2');
2391: --
2392: p_attribute3:=

Line 2393: hr_transaction_api.get_varchar2_value

2389: (p_transaction_step_id => p_transaction_step_id
2390: ,p_name => 'P_ATTRIBUTE2');
2391: --
2392: p_attribute3:=
2393: hr_transaction_api.get_varchar2_value
2394: (p_transaction_step_id => p_transaction_step_id
2395: ,p_name => 'P_ATTRIBUTE3');
2396: --
2397: p_attribute4:=

Line 2398: hr_transaction_api.get_varchar2_value

2394: (p_transaction_step_id => p_transaction_step_id
2395: ,p_name => 'P_ATTRIBUTE3');
2396: --
2397: p_attribute4:=
2398: hr_transaction_api.get_varchar2_value
2399: (p_transaction_step_id => p_transaction_step_id
2400: ,p_name => 'P_ATTRIBUTE4');
2401: --
2402: p_attribute5:=

Line 2403: hr_transaction_api.get_varchar2_value

2399: (p_transaction_step_id => p_transaction_step_id
2400: ,p_name => 'P_ATTRIBUTE4');
2401: --
2402: p_attribute5:=
2403: hr_transaction_api.get_varchar2_value
2404: (p_transaction_step_id => p_transaction_step_id
2405: ,p_name => 'P_ATTRIBUTE5');
2406: --
2407: p_attribute6:=

Line 2408: hr_transaction_api.get_varchar2_value

2404: (p_transaction_step_id => p_transaction_step_id
2405: ,p_name => 'P_ATTRIBUTE5');
2406: --
2407: p_attribute6:=
2408: hr_transaction_api.get_varchar2_value
2409: (p_transaction_step_id => p_transaction_step_id
2410: ,p_name => 'P_ATTRIBUTE6');
2411: --
2412: p_attribute7:=

Line 2413: hr_transaction_api.get_varchar2_value

2409: (p_transaction_step_id => p_transaction_step_id
2410: ,p_name => 'P_ATTRIBUTE6');
2411: --
2412: p_attribute7:=
2413: hr_transaction_api.get_varchar2_value
2414: (p_transaction_step_id => p_transaction_step_id
2415: ,p_name => 'P_ATTRIBUTE7');
2416: --
2417: p_attribute8:=

Line 2418: hr_transaction_api.get_varchar2_value

2414: (p_transaction_step_id => p_transaction_step_id
2415: ,p_name => 'P_ATTRIBUTE7');
2416: --
2417: p_attribute8:=
2418: hr_transaction_api.get_varchar2_value
2419: (p_transaction_step_id => p_transaction_step_id
2420: ,p_name => 'P_ATTRIBUTE8');
2421: --
2422: p_attribute9:=

Line 2423: hr_transaction_api.get_varchar2_value

2419: (p_transaction_step_id => p_transaction_step_id
2420: ,p_name => 'P_ATTRIBUTE8');
2421: --
2422: p_attribute9:=
2423: hr_transaction_api.get_varchar2_value
2424: (p_transaction_step_id => p_transaction_step_id
2425: ,p_name => 'P_ATTRIBUTE9');
2426: --
2427: p_attribute10:=

Line 2428: hr_transaction_api.get_varchar2_value

2424: (p_transaction_step_id => p_transaction_step_id
2425: ,p_name => 'P_ATTRIBUTE9');
2426: --
2427: p_attribute10:=
2428: hr_transaction_api.get_varchar2_value
2429: (p_transaction_step_id => p_transaction_step_id
2430: ,p_name => 'P_ATTRIBUTE10');
2431: --
2432: p_attribute11:=

Line 2433: hr_transaction_api.get_varchar2_value

2429: (p_transaction_step_id => p_transaction_step_id
2430: ,p_name => 'P_ATTRIBUTE10');
2431: --
2432: p_attribute11:=
2433: hr_transaction_api.get_varchar2_value
2434: (p_transaction_step_id => p_transaction_step_id
2435: ,p_name => 'P_ATTRIBUTE11');
2436: --
2437: p_attribute12:=

Line 2438: hr_transaction_api.get_varchar2_value

2434: (p_transaction_step_id => p_transaction_step_id
2435: ,p_name => 'P_ATTRIBUTE11');
2436: --
2437: p_attribute12:=
2438: hr_transaction_api.get_varchar2_value
2439: (p_transaction_step_id => p_transaction_step_id
2440: ,p_name => 'P_ATTRIBUTE12');
2441: --
2442: p_attribute13:=

Line 2443: hr_transaction_api.get_varchar2_value

2439: (p_transaction_step_id => p_transaction_step_id
2440: ,p_name => 'P_ATTRIBUTE12');
2441: --
2442: p_attribute13:=
2443: hr_transaction_api.get_varchar2_value
2444: (p_transaction_step_id => p_transaction_step_id
2445: ,p_name => 'P_ATTRIBUTE13');
2446: --
2447: p_attribute14:=

Line 2448: hr_transaction_api.get_varchar2_value

2444: (p_transaction_step_id => p_transaction_step_id
2445: ,p_name => 'P_ATTRIBUTE13');
2446: --
2447: p_attribute14:=
2448: hr_transaction_api.get_varchar2_value
2449: (p_transaction_step_id => p_transaction_step_id
2450: ,p_name => 'P_ATTRIBUTE14');
2451: --
2452: p_attribute15:=

Line 2453: hr_transaction_api.get_varchar2_value

2449: (p_transaction_step_id => p_transaction_step_id
2450: ,p_name => 'P_ATTRIBUTE14');
2451: --
2452: p_attribute15:=
2453: hr_transaction_api.get_varchar2_value
2454: (p_transaction_step_id => p_transaction_step_id
2455: ,p_name => 'P_ATTRIBUTE15');
2456: --
2457: p_attribute16:=

Line 2458: hr_transaction_api.get_varchar2_value

2454: (p_transaction_step_id => p_transaction_step_id
2455: ,p_name => 'P_ATTRIBUTE15');
2456: --
2457: p_attribute16:=
2458: hr_transaction_api.get_varchar2_value
2459: (p_transaction_step_id => p_transaction_step_id
2460: ,p_name => 'P_ATTRIBUTE16');
2461: --
2462: p_attribute17:=

Line 2463: hr_transaction_api.get_varchar2_value

2459: (p_transaction_step_id => p_transaction_step_id
2460: ,p_name => 'P_ATTRIBUTE16');
2461: --
2462: p_attribute17:=
2463: hr_transaction_api.get_varchar2_value
2464: (p_transaction_step_id => p_transaction_step_id
2465: ,p_name => 'P_ATTRIBUTE17');
2466: --
2467: p_attribute18:=

Line 2468: hr_transaction_api.get_varchar2_value

2464: (p_transaction_step_id => p_transaction_step_id
2465: ,p_name => 'P_ATTRIBUTE17');
2466: --
2467: p_attribute18:=
2468: hr_transaction_api.get_varchar2_value
2469: (p_transaction_step_id => p_transaction_step_id
2470: ,p_name => 'P_ATTRIBUTE18');
2471: --
2472: p_attribute19:=

Line 2473: hr_transaction_api.get_varchar2_value

2469: (p_transaction_step_id => p_transaction_step_id
2470: ,p_name => 'P_ATTRIBUTE18');
2471: --
2472: p_attribute19:=
2473: hr_transaction_api.get_varchar2_value
2474: (p_transaction_step_id => p_transaction_step_id
2475: ,p_name => 'P_ATTRIBUTE19');
2476: --
2477: p_attribute20:=

Line 2478: hr_transaction_api.get_varchar2_value

2474: (p_transaction_step_id => p_transaction_step_id
2475: ,p_name => 'P_ATTRIBUTE19');
2476: --
2477: p_attribute20:=
2478: hr_transaction_api.get_varchar2_value
2479: (p_transaction_step_id => p_transaction_step_id
2480: ,p_name => 'P_ATTRIBUTE20');
2481: --
2482: p_review_actid:=

Line 2483: hr_transaction_api.get_varchar2_value

2479: (p_transaction_step_id => p_transaction_step_id
2480: ,p_name => 'P_ATTRIBUTE20');
2481: --
2482: p_review_actid:=
2483: hr_transaction_api.get_varchar2_value
2484: (p_transaction_step_id => p_transaction_step_id
2485: ,p_name => 'P_REVIEW_ACTID');
2486: --
2487: p_review_proc_call:=

Line 2488: hr_transaction_api.get_varchar2_value

2484: (p_transaction_step_id => p_transaction_step_id
2485: ,p_name => 'P_REVIEW_ACTID');
2486: --
2487: p_review_proc_call:=
2488: hr_transaction_api.get_varchar2_value
2489: (p_transaction_step_id => p_transaction_step_id
2490: ,p_name => 'P_REVIEW_PROC_CALL');
2491:
2492: -- DDF Enhancement : Retrieve from Transaction table.

Line 2495: hr_transaction_api.get_varchar2_value

2491:
2492: -- DDF Enhancement : Retrieve from Transaction table.
2493: --
2494: p_pds_information_category:=
2495: hr_transaction_api.get_varchar2_value
2496: (p_transaction_step_id => p_transaction_step_id
2497: ,p_name => 'P_PDS_INFORMATION_CATEGORY');
2498: --
2499: p_pds_information1:=

Line 2500: hr_transaction_api.get_varchar2_value

2496: (p_transaction_step_id => p_transaction_step_id
2497: ,p_name => 'P_PDS_INFORMATION_CATEGORY');
2498: --
2499: p_pds_information1:=
2500: hr_transaction_api.get_varchar2_value
2501: (p_transaction_step_id => p_transaction_step_id
2502: ,p_name => 'P_PDS_INFORMATION1');
2503: --
2504: p_pds_information2:=

Line 2505: hr_transaction_api.get_varchar2_value

2501: (p_transaction_step_id => p_transaction_step_id
2502: ,p_name => 'P_PDS_INFORMATION1');
2503: --
2504: p_pds_information2:=
2505: hr_transaction_api.get_varchar2_value
2506: (p_transaction_step_id => p_transaction_step_id
2507: ,p_name => 'P_PDS_INFORMATION2');
2508: --
2509: p_pds_information3:=

Line 2510: hr_transaction_api.get_varchar2_value

2506: (p_transaction_step_id => p_transaction_step_id
2507: ,p_name => 'P_PDS_INFORMATION2');
2508: --
2509: p_pds_information3:=
2510: hr_transaction_api.get_varchar2_value
2511: (p_transaction_step_id => p_transaction_step_id
2512: ,p_name => 'P_PDS_INFORMATION3');
2513: --
2514: p_pds_information4:=

Line 2515: hr_transaction_api.get_varchar2_value

2511: (p_transaction_step_id => p_transaction_step_id
2512: ,p_name => 'P_PDS_INFORMATION3');
2513: --
2514: p_pds_information4:=
2515: hr_transaction_api.get_varchar2_value
2516: (p_transaction_step_id => p_transaction_step_id
2517: ,p_name => 'P_PDS_INFORMATION4');
2518: --
2519: p_pds_information5:=

Line 2520: hr_transaction_api.get_varchar2_value

2516: (p_transaction_step_id => p_transaction_step_id
2517: ,p_name => 'P_PDS_INFORMATION4');
2518: --
2519: p_pds_information5:=
2520: hr_transaction_api.get_varchar2_value
2521: (p_transaction_step_id => p_transaction_step_id
2522: ,p_name => 'P_PDS_INFORMATION5');
2523: --
2524: p_pds_information6:=

Line 2525: hr_transaction_api.get_varchar2_value

2521: (p_transaction_step_id => p_transaction_step_id
2522: ,p_name => 'P_PDS_INFORMATION5');
2523: --
2524: p_pds_information6:=
2525: hr_transaction_api.get_varchar2_value
2526: (p_transaction_step_id => p_transaction_step_id
2527: ,p_name => 'P_PDS_INFORMATION6');
2528: --
2529: p_pds_information7:=

Line 2530: hr_transaction_api.get_varchar2_value

2526: (p_transaction_step_id => p_transaction_step_id
2527: ,p_name => 'P_PDS_INFORMATION6');
2528: --
2529: p_pds_information7:=
2530: hr_transaction_api.get_varchar2_value
2531: (p_transaction_step_id => p_transaction_step_id
2532: ,p_name => 'P_PDS_INFORMATION7');
2533: --
2534: p_pds_information8:=

Line 2535: hr_transaction_api.get_varchar2_value

2531: (p_transaction_step_id => p_transaction_step_id
2532: ,p_name => 'P_PDS_INFORMATION7');
2533: --
2534: p_pds_information8:=
2535: hr_transaction_api.get_varchar2_value
2536: (p_transaction_step_id => p_transaction_step_id
2537: ,p_name => 'P_PDS_INFORMATION8');
2538: --
2539: p_pds_information9:=

Line 2540: hr_transaction_api.get_varchar2_value

2536: (p_transaction_step_id => p_transaction_step_id
2537: ,p_name => 'P_PDS_INFORMATION8');
2538: --
2539: p_pds_information9:=
2540: hr_transaction_api.get_varchar2_value
2541: (p_transaction_step_id => p_transaction_step_id
2542: ,p_name => 'P_PDS_INFORMATION9');
2543: --
2544: p_pds_information10:=

Line 2545: hr_transaction_api.get_varchar2_value

2541: (p_transaction_step_id => p_transaction_step_id
2542: ,p_name => 'P_PDS_INFORMATION9');
2543: --
2544: p_pds_information10:=
2545: hr_transaction_api.get_varchar2_value
2546: (p_transaction_step_id => p_transaction_step_id
2547: ,p_name => 'P_PDS_INFORMATION10');
2548: --
2549: p_pds_information11:=

Line 2550: hr_transaction_api.get_varchar2_value

2546: (p_transaction_step_id => p_transaction_step_id
2547: ,p_name => 'P_PDS_INFORMATION10');
2548: --
2549: p_pds_information11:=
2550: hr_transaction_api.get_varchar2_value
2551: (p_transaction_step_id => p_transaction_step_id
2552: ,p_name => 'P_PDS_INFORMATION11');
2553: --
2554: p_pds_information12:=

Line 2555: hr_transaction_api.get_varchar2_value

2551: (p_transaction_step_id => p_transaction_step_id
2552: ,p_name => 'P_PDS_INFORMATION11');
2553: --
2554: p_pds_information12:=
2555: hr_transaction_api.get_varchar2_value
2556: (p_transaction_step_id => p_transaction_step_id
2557: ,p_name => 'P_PDS_INFORMATION12');
2558: --
2559: p_pds_information13:=

Line 2560: hr_transaction_api.get_varchar2_value

2556: (p_transaction_step_id => p_transaction_step_id
2557: ,p_name => 'P_PDS_INFORMATION12');
2558: --
2559: p_pds_information13:=
2560: hr_transaction_api.get_varchar2_value
2561: (p_transaction_step_id => p_transaction_step_id
2562: ,p_name => 'P_PDS_INFORMATION13');
2563: --
2564: p_pds_information14:=

Line 2565: hr_transaction_api.get_varchar2_value

2561: (p_transaction_step_id => p_transaction_step_id
2562: ,p_name => 'P_PDS_INFORMATION13');
2563: --
2564: p_pds_information14:=
2565: hr_transaction_api.get_varchar2_value
2566: (p_transaction_step_id => p_transaction_step_id
2567: ,p_name => 'P_PDS_INFORMATION14');
2568: --
2569: p_pds_information15:=

Line 2570: hr_transaction_api.get_varchar2_value

2566: (p_transaction_step_id => p_transaction_step_id
2567: ,p_name => 'P_PDS_INFORMATION14');
2568: --
2569: p_pds_information15:=
2570: hr_transaction_api.get_varchar2_value
2571: (p_transaction_step_id => p_transaction_step_id
2572: ,p_name => 'P_PDS_INFORMATION15');
2573: --
2574: p_pds_information16:=

Line 2575: hr_transaction_api.get_varchar2_value

2571: (p_transaction_step_id => p_transaction_step_id
2572: ,p_name => 'P_PDS_INFORMATION15');
2573: --
2574: p_pds_information16:=
2575: hr_transaction_api.get_varchar2_value
2576: (p_transaction_step_id => p_transaction_step_id
2577: ,p_name => 'P_PDS_INFORMATION16');
2578: --
2579: p_pds_information17:=

Line 2580: hr_transaction_api.get_varchar2_value

2576: (p_transaction_step_id => p_transaction_step_id
2577: ,p_name => 'P_PDS_INFORMATION16');
2578: --
2579: p_pds_information17:=
2580: hr_transaction_api.get_varchar2_value
2581: (p_transaction_step_id => p_transaction_step_id
2582: ,p_name => 'P_PDS_INFORMATION17');
2583: --
2584: p_pds_information18:=

Line 2585: hr_transaction_api.get_varchar2_value

2581: (p_transaction_step_id => p_transaction_step_id
2582: ,p_name => 'P_PDS_INFORMATION17');
2583: --
2584: p_pds_information18:=
2585: hr_transaction_api.get_varchar2_value
2586: (p_transaction_step_id => p_transaction_step_id
2587: ,p_name => 'P_PDS_INFORMATION18');
2588: --
2589: p_pds_information19:=

Line 2590: hr_transaction_api.get_varchar2_value

2586: (p_transaction_step_id => p_transaction_step_id
2587: ,p_name => 'P_PDS_INFORMATION18');
2588: --
2589: p_pds_information19:=
2590: hr_transaction_api.get_varchar2_value
2591: (p_transaction_step_id => p_transaction_step_id
2592: ,p_name => 'P_PDS_INFORMATION19');
2593: --
2594: p_pds_information20:=

Line 2595: hr_transaction_api.get_varchar2_value

2591: (p_transaction_step_id => p_transaction_step_id
2592: ,p_name => 'P_PDS_INFORMATION19');
2593: --
2594: p_pds_information20:=
2595: hr_transaction_api.get_varchar2_value
2596: (p_transaction_step_id => p_transaction_step_id
2597: ,p_name => 'P_PDS_INFORMATION20');
2598: --
2599: p_pds_information21:=

Line 2600: hr_transaction_api.get_varchar2_value

2596: (p_transaction_step_id => p_transaction_step_id
2597: ,p_name => 'P_PDS_INFORMATION20');
2598: --
2599: p_pds_information21:=
2600: hr_transaction_api.get_varchar2_value
2601: (p_transaction_step_id => p_transaction_step_id
2602: ,p_name => 'P_PDS_INFORMATION21');
2603: --
2604: p_pds_information22:=

Line 2605: hr_transaction_api.get_varchar2_value

2601: (p_transaction_step_id => p_transaction_step_id
2602: ,p_name => 'P_PDS_INFORMATION21');
2603: --
2604: p_pds_information22:=
2605: hr_transaction_api.get_varchar2_value
2606: (p_transaction_step_id => p_transaction_step_id
2607: ,p_name => 'P_PDS_INFORMATION22');
2608: --
2609: p_pds_information23:=

Line 2610: hr_transaction_api.get_varchar2_value

2606: (p_transaction_step_id => p_transaction_step_id
2607: ,p_name => 'P_PDS_INFORMATION22');
2608: --
2609: p_pds_information23:=
2610: hr_transaction_api.get_varchar2_value
2611: (p_transaction_step_id => p_transaction_step_id
2612: ,p_name => 'P_PDS_INFORMATION23');
2613: --
2614: p_pds_information24:=

Line 2615: hr_transaction_api.get_varchar2_value

2611: (p_transaction_step_id => p_transaction_step_id
2612: ,p_name => 'P_PDS_INFORMATION23');
2613: --
2614: p_pds_information24:=
2615: hr_transaction_api.get_varchar2_value
2616: (p_transaction_step_id => p_transaction_step_id
2617: ,p_name => 'P_PDS_INFORMATION24');
2618: --
2619: p_pds_information25:=

Line 2620: hr_transaction_api.get_varchar2_value

2616: (p_transaction_step_id => p_transaction_step_id
2617: ,p_name => 'P_PDS_INFORMATION24');
2618: --
2619: p_pds_information25:=
2620: hr_transaction_api.get_varchar2_value
2621: (p_transaction_step_id => p_transaction_step_id
2622: ,p_name => 'P_PDS_INFORMATION25');
2623: --
2624: p_pds_information26:=

Line 2625: hr_transaction_api.get_varchar2_value

2621: (p_transaction_step_id => p_transaction_step_id
2622: ,p_name => 'P_PDS_INFORMATION25');
2623: --
2624: p_pds_information26:=
2625: hr_transaction_api.get_varchar2_value
2626: (p_transaction_step_id => p_transaction_step_id
2627: ,p_name => 'P_PDS_INFORMATION26');
2628: --
2629: p_pds_information27:=

Line 2630: hr_transaction_api.get_varchar2_value

2626: (p_transaction_step_id => p_transaction_step_id
2627: ,p_name => 'P_PDS_INFORMATION26');
2628: --
2629: p_pds_information27:=
2630: hr_transaction_api.get_varchar2_value
2631: (p_transaction_step_id => p_transaction_step_id
2632: ,p_name => 'P_PDS_INFORMATION27');
2633: --
2634: p_pds_information28:=

Line 2635: hr_transaction_api.get_varchar2_value

2631: (p_transaction_step_id => p_transaction_step_id
2632: ,p_name => 'P_PDS_INFORMATION27');
2633: --
2634: p_pds_information28:=
2635: hr_transaction_api.get_varchar2_value
2636: (p_transaction_step_id => p_transaction_step_id
2637: ,p_name => 'P_PDS_INFORMATION28');
2638: --
2639: p_pds_information29:=

Line 2640: hr_transaction_api.get_varchar2_value

2636: (p_transaction_step_id => p_transaction_step_id
2637: ,p_name => 'P_PDS_INFORMATION28');
2638: --
2639: p_pds_information29:=
2640: hr_transaction_api.get_varchar2_value
2641: (p_transaction_step_id => p_transaction_step_id
2642: ,p_name => 'P_PDS_INFORMATION29');
2643: --
2644: p_pds_information30:=

Line 2645: hr_transaction_api.get_varchar2_value

2641: (p_transaction_step_id => p_transaction_step_id
2642: ,p_name => 'P_PDS_INFORMATION29');
2643: --
2644: p_pds_information30:=
2645: hr_transaction_api.get_varchar2_value
2646: (p_transaction_step_id => p_transaction_step_id
2647: ,p_name => 'P_PDS_INFORMATION30');
2648: --
2649: hr_utility.set_location('Leaving: '|| l_proc,10);