DBA Data[Home] [Help]

APPS.HR_COMP_PROFILE_SS dependencies on HR_TRANSACTION_SS

Line 470: l_transaction_id := hr_transaction_ss.get_transaction_id(p_item_type => p_item_type

466: hr_utility.set_location(' Leaving:' || l_proc,35);
467: Return;
468: end if;
469: hr_utility.set_location(l_proc,40);
470: l_transaction_id := hr_transaction_ss.get_transaction_id(p_item_type => p_item_type
471: ,p_item_key => p_item_key);
472: IF l_transaction_id is null THEN
473: hr_utility.set_location(l_proc,45);
474: -- Start a Transaction

Line 475: hr_transaction_ss.start_transaction

471: ,p_item_key => p_item_key);
472: IF l_transaction_id is null THEN
473: hr_utility.set_location(l_proc,45);
474: -- Start a Transaction
475: hr_transaction_ss.start_transaction
476: (itemtype => p_item_type
477: ,itemkey => p_item_key
478: ,actid => to_number(p_actid)
479: ,funmode => 'RUN'

Line 482: l_transaction_id := hr_transaction_ss.get_transaction_id

478: ,actid => to_number(p_actid)
479: ,funmode => 'RUN'
480: ,p_login_person_id => fnd_global.employee_id
481: ,result => l_result);
482: l_transaction_id := hr_transaction_ss.get_transaction_id
483: (p_item_type => p_item_type
484: ,p_item_key => p_item_key);
485: END IF;
486: hr_utility.set_location(l_proc,50);

Line 800: l_transaction_id := hr_transaction_ss.get_transaction_id

796: hr_utility.set_location(l_proc,55);
797: l_next_certifctn_date := to_date(p_next_certifctn_date, l_user_date_format);
798: END IF;
799: hr_utility.set_location(l_proc,60);
800: l_transaction_id := hr_transaction_ss.get_transaction_id
801: (p_item_type => p_item_type
802: ,p_item_key => p_item_key);
803: IF l_transaction_id is null THEN
804: hr_utility.set_location(l_proc,65);

Line 805: hr_transaction_ss.start_transaction

801: (p_item_type => p_item_type
802: ,p_item_key => p_item_key);
803: IF l_transaction_id is null THEN
804: hr_utility.set_location(l_proc,65);
805: hr_transaction_ss.start_transaction
806: (itemtype => p_item_type
807: ,itemkey => p_item_key
808: ,actid => to_number(p_actid)
809: ,funmode => 'RUN'

Line 812: l_transaction_id := hr_transaction_ss.get_transaction_id

808: ,actid => to_number(p_actid)
809: ,funmode => 'RUN'
810: ,p_login_person_id => fnd_global.employee_id
811: ,result => l_result);
812: l_transaction_id := hr_transaction_ss.get_transaction_id
813: (p_item_type => p_item_type
814: ,p_item_key => p_item_key);
815: END IF;
816: --

Line 1645: l_transaction_id:=hr_transaction_ss.get_transaction_id

1641: l_index number;
1642: l_transaction_id number;
1643: begin
1644: hr_utility.set_location(' Entering:' || l_proc,5);
1645: l_transaction_id:=hr_transaction_ss.get_transaction_id
1646: (p_item_type => p_item_type
1647: ,p_item_key => p_item_key);
1648: l_index := 0;
1649: for l_step_values in get_add_ids(p_transaction_id => l_transaction_id) loop

Line 1672: l_transaction_id:=hr_transaction_ss.get_transaction_id

1668: l_step_values number ;
1669: l_transaction_id number;
1670: begin
1671: hr_utility.set_location(' Entering:' || l_proc,5);
1672: l_transaction_id:=hr_transaction_ss.get_transaction_id
1673: (p_item_type => p_item_type
1674: ,p_item_key => p_item_key);
1675: for I in get_upd_ids(l_transaction_id) loop
1676: hr_utility.set_location(l_proc || 'LOOP' ,10);

Line 1704: l_transaction_id:=hr_transaction_ss.get_transaction_id

1700: l_step_values number ;
1701: l_transaction_id number;
1702: begin
1703: hr_utility.set_location(' Entering:' || l_proc,5);
1704: l_transaction_id:=hr_transaction_ss.get_transaction_id
1705: (p_item_type => p_item_type
1706: ,p_item_key => p_item_key);
1707: for I in get_add_ids(l_transaction_id) loop
1708: hr_utility.set_location(l_proc || 'LOOP' ,10);

Line 1724: | Created as hr_transaction_ss.save_transaction_step fails when

1720: |
1721: | Purpose :
1722: |
1723: | Saves the records into Transaction Tables.
1724: | Created as hr_transaction_ss.save_transaction_step fails when
1725: | value is passed in NULL
1726: |
1727: +-----------------------------------------------------------------------------*/
1728: PROCEDURE save_transaction_step

Line 1789: l_transaction_id:=hr_transaction_ss.get_transaction_id

1785: l_result number ;
1786: l_transaction_id number ;
1787: begin
1788: hr_utility.set_location(' Entering:' || l_proc,5);
1789: l_transaction_id:=hr_transaction_ss.get_transaction_id
1790: (p_item_type => p_item_type
1791: ,p_item_key => p_item_key);
1792: for l_result in get_all_ids(p_transaction_id => l_transaction_id) loop
1793: hr_utility.set_location(l_proc || 'LOOP',10);

Line 2133: l_transaction_id := hr_transaction_ss.get_transaction_id

2129: l_preupd_date_to date;
2130: l_transaction_id number;
2131: begin
2132: hr_utility.set_location(' Entering:' || l_proc,5);
2133: l_transaction_id := hr_transaction_ss.get_transaction_id
2134: (p_item_type => p_item_type
2135: ,p_item_key => p_item_key);
2136: l_eff_date_from := to_date(p_eff_date_from,g_date_format);
2137: l_preupd_date_to := l_eff_date_from - 1 ;

Line 2364: l_transaction_id := hr_transaction_ss.get_transaction_id

2360: if p_eff_date_from is not null then
2361: hr_utility.set_location(' Entering:' || l_proc,40);
2362: l_eff_date_from := to_date(p_eff_date_from, l_user_date_format);
2363: end if;
2364: l_transaction_id := hr_transaction_ss.get_transaction_id
2365: (p_item_type => p_item_type
2366: ,p_item_key => p_item_key);
2367: IF l_transaction_id is null THEN
2368: hr_utility.set_location(' Entering:' || l_proc,45);

Line 2370: hr_transaction_ss.start_transaction

2366: ,p_item_key => p_item_key);
2367: IF l_transaction_id is null THEN
2368: hr_utility.set_location(' Entering:' || l_proc,45);
2369: -- Start a Transaction
2370: hr_transaction_ss.start_transaction
2371: (itemtype => p_item_type
2372: ,itemkey => p_item_key
2373: ,actid => to_number(p_activity_id)
2374: ,funmode => 'RUN'

Line 2377: l_transaction_id := hr_transaction_ss.get_transaction_id

2373: ,actid => to_number(p_activity_id)
2374: ,funmode => 'RUN'
2375: ,p_login_person_id => fnd_global.employee_id
2376: ,result => l_result);
2377: l_transaction_id := hr_transaction_ss.get_transaction_id
2378: (p_item_type => p_item_type
2379: ,p_item_key => p_item_key);
2380: END IF;
2381: -- Create a transaction step

Line 2911: l_transaction_id := hr_transaction_ss.get_transaction_id

2907: l_proc varchar2(200) := g_package || 'add_to_addition';
2908: l_transaction_id number;
2909: begin
2910: hr_utility.set_location(' Entering:' || l_proc,5);
2911: l_transaction_id := hr_transaction_ss.get_transaction_id
2912: (p_item_type => p_item_type
2913: ,p_item_key => p_item_key);
2914: update hr_api_transaction_values val
2915: set val.varchar2_value = 'ADDITION'