APPS.BEN_PROCESS_COMPENSATION_W dependencies on HR_API

Line 25: from hr_api_transaction_steps hats

21: ,p_rows out nocopy number) is
22: --
23: cursor csr_hats is
24: select hats.transaction_step_id
25: from hr_api_transaction_steps hats
26: where hats.item_type = p_item_type
27: and hats.item_key = p_item_key
28: and hats.activity_id = p_activity_id
29: and hats.api_name = upper(g_package || 'process_api')

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 1044: from hr_api_transactions trn,

1040: l_update_mode boolean := true;
1041: --
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

Line 1045: hr_api_transaction_steps stp,

1041: --
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')

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 1061: if p_enrt_cvg_thru_dt <> hr_api.g_eot then

1057: -- Clear enrollment caching
1058: --
1059: ben_process_compensation_w.clear_enroll_caches;
1060: --
1061: if p_enrt_cvg_thru_dt <> hr_api.g_eot then
1062: l_enrt_cvg_thru_dt := p_enrt_cvg_thru_dt;
1063: end if;
1064: if p_rt_end_dt <> hr_api.g_eot then
1065: l_rt_end_dt := p_rt_end_dt;

Line 1064: if p_rt_end_dt <> hr_api.g_eot then

1060: --
1061: if p_enrt_cvg_thru_dt <> hr_api.g_eot then
1062: l_enrt_cvg_thru_dt := p_enrt_cvg_thru_dt;
1063: end if;
1064: if p_rt_end_dt <> hr_api.g_eot then
1065: l_rt_end_dt := p_rt_end_dt;
1066: end if;
1067: --
1068: if p_save_mode is null or

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;

Line 1622: delete hr_api_transaction_steps step

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;
1624: --
1625: end loop;
1626: --