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.PER_PHN_BUS dependencies on PER_PHONES

Line 43: (p_phone_id in per_phones.phone_id%TYPE

39: -- {End of Comments}
40: --
41: -- ---------------------------------------------------------------------------
42: procedure chk_date_from
43: (p_phone_id in per_phones.phone_id%TYPE
44: ,p_date_from in per_phones.date_from%TYPE
45: ,p_date_to in per_phones.date_to%TYPE
46: ,p_object_version_number in per_phones.object_version_number%TYPE
47: );

Line 44: ,p_date_from in per_phones.date_from%TYPE

40: --
41: -- ---------------------------------------------------------------------------
42: procedure chk_date_from
43: (p_phone_id in per_phones.phone_id%TYPE
44: ,p_date_from in per_phones.date_from%TYPE
45: ,p_date_to in per_phones.date_to%TYPE
46: ,p_object_version_number in per_phones.object_version_number%TYPE
47: );
48: --

Line 45: ,p_date_to in per_phones.date_to%TYPE

41: -- ---------------------------------------------------------------------------
42: procedure chk_date_from
43: (p_phone_id in per_phones.phone_id%TYPE
44: ,p_date_from in per_phones.date_from%TYPE
45: ,p_date_to in per_phones.date_to%TYPE
46: ,p_object_version_number in per_phones.object_version_number%TYPE
47: );
48: --
49: -- ---------------------------------------------------------------------------

Line 46: ,p_object_version_number in per_phones.object_version_number%TYPE

42: procedure chk_date_from
43: (p_phone_id in per_phones.phone_id%TYPE
44: ,p_date_from in per_phones.date_from%TYPE
45: ,p_date_to in per_phones.date_to%TYPE
46: ,p_object_version_number in per_phones.object_version_number%TYPE
47: );
48: --
49: -- ---------------------------------------------------------------------------
50: -- |-------------------------< chk_phone_type >---------------------------|

Line 84: (p_phone_id in per_phones.phone_id%TYPE

80: --
81: -- {End Of Comments}
82: -- ----------------------------------------------------------------------------
83: procedure chk_phone_type
84: (p_phone_id in per_phones.phone_id%TYPE
85: ,p_phone_type in per_phones.phone_type%TYPE
86: ,p_phone_number in per_phones.phone_number%TYPE
87: ,p_effective_date in date
88: ,p_object_version_number in per_phones.object_version_number%TYPE

Line 85: ,p_phone_type in per_phones.phone_type%TYPE

81: -- {End Of Comments}
82: -- ----------------------------------------------------------------------------
83: procedure chk_phone_type
84: (p_phone_id in per_phones.phone_id%TYPE
85: ,p_phone_type in per_phones.phone_type%TYPE
86: ,p_phone_number in per_phones.phone_number%TYPE
87: ,p_effective_date in date
88: ,p_object_version_number in per_phones.object_version_number%TYPE
89: );

Line 86: ,p_phone_number in per_phones.phone_number%TYPE

82: -- ----------------------------------------------------------------------------
83: procedure chk_phone_type
84: (p_phone_id in per_phones.phone_id%TYPE
85: ,p_phone_type in per_phones.phone_type%TYPE
86: ,p_phone_number in per_phones.phone_number%TYPE
87: ,p_effective_date in date
88: ,p_object_version_number in per_phones.object_version_number%TYPE
89: );
90: --

Line 88: ,p_object_version_number in per_phones.object_version_number%TYPE

84: (p_phone_id in per_phones.phone_id%TYPE
85: ,p_phone_type in per_phones.phone_type%TYPE
86: ,p_phone_number in per_phones.phone_number%TYPE
87: ,p_effective_date in date
88: ,p_object_version_number in per_phones.object_version_number%TYPE
89: );
90: --
91: -- ---------------------------------------------------------------------------
92: -- |-------------------------< chk_phone_type_limits >---------------------|

Line 123: (p_phone_id in per_phones.phone_id%TYPE

119: --
120: -- {End Of Comments}
121: -- ----------------------------------------------------------------------------
122: procedure chk_phone_type_limits
123: (p_phone_id in per_phones.phone_id%TYPE
124: ,p_date_from in per_phones.date_from%TYPE
125: ,p_date_to in per_phones.date_to%TYPE
126: ,p_phone_type in per_phones.phone_type%TYPE
127: ,p_parent_id in per_phones.parent_id%TYPE

Line 124: ,p_date_from in per_phones.date_from%TYPE

120: -- {End Of Comments}
121: -- ----------------------------------------------------------------------------
122: procedure chk_phone_type_limits
123: (p_phone_id in per_phones.phone_id%TYPE
124: ,p_date_from in per_phones.date_from%TYPE
125: ,p_date_to in per_phones.date_to%TYPE
126: ,p_phone_type in per_phones.phone_type%TYPE
127: ,p_parent_id in per_phones.parent_id%TYPE
128: ,p_parent_table in per_phones.parent_table%TYPE

Line 125: ,p_date_to in per_phones.date_to%TYPE

121: -- ----------------------------------------------------------------------------
122: procedure chk_phone_type_limits
123: (p_phone_id in per_phones.phone_id%TYPE
124: ,p_date_from in per_phones.date_from%TYPE
125: ,p_date_to in per_phones.date_to%TYPE
126: ,p_phone_type in per_phones.phone_type%TYPE
127: ,p_parent_id in per_phones.parent_id%TYPE
128: ,p_parent_table in per_phones.parent_table%TYPE
129: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge

Line 126: ,p_phone_type in per_phones.phone_type%TYPE

122: procedure chk_phone_type_limits
123: (p_phone_id in per_phones.phone_id%TYPE
124: ,p_date_from in per_phones.date_from%TYPE
125: ,p_date_to in per_phones.date_to%TYPE
126: ,p_phone_type in per_phones.phone_type%TYPE
127: ,p_parent_id in per_phones.parent_id%TYPE
128: ,p_parent_table in per_phones.parent_table%TYPE
129: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge
130: ,p_object_version_number in per_phones.object_version_number%TYPE);

Line 127: ,p_parent_id in per_phones.parent_id%TYPE

123: (p_phone_id in per_phones.phone_id%TYPE
124: ,p_date_from in per_phones.date_from%TYPE
125: ,p_date_to in per_phones.date_to%TYPE
126: ,p_phone_type in per_phones.phone_type%TYPE
127: ,p_parent_id in per_phones.parent_id%TYPE
128: ,p_parent_table in per_phones.parent_table%TYPE
129: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge
130: ,p_object_version_number in per_phones.object_version_number%TYPE);
131: --

Line 128: ,p_parent_table in per_phones.parent_table%TYPE

124: ,p_date_from in per_phones.date_from%TYPE
125: ,p_date_to in per_phones.date_to%TYPE
126: ,p_phone_type in per_phones.phone_type%TYPE
127: ,p_parent_id in per_phones.parent_id%TYPE
128: ,p_parent_table in per_phones.parent_table%TYPE
129: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge
130: ,p_object_version_number in per_phones.object_version_number%TYPE);
131: --
132: -- ---------------------------------------------------------------------------

Line 129: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge

125: ,p_date_to in per_phones.date_to%TYPE
126: ,p_phone_type in per_phones.phone_type%TYPE
127: ,p_parent_id in per_phones.parent_id%TYPE
128: ,p_parent_table in per_phones.parent_table%TYPE
129: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge
130: ,p_object_version_number in per_phones.object_version_number%TYPE);
131: --
132: -- ---------------------------------------------------------------------------
133: -- |----------------------------< chk_parent_id >----------------------------|

Line 130: ,p_object_version_number in per_phones.object_version_number%TYPE);

126: ,p_phone_type in per_phones.phone_type%TYPE
127: ,p_parent_id in per_phones.parent_id%TYPE
128: ,p_parent_table in per_phones.parent_table%TYPE
129: ,p_party_id in per_phones.party_id%TYPE -- HR/TCA merge
130: ,p_object_version_number in per_phones.object_version_number%TYPE);
131: --
132: -- ---------------------------------------------------------------------------
133: -- |----------------------------< chk_parent_id >----------------------------|
134: -- ---------------------------------------------------------------------------

Line 166: (p_phone_id in per_phones.phone_id%TYPE

162: -- {End of Comments}
163: --
164: -- ---------------------------------------------------------------------------
165: procedure chk_parent_id
166: (p_phone_id in per_phones.phone_id%TYPE
167: ,p_parent_id in per_phones.parent_id%TYPE
168: ,p_parent_table in per_phones.parent_table%TYPE
169: ,p_object_version_number in per_phones.object_version_number%TYPE
170: );

Line 167: ,p_parent_id in per_phones.parent_id%TYPE

163: --
164: -- ---------------------------------------------------------------------------
165: procedure chk_parent_id
166: (p_phone_id in per_phones.phone_id%TYPE
167: ,p_parent_id in per_phones.parent_id%TYPE
168: ,p_parent_table in per_phones.parent_table%TYPE
169: ,p_object_version_number in per_phones.object_version_number%TYPE
170: );
171: --

Line 168: ,p_parent_table in per_phones.parent_table%TYPE

164: -- ---------------------------------------------------------------------------
165: procedure chk_parent_id
166: (p_phone_id in per_phones.phone_id%TYPE
167: ,p_parent_id in per_phones.parent_id%TYPE
168: ,p_parent_table in per_phones.parent_table%TYPE
169: ,p_object_version_number in per_phones.object_version_number%TYPE
170: );
171: --
172: -- ----------------------------------------------------------------------------

Line 169: ,p_object_version_number in per_phones.object_version_number%TYPE

165: procedure chk_parent_id
166: (p_phone_id in per_phones.phone_id%TYPE
167: ,p_parent_id in per_phones.parent_id%TYPE
168: ,p_parent_table in per_phones.parent_table%TYPE
169: ,p_object_version_number in per_phones.object_version_number%TYPE
170: );
171: --
172: -- ----------------------------------------------------------------------------
173: -- |---------------------------< insert_validate >----------------------------|