eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_BANK_BRANCHES_PKG dependencies on HR_API

Line 26: ,P_START_DATE_ACTIVE IN DATE DEFAULT HR_API.G_SOT

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

Line 27: ,P_END_DATE_ACTIVE IN DATE DEFAULT HR_API.G_EOT

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

Line 51: ,P_BANK_CODE IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2

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

Line 52: ,P_BRANCH 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

Line 53: ,P_LONG_BRANCH 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

Line 54: ,P_EXTRA_INFORMATION1 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

Line 55: ,P_EXTRA_INFORMATION2 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

Line 56: ,P_EXTRA_INFORMATION3 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

Line 57: ,P_EXTRA_INFORMATION4 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

Line 58: ,P_EXTRA_INFORMATION5 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: );

Line 59: ,P_ENABLED_FLAG 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 >-------------------------------

Line 60: ,P_START_DATE_ACTIVE IN DATE DEFAULT HR_API.G_DATE

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: --

Line 61: ,P_END_DATE_ACTIVE IN DATE DEFAULT HR_API.G_DATE

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

Line 98: ,P_START_DATE_ACTIVE IN DATE DEFAULT HR_API.G_SOT

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

Line 99: ,P_END_DATE_ACTIVE IN DATE DEFAULT HR_API.G_EOT

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

Line 109: -- The HR_API constants (HR_API.G_VARCHAR2 or HR_API.G_DATE) are

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.

Line 117: ,P_BRANCH IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2

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

Line 118: ,P_LONG_BRANCH IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2

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

Line 120: ,P_ENABLED_FLAG IN VARCHAR2 DEFAULT HR_API.G_VARCHAR2

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: -------------------------------------------------------------

Line 121: ,P_START_DATE_ACTIVE IN DATE DEFAULT HR_API.G_DATE

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 --

Line 122: ,P_END_DATE_ACTIVE IN DATE DEFAULT HR_API.G_DATE

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. --