APPS.HR_UTIL_MISC_SS dependencies on HR_API_TRANSACTION_VALUES

Line 1702: , hr_api_transaction_values hatv1

1698: INTO l_person_id,l_irc_doc_id
1699: FROM hr_api_transactions hat
1700: , fnd_attached_documents fads
1701: , hr_api_transaction_steps hats
1702: , hr_api_transaction_values hatv1
1703: , hr_api_transaction_values hatv2
1704: WHERE hat.transaction_id = l_source_pk1_value
1705: AND hats.transaction_id = hat.transaction_id
1706: AND hats.api_name = 'HR_PROCESS_PERSON_SS.PROCESS_API'

Line 1703: , hr_api_transaction_values hatv2

1699: FROM hr_api_transactions hat
1700: , fnd_attached_documents fads
1701: , hr_api_transaction_steps hats
1702: , hr_api_transaction_values hatv1
1703: , hr_api_transaction_values hatv2
1704: WHERE hat.transaction_id = l_source_pk1_value
1705: AND hats.transaction_id = hat.transaction_id
1706: AND hats.api_name = 'HR_PROCESS_PERSON_SS.PROCESS_API'
1707: AND hatv1.transaction_step_id = hats.transaction_step_id

Line 1907: FROM hr_api_transaction_values hatv1, hr_api_transaction_values hatv2

1903: /*Added following cursor as a part of ER#9879782 Starts*/
1904: cursor csr_apl_hire_txn_vals(x_transaction_step_id NUMBER)
1905: is
1906: SELECT hatv1.NUMBER_VALUE IRC_DOC_ID, hatv2.NUMBER_VALUE FND_DOC_ID
1907: FROM hr_api_transaction_values hatv1, hr_api_transaction_values hatv2
1908: WHERE hatv1.transaction_step_id = x_transaction_step_id
1909: and hatv1.NAME like 'P_IRC_DOC_ID%'
1910: and hatv1.NUMBER_VALUE is not null
1911: and hatv2.transaction_step_id = hatv1.transaction_step_id

Line 1981: hr_api_transaction_values

1977:
1978: elsif(l_api_name = 'HR_TERMINATION_SS.PROCESS_API') then
1979:
1980: select number_value into l_period_of_serv_id from
1981: hr_api_transaction_values
1982: where TRANSACTION_STEP_ID = step_row.TRANSACTION_STEP_ID
1983: and NAME = 'P_PERIOD_OF_SERVICE_ID';
1984:
1985: l_entity_name := 'PER_PERIODS_OF_SERVICE';

Line 1991: hr_api_transaction_values

1987:
1988: elsif(l_api_name = 'HR_REVTERMINATION_SS.PROCESS_API') then
1989:
1990: select number_value into l_period_of_serv_id from
1991: hr_api_transaction_values
1992: where TRANSACTION_STEP_ID = step_row.TRANSACTION_STEP_ID
1993: and NAME = 'P_PERIODS_OF_SERVICE_ID';
1994:
1995: l_entity_name := 'PER_PERIODS_OF_SERVICE';

Line 2015: FROM hr_api_transaction_values

2011: THEN
2012: BEGIN
2013: SELECT COUNT(1)
2014: INTO l_apl_flag
2015: FROM hr_api_transaction_values
2016: WHERE transaction_step_id = step_row.TRANSACTION_STEP_ID
2017: AND NAME = 'P_APPLICANT_NUMBER'
2018: AND VARCHAR2_VALUE IS NOT NULL;
2019: EXCEPTION WHEN OTHERS THEN

Line 2025: hr_api_transaction_values

2021: END;
2022: IF l_apl_flag <> 0 THEN
2023: BEGIN
2024: select number_value into l_person_id from
2025: hr_api_transaction_values
2026: where TRANSACTION_STEP_ID = step_row.TRANSACTION_STEP_ID
2027: and NAME = 'P_PERSON_ID';
2028: EXCEPTION WHEN OTHERS
2029: THEN

Line 2034: hr_api_transaction_values

2030: l_person_id := null;
2031: END;
2032: BEGIN
2033: select date_value into l_doc_upload_date from
2034: hr_api_transaction_values
2035: where TRANSACTION_STEP_ID = step_row.TRANSACTION_STEP_ID
2036: and NAME = 'P_EFFECTIVE_DATE';
2037: EXCEPTION WHEN OTHERS
2038: THEN

Line 2043: hr_api_transaction_values

2039: l_doc_upload_date := null;
2040: END;
2041: BEGIN
2042: select number_value into l_assignment_id from
2043: hr_api_transaction_values
2044: where TRANSACTION_STEP_ID = step_row.TRANSACTION_STEP_ID
2045: and NAME = 'P_APPL_ASSIGNMENT_ID';
2046: EXCEPTION WHEN OTHERS
2047: THEN