APPS.BEN_PROCESS_COMPENSATION_W dependencies on HR_API_TRANSACTION_VALUES

Line 265: from hr_api_transaction_values txn

261: select txn.name
262: ,txn.varchar2_value
263: ,txn.number_value
264: ,txn.date_value
265: from hr_api_transaction_values txn
266: where txn.transaction_step_id = p_transaction_step_id
267: and (txn.varchar2_value is not null or
268: txn.number_value is not null or
269: txn.date_value is not null);

Line 1046: hr_api_transaction_values vlv

1042: cursor c_step_id is
1043: select stp.transaction_step_id
1044: from hr_api_transactions trn,
1045: hr_api_transaction_steps stp,
1046: hr_api_transaction_values vlv
1047: where trn.selected_person_id = p_person_id
1048: and trn.transaction_id = stp.transaction_id
1049: and stp.api_name = upper(g_package || 'process_api')
1050: and stp.transaction_step_id <> l_transaction_step_id

Line 1580: update hr_api_transaction_values

1576:
1577:
1578: if l_update_mode then
1579: forall i in 1..l_count
1580: update hr_api_transaction_values
1581: set
1582: varchar2_value = l_tx_char(i),
1583: number_value = l_tx_num(i),
1584: date_value = l_tx_date(i)

Line 1589: insert into hr_api_transaction_values

1585: where transaction_step_id = l_transaction_step_id
1586: and name = l_tx_name(i);
1587: else
1588: forall i in 1..l_count
1589: insert into hr_api_transaction_values
1590: ( transaction_value_id,
1591: transaction_step_id,
1592: datatype,
1593: name,

Line 1601: ( hr_api_transaction_values_s.nextval,

1597: original_varchar2_value,
1598: original_number_value,
1599: original_date_value)
1600: Values
1601: ( hr_api_transaction_values_s.nextval,
1602: l_transaction_step_id,
1603: l_tx_type(i),
1604: l_tx_name(i),
1605: l_tx_char(i),

Line 1619: delete hr_api_transaction_values vlv

1615: if p_elig_per_elctbl_chc_id is not null then
1616: --
1617: for l_step in c_step_id loop
1618: --
1619: delete hr_api_transaction_values vlv
1620: where vlv.transaction_step_id = l_step.transaction_step_id;
1621: --
1622: delete hr_api_transaction_steps step
1623: where step.transaction_step_id = l_step.transaction_step_id;