APPS.BEN_TEST_HARNESS dependencies on BEN_REPORTING

Line 349: from ben_reporting

345: is
346: select ERROR_MESSAGE_CODE,
347: max(person_id) mx_perid,
348: count(*) cnt
349: from ben_reporting
350: where benefit_action_id = c_bft_id
351: and ERROR_MESSAGE_CODE is not null
352: group by ERROR_MESSAGE_CODE
353: order by count(*) desc;

Line 1538: from ben_reporting

1534: (c_bft_id in number
1535: )
1536: is
1537: select text
1538: from ben_reporting
1539: where benefit_action_id = c_bft_id
1540: and text like '%ORA-%'
1541: order by THREAD_ID, REPORTING_ID;
1542: --

Line 1594: from ben_reporting rep

1590: ,c_err_cd varchar2
1591: )
1592: is
1593: select rep.person_id
1594: from ben_reporting rep
1595: where rep.benefit_action_id = c_bft_id
1596: and rep.ERROR_MESSAGE_CODE = c_err_cd;
1597: --
1598: cursor c_bpidets

Line 2122: from ben_reporting

2118: is
2119: select text,
2120: max(person_id) mx_perid,
2121: count(*) cnt
2122: from ben_reporting
2123: where benefit_action_id = c_bft_id
2124: and text like '%ORA-%'
2125: group by text
2126: order by count(*) desc;

Line 4603: -- Populate ben_reporting

4599: l_reptext_va(l_reptext_en) := '----';
4600: --
4601: end if;
4602: --
4603: -- Populate ben_reporting
4604: --
4605: if l_reptext_va.count > 0 then
4606: --
4607: for repvaen in l_reptext_va.first..l_reptext_va.last

Line 4624: select ben_reporting_s.nextval into

4620: -- Copy all varray to single column varrays.
4621: --
4622: l_num1_col.extend(1);
4623: --
4624: select ben_reporting_s.nextval into
4625: l_num1_col(repvaen)
4626: from sys.dual;
4627: /*
4628: l_num1_col(l_count) :=

Line 4695: insert into ben_reporting

4691: --
4692: end loop;
4693: --
4694: forall insvaen in l_num1_col.first..l_num1_col.last
4695: insert into ben_reporting
4696: (reporting_id,
4697: benefit_action_id,
4698: thread_id,
4699: sequence,

Line 4770: from ben_reporting rep

4766: (c_bft_id in number
4767: )
4768: is
4769: select rep.ERROR_MESSAGE_CODE
4770: from ben_reporting rep
4771: where rep.benefit_action_id = c_bft_id
4772: and rep.ERROR_MESSAGE_CODE is not null;
4773: --
4774: cursor c_gbenrepercdsum

Line 4781: from ben_reporting

4777: is
4778: select ERROR_MESSAGE_CODE,
4779: max(person_id) mx_perid,
4780: count(*) cnt
4781: from ben_reporting
4782: where benefit_action_id = c_bft_id
4783: and ERROR_MESSAGE_CODE is not null
4784: group by ERROR_MESSAGE_CODE
4785: order by count(*) desc;

Line 4795: from ben_reporting rep

4791: select rep.text,
4792: rep.thread_id,
4793: rep.person_id,
4794: rep.last_update_login
4795: from ben_reporting rep
4796: where rep.benefit_action_id = c_bft_id
4797: order by thread_id, reporting_id;
4798: --
4799: cursor c_ersltdetcnt