[Home] [Help]
PACKAGE: APPS.HR_PASSED_SQL
Source
1 PACKAGE HR_PASSED_SQL AS
2 /* $Header: hrpsdsql.pkh 120.1.12010000.1 2008/07/28 03:42:12 appldev ship $ */
3 --
4 --------------------------------------------------------------------------------
5 -- FUNCTION: GET_PASSED_SQL_ID --
6 -- --
7 -- DESCRIPTION: Inserts Query into Parameters tables, and a --
8 -- session date. --
9 -- --
10 -- PARAMETERS: WHERE clause - query to be executed by HR SQL Control --
11 -- Session Date - date to be used by HR SQL Control --
12 -- --
13 -- --
14 -- --
15 -- RETURN: parameter list id. --
16 -- --
17 -- MODIFICATION HISTORY --
18 -- Date Username Description --
19 -- 10-JUL-02 smcmilla CREATED --
20 --------------------------------------------------------------------------------
21 --
22 --
23 FUNCTION GET_PASSED_SQL_ID(p_where_clause in VARCHAR2
24 ,p_session_date in VARCHAR2
25 ,p_form_name in VARCHAR2 default null) RETURN VARCHAR2;
26
27 END HR_PASSED_SQL;