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

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

518: End If;
519:
520: If p_transaction_id is not null then
521:
522: hr_transaction_api.update_transaction(p_transaction_id => p_transaction_id,
523: p_status => p_status );
524: end If;
525:
526: hr_utility.set_location('Leaving: '|| l_proc,10);

Line 995: hr_transaction_api.create_transaction

991: ,avalue => l_transaction_privilege);
992: end if;
993: -- call the BP API to create the transaction
994: /*
995: hr_transaction_api.create_transaction
996: (p_validate => false
997: ,p_creator_person_id => p_login_person_id
998: ,p_transaction_privilege => l_transaction_privilege
999: ,p_transaction_id => l_transaction_id);

Line 1003: hr_transaction_api.create_transaction(

999: ,p_transaction_id => l_transaction_id);
1000: */
1001:
1002:
1003: hr_transaction_api.create_transaction(
1004: p_validate => false
1005: ,p_creator_person_id => p_login_person_id
1006: ,p_transaction_privilege => l_transaction_privilege
1007: ,p_transaction_id => l_transaction_id

Line 1104: hr_transaction_api.rollback_transaction

1100: 'rollback_transaction'||' : ' || sqlerrm);
1101: -- just log the message no need to raise it
1102: end;
1103:
1104: hr_transaction_api.rollback_transaction
1105: (p_transaction_id => get_transaction_id
1106: (p_item_type => itemtype
1107: ,p_item_key => itemkey));
1108: end if;

Line 1725: hr_transaction_api.update_transaction(

1721: ,aname => 'ERROR_MESSAGE_TEXT'
1722: ,avalue => nvl(l_error_text, l_sqlerrm));
1723:
1724: -- update the transaction table status
1725: hr_transaction_api.update_transaction(
1726: p_transaction_id => get_transaction_id
1727: (p_item_type => itemtype
1728: ,p_item_key => itemkey),
1729: p_status => 'E');

Line 1750: hr_transaction_api.update_transaction(

1746: ,itemkey => itemkey
1747: ,aname => 'ERROR_MESSAGE_TEXT'
1748: ,avalue => l_sqlerrm);
1749: -- update the transaction table status
1750: hr_transaction_api.update_transaction(
1751: p_transaction_id => get_transaction_id
1752: (p_item_type => itemtype
1753: ,p_item_key => itemkey),
1754: p_status => 'E');

Line 1961: hr_transaction_api.create_transaction_step

1957: ,p_rptg_grp_id=> p_rptg_grp_id
1958: ,p_effective_date_option=> p_effective_date_option
1959: );
1960: -- Create a Transaction Step for this Transaction.
1961: hr_transaction_api.create_transaction_step
1962: (p_validate => false
1963: ,p_creator_person_id => p_login_person_id
1964: ,p_transaction_id => get_transaction_id
1965: (p_item_type => p_item_type

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

1972: ,p_transaction_step_id => p_transaction_step_id
1973: ,p_object_version_number => l_trs_ovn);
1974: END IF;
1975:
1976: hr_transaction_api.g_update_flag := 'N';
1977: l_count := p_transaction_data.COUNT;
1978: hr_utility.trace('In(for I in csr_trs loop)'||l_proc);
1979: FOR i IN 1..l_count LOOP
1980: IF p_transaction_data(i).param_data_type = 'DATE' THEN

Line 1996: hr_transaction_api.set_date_value

1992: l_value_error := true;
1993: fnd_message.set_name('PER', 'HR_51778_WEB_KIOSK_INV_EDATE');
1994: l_date := trunc(sysdate);
1995: END;
1996: hr_transaction_api.set_date_value
1997: (p_transaction_step_id => p_transaction_step_id
1998: ,p_person_id => p_login_person_id
1999: ,p_name => p_transaction_data(i).param_name
2000: ,p_value => l_date

Line 2023: hr_transaction_api.set_number_value

2019: -- or value error.
2020: -----------------------------------------------------------------------
2021: IF p_transaction_data(i).param_value is NULL
2022: THEN
2023: hr_transaction_api.set_number_value
2024: (p_transaction_step_id => p_transaction_step_id
2025: ,p_person_id => p_login_person_id
2026: ,p_name => p_transaction_data(i).param_name
2027: ,p_original_value => l_original_number); --ns

Line 2029: hr_transaction_api.set_number_value

2025: ,p_person_id => p_login_person_id
2026: ,p_name => p_transaction_data(i).param_name
2027: ,p_original_value => l_original_number); --ns
2028: ELSE
2029: hr_transaction_api.set_number_value
2030: (p_transaction_step_id => p_transaction_step_id
2031: ,p_person_id => p_login_person_id
2032: ,p_name => p_transaction_data(i).param_name
2033: ,p_value => to_number(p_transaction_data(i).param_value)

Line 2044: hr_transaction_api.set_varchar2_value

2040: RAISE hr_utility.hr_error;
2041: END;
2042: ELSIF p_transaction_data(i).param_data_type = 'VARCHAR2' THEN
2043: BEGIN
2044: hr_transaction_api.set_varchar2_value
2045: (p_transaction_step_id => p_transaction_step_id
2046: ,p_person_id => p_login_person_id
2047: ,p_name => p_transaction_data(i).param_name
2048: ,p_value => p_transaction_data(i).param_value

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

2055: END;
2056: END IF;
2057: END LOOP;
2058:
2059: if (hr_transaction_api.g_update_flag = 'Y') then
2060: l_transaction_state := 'W';
2061: hr_transaction_api.g_update_flag := 'N';
2062: end if;
2063:

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

2057: END LOOP;
2058:
2059: if (hr_transaction_api.g_update_flag = 'Y') then
2060: l_transaction_state := 'W';
2061: hr_transaction_api.g_update_flag := 'N';
2062: end if;
2063:
2064: -- --------------------------------------------------------------------
2065: -- for each of the transaction values which need to be either created or

Line 2089: hr_transaction_api.update_transaction

2085: hr_utility.set_location('EXCEPTION: '|| l_proc,570);
2086: null;
2087: End;
2088:
2089: hr_transaction_api.update_transaction
2090: (p_transaction_id => ln_transaction_id
2091: ,p_status => lv_status
2092: ,p_transaction_state => l_transaction_state
2093: ,p_transaction_effective_date => ld_trans_effec_date

Line 2130: hr_transaction_api.get_varchar2_value

2126: li_step_count := p_trans_step_id_tbl.COUNT;
2127: hr_utility.trace('Going to ( FOR i IN 0..li_step_count LOOP): '|| l_proc);
2128: FOR i IN 0..li_step_count LOOP
2129: IF p_activity_name =
2130: hr_transaction_api.get_varchar2_value
2131: (p_transaction_step_id => p_trans_step_id_tbl(i)
2132: ,p_name => 'p_activity_name')
2133: THEN
2134: RETURN p_trans_step_id_tbl(i);

Line 2174: hr_transaction_api.get_transaction_step_info

2170:
2171: IF ln_transaction_id IS NOT NULL
2172: THEN
2173: hr_utility.trace(' In(IF ln_transaction_id IS NOT NULL)'|| l_proc);
2174: hr_transaction_api.get_transaction_step_info
2175: (p_Item_Type => p_item_type,
2176: p_Item_Key => p_item_key,
2177: p_activity_id =>p_actid,
2178: p_transaction_step_id => ltt_trans_step_ids,

Line 2229: hr_transaction_api.get_transaction_step_info

2225: p_Item_Key => p_item_key);
2226: IF ln_transaction_id IS NOT NULL
2227: THEN
2228: hr_utility.trace('In( IF ln_transaction_id IS NOT NULL) '|| l_proc);
2229: hr_transaction_api.get_transaction_step_info
2230: (p_Item_Type => p_item_type,
2231: p_Item_Key => p_item_key,
2232: p_activity_id =>p_actid,
2233: p_transaction_step_id => ltt_trans_step_ids,

Line 2279: hr_transaction_api.get_transaction_step_info (

2275:
2276: BEGIN
2277: hr_utility.set_location('Entering: '|| l_proc,5);
2278: if p_actid IS NULL then
2279: hr_transaction_api.get_transaction_step_info (
2280: p_Item_Type => p_item_type,
2281: p_Item_Key => p_item_key,
2282: p_transaction_step_id => l_trans_step_ids,
2283: p_object_version_number => l_trans_obj_vers_num,

Line 2287: hr_transaction_api.get_transaction_step_info (

2283: p_object_version_number => l_trans_obj_vers_num,
2284: p_rows => l_trans_step_rows
2285: );
2286: else
2287: hr_transaction_api.get_transaction_step_info (
2288: p_Item_Type => p_item_type,
2289: p_Item_Key => p_item_key,
2290: p_activity_id => to_number(p_actid),
2291: p_transaction_step_id => l_trans_step_ids,

Line 2349: L_DEL_PHONE_NUMBER := hr_transaction_api.get_varchar2_value

2345: l_object_version_number := to_number(p_object_version_number);
2346: end if;
2347:
2348: ----- bug 5102128
2349: L_DEL_PHONE_NUMBER := hr_transaction_api.get_varchar2_value
2350: (p_transaction_step_id => to_number(p_transaction_step_id)
2351: ,p_name => 'P_PHONE_NUMBER');
2352: L_DEL_PHONE_TYPE := hr_transaction_api.get_varchar2_value
2353: (p_transaction_step_id => to_number(p_transaction_step_id)

Line 2352: L_DEL_PHONE_TYPE := hr_transaction_api.get_varchar2_value

2348: ----- bug 5102128
2349: L_DEL_PHONE_NUMBER := hr_transaction_api.get_varchar2_value
2350: (p_transaction_step_id => to_number(p_transaction_step_id)
2351: ,p_name => 'P_PHONE_NUMBER');
2352: L_DEL_PHONE_TYPE := hr_transaction_api.get_varchar2_value
2353: (p_transaction_step_id => to_number(p_transaction_step_id)
2354: ,p_name => 'P_PHONE_TYPE');
2355: L_DEL_PHONE_ID := hr_transaction_api.get_number_value
2356: (p_transaction_step_id => to_number(p_transaction_step_id)

Line 2355: L_DEL_PHONE_ID := hr_transaction_api.get_number_value

2351: ,p_name => 'P_PHONE_NUMBER');
2352: L_DEL_PHONE_TYPE := hr_transaction_api.get_varchar2_value
2353: (p_transaction_step_id => to_number(p_transaction_step_id)
2354: ,p_name => 'P_PHONE_TYPE');
2355: L_DEL_PHONE_ID := hr_transaction_api.get_number_value
2356: (p_transaction_step_id => to_number(p_transaction_step_id)
2357: ,p_name => 'P_PHONE_ID');
2358:
2359: if L_DEL_PHONE_ID is not null and L_DEL_PHONE_TYPE = 'DELETE' and L_DEL_PHONE_NUMBER = 'DELETE_NUMBER' then

Line 2364: hr_transaction_api.delete_transaction_step

2360: null;
2361: else
2362: ----- bug 5102128
2363:
2364: hr_transaction_api.delete_transaction_step
2365: (p_validate => FALSE
2366: ,p_transaction_step_id => to_number(p_transaction_step_id)
2367: ,p_object_version_number => l_object_version_number
2368: ,p_person_id => to_number(p_login_person_id));

Line 2426: hr_transaction_api.set_varchar2_value

2422: begin
2423: hr_utility.set_location('Entering: '|| l_proc,5);
2424: if (p_datatype = 'VARCHAR2') then
2425: hr_utility.trace('In (if (p_datatype = VARCHAR2)) '|| l_proc);
2426: hr_transaction_api.set_varchar2_value
2427: (p_transaction_step_id => p_transaction_step_id
2428: ,p_person_id => p_login_person_id
2429: ,p_name => p_name
2430: ,p_value => p_value);

Line 2433: hr_transaction_api.set_number_value

2429: ,p_name => p_name
2430: ,p_value => p_value);
2431: elsif p_datatype = 'NUMBER' then
2432: hr_utility.trace('In ( elsif p_datatype = NUMBER) '|| l_proc);
2433: hr_transaction_api.set_number_value
2434: (p_transaction_step_id => p_transaction_step_id
2435: ,p_person_id => p_login_person_id
2436: ,p_name => p_name
2437: ,p_value => to_number(p_value));

Line 2440: hr_transaction_api.set_date_value

2436: ,p_name => p_name
2437: ,p_value => to_number(p_value));
2438: elsif p_datatype = 'DATE' then
2439: hr_utility.trace('In ( elsif p_datatype = DATE) '|| l_proc);
2440: hr_transaction_api.set_date_value
2441: (p_transaction_step_id => p_transaction_step_id
2442: ,p_person_id => p_login_person_id
2443: ,p_name => p_name
2444: ,p_value => to_date(p_value, g_date_format));

Line 2491: hr_transaction_api.create_transaction_step

2487: (p_item_type => p_item_type
2488: ,p_item_key => p_item_key);
2489: end if;
2490:
2491: hr_transaction_api.create_transaction_step
2492: (p_validate => false
2493: ,p_creator_person_id => to_number(p_login_person_id)
2494: ,p_transaction_id => l_transaction_id
2495: ,p_api_name => p_api_name