DBA Data[Home] [Help]

APPS.HR_TRANSACTION_SS dependencies on HR_TRANSACTION_API

Line 585: hr_transaction_api.update_transaction(p_transaction_id => p_transaction_id,

581: End If;
582:
583: If p_transaction_id is not null then
584:
585: hr_transaction_api.update_transaction(p_transaction_id => p_transaction_id,
586: p_status => p_status );
587: end If;
588:
589: hr_utility.set_location('Leaving: '|| l_proc,10);

Line 1058: hr_transaction_api.create_transaction

1054: ,avalue => l_transaction_privilege);
1055: end if;
1056: -- call the BP API to create the transaction
1057: /*
1058: hr_transaction_api.create_transaction
1059: (p_validate => false
1060: ,p_creator_person_id => p_login_person_id
1061: ,p_transaction_privilege => l_transaction_privilege
1062: ,p_transaction_id => l_transaction_id);

Line 1066: hr_transaction_api.create_transaction(

1062: ,p_transaction_id => l_transaction_id);
1063: */
1064:
1065:
1066: hr_transaction_api.create_transaction(
1067: p_validate => false
1068: ,p_creator_person_id => p_login_person_id
1069: ,p_transaction_privilege => l_transaction_privilege
1070: ,p_transaction_id => l_transaction_id

Line 1189: hr_transaction_api.rollback_transaction

1185: -- just log the message no need to raise it
1186: end;
1187: --- Added If Condition for bug#10407680
1188: IF l_allow_delete = 'Y' THEN
1189: hr_transaction_api.rollback_transaction
1190: (p_transaction_id => get_transaction_id
1191: (p_item_type => itemtype
1192: ,p_item_key => itemkey));
1193: END IF;

Line 1859: hr_transaction_api.update_transaction(

1855: ,aname => 'ERROR_MESSAGE_TEXT'
1856: ,avalue => nvl(l_error_text, l_sqlerrm));
1857:
1858: -- update the transaction table status
1859: hr_transaction_api.update_transaction(
1860: p_transaction_id => get_transaction_id
1861: (p_item_type => itemtype
1862: ,p_item_key => itemkey),
1863: p_status => 'E');

Line 1907: hr_transaction_api.update_transaction(

1903: ,itemkey => itemkey
1904: ,aname => 'ERROR_MESSAGE_TEXT'
1905: ,avalue => l_sqlerrm);
1906: -- update the transaction table status
1907: hr_transaction_api.update_transaction(
1908: p_transaction_id => get_transaction_id
1909: (p_item_type => itemtype
1910: ,p_item_key => itemkey),
1911: p_status => 'E');

Line 2118: hr_transaction_api.create_transaction_step

2114: ,p_rptg_grp_id=> p_rptg_grp_id
2115: ,p_effective_date_option=> p_effective_date_option
2116: );
2117: -- Create a Transaction Step for this Transaction.
2118: hr_transaction_api.create_transaction_step
2119: (p_validate => false
2120: ,p_creator_person_id => p_login_person_id
2121: ,p_transaction_id => get_transaction_id
2122: (p_item_type => p_item_type

Line 2133: hr_transaction_api.g_update_flag := 'N';

2129: ,p_transaction_step_id => p_transaction_step_id
2130: ,p_object_version_number => l_trs_ovn);
2131: END IF;
2132:
2133: hr_transaction_api.g_update_flag := 'N';
2134: l_count := p_transaction_data.COUNT;
2135: hr_utility.trace('In(for I in csr_trs loop)'||l_proc);
2136: FOR i IN 1..l_count LOOP
2137: IF p_transaction_data(i).param_data_type = 'DATE' THEN

Line 2153: hr_transaction_api.set_date_value

2149: l_value_error := true;
2150: fnd_message.set_name('PER', 'HR_51778_WEB_KIOSK_INV_EDATE');
2151: l_date := trunc(sysdate);
2152: END;
2153: hr_transaction_api.set_date_value
2154: (p_transaction_step_id => p_transaction_step_id
2155: ,p_person_id => p_login_person_id
2156: ,p_name => p_transaction_data(i).param_name
2157: ,p_value => l_date

Line 2180: hr_transaction_api.set_number_value

2176: -- or value error.
2177: -----------------------------------------------------------------------
2178: IF p_transaction_data(i).param_value is NULL
2179: THEN
2180: hr_transaction_api.set_number_value
2181: (p_transaction_step_id => p_transaction_step_id
2182: ,p_person_id => p_login_person_id
2183: ,p_name => p_transaction_data(i).param_name
2184: ,p_original_value => l_original_number); --ns

Line 2186: hr_transaction_api.set_number_value

2182: ,p_person_id => p_login_person_id
2183: ,p_name => p_transaction_data(i).param_name
2184: ,p_original_value => l_original_number); --ns
2185: ELSE
2186: hr_transaction_api.set_number_value
2187: (p_transaction_step_id => p_transaction_step_id
2188: ,p_person_id => p_login_person_id
2189: ,p_name => p_transaction_data(i).param_name
2190: ,p_value => to_number(p_transaction_data(i).param_value)

Line 2201: hr_transaction_api.set_varchar2_value

2197: RAISE hr_utility.hr_error;
2198: END;
2199: ELSIF p_transaction_data(i).param_data_type = 'VARCHAR2' THEN
2200: BEGIN
2201: hr_transaction_api.set_varchar2_value
2202: (p_transaction_step_id => p_transaction_step_id
2203: ,p_person_id => p_login_person_id
2204: ,p_name => p_transaction_data(i).param_name
2205: ,p_value => p_transaction_data(i).param_value

Line 2216: if (hr_transaction_api.g_update_flag = 'Y') then

2212: END;
2213: END IF;
2214: END LOOP;
2215:
2216: if (hr_transaction_api.g_update_flag = 'Y') then
2217: l_transaction_state := 'W';
2218: hr_transaction_api.g_update_flag := 'N';
2219: end if;
2220:

Line 2218: hr_transaction_api.g_update_flag := 'N';

2214: END LOOP;
2215:
2216: if (hr_transaction_api.g_update_flag = 'Y') then
2217: l_transaction_state := 'W';
2218: hr_transaction_api.g_update_flag := 'N';
2219: end if;
2220:
2221: -- --------------------------------------------------------------------
2222: -- for each of the transaction values which need to be either created or

Line 2246: hr_transaction_api.update_transaction

2242: hr_utility.set_location('EXCEPTION: '|| l_proc,570);
2243: null;
2244: End;
2245:
2246: hr_transaction_api.update_transaction
2247: (p_transaction_id => ln_transaction_id
2248: ,p_status => lv_status
2249: ,p_transaction_state => l_transaction_state
2250: ,p_transaction_effective_date => ld_trans_effec_date

Line 2287: hr_transaction_api.get_varchar2_value

2283: li_step_count := p_trans_step_id_tbl.COUNT;
2284: hr_utility.trace('Going to ( FOR i IN 0..li_step_count LOOP): '|| l_proc);
2285: FOR i IN 0..li_step_count LOOP
2286: IF p_activity_name =
2287: hr_transaction_api.get_varchar2_value
2288: (p_transaction_step_id => p_trans_step_id_tbl(i)
2289: ,p_name => 'p_activity_name')
2290: THEN
2291: RETURN p_trans_step_id_tbl(i);

Line 2331: hr_transaction_api.get_transaction_step_info

2327:
2328: IF ln_transaction_id IS NOT NULL
2329: THEN
2330: hr_utility.trace(' In(IF ln_transaction_id IS NOT NULL)'|| l_proc);
2331: hr_transaction_api.get_transaction_step_info
2332: (p_Item_Type => p_item_type,
2333: p_Item_Key => p_item_key,
2334: p_activity_id =>p_actid,
2335: p_transaction_step_id => ltt_trans_step_ids,

Line 2386: hr_transaction_api.get_transaction_step_info

2382: p_Item_Key => p_item_key);
2383: IF ln_transaction_id IS NOT NULL
2384: THEN
2385: hr_utility.trace('In( IF ln_transaction_id IS NOT NULL) '|| l_proc);
2386: hr_transaction_api.get_transaction_step_info
2387: (p_Item_Type => p_item_type,
2388: p_Item_Key => p_item_key,
2389: p_activity_id =>p_actid,
2390: p_transaction_step_id => ltt_trans_step_ids,

Line 2436: hr_transaction_api.get_transaction_step_info (

2432:
2433: BEGIN
2434: hr_utility.set_location('Entering: '|| l_proc,5);
2435: if p_actid IS NULL then
2436: hr_transaction_api.get_transaction_step_info (
2437: p_Item_Type => p_item_type,
2438: p_Item_Key => p_item_key,
2439: p_transaction_step_id => l_trans_step_ids,
2440: p_object_version_number => l_trans_obj_vers_num,

Line 2444: hr_transaction_api.get_transaction_step_info (

2440: p_object_version_number => l_trans_obj_vers_num,
2441: p_rows => l_trans_step_rows
2442: );
2443: else
2444: hr_transaction_api.get_transaction_step_info (
2445: p_Item_Type => p_item_type,
2446: p_Item_Key => p_item_key,
2447: p_activity_id => to_number(p_actid),
2448: p_transaction_step_id => l_trans_step_ids,

Line 2506: L_DEL_PHONE_NUMBER := hr_transaction_api.get_varchar2_value

2502: l_object_version_number := to_number(p_object_version_number);
2503: end if;
2504:
2505: ----- bug 5102128
2506: L_DEL_PHONE_NUMBER := hr_transaction_api.get_varchar2_value
2507: (p_transaction_step_id => to_number(p_transaction_step_id)
2508: ,p_name => 'P_PHONE_NUMBER');
2509: L_DEL_PHONE_TYPE := hr_transaction_api.get_varchar2_value
2510: (p_transaction_step_id => to_number(p_transaction_step_id)

Line 2509: L_DEL_PHONE_TYPE := hr_transaction_api.get_varchar2_value

2505: ----- bug 5102128
2506: L_DEL_PHONE_NUMBER := hr_transaction_api.get_varchar2_value
2507: (p_transaction_step_id => to_number(p_transaction_step_id)
2508: ,p_name => 'P_PHONE_NUMBER');
2509: L_DEL_PHONE_TYPE := hr_transaction_api.get_varchar2_value
2510: (p_transaction_step_id => to_number(p_transaction_step_id)
2511: ,p_name => 'P_PHONE_TYPE');
2512: L_DEL_PHONE_ID := hr_transaction_api.get_number_value
2513: (p_transaction_step_id => to_number(p_transaction_step_id)

Line 2512: L_DEL_PHONE_ID := hr_transaction_api.get_number_value

2508: ,p_name => 'P_PHONE_NUMBER');
2509: L_DEL_PHONE_TYPE := hr_transaction_api.get_varchar2_value
2510: (p_transaction_step_id => to_number(p_transaction_step_id)
2511: ,p_name => 'P_PHONE_TYPE');
2512: L_DEL_PHONE_ID := hr_transaction_api.get_number_value
2513: (p_transaction_step_id => to_number(p_transaction_step_id)
2514: ,p_name => 'P_PHONE_ID');
2515:
2516: if L_DEL_PHONE_ID is not null and L_DEL_PHONE_TYPE = 'DELETE' and L_DEL_PHONE_NUMBER = 'DELETE_NUMBER' then

Line 2521: hr_transaction_api.delete_transaction_step

2517: null;
2518: else
2519: ----- bug 5102128
2520:
2521: hr_transaction_api.delete_transaction_step
2522: (p_validate => FALSE
2523: ,p_transaction_step_id => to_number(p_transaction_step_id)
2524: ,p_object_version_number => l_object_version_number
2525: ,p_person_id => to_number(p_login_person_id));

Line 2583: hr_transaction_api.set_varchar2_value

2579: begin
2580: hr_utility.set_location('Entering: '|| l_proc,5);
2581: if (p_datatype = 'VARCHAR2') then
2582: hr_utility.trace('In (if (p_datatype = VARCHAR2)) '|| l_proc);
2583: hr_transaction_api.set_varchar2_value
2584: (p_transaction_step_id => p_transaction_step_id
2585: ,p_person_id => p_login_person_id
2586: ,p_name => p_name
2587: ,p_value => p_value);

Line 2590: hr_transaction_api.set_number_value

2586: ,p_name => p_name
2587: ,p_value => p_value);
2588: elsif p_datatype = 'NUMBER' then
2589: hr_utility.trace('In ( elsif p_datatype = NUMBER) '|| l_proc);
2590: hr_transaction_api.set_number_value
2591: (p_transaction_step_id => p_transaction_step_id
2592: ,p_person_id => p_login_person_id
2593: ,p_name => p_name
2594: ,p_value => to_number(p_value));

Line 2597: hr_transaction_api.set_date_value

2593: ,p_name => p_name
2594: ,p_value => to_number(p_value));
2595: elsif p_datatype = 'DATE' then
2596: hr_utility.trace('In ( elsif p_datatype = DATE) '|| l_proc);
2597: hr_transaction_api.set_date_value
2598: (p_transaction_step_id => p_transaction_step_id
2599: ,p_person_id => p_login_person_id
2600: ,p_name => p_name
2601: ,p_value => to_date(p_value, g_date_format));

Line 2648: hr_transaction_api.create_transaction_step

2644: (p_item_type => p_item_type
2645: ,p_item_key => p_item_key);
2646: end if;
2647:
2648: hr_transaction_api.create_transaction_step
2649: (p_validate => false
2650: ,p_creator_person_id => to_number(p_login_person_id)
2651: ,p_transaction_id => l_transaction_id
2652: ,p_api_name => p_api_name