[Home] [Help]
PACKAGE: APPS.PAY_CE_RECONCILIATION_PKG
Source
1 package pay_ce_reconciliation_pkg as
2 /* $Header: pycerecn.pkh 120.0 2005/05/29 03:57:50 appldev noship $ */
3
4 -- name
5 -- reconcile_payment
6 --
7 -- description
8 -- called from Oracle Cash Management to reconcile payments
9 -- from Oracle Payroll
10 --
11 -- parameters
12 -- p_payment_id payment identifier to reconcile (assignment_action_id)
13 -- p_cleared_date clearing date from bank statement
14 -- p_trx_amount transaction amount (actual amount of payment)
15 -- p_trx_type transaction type (PAYMENT or STOP)
16 -- p_last_updated_by standard who column
17 -- p_last_update_login standard who column
18 -- p_created_by standard who column
19
20 procedure reconcile_payment(p_payment_id number,
21 p_cleared_date date,
22 p_trx_amount number,
23 p_trx_type varchar2,
24 p_last_updated_by number,
25 p_last_update_login number,
26 p_created_by number);
27
28 -- name
29 -- update_reconciled_payment
30 --
31 -- description
32 -- marks payment as reconciled by insertion into pay_ce_reconciled_payments
33 --
34 -- parameters
35 -- p_payment_id payment identifier to reconcile (assignment_action_id)
36 -- p_trx_amount transaction amount (actual amount of payment)
37 -- p_base_trx_amount transaction amount in bank base currency
38 -- p_trx_type transaction type (PAYMENT or STOP)
39 -- to previously reconciled payment
40 -- p_cleared_date clearing date from bank statement
41 -- p_payment_status ('C' or 'E') to indicate cleared (reconciled) or error
42
43 procedure update_reconciled_payment(p_payment_id number,
44 p_trx_amount number,
45 p_base_trx_amount number,
46 p_trx_type varchar2,
47 p_cleared_date date,
48 p_payment_status varchar2);
49
50
51 -- name
52 -- reverse_reconcile
53 --
54 -- description
55 -- unreconciles a previously reconciled payment
56 --
57 -- parameters
58 -- p_payment_id payment identifier to unreconcile (assignment_action_id)
59
60 procedure reverse_reconcile(p_payment_id number);
61
62
63 -- name
64 -- payment_reconciled
65 --
66 -- description
67 -- returns true if specified payment has been reconciled
68 --
69 -- parameters
70 -- p_payment_id payment identfier (assignment_action_id)
71
72 function payment_reconciled(p_payment_id number) return boolean;
73
74 -- name
75 -- payment_transaction_info
76 --
77 -- description
78 -- returns the value associated with the identifier
79 --
80 -- parameters
81 -- p_effective_date - Effective date of the payroll action.
82 -- p_identifier_name - Identifier's name
83 -- p_payroll_action_id - Payroll action identifier
84 -- p_payment_type_id - Payment type identifier
85 -- p_org_payment_method_id - Organization payment method identifier
86 -- p_personal_payment_method_id - Personal Payment method identifier
87 -- p_assignment_action_id - Assignment Action identifier for the mag tape process
88 -- p_pre_payment_id - Pre Payment identifier
89 -- p_delimeter_string - Delimiter string to be used for concatenated identifier.
90
91 function payment_transaction_info(p_effective_date date,
92 p_identifier_name varchar2,
93 p_payroll_action_id number,
94 p_payment_type_id number,
95 p_org_payment_method_id number,
96 p_personal_payment_method_id number,
97 p_assignment_action_id number,
98 p_pre_payment_id number,
99 p_delimiter_string varchar2 default '/') return varchar2;
100
101 function payinfo(p_identifier varchar2,
102 p_assignment_action_id number)
103 return varchar2;
104 --
105 end pay_ce_reconciliation_pkg;