DBA Data[Home] [Help]

APPS.BENUTILS dependencies on BEN_REPORTING

Line 1002: -- Loop through cache routine and write to ben_reporting table and

998: begin
999: --
1000: hr_utility.set_location('Entering:'||l_proc, 5);
1001: --
1002: -- Loop through cache routine and write to ben_reporting table and
1003: -- to the output file
1004: --
1005: if p_table = false and
1006: p_file = false then

Line 1035: select ben_reporting_s.nextval into

1031: -- Copy all varray to single column varrays.
1032: --
1033: l_num1_col.extend(1);
1034: --
1035: select ben_reporting_s.nextval into
1036: l_num1_col(l_count)
1037: from sys.dual;
1038: /*
1039: l_num1_col(l_count) :=

Line 1113: l_table_name := 'BEN_REPORTING';

1109: --
1110: if p_table then
1111: --
1112: hr_utility.set_location('BEN_REP Ins: '||l_proc, 6);
1113: l_table_name := 'BEN_REPORTING';
1114: forall l_count in 1..l_num_recs
1115: insert into ben_reporting
1116: (reporting_id,
1117: benefit_action_id,

Line 1115: insert into ben_reporting

1111: --
1112: hr_utility.set_location('BEN_REP Ins: '||l_proc, 6);
1113: l_table_name := 'BEN_REPORTING';
1114: forall l_count in 1..l_num_recs
1115: insert into ben_reporting
1116: (reporting_id,
1117: benefit_action_id,
1118: thread_id,
1119: sequence,

Line 1952: select ben_reporting_s.nextval into

1948: --
1949: g_report_table_object.extend(1);
1950: l_count := g_report_table_object.count;
1951: /*
1952: select ben_reporting_s.nextval into
1953: g_report_table_object(l_count).reporting_id
1954: from sys.dual;
1955: */
1956: g_report_table_object(l_count).reporting_id := null;

Line 2508: select ben_reporting_s.nextval into

2504: -- hr_utility.set_location('Report Varray:'||l_proc, 5);
2505: g_report_table_object.extend(1);
2506: l_count := g_report_table_object.count;
2507: /*
2508: select ben_reporting_s.nextval into
2509: g_report_table_object(l_count).reporting_id
2510: from sys.dual;
2511: */
2512: g_report_table_object(l_count).reporting_id := null;