APPS.HR_GEN_PKG SQL Statements

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

Line: 19

	17 May 95	N Simpson	Added comment_text, insert_comment
					and get_customized_restriction to
					remove all sql from client side, and
					thus allow the library to be made
					global.
	05-JUN-1995	N Simpson	Modified legislation/business group
					restriction on
					get_customized_restriction.
	14 Jun 95	N Simpson	Added get_dates, change_ses_date
	23 Jun 95       D Kerr		Added bg_name and bg_currency_code
					to init_forms and temporary overload.
        11 Oct 95       J Thuringer     Removed spurious end of comment marker
	20 Dec 96       D Kerr		init_forms: Removed temp. overload.
				        Modified in line with changes to
					underlying procedure.
					Added tracing procedures.
	19 Aug 97	Sxshah	        Banner now on eack line.
	24 Dec 97	D Kerr          Added delete_ses_rows
        17-FEB-99       D Kerr          11.5: added get_dates overload

        05 Dec 99       Dave Kerr       This file now diverges from 11.0 version
                                        Added p_hr_trace_dest to init_forms
        06 Jul 00       G Perry         Changed comment text to 32000 for
                                        WWBUG 1382371.
        17 Jul 01       M Enderby       Addition of ADE related pipe code
        05 Feb 02       G Sayers        Added dbdrv and commit to comply with
                                        GSCC Standards.
        05-Dec-2002     A.Holt          NOCOPY Performance Changes for 11.5.9
	01-Jul-2003     tvankayl        procedure Get_customized_restriction modified
					to take values from PAY_CUSTOM_RESTRICTIONS_VL instead of
					PAY_CUSTOMIZED_RESTRICTIONS.
 115.10 21-Nov-2003     vramanai        Modified message name in Procedure
                                        Get_Customized_Restriction to
                                        HR_7070_CUST_INVALID_CUST_NAME .
 115.11 12-May-2003    njaladi          3577964- Added new autonomous transactin wrapper
                                        procedure putSessionAttributeValue which calls
                                        the icx_sec.putSessionAttributeValue.

*/
g_dummy	number;	-- Used in various places throughout the package

Line: 113

	select	application_id,
		query_form_title,
		standard_form_title,
		enabled_flag,
		customized_restriction_id
	from	pay_custom_restrictions_vl
	where	name = p_restriction_name
	and	form_name = p_form_name
	and	(business_group_id = p_business_group_id
		or business_group_id is null)
	and 	(legislation_code = p_legislation_code
		or legislation_code is null);

Line: 127

	select	1
	from	pay_customized_restrictions
	where	name = p_restriction_name;

Line: 194

procedure insert_comment (
--
-- Inserts a comment into the HR comments table
--
	--
	p_source_table_name	varchar2,
	p_comment_text		varchar2,
	p_comment_id		in out nocopy number) is
--
cursor csr_next_comment_id is
	select	hr_comments_s.nextval
	from	sys.dual;

Line: 213

insert into hr_comments (
	--
	comment_id,
	source_table_name,
	comment_text)
values (
	p_comment_id,
	p_source_table_name,
	p_comment_text);

Line: 223

end insert_comment;

Line: 230

	select	comment_text
	from	hr_comments
	where	comment_id = p_comment_id;

Line: 302

procedure delete_ses_rows is
  v_commit number;

Line: 305

  dt_fndate.delete_ses_rows(p_commit => v_commit);

Line: 309

end delete_ses_rows ;