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;