DBA Data[Home] [Help]

APPS.BENUTILS dependencies on BEN_REPORTING

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

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

Line 1038: select ben_reporting_s.nextval into

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

Line 1116: l_table_name := 'BEN_REPORTING';

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

Line 1118: insert into ben_reporting

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

Line 1955: select ben_reporting_s.nextval into

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

Line 2511: select ben_reporting_s.nextval into

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