PACKAGE: APPS.PAY_CE_SUPPORT_PKG

Source

1 package pay_ce_support_pkg AUTHID CURRENT_USER as
2 /* $Header: pyceinsp.pkh 115.4 2002/03/08 10:48:54 pkm ship     $ */
3 
4 --  name
5 --    bank_segment_value
6 --
7 --  description
8 --    returns value of bank flexfield segment based on segment name
9 --    and legislation code.
10 --
11 --  parameters
12 --    p_external_account_id   bank account id. primary key
13 --                            of table pay_external_accounts
14 --    p_lookup_type           name of bank flexfield segment (e.g. 'BANK_NAME')
15 --    p_legislation_code      two letter legislation code ('US', 'GB' etc.)
16 
17 function bank_segment_value(
18   p_external_account_id in number,
19   p_lookup_type         in varchar2,
20   p_legislation_code    in varchar2) return varchar2;
21 
22 pragma restrict_references(bank_segment_value, wnds);
23 
24 
25 -- name
26 --   pay_and_ce_licensed
27 --
28 -- description
29 --   returns true if both ce and pay are licensed on the
30 --   database.
31 --
32 -- parameters
33 --   none
34 
35 function pay_and_ce_licensed return boolean;
36 
37 
38 -- name
39 --   session_date
40 --
41 -- description
42 --   returns effective date of current session
43 --
44 -- parameters
45 --   none
46 
47 function session_date return date;
48 
49 pragma restrict_references(session_date, wnds, wnps);
50 
51 
52 -- name
53 --   payment_status
54 --
55 -- description
56 --   returns status of specified payment (reconciled, errored, etc.)
57 --
58 -- parameters
59 --   p_payment_id  payment identifier (assignment_action_id)
60 
61 function payment_status(p_payment_id in number) return varchar2;
62 
63 function lookup_meaning(p_meaning in varchar2, p_code in varchar2) return varchar2;
64 
65 
66 end pay_ce_support_pkg;