1 package hr_payments AUTHID CURRENT_USER as
2 /* $Header: pypaymnt.pkh 120.1 2011/06/27 09:43:52 kskoduri noship $ */
3 /*
4 * ---------------------------------------------------------------------------
5 Copyright (c) Oracle Corporation (UK) Ltd 1992.
6 All Rights Reserved.
7 --
8 --
9 PRODUCT
10 Oracle*Payroll
11 NAME
12 hr_payments (hrppm.pkh)
13 NOTES
14 Pre-payments validation procedures. Deals with DDL on:
15 PAY_PAYMENT_TYPES
16 PAY_ORG_PAYMENT_METHODS
17 PAY_ORG_PAY_METHOD_USAGES
18 PAY_PERSONAL_PAYMENT_METHODS
19 PROCEDURES
20 ppt_brui
21 MODIFIED
22
23 amcinnes 14-JUN-1993 Changes for change to PPT that whoever
24 changed it should have done.
25 amcinnes 20-DEC-1992 Added all other payments procedures
26 amcinnes 16-NOV-1992 Created with ppt_brui
27 rneale 20-JUN-1994 Added match_currency.
28 nbristow 24-OCT-1994 Added Header line
29 kskoduri 14-JUN-2011 Added new function to validate if prepayments
30 exist before updating the ppm via selfservice
31 kskoduri 27-JUN-2011 Added NOCOPY hint to remove the GSCC failure
32 --
33 * ---------------------------------------------------------------------------
34 */
35 --
36 procedure ppt_brui(allow_as_default in varchar2,
37 category in varchar2,
38 pre_validation_required in varchar2,
39 validation_days in number,
40 validation_value in varchar2);
41 --
42 procedure match_currency(type in varchar2,
43 opm_currency in varchar2,
44 def_balance in varchar2);
45 --
46 function check_account(account in varchar2, type in varchar2)
47 return boolean;
48 --
49 function check_currency(type in varchar2, opm_currency in varchar2)
50 return boolean;
51 --
52 function gen_balance(leg_code in varchar2)
53 return number;
54 --
55 function check_prepay(opm_id in number, val_start_date in varchar2)
56 return boolean;
57 --
58 function check_ppm(val_start_date in varchar2, opm_id in varchar2)
59 return boolean;
60 --
61 function check_default(opm_id in varchar2, val_start_date in varchar2)
62 return boolean;
63 --
64 --
65 function check_amt(percent in varchar2, amount in varchar2) return boolean;
66 --
67 function mt_checks(opm_id in varchar2,
68 val_start_date in varchar2,
69 account_id in varchar2) return boolean;
70 --
71 function unique_priority(in_priority in varchar2,
72 val_start_date in varchar2,
73 val_end_date in varchar2,
74 assignment in varchar2) return boolean;
75 --
76 function check_pp(ppm_id in varchar2,
77 val_start_date in varchar2) return boolean;
78 --
79 /*Added for bug 10392383*/
80 procedure check_ppm(trans_step_id in varchar2,
81 status out nocopy varchar2);
82 --
83 end hr_payments;