PACKAGE: APPS.PAY_MAINTAIN_BANK_ACCT

Source

1 Package PAY_MAINTAIN_BANK_ACCT AUTHID CURRENT_USER 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;