APPS.BEN_CPI_INS dependencies on BEN_CPI_SHD

Line 129: (p_rec in out nocopy ben_cpi_shd.g_rec_type

125: --
126: -- {End Of Comments}
127: -- ----------------------------------------------------------------------------
128: Procedure insert_dml
129: (p_rec in out nocopy ben_cpi_shd.g_rec_type
130: ) is
131: --
132: l_proc varchar2(72) := g_package||'insert_dml';
133: --

Line 140: ben_cpi_shd.g_api_dml := true; -- Set the api dml status

136: hr_utility.set_location('Entering:'||l_proc, 5);
137: end if;
138: p_rec.object_version_number := 1; -- Initialise the object version
139: --
140: ben_cpi_shd.g_api_dml := true; -- Set the api dml status
141: --
142: -- Insert the row into: ben_cwb_person_info
143: --
144: insert into ben_cwb_person_info

Line 453: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status

449: ,p_rec.cpi_attribute30
450: ,p_rec.feedback_date
451: );
452: --
453: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status
454: --
455: if g_debug then
456: hr_utility.set_location(' Leaving:'||l_proc, 10);
457: end if;

Line 461: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status

457: end if;
458: Exception
459: When hr_api.check_integrity_violated Then
460: -- A check constraint has been violated
461: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status
462: ben_cpi_shd.constraint_error
463: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
464: When hr_api.parent_integrity_violated Then
465: -- Parent integrity has been violated

Line 462: ben_cpi_shd.constraint_error

458: Exception
459: When hr_api.check_integrity_violated Then
460: -- A check constraint has been violated
461: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status
462: ben_cpi_shd.constraint_error
463: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
464: When hr_api.parent_integrity_violated Then
465: -- Parent integrity has been violated
466: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status

Line 466: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status

462: ben_cpi_shd.constraint_error
463: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
464: When hr_api.parent_integrity_violated Then
465: -- Parent integrity has been violated
466: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status
467: ben_cpi_shd.constraint_error
468: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
469: When hr_api.unique_integrity_violated Then
470: -- Unique integrity has been violated

Line 467: ben_cpi_shd.constraint_error

463: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
464: When hr_api.parent_integrity_violated Then
465: -- Parent integrity has been violated
466: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status
467: ben_cpi_shd.constraint_error
468: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
469: When hr_api.unique_integrity_violated Then
470: -- Unique integrity has been violated
471: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status

Line 471: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status

467: ben_cpi_shd.constraint_error
468: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
469: When hr_api.unique_integrity_violated Then
470: -- Unique integrity has been violated
471: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status
472: ben_cpi_shd.constraint_error
473: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
474: When Others Then
475: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status

Line 472: ben_cpi_shd.constraint_error

468: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
469: When hr_api.unique_integrity_violated Then
470: -- Unique integrity has been violated
471: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status
472: ben_cpi_shd.constraint_error
473: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
474: When Others Then
475: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status
476: Raise;

Line 475: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status

471: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status
472: ben_cpi_shd.constraint_error
473: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
474: When Others Then
475: ben_cpi_shd.g_api_dml := false; -- Unset the api dml status
476: Raise;
477: End insert_dml;
478: --
479: -- ----------------------------------------------------------------------------

Line 517: (p_rec in out nocopy ben_cpi_shd.g_rec_type

513: --
514: -- {End Of Comments}
515: -- ----------------------------------------------------------------------------
516: Procedure pre_insert
517: (p_rec in out nocopy ben_cpi_shd.g_rec_type
518: ) is
519: --
520: Cursor C_Sel2 is
521: Select null

Line 607: (p_rec in ben_cpi_shd.g_rec_type

603: --
604: -- {End Of Comments}
605: -- ----------------------------------------------------------------------------
606: Procedure post_insert
607: (p_rec in ben_cpi_shd.g_rec_type
608: ) is
609: --
610: l_proc varchar2(72) := g_package||'post_insert';
611: --

Line 950: (p_rec in out nocopy ben_cpi_shd.g_rec_type

946: -- ----------------------------------------------------------------------------
947: -- |---------------------------------< ins >----------------------------------|
948: -- ----------------------------------------------------------------------------
949: Procedure ins
950: (p_rec in out nocopy ben_cpi_shd.g_rec_type
951: ) is
952: --
953: l_proc varchar2(72) := g_package||'ins';
954: --

Line 1149: l_rec ben_cpi_shd.g_rec_type;

1145: ,p_feedback_date in date default null
1146: ,p_object_version_number out nocopy number
1147: ) is
1148: --
1149: l_rec ben_cpi_shd.g_rec_type;
1150: l_proc varchar2(72) := g_package||'ins';
1151: --
1152: Begin
1153: if g_debug then

Line 1161: ben_cpi_shd.convert_args

1157: -- Call conversion function to turn arguments into the
1158: -- p_rec structure.
1159: --
1160: l_rec :=
1161: ben_cpi_shd.convert_args
1162: (p_group_per_in_ler_id
1163: ,p_assignment_id
1164: ,p_person_id
1165: ,p_supervisor_id