1 package PAYUSUNB_PKG as
2 /* $Header: payusunb.pkh 120.0.12010000.1 2008/07/27 21:56:38 appldev ship $ */
3 /*
4 ******************************************************************
5 * *
6 * Copyright (C) 1999 Oracle Corporation Ltd., *
7 * Redwood Shores, California. *
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 Ltd, *
18 * Redwood Shores, California, USA. *
19 * *
20 * *
21 ******************************************************************
22 Change List
23 -----------
24 Date Name Vers Bug No Description
25 ----------- ---------- ----- ------- -----------------------------------
26 29-SEP-1999 mcpham 110.0 Created.
27 26-NOV-2001 meshah 115.1 added dbdrv command.
28 06-DEC-2002 tclewis 115.2 added NOCOPY directive.
29 25-JUN-2003 vinaraya 115.4 Changed the prc_process_data
30 procedure declaration.
31 30-JUN-2003 vinaraya 115.5 2963239 Removed the function
32 fnc_get_ptd_start_dt and pragma
33 restrict references.
34 --
35 */
36 PROCEDURE range_cursor ( IN_pactid IN NUMBER,
37 OUT_sqlstr OUT NOCOPY VARCHAR2
38 );
39 PROCEDURE action_creation ( IN_pactid IN NUMBER,
40 IN_stperson IN NUMBER,
41 IN_endperson IN NUMBER,
42 IN_chunk IN NUMBER
43 );
44 PROCEDURE sort_action ( IN_payactid IN VARCHAR2,
45 IO_sqlstr IN OUT NOCOPY VARCHAR2,
46 OUT_len OUT NOCOPY NUMBER
47 );
48 FUNCTION fnc_get_parameter(IN_name IN VARCHAR2,
49 IN_parameter_list IN VARCHAR2) RETURN VARCHAR2;
50 PROCEDURE prc_process_data( IN_pact_id IN pay_payroll_actions.payroll_action_id%TYPE,
51 IN_chunk_no IN NUMBER,
52 IN_commit_count IN NUMBER DEFAULT 1000,
53 IN_prc_lockingactid IN pay_assignment_actions.assignment_action_id%TYPE,
54 IN_prc_lockedactid IN pay_assignment_actions.assignment_action_id%TYPE,
55 IN_prc_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
56 IN_prc_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE,
57 IN_prc_person_id IN per_all_assignments_f.person_id%TYPE,
58 IN_prc_location_id IN per_all_assignments_f.location_id%TYPE,
59 IN_prc_organization_id IN per_all_assignments_f.organization_id%TYPE,
60 IN_prc_assignment_number IN per_all_assignments_f.assignment_number%TYPE );
61 --
62 END PAYUSUNB_PKG;