1 package hr_gen_pkg AUTHID CURRENT_USER as
2 /* $Header: hrgen.pkh 115.6 2004/05/12 04:05:23 njaladi ship $ */
3 ------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1994 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 Name
11 HR Libraries server-side agent
12 Purpose
13 Agent handles all server-side traffic to and from forms libraries. This
14 is particularly necessary because we wish to avoid the situation where
15 a form and its libraries both refer to the same server-side package.
16 Forms/libraries appears to be unable to cope with this situation in
17 circumstances which we cannot yet define.
18 History
19 21 Apr 95 N Simpson Created
20 17 May 95 N Simpson Added comment_text, insert_comment
21 and get_customized_restriction to
22 remove all sql from client side, and
23 thus allow the library to be made
24 global.
25 14 Jun 95 N Simpson Added change_ses_date, get_dates
26 23 Jun 95 D Kerr Added bg_name and bg_currency_code to
27 to init_forms and temporary overload.
28 20 Dec 96 D Kerr Removed temporary overload
29 Changes to init_forms interface
30 Added tracing procedures.
31 19 Aug 97 Sxshah Banner now on eack line.
32 24 Dec 97 D Kerr Added delete_ses_rows
33 17 Feb 99 D Kerr 11.5:Added overload for get_dates
34
35 05 Dec 99 Dave Kerr This file now diverges from 11.0 version
36 init_forms: added p_hr_trace_dest param
37 Cover for hr_utility.set_trace_options.
38 18 Jul 01 M Enderby Addition of ADE related pipe code
39 05 Feb 02 G Sayers Added dbdrv and commit to comply with
40 GSCC standards.
41 03-Dec-02 A.Holt NOCOPY Performance Changes for 11.5.9
42 12-May-04 njaladi 3577964- Added new autonomous transactin wrapper
43 procedure putSessionAttributeValue which calls
44 the icx_sec.putSessionAttributeValue.
45 */
46 PROCEDURE init_forms(
47 --
48 p_business_group_id IN NUMBER,
49 p_short_name OUT NOCOPY VARCHAR2,
50 p_bg_name OUT NOCOPY VARCHAR2,
51 p_bg_currency_code OUT NOCOPY VARCHAR2,
52 p_legislation_code OUT NOCOPY VARCHAR2,
53 p_session_date IN OUT NOCOPY DATE,
54 p_ses_yesterday OUT NOCOPY DATE,
55 p_start_of_time OUT NOCOPY DATE,
56 p_end_of_time OUT NOCOPY DATE,
57 p_sys_date OUT NOCOPY DATE,
58 p_enable_hr_trace IN BOOLEAN,
59 p_hr_trace_dest IN VARCHAR2 DEFAULT 'DBMS_PIPE'
60 /* This code not yet implemented
61 ,p_form_name varchar2 default null
62 ,p_actual_version varchar2 default null*/
63 );
64 --
65 procedure get_customized_restriction (
66 --
67 p_restriction_name in varchar2,
68 p_form_name in varchar2,
69 p_business_group_id in number,
70 p_legislation_code in varchar2,
71 p_application_id out nocopy number,
72 p_query_title out nocopy varchar2,
73 p_standard_title out nocopy varchar2,
74 p_customized_restriction_id out nocopy number,
75 p_message_name out nocopy varchar2);
76 --
77 procedure insert_comment (
78 --
79 p_source_table_name varchar2,
80 p_comment_text varchar2,
81 p_comment_id in out nocopy number);
82 --
83 function comment_text (p_comment_id number) return varchar2;
84 --
85 procedure get_dates(
86 p_ses_date out nocopy date,
87 p_ses_yesterday_date out nocopy date,
88 p_start_of_time out nocopy date,
89 p_end_of_time out nocopy date,
90 p_sys_date out nocopy date,
91 p_commit out nocopy number);
92
93 procedure get_dates(
94 p_ses_date out nocopy date,
95 p_ses_yesterday_date out nocopy date,
96 p_start_of_time out nocopy date,
97 p_end_of_time out nocopy date,
98 p_sys_date out nocopy date);
99 --
100 procedure change_ses_date (
101 p_ses_date date,
102 p_commit out nocopy number);
103 --
104 procedure delete_ses_rows ;
105 --
106 procedure trace_on(trace_mode in varchar2,session_identifier in varchar2);
107 procedure trace_off;
108 procedure trace(trace_data in varchar2) ;
109 procedure set_location(procedure_name in varchar2, stage in number) ;
110 procedure set_trace_options(p_options in varchar2) ;
111 procedure pipe_ade_detail(p_detail IN varchar2);
112 procedure reset_pipe_buffer;
113 procedure purge_pipe(p_pipename IN varchar2);
114 procedure send_pipe_message(p_pipename IN varchar2);
115
116 procedure putSessionAttributeValue ( p_name in varchar2,
117 p_value in varchar2,
118 p_session_id in number);
119
120 end hr_gen_pkg;