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
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
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
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
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
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
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
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
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
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: );
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 >-------------------------------
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: --
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
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
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
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.
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
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
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: -------------------------------------------------------------
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 --
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. --