APPS.HR_TRANSACTION_SS dependencies on HR_API_TRANSACTION_VALUES

Line 1268: from hr_api_transaction_values hatv

1264: ,nvl(date_value, hr_api.g_date) date_value
1265: ,nvl(original_varchar2_value, hr_api.g_varchar2) original_varchar2_value
1266: ,nvl(original_number_value, hr_api.g_number) original_number_value
1267: ,nvl(original_date_value, hr_api.g_date) original_date_value
1268: from hr_api_transaction_values hatv
1269: where hatv.transaction_step_id = p_transaction_step_id;
1270: --
1271: begin
1272: /* this step has been commented out nocopy and should not be used until */

Line 2699: ,p_name in hr_api_transaction_values.name%type

2695: -- the given person id
2696: cursor csr_hatv (
2697: p_item_key in hr_api_transaction_steps.item_key%type
2698: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2699: ,p_name in hr_api_transaction_values.name%type
2700: ) is
2701: select val.varchar2_value, val.transaction_step_id
2702: from hr_api_transaction_values val, hr_api_transaction_steps step
2703: where step.item_type = p_item_type

Line 2702: from hr_api_transaction_values val, hr_api_transaction_steps step

2698: ,p_item_Type in hr_api_transaction_steps.item_Type%type
2699: ,p_name in hr_api_transaction_values.name%type
2700: ) is
2701: select val.varchar2_value, val.transaction_step_id
2702: from hr_api_transaction_values val, hr_api_transaction_steps step
2703: where step.item_type = p_item_type
2704: and step.item_key = p_item_key
2705: and step.transaction_step_id = val.transaction_step_id
2706: and val.name = p_name

Line 2713: ,p_name in hr_api_transaction_values.name%type

2709:
2710: cursor csr_act (
2711: p_transaction_step_id
2712: in hr_api_transaction_steps.transaction_step_id%type
2713: ,p_name in hr_api_transaction_values.name%type
2714: ) is
2715: select varchar2_value
2716: from hr_api_transaction_values
2717: where transaction_step_id = p_transaction_step_id

Line 2716: from hr_api_transaction_values

2712: in hr_api_transaction_steps.transaction_step_id%type
2713: ,p_name in hr_api_transaction_values.name%type
2714: ) is
2715: select varchar2_value
2716: from hr_api_transaction_values
2717: where transaction_step_id = p_transaction_step_id
2718: and name = p_name
2719: and varchar2_value Is Not Null;
2720:

Line 2833: from hr_api_transaction_values

2829: select NAME,
2830: VARCHAR2_VALUE,
2831: NUMBER_VALUE,
2832: DATE_VALUE
2833: from hr_api_transaction_values
2834: where transaction_step_id = p_transaction_step_id
2835: order by transaction_value_id;
2836:
2837: i integer := 0;