[Home] [Help]
PACKAGE: APPS.PAY_SA_TRAN_IDENTIFIERS
Source
1 PACKAGE pay_sa_tran_identifiers AUTHID CURRENT_USER AS
2 /* $Header: pysatran.pkh 120.1 2010/05/05 05:09:00 bkeshary noship $ */
3
4
5
6 --------------------------------------------------------------------------
7 -- --
8 -- Name : GET_EFT_RECON_DATA --
9 -- Type : FUNCTION --
10 -- Access : Public --
11 -- Description : Function to identify the batch transaction --
12 -- identifiers for reconciliation --
13 -- --
14 -- Parameters : --
15 -- IN : p_effective_date DATE --
16 -- p_identifier_name VARCHAR2 --
17 -- p_payroll_action_id NUMBER --
18 -- p_payment_type_id NUMBER --
19 -- p_org_payment_method_id NUMBER --
20 -- p_personal_payment_method_id NUMBER --
21 -- p_assignment_action_id NUMBER --
22 -- p_pre_payment_id NUMBER --
23 -- p_delimiter_string VARCHAR2 --
24 -- --
25 -- OUT : N/A --
26 -- --
27 -- Change History : --
28 --------------------------------------------------------------------------
29 -- Rev# Date Userid Description --
30 --------------------------------------------------------------------------
31 -- 12.0 17-Jul-2009 bkeshary Initial Version --
32 --------------------------------------------------------------------------
33 FUNCTION get_eft_recon_data(p_effective_date DATE,
34 p_identifier_name VARCHAR2,
35 p_payroll_action_id NUMBER,
36 p_payment_type_id NUMBER,
37 p_org_payment_method_id NUMBER,
38 p_personal_payment_method_id NUMBER,
39 p_assignment_action_id NUMBER,
40 p_pre_payment_id NUMBER,
41 p_delimiter_string VARCHAR2) RETURN VARCHAR2;
42 END pay_sa_tran_identifiers;