APPS.HR_TRANSACTION_SS dependencies on HR_API_TRANSACTION_VALUES

Line 1182: from hr_api_transaction_values hatv

1178: ,nvl(date_value, hr_api.g_date) date_value
1179: ,nvl(original_varchar2_value, hr_api.g_varchar2) original_varchar2_value
1180: ,nvl(original_number_value, hr_api.g_number) original_number_value
1181: ,nvl(original_date_value, hr_api.g_date) original_date_value
1182: from hr_api_transaction_values hatv
1183: where hatv.transaction_step_id = p_transaction_step_id;
1184: --
1185: begin
1186: /* this step has been commented out nocopy and should not be used until */

Line 2542: ,p_name in hr_api_transaction_values.name%type

2538: -- the given person id
2539: cursor csr_hatv (
2540: p_item_key in hr_api_transaction_steps.item_key%type
2541: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2542: ,p_name in hr_api_transaction_values.name%type
2543: ) is
2544: select val.varchar2_value, val.transaction_step_id
2545: from hr_api_transaction_values val, hr_api_transaction_steps step
2546: where step.item_type = p_item_type

Line 2545: from hr_api_transaction_values val, hr_api_transaction_steps step

2541: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2542: ,p_name in hr_api_transaction_values.name%type
2543: ) is
2544: select val.varchar2_value, val.transaction_step_id
2545: from hr_api_transaction_values val, hr_api_transaction_steps step
2546: where step.item_type = p_item_type
2547: and step.item_key = p_item_key
2548: and step.transaction_step_id = val.transaction_step_id
2549: and val.name = p_name

Line 2556: ,p_name in hr_api_transaction_values.name%type

2552:
2553: cursor csr_act (
2554: p_transaction_step_id
2555: in hr_api_transaction_steps.transaction_step_id%type
2556: ,p_name in hr_api_transaction_values.name%type
2557: ) is
2558: select varchar2_value
2559: from hr_api_transaction_values
2560: where transaction_step_id = p_transaction_step_id

Line 2559: from hr_api_transaction_values

2555: in hr_api_transaction_steps.transaction_step_id%type
2556: ,p_name in hr_api_transaction_values.name%type
2557: ) is
2558: select varchar2_value
2559: from hr_api_transaction_values
2560: where transaction_step_id = p_transaction_step_id
2561: and name = p_name
2562: and varchar2_value Is Not Null;
2563:

Line 2676: from hr_api_transaction_values

2672: select NAME,
2673: VARCHAR2_VALUE,
2674: NUMBER_VALUE,
2675: DATE_VALUE
2676: from hr_api_transaction_values
2677: where transaction_step_id = p_transaction_step_id
2678: order by transaction_value_id;
2679:
2680: i integer := 0;