1 package pay_chqwrt_pkg as
2 /* $Header: pychqwrt.pkh 120.0.12010000.1 2008/07/27 22:20:16 appldev ship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1992 Oracle Corporation UK Ltd., *
7 * Chertsey, England. *
8 * *
9 * All rights reserved. *
10 * *
11 * This material has been provided pursuant to an agreement *
12 * containing restrictions on its use. The material is also *
13 * protected by copyright law. No part of this material may *
14 * be copied or distributed, transmitted or transcribed, in *
15 * any form or by any means, electronic, mechanical, magnetic, *
16 * manual, or otherwise, or disclosed to third parties without *
17 * the express written permission of Oracle Corporation UK Ltd, *
18 * Oracle Park, Bittams Lane, Guildford Road, Chertsey, Surrey, *
19 * England. *
20 * *
21 ******************************************************************
22
23 Name : chqsql
24
25 Description : Build dynamic sql for cheque writer process.
26
27 Test List
28 ---------
29
30 Change List
31 -----------
32 Date Name Vers Bug No Description
33 ----------- ---------- ----- ------- -----------------------------------
34 12-OCT-1993 CLEVERLY 1.0 First created.
35 05-OCT-1994 RFINE 40.4 Renamed package to pay_chqwrt_pkg
36 06-Dec-2004 SuSivasu 115.1 Added cheque_date function.
37 10-Dec-2004 SuSivasu 115.2 Removed cheque_date function.
38 */
39
40 ---------------------------------- chqsql ----------------------------------
41 /*
42 NAME
43 chqsql - build dynamic sql.
44 DESCRIPTION
45 selects a SQL statement with the correct ordering of pre-payments
46 so that cheque numbers are allocated and printed in the correct
47 sequence for the organisation.
48 NOTES
49 <none>
50 */
51 procedure chqsql
52 (
53 procname in varchar2, /* name of the select statement to use */
54 sqlstr in out nocopy varchar2, /* string holding the sql statement */
55 len out nocopy number /* length of the sql string */
56 );
57
58
59 --------------------------------- cheque_date ------------------------------
60 /*
61 NAME
62 cheque_date - derives the cheque date.
63 DESCRIPTION
64 Returns the cheque date based on the select payment
65 NOTES
66 <none>
67 */
68 -- function cheque_date
69 -- (
70 -- p_business_group_id in number,
71 -- p_payroll_id in number,
72 -- p_consolidation_set_id in number,
73 -- p_start_date in date,
74 -- p_end_date in date,
75 -- p_payment_type_id in number,
76 -- p_payment_method_id in number,
77 -- p_cheque_style in varchar2
78 -- ) return date;
79
80 end pay_chqwrt_pkg;