1 package PAY_PAYMENT_GL_ACCOUNTS_PKG as
2 /* $Header: pypga01t.pkh 120.0 2005/09/29 10:52 tvankayl noship $ */
3
4 procedure INSERT_ROW (
5 P_PAY_GL_ACCOUNT_ID OUT NOCOPY NUMBER,
6 P_EFFECTIVE_START_DATE in DATE,
7 P_EFFECTIVE_END_DATE in DATE,
8 P_SET_OF_BOOKS_ID in NUMBER,
9 P_GL_CASH_AC_ID in NUMBER,
10 P_GL_CASH_CLEARING_AC_ID in NUMBER,
11 P_GL_CONTROL_AC_ID in NUMBER,
12 P_GL_ERROR_AC_ID in NUMBER,
13 P_EXTERNAL_ACCOUNT_ID in NUMBER,
14 P_ORG_PAYMENT_METHOD_ID in NUMBER,
15 P_DEFAULT_GL_ACCOUNT in VARCHAR2);
16
17 procedure UPDATE_ROW (
18 P_EFFECTIVE_START_DATE in DATE,
19 P_EFFECTIVE_END_DATE in DATE,
20 P_SET_OF_BOOKS_ID in NUMBER,
21 P_GL_CASH_AC_ID in NUMBER,
22 P_GL_CASH_CLEARING_AC_ID in NUMBER,
23 P_GL_CONTROL_AC_ID in NUMBER,
24 P_GL_ERROR_AC_ID in NUMBER,
25 P_EXTERNAL_ACCOUNT_ID in NUMBER,
26 P_ORG_PAYMENT_METHOD_ID in NUMBER,
27 P_DT_UPDATE_MODE in VARCHAR2,
28 P_DEFAULT_GL_ACCOUNT in VARCHAR2,
29 P_PAY_GL_ACCOUNT_ID_OUT OUT NOCOPY NUMBER );
30
31
32 procedure DELETE_ROW (
33 p_org_payment_method_id in NUMBER
34 ,p_effective_date in DATE
35 ,p_datetrack_mode in VARCHAR2
36 ,p_org_eff_start_date in DATE
37 ,p_org_eff_end_date in DATE );
38
39
40 function DEFAULT_GL_ACCOUNTS (
41 P_EXTERNAL_ACCOUNT_ID in NUMBER)
42 RETURN NUMBER ;
43
44 function OPM_GL_ACCOUNTS (
45 P_ORG_PAYMENT_METHOD_ID in NUMBER)
46 RETURN NUMBER ;
47
48 procedure GET_GL_ACCOUNTS
49 ( p_pay_gl_account_id in number,
50 p_effective_date in date ,
51 p_set_of_books_id out NOCOPY number,
52 p_set_of_books_name out NOCOPY varchar2,
53 p_gl_account_flex_num out NOCOPY number,
54 p_gl_cash_ac_id out NOCOPY number,
55 p_gl_cash_clearing_ac_id out NOCOPY number,
56 p_gl_control_ac_id out NOCOPY number,
57 p_gl_error_ac_id out NOCOPY number
58 );
59
60 end PAY_PAYMENT_GL_ACCOUNTS_PKG;
61