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_APL_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_apl_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 65


  insert into per_applications
  (	application_id,
	business_group_id,
	person_id,
	date_received,
	comments,
	current_employer,
	projected_hire_date,
	successful_flag,
	termination_reason,
	request_id,
	program_application_id,
	program_id,
	program_update_date,
	appl_attribute_category,
	appl_attribute1,
	appl_attribute2,
	appl_attribute3,
	appl_attribute4,
	appl_attribute5,
	appl_attribute6,
	appl_attribute7,
	appl_attribute8,
	appl_attribute9,
	appl_attribute10,
	appl_attribute11,
	appl_attribute12,
	appl_attribute13,
	appl_attribute14,
	appl_attribute15,
	appl_attribute16,
	appl_attribute17,
	appl_attribute18,
	appl_attribute19,
	appl_attribute20,
	object_version_number
  )
  Values
  (	p_rec.application_id,
	p_rec.business_group_id,
	p_rec.person_id,
	p_rec.date_received,
	p_rec.comments,
	p_rec.current_employer,
	p_rec.projected_hire_date,
	p_rec.successful_flag,
	p_rec.termination_reason,
	p_rec.request_id,
	p_rec.program_application_id,
	p_rec.program_id,
	p_rec.program_update_date,
	p_rec.appl_attribute_category,
	p_rec.appl_attribute1,
	p_rec.appl_attribute2,
	p_rec.appl_attribute3,
	p_rec.appl_attribute4,
	p_rec.appl_attribute5,
	p_rec.appl_attribute6,
	p_rec.appl_attribute7,
	p_rec.appl_attribute8,
	p_rec.appl_attribute9,
	p_rec.appl_attribute10,
	p_rec.appl_attribute11,
	p_rec.appl_attribute12,
	p_rec.appl_attribute13,
	p_rec.appl_attribute14,
	p_rec.appl_attribute15,
	p_rec.appl_attribute16,
	p_rec.appl_attribute17,
	p_rec.appl_attribute18,
	p_rec.appl_attribute19,
	p_rec.appl_attribute20,
	p_rec.object_version_number
  );

Line: 162


End insert_dml;

Line: 201


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

Line: 205


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

Line: 218


End pre_insert;

Line: 252


Procedure post_insert(p_rec             in per_apl_shd.g_rec_type
                     ,p_effective_date  in date) is
--
  l_proc  varchar2(72) := g_package||'post_insert';

Line: 262


    per_apl_rki.after_insert
      (p_application_id               => p_rec.application_id
      ,p_business_group_id            => p_rec.business_group_id
      ,p_person_id                    => p_rec.person_id
      ,p_date_received                => p_rec.date_received
      ,p_comments                     => p_rec.comments
      ,p_current_employer             => p_rec.current_employer
      ,p_projected_hire_date          => p_rec.projected_hire_date
      ,p_successful_flag              => p_rec.successful_flag
      ,p_termination_reason           => p_rec.termination_reason
      ,p_request_id                   => p_rec.request_id
      ,p_program_application_id       => p_rec.program_application_id
      ,p_program_id                   => p_rec.program_id
      ,p_program_update_date          => p_rec.program_update_date
      ,p_appl_attribute_category      => p_rec.appl_attribute_category
      ,p_appl_attribute1              => p_rec.appl_attribute1
      ,p_appl_attribute2              => p_rec.appl_attribute2
      ,p_appl_attribute3              => p_rec.appl_attribute3
      ,p_appl_attribute4              => p_rec.appl_attribute4
      ,p_appl_attribute5              => p_rec.appl_attribute5
      ,p_appl_attribute6              => p_rec.appl_attribute6
      ,p_appl_attribute7              => p_rec.appl_attribute7
      ,p_appl_attribute8              => p_rec.appl_attribute8
      ,p_appl_attribute9              => p_rec.appl_attribute9
      ,p_appl_attribute10             => p_rec.appl_attribute10
      ,p_appl_attribute11             => p_rec.appl_attribute11
      ,p_appl_attribute12             => p_rec.appl_attribute12
      ,p_appl_attribute13             => p_rec.appl_attribute13
      ,p_appl_attribute14             => p_rec.appl_attribute14
      ,p_appl_attribute15             => p_rec.appl_attribute15
      ,p_appl_attribute16             => p_rec.appl_attribute16
      ,p_appl_attribute17             => p_rec.appl_attribute17
      ,p_appl_attribute18             => p_rec.appl_attribute18
      ,p_appl_attribute19             => p_rec.appl_attribute19
      ,p_appl_attribute20             => p_rec.appl_attribute20
      ,p_object_version_number        => p_rec.object_version_number
      ,p_effective_date               => p_effective_date
      );

Line: 310


End post_insert;

Line: 339


  per_apl_bus.insert_validate(p_rec
			     ,p_effective_date
			     ,false); --risgupta

Line: 349


  pre_insert(p_rec);

Line: 353


  insert_dml(p_rec);

Line: 357


  post_insert(p_rec
             ,p_effective_date);

Line: 397


  p_program_update_date          in date             default null,
  p_appl_attribute_category      in varchar2         default null,
  p_appl_attribute1              in varchar2         default null,
  p_appl_attribute2              in varchar2         default null,
  p_appl_attribute3              in varchar2         default null,
  p_appl_attribute4              in varchar2         default null,
  p_appl_attribute5              in varchar2         default null,
  p_appl_attribute6              in varchar2         default null,
  p_appl_attribute7              in varchar2         default null,
  p_appl_attribute8              in varchar2         default null,
  p_appl_attribute9              in varchar2         default null,
  p_appl_attribute10             in varchar2         default null,
  p_appl_attribute11             in varchar2         default null,
  p_appl_attribute12             in varchar2         default null,
  p_appl_attribute13             in varchar2         default null,
  p_appl_attribute14             in varchar2         default null,
  p_appl_attribute15             in varchar2         default null,
  p_appl_attribute16             in varchar2         default null,
  p_appl_attribute17             in varchar2         default null,
  p_appl_attribute18             in varchar2         default null,
  p_appl_attribute19             in varchar2         default null,
  p_appl_attribute20             in varchar2         default null,
  p_object_version_number        out nocopy number,
  p_effective_date               in date,
  p_validate                     in boolean   default false,
  p_validate_df_flex             in   boolean default true --4689836
  ) is
--
  l_rec	  per_apl_shd.g_rec_type;

Line: 450


  p_program_update_date,
  p_appl_attribute_category,
  p_appl_attribute1,
  p_appl_attribute2,
  p_appl_attribute3,
  p_appl_attribute4,
  p_appl_attribute5,
  p_appl_attribute6,
  p_appl_attribute7,
  p_appl_attribute8,
  p_appl_attribute9,
  p_appl_attribute10,
  p_appl_attribute11,
  p_appl_attribute12,
  p_appl_attribute13,
  p_appl_attribute14,
  p_appl_attribute15,
  p_appl_attribute16,
  p_appl_attribute17,
  p_appl_attribute18,
  p_appl_attribute19,
  p_appl_attribute20,
  null
  );