eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ECA_INS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 53


Procedure insert_dml
(p_rec in out nocopy per_eca_shd.g_rec_type
) is
--
l_proc  varchar2(72) := g_package||'insert_dml';

Line: 60


  l_last_update_date    per_election_candidates.last_update_date%TYPE;

Line: 61


  l_last_updated_by     per_election_candidates.last_updated_by%TYPE;

Line: 62


  l_last_update_login   per_election_candidates.last_update_login%TYPE;

Line: 73


  l_last_update_date   := sysdate;

Line: 74


  l_last_updated_by    := fnd_global.user_id;

Line: 75


  l_last_update_login  := fnd_global.login_id;

Line: 79


insert into per_election_candidates
(election_candidate_id
,business_group_id
,election_id
,person_id
,rank
,role_id
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,attribute23
,attribute24
,attribute25
,attribute26
,attribute27
,attribute28
,attribute29
,attribute30
,candidate_info_category
,candidate_information1
,candidate_information2
,candidate_information3
,candidate_information4
,candidate_information5
,candidate_information6
,candidate_information7
,candidate_information8
,candidate_information9
,candidate_information10
,candidate_information11
,candidate_information12
,candidate_information13
,candidate_information14
,candidate_information15
,candidate_information16
,candidate_information17
,candidate_information18
,candidate_information19
,candidate_information20
,candidate_information21
,candidate_information22
,candidate_information23
,candidate_information24
,candidate_information25
,candidate_information26
,candidate_information27
,candidate_information28
,candidate_information29
,candidate_information30
,object_version_number
      ,creation_date
      ,created_by
      ,last_update_date
      ,last_updated_by
      ,last_update_login
)
Values
(p_rec.election_candidate_id
,p_rec.business_group_id
,p_rec.election_id
,p_rec.person_id
,p_rec.rank
,p_rec.role_id
,p_rec.attribute_category
,p_rec.attribute1
,p_rec.attribute2
,p_rec.attribute3
,p_rec.attribute4
,p_rec.attribute5
,p_rec.attribute6
,p_rec.attribute7
,p_rec.attribute8
,p_rec.attribute9
,p_rec.attribute10
,p_rec.attribute11
,p_rec.attribute12
,p_rec.attribute13
,p_rec.attribute14
,p_rec.attribute15
,p_rec.attribute16
,p_rec.attribute17
,p_rec.attribute18
,p_rec.attribute19
,p_rec.attribute20
,p_rec.attribute21
,p_rec.attribute22
,p_rec.attribute23
,p_rec.attribute24
,p_rec.attribute25
,p_rec.attribute26
,p_rec.attribute27
,p_rec.attribute28
,p_rec.attribute29
,p_rec.attribute30
,p_rec.candidate_info_category
,p_rec.candidate_information1
,p_rec.candidate_information2
,p_rec.candidate_information3
,p_rec.candidate_information4
,p_rec.candidate_information5
,p_rec.candidate_information6
,p_rec.candidate_information7
,p_rec.candidate_information8
,p_rec.candidate_information9
,p_rec.candidate_information10
,p_rec.candidate_information11
,p_rec.candidate_information12
,p_rec.candidate_information13
,p_rec.candidate_information14
,p_rec.candidate_information15
,p_rec.candidate_information16
,p_rec.candidate_information17
,p_rec.candidate_information18
,p_rec.candidate_information19
,p_rec.candidate_information20
,p_rec.candidate_information21
,p_rec.candidate_information22
,p_rec.candidate_information23
,p_rec.candidate_information24
,p_rec.candidate_information25
,p_rec.candidate_information26
,p_rec.candidate_information27
,p_rec.candidate_information28
,p_rec.candidate_information29
,p_rec.candidate_information30
,p_rec.object_version_number
    ,l_creation_date
    ,l_created_by
    ,l_last_update_date
    ,l_last_updated_by
    ,l_last_update_login
);

Line: 254


End insert_dml;

Line: 293


Procedure pre_insert
(p_rec  in out nocopy per_eca_shd.g_rec_type
) is
--
l_proc  varchar2(72) := g_package||'pre_insert';

Line: 299


Cursor C_Sel1 is select per_election_candidates_s.nextval from sys.dual;

Line: 312


End pre_insert;

Line: 346


Procedure post_insert
(p_rec                          in per_eca_shd.g_rec_type
) is
--
l_proc  varchar2(72) := g_package||'post_insert';

Line: 356


per_eca_rki.after_insert
(p_election_candidate_id
=> p_rec.election_candidate_id
,p_business_group_id
=> p_rec.business_group_id
,p_election_id
=> p_rec.election_id
,p_person_id
=> p_rec.person_id
,p_rank
=> p_rec.rank
,p_role_id
=> p_rec.role_id
,p_attribute_category
=> p_rec.attribute_category
,p_attribute1
=> p_rec.attribute1
,p_attribute2
=> p_rec.attribute2
,p_attribute3
=> p_rec.attribute3
,p_attribute4
=> p_rec.attribute4
,p_attribute5
=> p_rec.attribute5
,p_attribute6
=> p_rec.attribute6
,p_attribute7
=> p_rec.attribute7
,p_attribute8
=> p_rec.attribute8
,p_attribute9
=> p_rec.attribute9
,p_attribute10
=> p_rec.attribute10
,p_attribute11
=> p_rec.attribute11
,p_attribute12
=> p_rec.attribute12
,p_attribute13
=> p_rec.attribute13
,p_attribute14
=> p_rec.attribute14
,p_attribute15
=> p_rec.attribute15
,p_attribute16
=> p_rec.attribute16
,p_attribute17
=> p_rec.attribute17
,p_attribute18
=> p_rec.attribute18
,p_attribute19
=> p_rec.attribute19
,p_attribute20
=> p_rec.attribute20
,p_attribute21
=> p_rec.attribute21
,p_attribute22
=> p_rec.attribute22
,p_attribute23
=> p_rec.attribute23
,p_attribute24
=> p_rec.attribute24
,p_attribute25
=> p_rec.attribute25
,p_attribute26
=> p_rec.attribute26
,p_attribute27
=> p_rec.attribute27
,p_attribute28
=> p_rec.attribute28
,p_attribute29
=> p_rec.attribute29
,p_attribute30
=> p_rec.attribute30
,p_candidate_info_category
=> p_rec.candidate_info_category
,p_candidate_information1
=> p_rec.candidate_information1
,p_candidate_information2
=> p_rec.candidate_information2
,p_candidate_information3
=> p_rec.candidate_information3
,p_candidate_information4
=> p_rec.candidate_information4
,p_candidate_information5
=> p_rec.candidate_information5
,p_candidate_information6
=> p_rec.candidate_information6
,p_candidate_information7
=> p_rec.candidate_information7
,p_candidate_information8
=> p_rec.candidate_information8
,p_candidate_information9
=> p_rec.candidate_information9
,p_candidate_information10
=> p_rec.candidate_information10
,p_candidate_information11
=> p_rec.candidate_information11
,p_candidate_information12
=> p_rec.candidate_information12
,p_candidate_information13
=> p_rec.candidate_information13
,p_candidate_information14
=> p_rec.candidate_information14
,p_candidate_information15
=> p_rec.candidate_information15
,p_candidate_information16
=> p_rec.candidate_information16
,p_candidate_information17
=> p_rec.candidate_information17
,p_candidate_information18
=> p_rec.candidate_information18
,p_candidate_information19
=> p_rec.candidate_information19
,p_candidate_information20
=> p_rec.candidate_information20
,p_candidate_information21
=> p_rec.candidate_information21
,p_candidate_information22
=> p_rec.candidate_information22
,p_candidate_information23
=> p_rec.candidate_information23
,p_candidate_information24
=> p_rec.candidate_information24
,p_candidate_information25
=> p_rec.candidate_information25
,p_candidate_information26
=> p_rec.candidate_information26
,p_candidate_information27
=> p_rec.candidate_information27
,p_candidate_information28
=> p_rec.candidate_information28
,p_candidate_information29
=> p_rec.candidate_information29
,p_candidate_information30
=> p_rec.candidate_information30
,p_object_version_number
=> p_rec.object_version_number
);

Line: 508


End post_insert;

Line: 535


  per_eca_bus.insert_validate
     (p_rec
     );

Line: 541


  per_eca_ins.pre_insert(p_rec);

Line: 545


  per_eca_ins.insert_dml(p_rec);

Line: 549


  per_eca_ins.post_insert
     (p_rec
     );