1 PACKAGE PAY_BANK_BRANCHES_PKG AUTHID CURRENT_USER AS
2 /* $Header: pybbr01t.pkh 115.3 2004/08/20 10:49:59 arashid noship $ */
3 -----------------------------------------------------------
4 -- The following procedures deal with the maintenance of --
5 -- PAY_BANK_BRANCHES. --
6 -----------------------------------------------------------
7 ------------------------------< INSERT_ROW >--------------------------------
8 -- Name
9 -- INSERT_ROW
10 --
11 -- Notes
12 -- An exception is raised upon failure
13 --
14 PROCEDURE INSERT_ROW
15 (P_BRANCH_CODE IN VARCHAR2
16 ,P_LEGISLATION_CODE IN VARCHAR2
17 ,P_BANK_CODE IN VARCHAR2
18 ,P_BRANCH IN VARCHAR2
19 ,P_LONG_BRANCH IN VARCHAR2 DEFAULT NULL
20 ,P_EXTRA_INFORMATION1 IN VARCHAR2 DEFAULT NULL
21 ,P_EXTRA_INFORMATION2 IN VARCHAR2 DEFAULT NULL
22 ,P_EXTRA_INFORMATION3 IN VARCHAR2 DEFAULT NULL
23 ,P_EXTRA_INFORMATION4 IN VARCHAR2 DEFAULT NULL
24 ,P_EXTRA_INFORMATION5 IN VARCHAR2 DEFAULT NULL
25 ,P_ENABLED_FLAG IN VARCHAR2 DEFAULT 'Y'
26 ,P_START_DATE_ACTIVE IN DATE DEFAULT HR_API.G_SOT
27 ,P_END_DATE_ACTIVE IN DATE DEFAULT HR_API.G_EOT
28 );
29 -------------------------------< LOCK_ROW >--------------------------------
30 -- Name
31 -- LOCK_ROW
32 --
33 -- Notes
34 -- An exception is raised upon failure.
35 --
36 PROCEDURE LOCK_ROW
37 (P_BRANCH_CODE IN VARCHAR2
38 ,P_LEGISLATION_CODE IN VARCHAR2
39 );
40 ------------------------------< UPDATE_ROW >-------------------------------
41 --
42 -- Name
43 -- UPDATE_ROW
44 --
45 -- Notes
46 -- An exception is raised upon failure.
47 --
48 PROCEDURE UPDATE_ROW
49 (P_BRANCH_CODE IN VARCHAR2
50 ,P_LEGISLATION_CODE IN VARCHAR2
51 ,P_BANK_CODE IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
52 ,P_BRANCH IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
53 ,P_LONG_BRANCH IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
54 ,P_EXTRA_INFORMATION1 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
55 ,P_EXTRA_INFORMATION2 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
56 ,P_EXTRA_INFORMATION3 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
57 ,P_EXTRA_INFORMATION4 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
58 ,P_EXTRA_INFORMATION5 IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
59 ,P_ENABLED_FLAG IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
60 ,P_START_DATE_ACTIVE IN DATE DEFAULT HR_API.G_DATE
61 ,P_END_DATE_ACTIVE IN DATE DEFAULT HR_API.G_DATE
62 );
63 ------------------------------< DELETE_ROW >-------------------------------
64 --
65 -- Name
66 -- DELETE_ROW
67 --
68 -- Notes
69 -- An exception is raised upon failure.
70 --
71 PROCEDURE DELETE_ROW
72 (P_BRANCH_CODE IN VARCHAR2
73 ,P_LEGISLATION_CODE IN VARCHAR2
74 );
75 ----------------------------------------------------------
76 -- GB legislation covers for INSERT_ROW and UPDATE_ROW. --
77 ----------------------------------------------------------
78 ----------------------------< INSERT_GB_ROW >------------------------------
79 -- Name
80 -- INSERT_GB_ROW
81 --
82 -- Description
83 -- GB legislation cover for INSERT_ROW.
84 --
85 -- Notes
86 -- P_SORT_CODE is 0-left padded on output.
87 -- P_BUILDING_SOCIETY_ACCT is ignored.
88 -- The converted values are passed to INSERT_ROW.
89 -- An exception is raised upon failure.
90 --
91 PROCEDURE INSERT_GB_ROW
92 (P_SORT_CODE IN OUT NOCOPY VARCHAR2
93 ,P_BANK_CODE IN VARCHAR2
94 ,P_BRANCH IN VARCHAR2
95 ,P_LONG_BRANCH IN VARCHAR2 DEFAULT NULL
96 ,P_BUILDING_SOCIETY_ACCT IN OUT NOCOPY VARCHAR2
97 ,P_ENABLED_FLAG IN VARCHAR2 DEFAULT 'Y'
98 ,P_START_DATE_ACTIVE IN DATE DEFAULT HR_API.G_SOT
99 ,P_END_DATE_ACTIVE IN DATE DEFAULT HR_API.G_EOT
100 );
101 ----------------------------< UPDATE_GB_ROW >------------------------------
102 -- Name
103 -- UPDATE_GB_ROW
104 --
105 -- Description
106 -- GB legislation cover for UPDATE_ROW.
107 --
108 -- Notes
109 -- The HR_API constants (HR_API.G_VARCHAR2 or HR_API.G_DATE) are
110 -- treated as the 'no-change' values.
111 -- P_BUILDING_SOCIETY_ACCT is ignored.
112 -- The converted value is passed to UPDATE_ROW.
113 -- An exception is raised upon failure.
114 --
115 PROCEDURE UPDATE_GB_ROW
116 (P_SORT_CODE IN VARCHAR2
117 ,P_BRANCH IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
118 ,P_LONG_BRANCH IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
119 ,P_BUILDING_SOCIETY_ACCT IN OUT NOCOPY VARCHAR2
120 ,P_ENABLED_FLAG IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2
121 ,P_START_DATE_ACTIVE IN DATE DEFAULT HR_API.G_DATE
122 ,P_END_DATE_ACTIVE IN DATE DEFAULT HR_API.G_DATE
123 );
124 -------------------------------------------------------------
125 -- The following procedures are for self-service and other --
126 -- forms that deal with the bank accounts. --
127 -------------------------------------------------------------
128 ------------------------< DISPLAY_TO_GB_ACCOUNT >--------------------------
129 -- Name
130 -- DISPLAY_TO_GB_ACCOUNT
131 --
132 -- Description
133 -- If necessary creates a new PAY_EXTERNAL_ACCOUNTS row
134 -- based upon changes to information displayed on the screen.
135 --
136 -- An exception is raised upon failure.
137 --
138 -- Upon success a new row may be created in PAY_EXTERNAL_ACCOUNTS and
139 -- P_EXTERNAL_ACCOUNT_ID, and P_OBJECT_VERSION_NUMBER are updated for
140 -- this new row. These parameters are not updated if a new account row
141 -- was not created.
142 --
143 -- Notes
144 -- If ACCOUNT_NAME, ACCOUNT_NUMBER or SORT_CODE differ from
145 -- the values in PAY_EXTERNAL_ACCOUNTS then a new row is
146 -- created using information from PAY_BANK_BRANCHES and the
147 -- supplied data.
148 --
149 PROCEDURE DISPLAY_TO_GB_ACCOUNT
150 (P_EXTERNAL_ACCOUNT_ID IN OUT NOCOPY NUMBER
151 ,P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER
152 ,P_BUSINESS_GROUP_ID IN NUMBER
153 ,P_EFFECTIVE_DATE IN DATE
154 ,P_ACCOUNT_NAME IN VARCHAR2
155 ,P_ACCOUNT_NUMBER IN VARCHAR2
156 ,P_SORT_CODE IN VARCHAR2
157 ,P_BUILDING_SOCIETY_ACCT IN VARCHAR2 DEFAULT NULL
158 ,P_MULTI_MESSAGE IN BOOLEAN DEFAULT FALSE
159 ,P_RETURN_STATUS OUT NOCOPY VARCHAR2
160 ,P_MSG_COUNT OUT NOCOPY NUMBER
161 ,P_MSG_DATA OUT NOCOPY VARCHAR2
162 );
163 --
164 END PAY_BANK_BRANCHES_PKG;