[Home] [Help]
PACKAGE: APPS.HRUSERDT
Source
1 package hruserdt AUTHID CURRENT_USER as
2 /* $Header: pyuserdt.pkh 115.4 2002/07/17 11:30:52 alogue ship $ */
3 --
4 /*
5 --
6 -- Copyright (c) Oracle Corporation 1991,1992,1993. All rights reserved
7 /*
8 PRODUCT
9 Oracle*Payroll
10 --
11 NAME
12 pyuserdt.pkh - Function for retrieving from USER Defined Tables
13 --
14 DESCRIPTION
15 --
16 MODIFIED (DD-MON-YYYY)
17 mwcallag 12-NOV-1993 - Created (G37).
18 wkerr 03-Mar-1999 - Added PRAGMA for use in euro work
19 ccarter 12-OCT-1999 - Bug 1027169, removed pragma restriction
20 from get_table_value
21 vborhade 10-JUL-2002 - Added function get_row_value
22 alogue 17-JUL-2002 - Added set_g_effective_date and
23 unset_g_effective_date procedures.
24 Remove get_row_value function.
25
26 */
27 procedure set_g_effective_date(p_effective_date in date);
28
29 procedure unset_g_effective_date;
30
31 function get_table_value (p_bus_group_id in number,
32 p_table_name in varchar2,
33 p_col_name in varchar2,
34 p_row_value in varchar2,
35 p_effective_date in date default null)
36 return varchar2;
37
38 --
39 --PRAGMA RESTRICT_REFERENCES(get_table_value,WNDS);
40 --
41 END hruserdt;