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_RATE_VALUES_SWI dependencies on HR_API_TRANSACTION_VALUES

Line 825: select name, number_value from hr_api_transaction_values

821: l_stp_value_name varchar2(20);
822: l_po_installed boolean default false;
823:
824: cursor get_step_values (p_transaction_step_id in number) is
825: select name, number_value from hr_api_transaction_values
826: where transaction_step_id = p_transaction_step_id
827: and name = 'P_PO_LINE_ID';
828:
829: not_a_valid_po_txn exception;

Line 1015: delete from hr_api_transaction_values

1011: if l_record_status = g_no_change
1012: then
1013: if l_asg_rate_rec.transaction_step_id is not null
1014: then
1015: delete from hr_api_transaction_values
1016: where transaction_step_id = l_asg_rate_rec.transaction_step_id;
1017: delete from hr_api_transaction_steps
1018: where transaction_step_id = l_asg_rate_rec.transaction_step_id;
1019: end if;

Line 1382: hr_api_transaction_values a, hr_api_transaction_values b,

1378: i.number_value grade_rule_id,
1379: j.varchar2_value currency_code,
1380: to_char(s.transaction_step_id) transaction_step_id
1381: FROM hr_api_transaction_steps s,
1382: hr_api_transaction_values a, hr_api_transaction_values b,
1383: hr_api_transaction_values c, hr_api_transaction_values d,
1384: hr_api_transaction_values e, hr_api_transaction_values f,
1385: hr_api_transaction_values g, hr_api_transaction_values h,
1386: hr_api_transaction_values i, hr_api_transaction_values j

Line 1383: hr_api_transaction_values c, hr_api_transaction_values d,

1379: j.varchar2_value currency_code,
1380: to_char(s.transaction_step_id) transaction_step_id
1381: FROM hr_api_transaction_steps s,
1382: hr_api_transaction_values a, hr_api_transaction_values b,
1383: hr_api_transaction_values c, hr_api_transaction_values d,
1384: hr_api_transaction_values e, hr_api_transaction_values f,
1385: hr_api_transaction_values g, hr_api_transaction_values h,
1386: hr_api_transaction_values i, hr_api_transaction_values j
1387: WHERE s.item_type = p_item_type

Line 1384: hr_api_transaction_values e, hr_api_transaction_values f,

1380: to_char(s.transaction_step_id) transaction_step_id
1381: FROM hr_api_transaction_steps s,
1382: hr_api_transaction_values a, hr_api_transaction_values b,
1383: hr_api_transaction_values c, hr_api_transaction_values d,
1384: hr_api_transaction_values e, hr_api_transaction_values f,
1385: hr_api_transaction_values g, hr_api_transaction_values h,
1386: hr_api_transaction_values i, hr_api_transaction_values j
1387: WHERE s.item_type = p_item_type
1388: AND s.item_key = p_item_key

Line 1385: hr_api_transaction_values g, hr_api_transaction_values h,

1381: FROM hr_api_transaction_steps s,
1382: hr_api_transaction_values a, hr_api_transaction_values b,
1383: hr_api_transaction_values c, hr_api_transaction_values d,
1384: hr_api_transaction_values e, hr_api_transaction_values f,
1385: hr_api_transaction_values g, hr_api_transaction_values h,
1386: hr_api_transaction_values i, hr_api_transaction_values j
1387: WHERE s.item_type = p_item_type
1388: AND s.item_key = p_item_key
1389: AND s.api_name = g_package||'.PROCESS_API'

Line 1386: hr_api_transaction_values i, hr_api_transaction_values j

1382: hr_api_transaction_values a, hr_api_transaction_values b,
1383: hr_api_transaction_values c, hr_api_transaction_values d,
1384: hr_api_transaction_values e, hr_api_transaction_values f,
1385: hr_api_transaction_values g, hr_api_transaction_values h,
1386: hr_api_transaction_values i, hr_api_transaction_values j
1387: WHERE s.item_type = p_item_type
1388: AND s.item_key = p_item_key
1389: AND s.api_name = g_package||'.PROCESS_API'
1390: AND a.transaction_step_id = s.transaction_step_id

Line 1431: hr_api_transaction_values a

1427: AND pgr.assignment_id = to_number(p_assignment_id)
1428: AND pgr.business_group_id = to_number(p_business_gp_id)
1429: AND pgr.grade_rule_id NOT IN (SELECT nvl(a.number_value, -1)
1430: FROM hr_api_transaction_steps s,
1431: hr_api_transaction_values a
1432: WHERE s.item_type = p_item_type
1433: AND s.item_key = p_item_key
1434: AND s.api_name = g_package||'.PROCESS_API'
1435: AND a.transaction_step_id = s.transaction_step_id

Line 1667: delete from hr_api_transaction_values

1663: PROCEDURE delete_transaction_step
1664: (p_transaction_step_id in VARCHAR2
1665: ) is
1666: begin
1667: delete from hr_api_transaction_values
1668: where transaction_step_id = p_transaction_step_id;
1669: delete from hr_api_transaction_steps
1670: where transaction_step_id = p_transaction_step_id;
1671: end delete_transaction_step;