1 PACKAGE pay_us_payment_pkg AS
2 /* $Header: pyuspymt.pkh 120.0 2005/05/29 09:52:53 appldev noship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 2005 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 Name : pay_us_payment_pkg
21
22 Description : This package contains the function get_trx_date to
23 fetch the payment date.
24
25 Change List
26 -----------
27 Date Name Vers Bug No Description
28 ----------- ---------- ------ ------- -------------------------
29 27-APR-2005 rsethupa 115.0 Created
30
31 *****************************************************************
32
33 ****************************************************************************
34 Function Name: get_trx_date
35 Description: Returns the Payment Date for a Check Payroll Action
36 ***************************************************************************/
37 FUNCTION get_trx_date (
38 p_business_group_id pay_payroll_actions.business_group_id%TYPE,
39 p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,
40 p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
41 DEFAULT NULL,
42 p_payroll_id pay_payroll_actions.payroll_id%TYPE
43 DEFAULT NULL,
44 p_consolidation_set_id pay_payroll_actions.consolidation_set_id%TYPE
45 DEFAULT NULL,
46 p_org_payment_method_id pay_payroll_actions.org_payment_method_id%TYPE
47 DEFAULT NULL,
48 p_effective_date pay_payroll_actions.effective_date%TYPE
49 DEFAULT NULL,
50 p_date_earned pay_payroll_actions.date_earned%TYPE
51 DEFAULT NULL,
52 p_override_date pay_payroll_actions.overriding_dd_date%TYPE
53 DEFAULT NULL,
54 p_pre_payment_id pay_pre_payments.pre_payment_id%TYPE
55 DEFAULT NULL,
56 p_payment_date pay_payroll_actions.effective_date%TYPE
57 DEFAULT NULL
58 )
59 RETURN DATE;
60
61 TYPE override_date_record IS RECORD (
62 payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,
63 override_date pay_payroll_actions.overriding_dd_date%TYPE
64 );
65
66 TYPE override_date_table IS TABLE OF override_date_record
67 INDEX BY BINARY_INTEGER;
68
69 ltr_override_date_table override_date_table;
70 END;