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.GHR_PAH_INS SQL Statements

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

Line: 53


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

Line: 65


  insert into ghr_pa_history
  (	pa_history_id,
	pa_request_id,
	process_date,
	nature_of_action_id,
	effective_date,
	altered_pa_request_id,
	person_id,
	assignment_id,
	dml_operation,
	table_name,
	pre_values_flag,
	information1,
	information2,
	information3,
	information4,
	information5,
	information6,
	information7,
	information8,
	information9,
	information10,
	information11,
	information12,
	information13,
	information14,
	information15,
	information16,
	information17,
	information18,
	information19,
	information20,
	information21,
	information22,
	information23,
	information24,
	information25,
	information26,
	information27,
	information28,
	information29,
	information30,
	information31,
	information32,
	information33,
	information34,
	information35,
	information36,
	information37,
	information38,
	information39,
	information47,
	information48,
	information49,
	information40,
	information41,
	information42,
	information43,
	information44,
	information45,
	information46,
	information50,
	information51,
	information52,
	information53,
	information54,
	information55,
	information56,
	information57,
	information58,
	information59,
	information60,
	information61,
	information62,
	information63,
	information64,
	information65,
	information66,
	information67,
	information68,
	information69,
	information70,
	information71,
	information72,
	information73,
	information74,
	information75,
	information76,
	information77,
	information78,
	information79,
	information80,
	information81,
	information82,
	information83,
	information84,
	information85,
	information86,
	information87,
	information88,
	information89,
	information90,
	information91,
	information92,
	information93,
	information94,
	information95,
	information96,
	information97,
	information98,
	information99,
	information100,
	information101,
	information102,
	information103,
	information104,
	information105,
	information106,
	information107,
	information108,
	information109,
	information110,
	information111,
	information112,
	information113,
	information114,
	information115,
	information116,
	information117,
	information118,
	information119,
	information120,
	information121,
	information122,
	information123,
	information124,
	information125,
	information126,
	information127,
	information128,
	information129,
	information130,
	information131,
	information132,
	information133,
	information134,
	information135,
	information136,
	information137,
	information138,
	information139,
	information140,
	information141,
	information142,
	information143,
	information144,
	information145,
	information146,
	information147,
	information148,
	information149,
	information150,
	information151,
	information152,
	information153,
	information154,
	information155,
	information156,
	information157,
	information158,
	information159,
	information160,
	information161,
	information162,
	information163,
	information164,
	information165,
	information166,
	information167,
	information168,
	information169,
	information170,
	information171,
	information172,
	information173,
	information174,
	information175,
	information176,
	information177,
	information178,
	information179,
	information180,
	information181,
	information182,
	information183,
	information184,
	information185,
	information186,
	information187,
	information188,
	information189,
	information190,
	information191,
	information192,
	information193,
	information194,
	information195,
	information196,
	information197,
	information198,
	information199,
	information200
  )
  Values
  (	p_rec.pa_history_id,
	p_rec.pa_request_id,
	p_rec.process_date,
	p_rec.nature_of_action_id,
	p_rec.effective_date,
	p_rec.altered_pa_request_id,
	p_rec.person_id,
	p_rec.assignment_id,
	p_rec.dml_operation,
	p_rec.table_name,
	p_rec.pre_values_flag,
	p_rec.information1,
	p_rec.information2,
	p_rec.information3,
	p_rec.information4,
	p_rec.information5,
	p_rec.information6,
	p_rec.information7,
	p_rec.information8,
	p_rec.information9,
	p_rec.information10,
	p_rec.information11,
	p_rec.information12,
	p_rec.information13,
	p_rec.information14,
	p_rec.information15,
	p_rec.information16,
	p_rec.information17,
	p_rec.information18,
	p_rec.information19,
	p_rec.information20,
	p_rec.information21,
	p_rec.information22,
	p_rec.information23,
	p_rec.information24,
	p_rec.information25,
	p_rec.information26,
	p_rec.information27,
	p_rec.information28,
	p_rec.information29,
	p_rec.information30,
	p_rec.information31,
	p_rec.information32,
	p_rec.information33,
	p_rec.information34,
	p_rec.information35,
	p_rec.information36,
	p_rec.information37,
	p_rec.information38,
	p_rec.information39,
	p_rec.information47,
	p_rec.information48,
	p_rec.information49,
	p_rec.information40,
	p_rec.information41,
	p_rec.information42,
	p_rec.information43,
	p_rec.information44,
	p_rec.information45,
	p_rec.information46,
	p_rec.information50,
	p_rec.information51,
	p_rec.information52,
	p_rec.information53,
	p_rec.information54,
	p_rec.information55,
	p_rec.information56,
	p_rec.information57,
	p_rec.information58,
	p_rec.information59,
	p_rec.information60,
	p_rec.information61,
	p_rec.information62,
	p_rec.information63,
	p_rec.information64,
	p_rec.information65,
	p_rec.information66,
	p_rec.information67,
	p_rec.information68,
	p_rec.information69,
	p_rec.information70,
	p_rec.information71,
	p_rec.information72,
	p_rec.information73,
	p_rec.information74,
	p_rec.information75,
	p_rec.information76,
	p_rec.information77,
	p_rec.information78,
	p_rec.information79,
	p_rec.information80,
	p_rec.information81,
	p_rec.information82,
	p_rec.information83,
	p_rec.information84,
	p_rec.information85,
	p_rec.information86,
	p_rec.information87,
	p_rec.information88,
	p_rec.information89,
	p_rec.information90,
	p_rec.information91,
	p_rec.information92,
	p_rec.information93,
	p_rec.information94,
	p_rec.information95,
	p_rec.information96,
	p_rec.information97,
	p_rec.information98,
	p_rec.information99,
	p_rec.information100,
	p_rec.information101,
	p_rec.information102,
	p_rec.information103,
	p_rec.information104,
	p_rec.information105,
	p_rec.information106,
	p_rec.information107,
	p_rec.information108,
	p_rec.information109,
	p_rec.information110,
	p_rec.information111,
	p_rec.information112,
	p_rec.information113,
	p_rec.information114,
	p_rec.information115,
	p_rec.information116,
	p_rec.information117,
	p_rec.information118,
	p_rec.information119,
	p_rec.information120,
	p_rec.information121,
	p_rec.information122,
	p_rec.information123,
	p_rec.information124,
	p_rec.information125,
	p_rec.information126,
	p_rec.information127,
	p_rec.information128,
	p_rec.information129,
	p_rec.information130,
	p_rec.information131,
	p_rec.information132,
	p_rec.information133,
	p_rec.information134,
	p_rec.information135,
	p_rec.information136,
	p_rec.information137,
	p_rec.information138,
	p_rec.information139,
	p_rec.information140,
	p_rec.information141,
	p_rec.information142,
	p_rec.information143,
	p_rec.information144,
	p_rec.information145,
	p_rec.information146,
	p_rec.information147,
	p_rec.information148,
	p_rec.information149,
	p_rec.information150,
	p_rec.information151,
	p_rec.information152,
	p_rec.information153,
	p_rec.information154,
	p_rec.information155,
	p_rec.information156,
	p_rec.information157,
	p_rec.information158,
	p_rec.information159,
	p_rec.information160,
	p_rec.information161,
	p_rec.information162,
	p_rec.information163,
	p_rec.information164,
	p_rec.information165,
	p_rec.information166,
	p_rec.information167,
	p_rec.information168,
	p_rec.information169,
	p_rec.information170,
	p_rec.information171,
	p_rec.information172,
	p_rec.information173,
	p_rec.information174,
	p_rec.information175,
	p_rec.information176,
	p_rec.information177,
	p_rec.information178,
	p_rec.information179,
	p_rec.information180,
	p_rec.information181,
	p_rec.information182,
	p_rec.information183,
	p_rec.information184,
	p_rec.information185,
	p_rec.information186,
	p_rec.information187,
	p_rec.information188,
	p_rec.information189,
	p_rec.information190,
	p_rec.information191,
	p_rec.information192,
	p_rec.information193,
	p_rec.information194,
	p_rec.information195,
	p_rec.information196,
	p_rec.information197,
	p_rec.information198,
	p_rec.information199,
	p_rec.information200
  );

Line: 514


End insert_dml;

Line: 553


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

Line: 557


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

Line: 570


End pre_insert;

Line: 604


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

Line: 614


     ghr_pah_rki.after_insert	(
	p_PA_HISTORY_ID		=>	p_rec.PA_HISTORY_ID		,
	p_PA_REQUEST_ID		=>	p_rec.PA_REQUEST_ID		,
	p_PROCESS_DATE		=>	p_rec.PROCESS_DATE		,
	p_NATURE_OF_ACTION_ID	=>	p_rec.NATURE_OF_ACTION_ID	,
	p_EFFECTIVE_DATE		=>	p_rec.EFFECTIVE_DATE		,
	p_ALTERED_PA_REQUEST_ID	=>	p_rec.ALTERED_PA_REQUEST_ID	,
	p_PERSON_ID			=>	p_rec.PERSON_ID		,
	p_ASSIGNMENT_ID		=>	p_rec.ASSIGNMENT_ID	,
	p_DML_OPERATION		=>	p_rec.DML_OPERATION	,
	p_TABLE_NAME		=>	p_rec.TABLE_NAME	,
	p_PRE_VALUES_FLAG		=>	p_rec.PRE_VALUES_FLAG	,
	p_INFORMATION1		=>	p_rec.INFORMATION1	,
	p_INFORMATION2		=>	p_rec.INFORMATION2	,
	p_INFORMATION3		=>	p_rec.INFORMATION3	,
	p_INFORMATION4		=>	p_rec.INFORMATION4	,
	p_INFORMATION5		=>	p_rec.INFORMATION5	,
	p_INFORMATION6		=>	p_rec.INFORMATION6	,
	p_INFORMATION7		=>	p_rec.INFORMATION7	,
	p_INFORMATION8		=>	p_rec.INFORMATION8	,
	p_INFORMATION9		=>	p_rec.INFORMATION9	,
	p_INFORMATION10		=>	p_rec.INFORMATION10	,
	p_INFORMATION11		=>	p_rec.INFORMATION11	,
	p_INFORMATION12		=>	p_rec.INFORMATION12	,
	p_INFORMATION13		=>	p_rec.INFORMATION13	,
	p_INFORMATION14		=>	p_rec.INFORMATION14	,
	p_INFORMATION15		=>	p_rec.INFORMATION15	,
	p_INFORMATION16		=>	p_rec.INFORMATION16	,
	p_INFORMATION17		=>	p_rec.INFORMATION17	,
	p_INFORMATION18		=>	p_rec.INFORMATION18	,
	p_INFORMATION19		=>	p_rec.INFORMATION19	,
	p_INFORMATION20		=>	p_rec.INFORMATION20	,
	p_INFORMATION21		=>	p_rec.INFORMATION21	,
	p_INFORMATION22		=>	p_rec.INFORMATION22	,
	p_INFORMATION23		=>	p_rec.INFORMATION23	,
	p_INFORMATION24		=>	p_rec.INFORMATION24	,
	p_INFORMATION25		=>	p_rec.INFORMATION25	,
	p_INFORMATION26		=>	p_rec.INFORMATION26	,
	p_INFORMATION27		=>	p_rec.INFORMATION27	,
	p_INFORMATION28		=>	p_rec.INFORMATION28	,
	p_INFORMATION29		=>	p_rec.INFORMATION29	,
	p_INFORMATION30		=>	p_rec.INFORMATION30	,
	p_INFORMATION31		=>	p_rec.INFORMATION31	,
	p_INFORMATION32		=>	p_rec.INFORMATION32	,
	p_INFORMATION33		=>	p_rec.INFORMATION33	,
	p_INFORMATION34		=>	p_rec.INFORMATION34	,
	p_INFORMATION35		=>	p_rec.INFORMATION35	,
	p_INFORMATION36		=>	p_rec.INFORMATION36	,
	p_INFORMATION37		=>	p_rec.INFORMATION37	,
	p_INFORMATION38		=>	p_rec.INFORMATION38	,
	p_INFORMATION39		=>	p_rec.INFORMATION39	,
	p_INFORMATION47		=>	p_rec.INFORMATION47	,
	p_INFORMATION48		=>	p_rec.INFORMATION48	,
	p_INFORMATION49		=>	p_rec.INFORMATION49	,
	p_INFORMATION40		=>	p_rec.INFORMATION40	,
	p_INFORMATION41		=>	p_rec.INFORMATION41	,
	p_INFORMATION42		=>	p_rec.INFORMATION42	,
	p_INFORMATION43		=>	p_rec.INFORMATION43	,
	p_INFORMATION44		=>	p_rec.INFORMATION44	,
	p_INFORMATION45		=>	p_rec.INFORMATION45	,
	p_INFORMATION46		=>	p_rec.INFORMATION46	,
	p_INFORMATION50		=>	p_rec.INFORMATION50	,
	p_INFORMATION51		=>	p_rec.INFORMATION51	,
	p_INFORMATION52		=>	p_rec.INFORMATION52	,
	p_INFORMATION53		=>	p_rec.INFORMATION53	,
	p_INFORMATION54		=>	p_rec.INFORMATION54	,
	p_INFORMATION55		=>	p_rec.INFORMATION55	,
	p_INFORMATION56		=>	p_rec.INFORMATION56	,
	p_INFORMATION57		=>	p_rec.INFORMATION57	,
	p_INFORMATION58		=>	p_rec.INFORMATION58	,
	p_INFORMATION59		=>	p_rec.INFORMATION59	,
	p_INFORMATION60		=>	p_rec.INFORMATION60	,
	p_INFORMATION61		=>	p_rec.INFORMATION61	,
	p_INFORMATION62		=>	p_rec.INFORMATION62	,
	p_INFORMATION63		=>	p_rec.INFORMATION63	,
	p_INFORMATION64		=>	p_rec.INFORMATION64	,
	p_INFORMATION65		=>	p_rec.INFORMATION65	,
	p_INFORMATION66		=>	p_rec.INFORMATION66	,
	p_INFORMATION67		=>	p_rec.INFORMATION67	,
	p_INFORMATION68		=>	p_rec.INFORMATION68	,
	p_INFORMATION69		=>	p_rec.INFORMATION69	,
	p_INFORMATION70		=>	p_rec.INFORMATION70	,
	p_INFORMATION71		=>	p_rec.INFORMATION71	,
	p_INFORMATION72		=>	p_rec.INFORMATION72	,
	p_INFORMATION73		=>	p_rec.INFORMATION73	,
	p_INFORMATION74		=>	p_rec.INFORMATION74	,
	p_INFORMATION75		=>	p_rec.INFORMATION75	,
	p_INFORMATION76		=>	p_rec.INFORMATION76	,
	p_INFORMATION77		=>	p_rec.INFORMATION77	,
	p_INFORMATION78		=>	p_rec.INFORMATION78	,
	p_INFORMATION79		=>	p_rec.INFORMATION79	,
	p_INFORMATION80		=>	p_rec.INFORMATION80	,
	p_INFORMATION81		=>	p_rec.INFORMATION81	,
	p_INFORMATION82		=>	p_rec.INFORMATION82	,
	p_INFORMATION83		=>	p_rec.INFORMATION83	,
	p_INFORMATION84		=>	p_rec.INFORMATION84	,
	p_INFORMATION85		=>	p_rec.INFORMATION85	,
	p_INFORMATION86		=>	p_rec.INFORMATION86	,
	p_INFORMATION87		=>	p_rec.INFORMATION87	,
	p_INFORMATION88		=>	p_rec.INFORMATION88	,
	p_INFORMATION89		=>	p_rec.INFORMATION89	,
	p_INFORMATION90		=>	p_rec.INFORMATION90	,
	p_INFORMATION91		=>	p_rec.INFORMATION91	,
	p_INFORMATION92		=>	p_rec.INFORMATION92	,
	p_INFORMATION93		=>	p_rec.INFORMATION93	,
	p_INFORMATION94		=>	p_rec.INFORMATION94	,
	p_INFORMATION95		=>	p_rec.INFORMATION95	,
	p_INFORMATION96		=>	p_rec.INFORMATION96	,
	p_INFORMATION97		=>	p_rec.INFORMATION97	,
	p_INFORMATION98		=>	p_rec.INFORMATION98	,
	p_INFORMATION99		=>	p_rec.INFORMATION99	,
	p_INFORMATION100		=>	p_rec.INFORMATION100	,
	p_INFORMATION101		=>	p_rec.INFORMATION101	,
	p_INFORMATION102		=>	p_rec.INFORMATION102	,
	p_INFORMATION103		=>	p_rec.INFORMATION103	,
	p_INFORMATION104		=>	p_rec.INFORMATION104	,
	p_INFORMATION105		=>	p_rec.INFORMATION105	,
	p_INFORMATION106		=>	p_rec.INFORMATION106	,
	p_INFORMATION107		=>	p_rec.INFORMATION107	,
	p_INFORMATION108		=>	p_rec.INFORMATION108	,
	p_INFORMATION109		=>	p_rec.INFORMATION109	,
	p_INFORMATION110		=>	p_rec.INFORMATION110	,
	p_INFORMATION111		=>	p_rec.INFORMATION111	,
	p_INFORMATION112		=>	p_rec.INFORMATION112	,
	p_INFORMATION113		=>	p_rec.INFORMATION113	,
	p_INFORMATION114		=>	p_rec.INFORMATION114	,
	p_INFORMATION115		=>	p_rec.INFORMATION115	,
	p_INFORMATION116		=>	p_rec.INFORMATION116	,
	p_INFORMATION117		=>	p_rec.INFORMATION117	,
	p_INFORMATION118		=>	p_rec.INFORMATION118	,
	p_INFORMATION119		=>	p_rec.INFORMATION119	,
	p_INFORMATION120		=>	p_rec.INFORMATION120	,
	p_INFORMATION121		=>	p_rec.INFORMATION121	,
	p_INFORMATION122		=>	p_rec.INFORMATION122	,
	p_INFORMATION123		=>	p_rec.INFORMATION123	,
	p_INFORMATION124		=>	p_rec.INFORMATION124	,
	p_INFORMATION125		=>	p_rec.INFORMATION125	,
	p_INFORMATION126		=>	p_rec.INFORMATION126	,
	p_INFORMATION127		=>	p_rec.INFORMATION127	,
	p_INFORMATION128		=>	p_rec.INFORMATION128	,
	p_INFORMATION129		=>	p_rec.INFORMATION129	,
	p_INFORMATION130		=>	p_rec.INFORMATION130	,
	p_INFORMATION131		=>	p_rec.INFORMATION131	,
	p_INFORMATION132		=>	p_rec.INFORMATION132	,
	p_INFORMATION133		=>	p_rec.INFORMATION133	,
	p_INFORMATION134		=>	p_rec.INFORMATION134	,
	p_INFORMATION135		=>	p_rec.INFORMATION135	,
	p_INFORMATION136		=>	p_rec.INFORMATION136	,
	p_INFORMATION137		=>	p_rec.INFORMATION137	,
	p_INFORMATION138		=>	p_rec.INFORMATION138	,
	p_INFORMATION139		=>	p_rec.INFORMATION139	,
	p_INFORMATION140		=>	p_rec.INFORMATION140	,
	p_INFORMATION141		=>	p_rec.INFORMATION141	,
	p_INFORMATION142		=>	p_rec.INFORMATION142	,
	p_INFORMATION143		=>	p_rec.INFORMATION143	,
	p_INFORMATION144		=>	p_rec.INFORMATION144	,
	p_INFORMATION145		=>	p_rec.INFORMATION145	,
	p_INFORMATION146		=>	p_rec.INFORMATION146	,
	p_INFORMATION147		=>	p_rec.INFORMATION147	,
	p_INFORMATION148		=>	p_rec.INFORMATION148	,
	p_INFORMATION149		=>	p_rec.INFORMATION149	,
	p_INFORMATION150		=>	p_rec.INFORMATION150	,
	p_INFORMATION151		=>	p_rec.INFORMATION151	,
	p_INFORMATION152		=>	p_rec.INFORMATION152	,
	p_INFORMATION153		=>	p_rec.INFORMATION153	,
	p_INFORMATION154		=>	p_rec.INFORMATION154	,
	p_INFORMATION155		=>	p_rec.INFORMATION155	,
	p_INFORMATION156		=>	p_rec.INFORMATION156	,
	p_INFORMATION157		=>	p_rec.INFORMATION157	,
	p_INFORMATION158		=>	p_rec.INFORMATION158	,
	p_INFORMATION159		=>	p_rec.INFORMATION159	,
	p_INFORMATION160		=>	p_rec.INFORMATION160	,
	p_INFORMATION161		=>	p_rec.INFORMATION161	,
	p_INFORMATION162		=>	p_rec.INFORMATION162	,
	p_INFORMATION163		=>	p_rec.INFORMATION163	,
	p_INFORMATION164		=>	p_rec.INFORMATION164	,
	p_INFORMATION165		=>	p_rec.INFORMATION165	,
	p_INFORMATION166		=>	p_rec.INFORMATION166	,
	p_INFORMATION167		=>	p_rec.INFORMATION167	,
	p_INFORMATION168		=>	p_rec.INFORMATION168	,
	p_INFORMATION169		=>	p_rec.INFORMATION169	,
	p_INFORMATION170		=>	p_rec.INFORMATION170	,
	p_INFORMATION171		=>	p_rec.INFORMATION171	,
	p_INFORMATION172		=>	p_rec.INFORMATION172	,
	p_INFORMATION173		=>	p_rec.INFORMATION173	,
	p_INFORMATION174		=>	p_rec.INFORMATION174	,
	p_INFORMATION175		=>	p_rec.INFORMATION175	,
	p_INFORMATION176		=>	p_rec.INFORMATION176	,
	p_INFORMATION177		=>	p_rec.INFORMATION177	,
	p_INFORMATION178		=>	p_rec.INFORMATION178	,
	p_INFORMATION179		=>	p_rec.INFORMATION179	,
	p_INFORMATION180		=>	p_rec.INFORMATION180	,
	p_INFORMATION181		=>	p_rec.INFORMATION181	,
	p_INFORMATION182		=>	p_rec.INFORMATION182	,
	p_INFORMATION183		=>	p_rec.INFORMATION183	,
	p_INFORMATION184		=>	p_rec.INFORMATION184	,
	p_INFORMATION185		=>	p_rec.INFORMATION185	,
	p_INFORMATION186		=>	p_rec.INFORMATION186	,
	p_INFORMATION187		=>	p_rec.INFORMATION187	,
	p_INFORMATION188		=>	p_rec.INFORMATION188	,
	p_INFORMATION189		=>	p_rec.INFORMATION189	,
	p_INFORMATION190		=>	p_rec.INFORMATION190	,
	p_INFORMATION191		=>	p_rec.INFORMATION191	,
	p_INFORMATION192		=>	p_rec.INFORMATION192	,
	p_INFORMATION193		=>	p_rec.INFORMATION193	,
	p_INFORMATION194		=>	p_rec.INFORMATION194	,
	p_INFORMATION195		=>	p_rec.INFORMATION195	,
	p_INFORMATION196		=>	p_rec.INFORMATION196	,
	p_INFORMATION197		=>	p_rec.INFORMATION197	,
	p_INFORMATION198		=>	p_rec.INFORMATION198	,
	p_INFORMATION199		=>	p_rec.INFORMATION199	,
	p_INFORMATION200		=>	p_rec.INFORMATION200
	);

Line: 837


End post_insert;

Line: 854


  ghr_pah_bus.insert_validate(p_rec);

Line: 858


  pre_insert(p_rec);

Line: 862


  insert_dml(p_rec);

Line: 866


  post_insert(p_rec);