APPS.PAY_BCT_INS dependencies on PAY_BATCH_CONTROL_TOTALS

Line 59: l_control_total_dup1 pay_batch_control_totals.control_total%TYPE;

55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_range_flag varchar2(2) := 'F';
59: l_control_total_dup1 pay_batch_control_totals.control_total%TYPE;
60:
61: --
62: Begin
63: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 87: -- Insert the row into: pay_batch_control_totals

83: l_range_flag,
84: null );
85:
86: p_rec.control_total := l_control_total_dup1;
87: -- Insert the row into: pay_batch_control_totals
88: --
89:
90: insert into pay_batch_control_totals
91: (batch_control_id

Line 90: insert into pay_batch_control_totals

86: p_rec.control_total := l_control_total_dup1;
87: -- Insert the row into: pay_batch_control_totals
88: --
89:
90: insert into pay_batch_control_totals
91: (batch_control_id
92: ,batch_id
93: ,control_status
94: ,control_total

Line 175: Cursor C_Sel1 is select pay_batch_control_totals_s.nextval from sys.dual;

171: ) is
172: --
173: l_proc varchar2(72) := g_package||'pre_insert';
174: --
175: Cursor C_Sel1 is select pay_batch_control_totals_s.nextval from sys.dual;
176: --
177: Begin
178: hr_utility.set_location('Entering:'||l_proc, 5);
179: --

Line 255: (p_module_name => 'PAY_BATCH_CONTROL_TOTALS'

251: --
252: when hr_api.cannot_find_prog_unit then
253: --
254: hr_api.cannot_find_prog_unit_error
255: (p_module_name => 'PAY_BATCH_CONTROL_TOTALS'
256: ,p_hook_type => 'AI');
257: --
258: end;
259: --