[Home] [Help]
PACKAGE: APPS.PAY_MAINTAIN_BANK_ACCT
Source
1 Package PAY_MAINTAIN_BANK_ACCT as
2 /* $Header: pymntbnk.pkh 120.3 2006/08/31 12:19:51 pgongada noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-------------------------< UPDATE_PAYROLL_BANK_ACCT >-----------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 --
12 -- Prerequisites:
13 --
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 --
18 --
19 -- Post Success:
20 --
21 -- Name Type Description
22 --
23 --
24 -- Post Failure:
25 --
26 --
27 -- Access Status:
28 -- Internal Development Use Only.
29 --
30 -- {End Of Comments}
31 --
32 Procedure update_payroll_bank_acct(
33 p_bank_account_id IN number,
34 p_external_account_id IN NUMBER,
35 p_org_payment_method_id IN number
36 );
37
38 procedure remove_redundant_bank_detail;
39
40 procedure get_payment_details(
41 p_payment_id in number,
42 p_voided_payment in boolean,
43 p_pay_currency_code out nocopy varchar2,
44 p_recon_currency_code out nocopy varchar2,
45 p_value out nocopy varchar2,
46 p_base_currency_value out nocopy number,
47 p_action_status out nocopy varchar2,
48 p_business_group_Id out nocopy number
49 );
50
51 function chk_bank_row_exists(
52 p_external_account_id in number
53 ) return varchar2;
54
55 procedure get_chart_of_accts_and_sob
56 (
57 p_external_account_id in number,
58 p_char_of_accounts_id out nocopy number,
59 p_set_of_books_id out nocopy number,
60 p_name out nocopy varchar2,
61 p_asset_ccid out nocopy number
62 );
63
64 procedure update_asset_ccid
65 (
66 p_assest_ccid in number,
67 p_set_of_books_id in number,
68 p_external_account_id in number
69 );
70
71 Function get_sob_id
72 (
73 p_org_payment_method_id in number
74 ) return number;
75
76
77 function chk_account_exists
78 (
79 p_org_payment_method_id in number,
80 p_validation_start_date in date,
81 p_validation_end_date in date
82 )return boolean;
83
84 procedure lock_row
85 (
86 p_external_account_id in number
87 );
88
89 procedure get_bank_details
90 (
91 p_external_account_id in number,
92 p_bank_account_id out nocopy number,
93 p_bank_account_name out nocopy varchar2
94 );
95 --
96 end PAY_MAINTAIN_BANK_ACCT;