APPS.HR_COMP_OUTCOME_PROFILE_SS dependencies on HR_TRANSACTION_SS

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

335: if p_error_message is not null then
336: Return;
337: end if;
338: hr_utility.set_location(' Entering:' || l_proc,25);
339: l_transaction_id := hr_transaction_ss.get_transaction_id(p_item_type => p_item_type
340: ,p_item_key => p_item_key);
341: --
342: IF l_transaction_id is null THEN
343: hr_utility.set_location(' Entering:' || l_proc,30);

Line 345: hr_transaction_ss.start_transaction

341: --
342: IF l_transaction_id is null THEN
343: hr_utility.set_location(' Entering:' || l_proc,30);
344: -- Start a Transaction
345: hr_transaction_ss.start_transaction
346: (itemtype => p_item_type
347: ,itemkey => p_item_key
348: ,actid => to_number(p_actid)
349: ,funmode => 'RUN'

Line 353: l_transaction_id := hr_transaction_ss.get_transaction_id

349: ,funmode => 'RUN'
350: ,p_login_person_id => fnd_global.employee_id
351: ,result => l_result);
352: hr_utility.set_location(' Entering:' || l_proc,40);
353: l_transaction_id := hr_transaction_ss.get_transaction_id
354: (p_item_type => p_item_type
355: ,p_item_key => p_item_key);
356: END IF;
357: --

Line 1202: l_transaction_id:=hr_transaction_ss.get_transaction_id

1198: and val.varchar2_value = 'ADD';
1199: l_index number;
1200: l_transaction_id number;
1201: begin
1202: l_transaction_id:=hr_transaction_ss.get_transaction_id
1203: (p_item_type => p_item_type
1204: ,p_item_key => p_item_key);
1205: l_index := 0;
1206: for l_step_values in get_add_ids(p_transaction_id => l_transaction_id) loop

Line 1226: l_transaction_id:=hr_transaction_ss.get_transaction_id

1222: and val.varchar2_value IN ('UPDATE_APPLY','UPDATE_HIST');
1223: l_step_values number ;
1224: l_transaction_id number;
1225: begin
1226: l_transaction_id:=hr_transaction_ss.get_transaction_id
1227: (p_item_type => p_item_type
1228: ,p_item_key => p_item_key);
1229: for I in get_upd_ids(l_transaction_id) loop
1230: delete from hr_api_transaction_values

Line 1250: l_transaction_id:=hr_transaction_ss.get_transaction_id

1246: and val.varchar2_value = 'ADD';
1247: l_step_values number ;
1248: l_transaction_id number;
1249: begin
1250: l_transaction_id:=hr_transaction_ss.get_transaction_id
1251: (p_item_type => p_item_type
1252: ,p_item_key => p_item_key);
1253: for I in get_add_ids(l_transaction_id) loop
1254: delete from hr_api_transaction_values

Line 1268: | Created as hr_transaction_ss.save_transaction_step fails when

1264: |
1265: | Purpose :
1266: |
1267: | Saves the records into Transaction Tables.
1268: | Created as hr_transaction_ss.save_transaction_step fails when
1269: | value is passed in NULL
1270: |
1271: +-----------------------------------------------------------------------------*/
1272: PROCEDURE save_transaction_step

Line 1331: l_transaction_id:=hr_transaction_ss.get_transaction_id

1327: l_result number ;
1328: l_transaction_id number ;
1329: begin
1330: --
1331: l_transaction_id:=hr_transaction_ss.get_transaction_id
1332: (p_item_type => p_item_type
1333: ,p_item_key => p_item_key);
1334: --
1335: for l_result in get_all_ids(p_transaction_id => l_transaction_id) loop

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

1811: l_proc varchar2(200);
1812: begin
1813: l_proc := g_package || 'mark_for_delete';
1814: hr_utility.set_location(' Entering:' || l_proc ,10);
1815: l_transaction_id := hr_transaction_ss.get_transaction_id(p_item_type => p_item_type
1816: ,p_item_key => p_item_key);
1817: --
1818: IF l_transaction_id is null THEN
1819: hr_utility.set_location(' Entering:' || l_proc ,20);

Line 1821: hr_transaction_ss.start_transaction

1817: --
1818: IF l_transaction_id is null THEN
1819: hr_utility.set_location(' Entering:' || l_proc ,20);
1820: -- Start a Transaction
1821: hr_transaction_ss.start_transaction
1822: (itemtype => p_item_type
1823: ,itemkey => p_item_key
1824: ,actid => to_number(p_activity_id)
1825: ,funmode => 'RUN'

Line 1829: l_transaction_id := hr_transaction_ss.get_transaction_id

1825: ,funmode => 'RUN'
1826: ,p_login_person_id => fnd_global.employee_id
1827: ,result => l_result);
1828: hr_utility.set_location(' Entering:' || l_proc ,30);
1829: l_transaction_id := hr_transaction_ss.get_transaction_id
1830: (p_item_type => p_item_type
1831: ,p_item_key => p_item_key);
1832: END IF;
1833: If p_transaction_step_id is NULL OR p_transaction_step_id = '-1' then