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 1704: hr_transaction_api.get_transaction_step_info (

1700: -- Retieve the transaction step for this current
1701: -- activity. We will update this transaction step with
1702: -- the new information.
1703: ---------------------------------------------------------------------
1704: hr_transaction_api.get_transaction_step_info (
1705: p_Item_Type => p_item_type,
1706: p_Item_Key => p_item_key,
1707: p_activity_id => to_number(p_actid),
1708: p_transaction_step_id => ltt_trans_step_ids,

Line 1720: hr_transaction_api.create_transaction_step (

1716: --------------------------------------------------------------------
1717: -- There is no transaction step for this transaction.
1718: -- Create a step within this new transaction
1719: --------------------------------------------------------------------
1720: hr_transaction_api.create_transaction_step (
1721: p_validate => false,
1722: p_creator_person_id => p_login_person_id,
1723: p_transaction_id => ln_transaction_id,
1724: p_api_name => g_package || '.PROCESS_API',

Line 1774: l_term_date := hr_transaction_api.get_date_value(ln_transaction_step_id, 'P_ACTUAL_TERMINATION_DATE');

1770: end if;
1771:
1772: if (isQKFn = 'Y' and isSupAsgPGExists = 'Y' ) then
1773:
1774: l_term_date := hr_transaction_api.get_date_value(ln_transaction_step_id, 'P_ACTUAL_TERMINATION_DATE');
1775:
1776: l_old_sup_person_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_PER_ID', true);
1777: l_old_sup_asg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_ASG_ID', true);
1778: l_old_sup_bg_id := wf_engine.getItemAttrText(p_item_type, p_item_key, 'QK_TERM_OLD_SUP_BG_ID', true);

Line 1944: hr_transaction_api.get_number_value (

1940: -----------------------------------------------------------------------
1941: -- get common data for APIs from transaction table
1942: -----------------------------------------------------------------------
1943: ln_period_of_service_id :=
1944: hr_transaction_api.get_number_value (
1945: p_transaction_step_id => p_transaction_step_id,
1946: p_name => 'P_PERIOD_OF_SERVICE_ID'
1947: );
1948:

Line 1950: hr_transaction_api.get_number_value (

1946: p_name => 'P_PERIOD_OF_SERVICE_ID'
1947: );
1948:
1949: ln_object_version_number :=
1950: hr_transaction_api.get_number_value (
1951: p_transaction_step_id => p_transaction_step_id,
1952: p_name => 'P_OBJECT_VERSION_NUMBER'
1953: );
1954:

Line 1991: hr_transaction_api.get_varchar2_value (

1987: p_transaction_step_id => p_transaction_step_id
1988: );
1989:
1990: lv_attribute_category :=
1991: hr_transaction_api.get_varchar2_value (
1992: p_transaction_step_id => p_transaction_step_id,
1993: p_name => 'P_ATTRIBUTE_CATEGORY'
1994: );
1995:

Line 1998: hr_transaction_api.get_varchar2_value (

1994: );
1995:
1996: -- DDF Enhancement : Get PDS_INFORMATION_CATEGORY
1997: lv_pds_information_category :=
1998: hr_transaction_api.get_varchar2_value (
1999: p_transaction_step_id => p_transaction_step_id,
2000: p_name => 'P_PDS_INFORMATION_CATEGORY'
2001: );
2002:

Line 2178: hr_transaction_api.get_transaction_step_info(

2174: --end of call bug 3843399
2175:
2176: -- Quick Termination changes start from here
2177:
2178: hr_transaction_api.get_transaction_step_info(
2179: p_transaction_step_id
2180: ,ItemType
2181: ,ItemKey
2182: ,ActivityId);

Line 2196: l_term_date := hr_transaction_api.get_date_value(p_transaction_step_id, 'P_ACTUAL_TERMINATION_DATE');

2192: end if;
2193:
2194: if (isQKFn = 'Y' and isSupAsgPGExists = 'Y' ) then
2195:
2196: l_term_date := hr_transaction_api.get_date_value(p_transaction_step_id, 'P_ACTUAL_TERMINATION_DATE');
2197:
2198: l_old_sup_person_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_PER_ID', true);
2199: l_old_sup_asg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_ASG_ID', true);
2200: l_old_sup_bg_id := wf_engine.getItemAttrText(ItemType, ItemKey, 'QK_TERM_OLD_SUP_BG_ID', true);

Line 2272: hr_transaction_api.get_date_value (

2268: l_proc constant varchar2(100) := g_package || ' get_termination_details';
2269: BEGIN
2270: hr_utility.set_location('Entering: '|| l_proc,5);
2271: lrt_termination.notified_termination_date :=
2272: hr_transaction_api.get_date_value (
2273: p_transaction_step_id => p_transaction_step_id,
2274: p_name => 'P_NOTIFIED_TERMINATION_DATE'
2275: );
2276:

Line 2278: hr_transaction_api.get_date_value (

2274: p_name => 'P_NOTIFIED_TERMINATION_DATE'
2275: );
2276:
2277: lrt_termination.last_standard_process_date :=
2278: hr_transaction_api.get_date_value (
2279: p_transaction_step_id => p_transaction_step_id,
2280: p_name => 'P_LAST_STANDARD_PROCESS_DATE'
2281: );
2282:

Line 2284: hr_transaction_api.get_date_value (

2280: p_name => 'P_LAST_STANDARD_PROCESS_DATE'
2281: );
2282:
2283: lrt_termination.projected_termination_date :=
2284: hr_transaction_api.get_date_value (
2285: p_transaction_step_id => p_transaction_step_id,
2286: p_name => 'P_PROJECTED_TERMINATION_DATE'
2287: );
2288:

Line 2290: hr_transaction_api.get_date_value (

2286: p_name => 'P_PROJECTED_TERMINATION_DATE'
2287: );
2288:
2289: lrt_termination.final_process_date :=
2290: hr_transaction_api.get_date_value (
2291: p_transaction_step_id => p_transaction_step_id,
2292: p_name => 'P_FINAL_PROCESS_DATE'
2293: );
2294:

Line 2296: hr_transaction_api.get_date_value (

2292: p_name => 'P_FINAL_PROCESS_DATE'
2293: );
2294:
2295: lrt_termination.actual_termination_date :=
2296: hr_transaction_api.get_date_value (
2297: p_transaction_step_id => p_transaction_step_id,
2298: p_name => 'P_ACTUAL_TERMINATION_DATE'
2299: );
2300:

Line 2302: hr_transaction_api.get_varchar2_value (

2298: p_name => 'P_ACTUAL_TERMINATION_DATE'
2299: );
2300:
2301: lrt_termination.leaving_reason :=
2302: hr_transaction_api.get_varchar2_value (
2303: p_transaction_step_id => p_transaction_step_id,
2304: p_name => 'P_LEAVING_REASON'
2305: );
2306:

Line 2308: hr_transaction_api.get_number_value (

2304: p_name => 'P_LEAVING_REASON'
2305: );
2306:
2307: lrt_termination.person_type_id :=
2308: hr_transaction_api.get_number_value (
2309: p_transaction_step_id => p_transaction_step_id,
2310: p_name => 'P_PERSON_TYPE_ID'
2311: );
2312:

Line 2314: hr_transaction_api.get_number_value (

2310: p_name => 'P_PERSON_TYPE_ID'
2311: );
2312:
2313: lrt_termination.assignment_status_type_id :=
2314: hr_transaction_api.get_number_value (
2315: p_transaction_step_id => p_transaction_step_id,
2316: p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID'
2317: );
2318:

Line 2320: hr_transaction_api.get_varchar2_value (

2316: p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID'
2317: );
2318:
2319: lrt_termination.comments :=
2320: hr_transaction_api.get_varchar2_value (
2321: p_transaction_step_id => p_transaction_step_id,
2322: p_name => 'P_COMMENTS'
2323: );
2324:

Line 2326: hr_transaction_api.get_number_value (

2322: p_name => 'P_COMMENTS'
2323: );
2324:
2325: lrt_termination.period_of_service_id :=
2326: hr_transaction_api.get_number_value (
2327: p_transaction_step_id => p_transaction_step_id,
2328: p_name => 'P_PERIOD_OF_SERVICE_ID'
2329: );
2330:

Line 2332: hr_transaction_api.get_number_value (

2328: p_name => 'P_PERIOD_OF_SERVICE_ID'
2329: );
2330:
2331: lrt_termination.object_version_number :=
2332: hr_transaction_api.get_number_value (
2333: p_transaction_step_id => p_transaction_step_id,
2334: p_name => 'P_OBJECT_VERSION_NUMBER'
2335: );
2336:

Line 2338: hr_transaction_api.get_varchar2_value (

2334: p_name => 'P_OBJECT_VERSION_NUMBER'
2335: );
2336:
2337: lrt_termination.rehire_recommendation :=
2338: hr_transaction_api.get_varchar2_value (
2339: p_transaction_step_id => p_transaction_step_id,
2340: p_name => 'P_REHIRE_RECOMMENDATION'
2341: );
2342:

Line 2344: hr_transaction_api.get_varchar2_value (

2340: p_name => 'P_REHIRE_RECOMMENDATION'
2341: );
2342:
2343: lrt_termination.rehire_reason :=
2344: hr_transaction_api.get_varchar2_value (
2345: p_transaction_step_id => p_transaction_step_id,
2346: p_name => 'P_REHIRE_REASON'
2347: );
2348: hr_utility.set_location('Leaving: '|| l_proc,10);

Line 2380: hr_transaction_api.get_varchar2_value (

2376: lt_term_flex(ln_counter) := NULL;
2377: END LOOP;
2378: FOR ln_counter IN 1..20 LOOP
2379: lt_term_flex(ln_counter) :=
2380: hr_transaction_api.get_varchar2_value (
2381: p_transaction_step_id => p_transaction_step_id,
2382: p_name => 'P_ATTRIBUTE' || to_char(ln_counter)
2383: );
2384: END LOOP;

Line 2394: hr_transaction_api.get_varchar2_value (

2390: lt_term_flex(ln_counter) := NULL;
2391: END LOOP;
2392: FOR ln_counter IN 21..50 LOOP
2393: lt_term_flex(ln_counter) :=
2394: hr_transaction_api.get_varchar2_value (
2395: p_transaction_step_id => p_transaction_step_id,
2396: p_name => 'P_PDS_INFORMATION' ||
2397: to_char(ln_counter - 20)
2398: );

Line 2513: hr_transaction_api.get_number_value

2509: BEGIN
2510: hr_utility.set_location('Entering: '|| l_proc,5);
2511: --
2512: p_period_of_service_id:=
2513: hr_transaction_api.get_number_value
2514: (p_transaction_step_id => p_transaction_step_id
2515: ,p_name => 'P_PERIOD_OF_SERVICE_ID');
2516: --
2517: p_object_version_number:=

Line 2518: hr_transaction_api.get_number_value

2514: (p_transaction_step_id => p_transaction_step_id
2515: ,p_name => 'P_PERIOD_OF_SERVICE_ID');
2516: --
2517: p_object_version_number:=
2518: hr_transaction_api.get_number_value
2519: (p_transaction_step_id => p_transaction_step_id
2520: ,p_name => 'P_OBJECT_VERSION_NUMBER');
2521: --
2522: -- Bug 2086516 Fix Begins - 11/15/2001

Line 2536: hr_transaction_api.get_date_value

2532: --
2533: -- Bug 2086516 Fix Ends - 11/15/2001
2534: --
2535: p_notified_termination_date:= to_char(
2536: hr_transaction_api.get_date_value
2537: (p_transaction_step_id => p_transaction_step_id
2538: ,p_name => 'P_NOTIFIED_TERMINATION_DATE')
2539: ,g_date_format);
2540: --

Line 2542: hr_transaction_api.get_date_value

2538: ,p_name => 'P_NOTIFIED_TERMINATION_DATE')
2539: ,g_date_format);
2540: --
2541: p_last_standard_process_date := to_char(
2542: hr_transaction_api.get_date_value
2543: (p_transaction_step_id => p_transaction_step_id
2544: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE')
2545: ,g_date_format);
2546: --

Line 2548: hr_transaction_api.get_date_value

2544: ,p_name => 'P_LAST_STANDARD_PROCESS_DATE')
2545: ,g_date_format);
2546: --
2547: p_projected_termination_date := to_char(
2548: hr_transaction_api.get_date_value
2549: (p_transaction_step_id => p_transaction_step_id
2550: ,p_name => 'P_PROJECTED_TERMINATION_DATE')
2551: ,g_date_format);
2552: --

Line 2554: hr_transaction_api.get_date_value

2550: ,p_name => 'P_PROJECTED_TERMINATION_DATE')
2551: ,g_date_format);
2552: --
2553: p_final_process_date := to_char(
2554: hr_transaction_api.get_date_value
2555: (p_transaction_step_id => p_transaction_step_id
2556: ,p_name => 'P_FINAL_PROCESS_DATE')
2557: ,g_date_format);
2558: --

Line 2560: hr_transaction_api.get_varchar2_value

2556: ,p_name => 'P_FINAL_PROCESS_DATE')
2557: ,g_date_format);
2558: --
2559: p_leaving_reason:=
2560: hr_transaction_api.get_varchar2_value
2561: (p_transaction_step_id => p_transaction_step_id
2562: ,p_name => 'P_LEAVING_REASON');
2563: --
2564: p_person_type_id:=

Line 2565: hr_transaction_api.get_number_value

2561: (p_transaction_step_id => p_transaction_step_id
2562: ,p_name => 'P_LEAVING_REASON');
2563: --
2564: p_person_type_id:=
2565: hr_transaction_api.get_number_value
2566: (p_transaction_step_id => p_transaction_step_id
2567: ,p_name => 'P_PERSON_TYPE_ID');
2568: --
2569: p_assignment_status_type_id:=

Line 2570: hr_transaction_api.get_number_value

2566: (p_transaction_step_id => p_transaction_step_id
2567: ,p_name => 'P_PERSON_TYPE_ID');
2568: --
2569: p_assignment_status_type_id:=
2570: hr_transaction_api.get_number_value
2571: (p_transaction_step_id => p_transaction_step_id
2572: ,p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID');
2573: --
2574: p_comments:=

Line 2575: hr_transaction_api.get_varchar2_value

2571: (p_transaction_step_id => p_transaction_step_id
2572: ,p_name => 'P_ASSIGNMENT_STATUS_TYPE_ID');
2573: --
2574: p_comments:=
2575: hr_transaction_api.get_varchar2_value
2576: (p_transaction_step_id => p_transaction_step_id
2577: ,p_name => 'P_COMMENTS');
2578: --
2579: p_rehire_recommendation:=

Line 2580: hr_transaction_api.get_varchar2_value

2576: (p_transaction_step_id => p_transaction_step_id
2577: ,p_name => 'P_COMMENTS');
2578: --
2579: p_rehire_recommendation:=
2580: hr_transaction_api.get_varchar2_value
2581: (p_transaction_step_id => p_transaction_step_id
2582: ,p_name => 'P_REHIRE_RECOMMENDATION');
2583: --
2584: p_rehire_reason:=

Line 2585: hr_transaction_api.get_varchar2_value

2581: (p_transaction_step_id => p_transaction_step_id
2582: ,p_name => 'P_REHIRE_RECOMMENDATION');
2583: --
2584: p_rehire_reason:=
2585: hr_transaction_api.get_varchar2_value
2586: (p_transaction_step_id => p_transaction_step_id
2587: ,p_name => 'P_REHIRE_REASON');
2588:
2589: --

Line 2591: hr_transaction_api.get_varchar2_value

2587: ,p_name => 'P_REHIRE_REASON');
2588:
2589: --
2590: p_attribute_category:=
2591: hr_transaction_api.get_varchar2_value
2592: (p_transaction_step_id => p_transaction_step_id
2593: ,p_name => 'P_ATTRIBUTE_CATEGORY');
2594: --
2595: p_attribute1:=

Line 2596: hr_transaction_api.get_varchar2_value

2592: (p_transaction_step_id => p_transaction_step_id
2593: ,p_name => 'P_ATTRIBUTE_CATEGORY');
2594: --
2595: p_attribute1:=
2596: hr_transaction_api.get_varchar2_value
2597: (p_transaction_step_id => p_transaction_step_id
2598: ,p_name => 'P_ATTRIBUTE1');
2599: --
2600: p_attribute2:=

Line 2601: hr_transaction_api.get_varchar2_value

2597: (p_transaction_step_id => p_transaction_step_id
2598: ,p_name => 'P_ATTRIBUTE1');
2599: --
2600: p_attribute2:=
2601: hr_transaction_api.get_varchar2_value
2602: (p_transaction_step_id => p_transaction_step_id
2603: ,p_name => 'P_ATTRIBUTE2');
2604: --
2605: p_attribute3:=

Line 2606: hr_transaction_api.get_varchar2_value

2602: (p_transaction_step_id => p_transaction_step_id
2603: ,p_name => 'P_ATTRIBUTE2');
2604: --
2605: p_attribute3:=
2606: hr_transaction_api.get_varchar2_value
2607: (p_transaction_step_id => p_transaction_step_id
2608: ,p_name => 'P_ATTRIBUTE3');
2609: --
2610: p_attribute4:=

Line 2611: hr_transaction_api.get_varchar2_value

2607: (p_transaction_step_id => p_transaction_step_id
2608: ,p_name => 'P_ATTRIBUTE3');
2609: --
2610: p_attribute4:=
2611: hr_transaction_api.get_varchar2_value
2612: (p_transaction_step_id => p_transaction_step_id
2613: ,p_name => 'P_ATTRIBUTE4');
2614: --
2615: p_attribute5:=

Line 2616: hr_transaction_api.get_varchar2_value

2612: (p_transaction_step_id => p_transaction_step_id
2613: ,p_name => 'P_ATTRIBUTE4');
2614: --
2615: p_attribute5:=
2616: hr_transaction_api.get_varchar2_value
2617: (p_transaction_step_id => p_transaction_step_id
2618: ,p_name => 'P_ATTRIBUTE5');
2619: --
2620: p_attribute6:=

Line 2621: hr_transaction_api.get_varchar2_value

2617: (p_transaction_step_id => p_transaction_step_id
2618: ,p_name => 'P_ATTRIBUTE5');
2619: --
2620: p_attribute6:=
2621: hr_transaction_api.get_varchar2_value
2622: (p_transaction_step_id => p_transaction_step_id
2623: ,p_name => 'P_ATTRIBUTE6');
2624: --
2625: p_attribute7:=

Line 2626: hr_transaction_api.get_varchar2_value

2622: (p_transaction_step_id => p_transaction_step_id
2623: ,p_name => 'P_ATTRIBUTE6');
2624: --
2625: p_attribute7:=
2626: hr_transaction_api.get_varchar2_value
2627: (p_transaction_step_id => p_transaction_step_id
2628: ,p_name => 'P_ATTRIBUTE7');
2629: --
2630: p_attribute8:=

Line 2631: hr_transaction_api.get_varchar2_value

2627: (p_transaction_step_id => p_transaction_step_id
2628: ,p_name => 'P_ATTRIBUTE7');
2629: --
2630: p_attribute8:=
2631: hr_transaction_api.get_varchar2_value
2632: (p_transaction_step_id => p_transaction_step_id
2633: ,p_name => 'P_ATTRIBUTE8');
2634: --
2635: p_attribute9:=

Line 2636: hr_transaction_api.get_varchar2_value

2632: (p_transaction_step_id => p_transaction_step_id
2633: ,p_name => 'P_ATTRIBUTE8');
2634: --
2635: p_attribute9:=
2636: hr_transaction_api.get_varchar2_value
2637: (p_transaction_step_id => p_transaction_step_id
2638: ,p_name => 'P_ATTRIBUTE9');
2639: --
2640: p_attribute10:=

Line 2641: hr_transaction_api.get_varchar2_value

2637: (p_transaction_step_id => p_transaction_step_id
2638: ,p_name => 'P_ATTRIBUTE9');
2639: --
2640: p_attribute10:=
2641: hr_transaction_api.get_varchar2_value
2642: (p_transaction_step_id => p_transaction_step_id
2643: ,p_name => 'P_ATTRIBUTE10');
2644: --
2645: p_attribute11:=

Line 2646: hr_transaction_api.get_varchar2_value

2642: (p_transaction_step_id => p_transaction_step_id
2643: ,p_name => 'P_ATTRIBUTE10');
2644: --
2645: p_attribute11:=
2646: hr_transaction_api.get_varchar2_value
2647: (p_transaction_step_id => p_transaction_step_id
2648: ,p_name => 'P_ATTRIBUTE11');
2649: --
2650: p_attribute12:=

Line 2651: hr_transaction_api.get_varchar2_value

2647: (p_transaction_step_id => p_transaction_step_id
2648: ,p_name => 'P_ATTRIBUTE11');
2649: --
2650: p_attribute12:=
2651: hr_transaction_api.get_varchar2_value
2652: (p_transaction_step_id => p_transaction_step_id
2653: ,p_name => 'P_ATTRIBUTE12');
2654: --
2655: p_attribute13:=

Line 2656: hr_transaction_api.get_varchar2_value

2652: (p_transaction_step_id => p_transaction_step_id
2653: ,p_name => 'P_ATTRIBUTE12');
2654: --
2655: p_attribute13:=
2656: hr_transaction_api.get_varchar2_value
2657: (p_transaction_step_id => p_transaction_step_id
2658: ,p_name => 'P_ATTRIBUTE13');
2659: --
2660: p_attribute14:=

Line 2661: hr_transaction_api.get_varchar2_value

2657: (p_transaction_step_id => p_transaction_step_id
2658: ,p_name => 'P_ATTRIBUTE13');
2659: --
2660: p_attribute14:=
2661: hr_transaction_api.get_varchar2_value
2662: (p_transaction_step_id => p_transaction_step_id
2663: ,p_name => 'P_ATTRIBUTE14');
2664: --
2665: p_attribute15:=

Line 2666: hr_transaction_api.get_varchar2_value

2662: (p_transaction_step_id => p_transaction_step_id
2663: ,p_name => 'P_ATTRIBUTE14');
2664: --
2665: p_attribute15:=
2666: hr_transaction_api.get_varchar2_value
2667: (p_transaction_step_id => p_transaction_step_id
2668: ,p_name => 'P_ATTRIBUTE15');
2669: --
2670: p_attribute16:=

Line 2671: hr_transaction_api.get_varchar2_value

2667: (p_transaction_step_id => p_transaction_step_id
2668: ,p_name => 'P_ATTRIBUTE15');
2669: --
2670: p_attribute16:=
2671: hr_transaction_api.get_varchar2_value
2672: (p_transaction_step_id => p_transaction_step_id
2673: ,p_name => 'P_ATTRIBUTE16');
2674: --
2675: p_attribute17:=

Line 2676: hr_transaction_api.get_varchar2_value

2672: (p_transaction_step_id => p_transaction_step_id
2673: ,p_name => 'P_ATTRIBUTE16');
2674: --
2675: p_attribute17:=
2676: hr_transaction_api.get_varchar2_value
2677: (p_transaction_step_id => p_transaction_step_id
2678: ,p_name => 'P_ATTRIBUTE17');
2679: --
2680: p_attribute18:=

Line 2681: hr_transaction_api.get_varchar2_value

2677: (p_transaction_step_id => p_transaction_step_id
2678: ,p_name => 'P_ATTRIBUTE17');
2679: --
2680: p_attribute18:=
2681: hr_transaction_api.get_varchar2_value
2682: (p_transaction_step_id => p_transaction_step_id
2683: ,p_name => 'P_ATTRIBUTE18');
2684: --
2685: p_attribute19:=

Line 2686: hr_transaction_api.get_varchar2_value

2682: (p_transaction_step_id => p_transaction_step_id
2683: ,p_name => 'P_ATTRIBUTE18');
2684: --
2685: p_attribute19:=
2686: hr_transaction_api.get_varchar2_value
2687: (p_transaction_step_id => p_transaction_step_id
2688: ,p_name => 'P_ATTRIBUTE19');
2689: --
2690: p_attribute20:=

Line 2691: hr_transaction_api.get_varchar2_value

2687: (p_transaction_step_id => p_transaction_step_id
2688: ,p_name => 'P_ATTRIBUTE19');
2689: --
2690: p_attribute20:=
2691: hr_transaction_api.get_varchar2_value
2692: (p_transaction_step_id => p_transaction_step_id
2693: ,p_name => 'P_ATTRIBUTE20');
2694: --
2695: p_review_actid:=

Line 2696: hr_transaction_api.get_varchar2_value

2692: (p_transaction_step_id => p_transaction_step_id
2693: ,p_name => 'P_ATTRIBUTE20');
2694: --
2695: p_review_actid:=
2696: hr_transaction_api.get_varchar2_value
2697: (p_transaction_step_id => p_transaction_step_id
2698: ,p_name => 'P_REVIEW_ACTID');
2699: --
2700: p_review_proc_call:=

Line 2701: hr_transaction_api.get_varchar2_value

2697: (p_transaction_step_id => p_transaction_step_id
2698: ,p_name => 'P_REVIEW_ACTID');
2699: --
2700: p_review_proc_call:=
2701: hr_transaction_api.get_varchar2_value
2702: (p_transaction_step_id => p_transaction_step_id
2703: ,p_name => 'P_REVIEW_PROC_CALL');
2704:
2705: -- DDF Enhancement : Retrieve from Transaction table.

Line 2708: hr_transaction_api.get_varchar2_value

2704:
2705: -- DDF Enhancement : Retrieve from Transaction table.
2706: --
2707: p_pds_information_category:=
2708: hr_transaction_api.get_varchar2_value
2709: (p_transaction_step_id => p_transaction_step_id
2710: ,p_name => 'P_PDS_INFORMATION_CATEGORY');
2711: --
2712: p_pds_information1:=

Line 2713: hr_transaction_api.get_varchar2_value

2709: (p_transaction_step_id => p_transaction_step_id
2710: ,p_name => 'P_PDS_INFORMATION_CATEGORY');
2711: --
2712: p_pds_information1:=
2713: hr_transaction_api.get_varchar2_value
2714: (p_transaction_step_id => p_transaction_step_id
2715: ,p_name => 'P_PDS_INFORMATION1');
2716: --
2717: p_pds_information2:=

Line 2718: hr_transaction_api.get_varchar2_value

2714: (p_transaction_step_id => p_transaction_step_id
2715: ,p_name => 'P_PDS_INFORMATION1');
2716: --
2717: p_pds_information2:=
2718: hr_transaction_api.get_varchar2_value
2719: (p_transaction_step_id => p_transaction_step_id
2720: ,p_name => 'P_PDS_INFORMATION2');
2721: --
2722: p_pds_information3:=

Line 2723: hr_transaction_api.get_varchar2_value

2719: (p_transaction_step_id => p_transaction_step_id
2720: ,p_name => 'P_PDS_INFORMATION2');
2721: --
2722: p_pds_information3:=
2723: hr_transaction_api.get_varchar2_value
2724: (p_transaction_step_id => p_transaction_step_id
2725: ,p_name => 'P_PDS_INFORMATION3');
2726: --
2727: p_pds_information4:=

Line 2728: hr_transaction_api.get_varchar2_value

2724: (p_transaction_step_id => p_transaction_step_id
2725: ,p_name => 'P_PDS_INFORMATION3');
2726: --
2727: p_pds_information4:=
2728: hr_transaction_api.get_varchar2_value
2729: (p_transaction_step_id => p_transaction_step_id
2730: ,p_name => 'P_PDS_INFORMATION4');
2731: --
2732: p_pds_information5:=

Line 2733: hr_transaction_api.get_varchar2_value

2729: (p_transaction_step_id => p_transaction_step_id
2730: ,p_name => 'P_PDS_INFORMATION4');
2731: --
2732: p_pds_information5:=
2733: hr_transaction_api.get_varchar2_value
2734: (p_transaction_step_id => p_transaction_step_id
2735: ,p_name => 'P_PDS_INFORMATION5');
2736: --
2737: p_pds_information6:=

Line 2738: hr_transaction_api.get_varchar2_value

2734: (p_transaction_step_id => p_transaction_step_id
2735: ,p_name => 'P_PDS_INFORMATION5');
2736: --
2737: p_pds_information6:=
2738: hr_transaction_api.get_varchar2_value
2739: (p_transaction_step_id => p_transaction_step_id
2740: ,p_name => 'P_PDS_INFORMATION6');
2741: --
2742: p_pds_information7:=

Line 2743: hr_transaction_api.get_varchar2_value

2739: (p_transaction_step_id => p_transaction_step_id
2740: ,p_name => 'P_PDS_INFORMATION6');
2741: --
2742: p_pds_information7:=
2743: hr_transaction_api.get_varchar2_value
2744: (p_transaction_step_id => p_transaction_step_id
2745: ,p_name => 'P_PDS_INFORMATION7');
2746: --
2747: p_pds_information8:=

Line 2748: hr_transaction_api.get_varchar2_value

2744: (p_transaction_step_id => p_transaction_step_id
2745: ,p_name => 'P_PDS_INFORMATION7');
2746: --
2747: p_pds_information8:=
2748: hr_transaction_api.get_varchar2_value
2749: (p_transaction_step_id => p_transaction_step_id
2750: ,p_name => 'P_PDS_INFORMATION8');
2751: --
2752: p_pds_information9:=

Line 2753: hr_transaction_api.get_varchar2_value

2749: (p_transaction_step_id => p_transaction_step_id
2750: ,p_name => 'P_PDS_INFORMATION8');
2751: --
2752: p_pds_information9:=
2753: hr_transaction_api.get_varchar2_value
2754: (p_transaction_step_id => p_transaction_step_id
2755: ,p_name => 'P_PDS_INFORMATION9');
2756: --
2757: p_pds_information10:=

Line 2758: hr_transaction_api.get_varchar2_value

2754: (p_transaction_step_id => p_transaction_step_id
2755: ,p_name => 'P_PDS_INFORMATION9');
2756: --
2757: p_pds_information10:=
2758: hr_transaction_api.get_varchar2_value
2759: (p_transaction_step_id => p_transaction_step_id
2760: ,p_name => 'P_PDS_INFORMATION10');
2761: --
2762: p_pds_information11:=

Line 2763: hr_transaction_api.get_varchar2_value

2759: (p_transaction_step_id => p_transaction_step_id
2760: ,p_name => 'P_PDS_INFORMATION10');
2761: --
2762: p_pds_information11:=
2763: hr_transaction_api.get_varchar2_value
2764: (p_transaction_step_id => p_transaction_step_id
2765: ,p_name => 'P_PDS_INFORMATION11');
2766: --
2767: p_pds_information12:=

Line 2768: hr_transaction_api.get_varchar2_value

2764: (p_transaction_step_id => p_transaction_step_id
2765: ,p_name => 'P_PDS_INFORMATION11');
2766: --
2767: p_pds_information12:=
2768: hr_transaction_api.get_varchar2_value
2769: (p_transaction_step_id => p_transaction_step_id
2770: ,p_name => 'P_PDS_INFORMATION12');
2771: --
2772: p_pds_information13:=

Line 2773: hr_transaction_api.get_varchar2_value

2769: (p_transaction_step_id => p_transaction_step_id
2770: ,p_name => 'P_PDS_INFORMATION12');
2771: --
2772: p_pds_information13:=
2773: hr_transaction_api.get_varchar2_value
2774: (p_transaction_step_id => p_transaction_step_id
2775: ,p_name => 'P_PDS_INFORMATION13');
2776: --
2777: p_pds_information14:=

Line 2778: hr_transaction_api.get_varchar2_value

2774: (p_transaction_step_id => p_transaction_step_id
2775: ,p_name => 'P_PDS_INFORMATION13');
2776: --
2777: p_pds_information14:=
2778: hr_transaction_api.get_varchar2_value
2779: (p_transaction_step_id => p_transaction_step_id
2780: ,p_name => 'P_PDS_INFORMATION14');
2781: --
2782: p_pds_information15:=

Line 2783: hr_transaction_api.get_varchar2_value

2779: (p_transaction_step_id => p_transaction_step_id
2780: ,p_name => 'P_PDS_INFORMATION14');
2781: --
2782: p_pds_information15:=
2783: hr_transaction_api.get_varchar2_value
2784: (p_transaction_step_id => p_transaction_step_id
2785: ,p_name => 'P_PDS_INFORMATION15');
2786: --
2787: p_pds_information16:=

Line 2788: hr_transaction_api.get_varchar2_value

2784: (p_transaction_step_id => p_transaction_step_id
2785: ,p_name => 'P_PDS_INFORMATION15');
2786: --
2787: p_pds_information16:=
2788: hr_transaction_api.get_varchar2_value
2789: (p_transaction_step_id => p_transaction_step_id
2790: ,p_name => 'P_PDS_INFORMATION16');
2791: --
2792: p_pds_information17:=

Line 2793: hr_transaction_api.get_varchar2_value

2789: (p_transaction_step_id => p_transaction_step_id
2790: ,p_name => 'P_PDS_INFORMATION16');
2791: --
2792: p_pds_information17:=
2793: hr_transaction_api.get_varchar2_value
2794: (p_transaction_step_id => p_transaction_step_id
2795: ,p_name => 'P_PDS_INFORMATION17');
2796: --
2797: p_pds_information18:=

Line 2798: hr_transaction_api.get_varchar2_value

2794: (p_transaction_step_id => p_transaction_step_id
2795: ,p_name => 'P_PDS_INFORMATION17');
2796: --
2797: p_pds_information18:=
2798: hr_transaction_api.get_varchar2_value
2799: (p_transaction_step_id => p_transaction_step_id
2800: ,p_name => 'P_PDS_INFORMATION18');
2801: --
2802: p_pds_information19:=

Line 2803: hr_transaction_api.get_varchar2_value

2799: (p_transaction_step_id => p_transaction_step_id
2800: ,p_name => 'P_PDS_INFORMATION18');
2801: --
2802: p_pds_information19:=
2803: hr_transaction_api.get_varchar2_value
2804: (p_transaction_step_id => p_transaction_step_id
2805: ,p_name => 'P_PDS_INFORMATION19');
2806: --
2807: p_pds_information20:=

Line 2808: hr_transaction_api.get_varchar2_value

2804: (p_transaction_step_id => p_transaction_step_id
2805: ,p_name => 'P_PDS_INFORMATION19');
2806: --
2807: p_pds_information20:=
2808: hr_transaction_api.get_varchar2_value
2809: (p_transaction_step_id => p_transaction_step_id
2810: ,p_name => 'P_PDS_INFORMATION20');
2811: --
2812: p_pds_information21:=

Line 2813: hr_transaction_api.get_varchar2_value

2809: (p_transaction_step_id => p_transaction_step_id
2810: ,p_name => 'P_PDS_INFORMATION20');
2811: --
2812: p_pds_information21:=
2813: hr_transaction_api.get_varchar2_value
2814: (p_transaction_step_id => p_transaction_step_id
2815: ,p_name => 'P_PDS_INFORMATION21');
2816: --
2817: p_pds_information22:=

Line 2818: hr_transaction_api.get_varchar2_value

2814: (p_transaction_step_id => p_transaction_step_id
2815: ,p_name => 'P_PDS_INFORMATION21');
2816: --
2817: p_pds_information22:=
2818: hr_transaction_api.get_varchar2_value
2819: (p_transaction_step_id => p_transaction_step_id
2820: ,p_name => 'P_PDS_INFORMATION22');
2821: --
2822: p_pds_information23:=

Line 2823: hr_transaction_api.get_varchar2_value

2819: (p_transaction_step_id => p_transaction_step_id
2820: ,p_name => 'P_PDS_INFORMATION22');
2821: --
2822: p_pds_information23:=
2823: hr_transaction_api.get_varchar2_value
2824: (p_transaction_step_id => p_transaction_step_id
2825: ,p_name => 'P_PDS_INFORMATION23');
2826: --
2827: p_pds_information24:=

Line 2828: hr_transaction_api.get_varchar2_value

2824: (p_transaction_step_id => p_transaction_step_id
2825: ,p_name => 'P_PDS_INFORMATION23');
2826: --
2827: p_pds_information24:=
2828: hr_transaction_api.get_varchar2_value
2829: (p_transaction_step_id => p_transaction_step_id
2830: ,p_name => 'P_PDS_INFORMATION24');
2831: --
2832: p_pds_information25:=

Line 2833: hr_transaction_api.get_varchar2_value

2829: (p_transaction_step_id => p_transaction_step_id
2830: ,p_name => 'P_PDS_INFORMATION24');
2831: --
2832: p_pds_information25:=
2833: hr_transaction_api.get_varchar2_value
2834: (p_transaction_step_id => p_transaction_step_id
2835: ,p_name => 'P_PDS_INFORMATION25');
2836: --
2837: p_pds_information26:=

Line 2838: hr_transaction_api.get_varchar2_value

2834: (p_transaction_step_id => p_transaction_step_id
2835: ,p_name => 'P_PDS_INFORMATION25');
2836: --
2837: p_pds_information26:=
2838: hr_transaction_api.get_varchar2_value
2839: (p_transaction_step_id => p_transaction_step_id
2840: ,p_name => 'P_PDS_INFORMATION26');
2841: --
2842: p_pds_information27:=

Line 2843: hr_transaction_api.get_varchar2_value

2839: (p_transaction_step_id => p_transaction_step_id
2840: ,p_name => 'P_PDS_INFORMATION26');
2841: --
2842: p_pds_information27:=
2843: hr_transaction_api.get_varchar2_value
2844: (p_transaction_step_id => p_transaction_step_id
2845: ,p_name => 'P_PDS_INFORMATION27');
2846: --
2847: p_pds_information28:=

Line 2848: hr_transaction_api.get_varchar2_value

2844: (p_transaction_step_id => p_transaction_step_id
2845: ,p_name => 'P_PDS_INFORMATION27');
2846: --
2847: p_pds_information28:=
2848: hr_transaction_api.get_varchar2_value
2849: (p_transaction_step_id => p_transaction_step_id
2850: ,p_name => 'P_PDS_INFORMATION28');
2851: --
2852: p_pds_information29:=

Line 2853: hr_transaction_api.get_varchar2_value

2849: (p_transaction_step_id => p_transaction_step_id
2850: ,p_name => 'P_PDS_INFORMATION28');
2851: --
2852: p_pds_information29:=
2853: hr_transaction_api.get_varchar2_value
2854: (p_transaction_step_id => p_transaction_step_id
2855: ,p_name => 'P_PDS_INFORMATION29');
2856: --
2857: p_pds_information30:=

Line 2858: hr_transaction_api.get_varchar2_value

2854: (p_transaction_step_id => p_transaction_step_id
2855: ,p_name => 'P_PDS_INFORMATION29');
2856: --
2857: p_pds_information30:=
2858: hr_transaction_api.get_varchar2_value
2859: (p_transaction_step_id => p_transaction_step_id
2860: ,p_name => 'P_PDS_INFORMATION30');
2861: --
2862: hr_utility.set_location('Leaving: '|| l_proc,10);