1 PACKAGE PAY_US_ADHOC_UTILS as
2 /* $Header: pyusdisc.pkh 120.2 2005/06/03 06:49:46 sdhole noship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1993 Oracle Corporation. *
7 * All rights reserved. *
8 * *
9 * This material has been provided pursuant to an agreement *
10 * containing restrictions on its use. The material is also *
11 * protected by copyright law. No part of this material may *
12 * be copied or distributed, transmitted or transcribed, in *
13 * any form or by any means, electronic, mechanical, magnetic, *
14 * manual, or otherwise, or disclosed to third parties without *
15 * the express written permission of Oracle Corporation, *
16 * 500 Oracle Parkway, Redwood City, CA, 94065. *
17 * *
18 ******************************************************************
19
20
21 Name : PAY_US_ADHOC_UTILS
22
23 Description : This package is created for the discoverer W2
24 (Year End) Reporting purpose for getting the
25 details about common pay agent, locality name
26 In future we can use the same package by adding
27 more functions, for the other reporting purpose.
28
29 Change List
30 -----------
31 Date Name Vers Bug No Description
32 ----------- ---------- ------ ------- -----------------------------------
33 09-NOV-2004 sdhole 115.0 Created.
34 09-NOV-2004 sdhole 115.1 Added function
35 get_secprofile_bg_id.
36 26-APR-2005 sdhole 115.3 4226022 Removed the code added in 115.2
37 version and it has been moved
38 to PAY_ADHOC_UTILS_PKG.
39 26-APR-2005 sdhole 115.4 4226022 Added global valrables and function
40 get_balance_valid_load_date
41 30-MAY-2005 sdhole 115.5 4400526 Modified get_balance_valid_load_date
42 function.
43 03-JUN-2005 sdhole 115.6 4400526 Code for the function
44 get_balance_valid_load_date moved to
45 PAY_ADHOC_UTILS_PKG. No longer needed
46 in US utils package.
47 ---------------------------------------------------------------------------
48 */
49 --
50 --
51 function get_locality_name(p_tax_type VARCHAR2,
52 p_state_abbrev VARCHAR2,
53 p_assig_action_id NUMBER,
54 p_locality_name VARCHAR2,
55 p_jurisdiction VARCHAR2) return varchar2;
56 --
57 --
58 function get_common_pay_agent_id(p_year varchar2) return number;
59 --
60 --
61 function get_commonpay_agent_details(p_year varchar2,
62 p_commonpay_agent_id number,
63 p_type varchar2) return varchar2 ;
64 --
65 --
66 FUNCTION get_secprofile_bg_id
67 RETURN per_security_profiles.business_group_id%TYPE;
68 --
69 --
70 END PAY_US_ADHOC_UTILS;