DBA Data[Home] [Help]

APPS.PAY_BTL_INS dependencies on PAY_BTL_SHD

Line 54: (p_rec in out nocopy pay_btl_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml
54: (p_rec in out nocopy pay_btl_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: --

Line 63: pay_btl_shd.g_api_dml := true; -- Set the api dml status

59: Begin
60: hr_utility.set_location('Entering:'||l_proc, 5);
61: p_rec.object_version_number := 1; -- Initialise the object version
62: --
63: pay_btl_shd.g_api_dml := true; -- Set the api dml status
64: --
65: -- Insert the row into: pay_batch_lines
66: --
67: insert into pay_batch_lines

Line 304: pay_btl_shd.g_api_dml := false; -- Unset the api dml status

300: ,p_rec.effective_end_date
301: ,p_rec.object_version_number
302: );
303: --
304: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
305: --
306: hr_utility.set_location(' Leaving:'||l_proc, 10);
307: Exception
308: When hr_api.check_integrity_violated Then

Line 310: pay_btl_shd.g_api_dml := false; -- Unset the api dml status

306: hr_utility.set_location(' Leaving:'||l_proc, 10);
307: Exception
308: When hr_api.check_integrity_violated Then
309: -- A check constraint has been violated
310: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
311: pay_btl_shd.constraint_error
312: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
313: When hr_api.parent_integrity_violated Then
314: -- Parent integrity has been violated

Line 311: pay_btl_shd.constraint_error

307: Exception
308: When hr_api.check_integrity_violated Then
309: -- A check constraint has been violated
310: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
311: pay_btl_shd.constraint_error
312: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
313: When hr_api.parent_integrity_violated Then
314: -- Parent integrity has been violated
315: pay_btl_shd.g_api_dml := false; -- Unset the api dml status

Line 315: pay_btl_shd.g_api_dml := false; -- Unset the api dml status

311: pay_btl_shd.constraint_error
312: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
313: When hr_api.parent_integrity_violated Then
314: -- Parent integrity has been violated
315: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
316: pay_btl_shd.constraint_error
317: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
318: When hr_api.unique_integrity_violated Then
319: -- Unique integrity has been violated

Line 316: pay_btl_shd.constraint_error

312: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
313: When hr_api.parent_integrity_violated Then
314: -- Parent integrity has been violated
315: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
316: pay_btl_shd.constraint_error
317: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
318: When hr_api.unique_integrity_violated Then
319: -- Unique integrity has been violated
320: pay_btl_shd.g_api_dml := false; -- Unset the api dml status

Line 320: pay_btl_shd.g_api_dml := false; -- Unset the api dml status

316: pay_btl_shd.constraint_error
317: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
318: When hr_api.unique_integrity_violated Then
319: -- Unique integrity has been violated
320: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
321: pay_btl_shd.constraint_error
322: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
323: When Others Then
324: pay_btl_shd.g_api_dml := false; -- Unset the api dml status

Line 321: pay_btl_shd.constraint_error

317: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
318: When hr_api.unique_integrity_violated Then
319: -- Unique integrity has been violated
320: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
321: pay_btl_shd.constraint_error
322: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
323: When Others Then
324: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
325: Raise;

Line 324: pay_btl_shd.g_api_dml := false; -- Unset the api dml status

320: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
321: pay_btl_shd.constraint_error
322: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
323: When Others Then
324: pay_btl_shd.g_api_dml := false; -- Unset the api dml status
325: Raise;
326: End insert_dml;
327: --
328: -- ----------------------------------------------------------------------------

Line 366: (p_rec in out nocopy pay_btl_shd.g_rec_type

362: --
363: -- {End Of Comments}
364: -- ----------------------------------------------------------------------------
365: Procedure pre_insert
366: (p_rec in out nocopy pay_btl_shd.g_rec_type
367: ) is
368: --
369: l_proc varchar2(72) := g_package||'pre_insert';
370: --

Line 420: ,p_rec in pay_btl_shd.g_rec_type

416: -- {End Of Comments}
417: -- ----------------------------------------------------------------------------
418: Procedure post_insert
419: (p_session_date in date
420: ,p_rec in pay_btl_shd.g_rec_type
421: ) is
422: --
423: l_proc varchar2(72) := g_package||'post_insert';
424: --

Line 684: p_rec in out nocopy pay_btl_shd.g_rec_type

680: -- |---------------------------------< ins >----------------------------------|
681: -- ----------------------------------------------------------------------------
682: Procedure ins
683: (p_session_date in date,
684: p_rec in out nocopy pay_btl_shd.g_rec_type
685: ) is
686: --
687: l_proc varchar2(72) := g_package||'ins';
688: l_segment_passed boolean;

Line 689: l_segments pay_btl_shd.segment_value;

685: ) is
686: --
687: l_proc varchar2(72) := g_package||'ins';
688: l_segment_passed boolean;
689: l_segments pay_btl_shd.segment_value;
690: l_cost_allocation_keyflex_id pay_batch_lines.cost_allocation_keyflex_id%type;
691: l_concat_segments_out pay_batch_lines.concatenated_segments%type;
692: --
693: Begin

Line 700: l_segments := pay_btl_shd.segment_value( p_rec.segment1, p_rec.segment2, p_rec.segment3, p_rec.segment4,

696:
697: l_segment_passed := false;
698:
699: if ( p_rec.cost_allocation_keyflex_id is not null ) then
700: l_segments := pay_btl_shd.segment_value( p_rec.segment1, p_rec.segment2, p_rec.segment3, p_rec.segment4,
701: p_rec.segment5, p_rec.segment6, p_rec.segment7, p_rec.segment8,
702: p_rec.segment9, p_rec.segment10,p_rec.segment11,p_rec.segment12,
703: p_rec.segment13,p_rec.segment14,p_rec.segment15,p_rec.segment16,
704: p_rec.segment17,p_rec.segment18,p_rec.segment19,p_rec.segment20,

Line 718: pay_btl_shd.get_flex_segs(p_rec);

714: end if;
715: end loop;
716:
717: if ( l_segment_passed = false) then
718: pay_btl_shd.get_flex_segs(p_rec);
719: end if;
720:
721: end if;
722:

Line 761: pay_btl_shd.keyflex_comb(

757: p_rec.segment28 is null and
758: p_rec.segment29 is null and
759: p_rec.segment30 is null) then
760:
761: pay_btl_shd.keyflex_comb(
762: p_dml_mode => 'INSERT',
763: p_appl_short_name => 'PAY',
764: p_flex_code => 'COST',
765: p_segment1 => p_rec.segment1,

Line 951: l_rec pay_btl_shd.g_rec_type;

947: ,p_batch_line_id out nocopy number
948: ,p_object_version_number out nocopy number
949: ) is
950: --
951: l_rec pay_btl_shd.g_rec_type;
952: l_proc varchar2(72) := g_package||'ins';
953: l_concat_segments_out varchar2(2000);
954: l_cost_allocation_keyflex_id number;
955: --

Line 964: pay_btl_shd.convert_args

960: -- p_rec structure.
961: --
962: l_cost_allocation_keyflex_id := p_cost_allocation_keyflex_id;
963: l_rec :=
964: pay_btl_shd.convert_args
965: (null
966: ,p_cost_allocation_keyflex_id
967: ,p_element_type_id
968: ,p_assignment_id