APPS.PER_IN_CON_LEG_HOOK dependencies on PER_CONTACT_EXTRA_INFO_F

Line 29: PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE);

25: --vbanner, commenting out for bug 4674384.
26: --sukukuma, uncommented out for bug 4674384
27: PROCEDURE nominee_age_check
28: ( p_contact_relationship_id IN
29: PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE);
30:
31: -- -----------------------------------------------------------------------+
32: -- Name : nomination_share_insert_check --+
33: -- Type : Procedure --+

Line 57: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE

53: -- 1.1 16-May-2005 sukukuma Updated this procedure --+
54: --------------------------------------------------------------------------+
55:
56: PROCEDURE nomination_share_insert_check
57: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
58: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
59: ,p_effective_date IN DATE
60: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
61: );

Line 58: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE

54: --------------------------------------------------------------------------+
55:
56: PROCEDURE nomination_share_insert_check
57: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
58: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
59: ,p_effective_date IN DATE
60: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
61: );
62:

Line 60: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE

56: PROCEDURE nomination_share_insert_check
57: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
58: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
59: ,p_effective_date IN DATE
60: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
61: );
62:
63:
64: -- -----------------------------------------------------------------------+

Line 91: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE

87: -- 1.1 16-May-2005 sukukuma Updated this procedure --+
88: --------------------------------------------------------------------------+
89:
90: PROCEDURE nomination_share_update_check
91: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
92: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
93: ,p_effective_date IN DATE
94: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
95: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE);

Line 92: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE

88: --------------------------------------------------------------------------+
89:
90: PROCEDURE nomination_share_update_check
91: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
92: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
93: ,p_effective_date IN DATE
94: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
95: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE);
96:

Line 94: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE

90: PROCEDURE nomination_share_update_check
91: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
92: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
93: ,p_effective_date IN DATE
94: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
95: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE);
96:
97:
98: -- -----------------------------------------------------------------------+

Line 95: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE);

91: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
92: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
93: ,p_effective_date IN DATE
94: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
95: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE);
96:
97:
98: -- -----------------------------------------------------------------------+
99: -- Name : check_nominee_age --+

Line 123: ( p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE

119: --------------------------------------------------------------------------+
120: --sukukuma, changed the name of this procedure from nominee_age_check
121: -- to check_nominee_age
122: PROCEDURE check_nominee_age
123: ( p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
124: ,p_information_type IN PER_CONTACT_EXTRA_INFO_F.information_type%TYPE
125: ,p_message_name OUT NOCOPY VARCHAR2
126: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
127: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);

Line 124: ,p_information_type IN PER_CONTACT_EXTRA_INFO_F.information_type%TYPE

120: --sukukuma, changed the name of this procedure from nominee_age_check
121: -- to check_nominee_age
122: PROCEDURE check_nominee_age
123: ( p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
124: ,p_information_type IN PER_CONTACT_EXTRA_INFO_F.information_type%TYPE
125: ,p_message_name OUT NOCOPY VARCHAR2
126: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
127: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
128:

Line 156: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE

152: -- 1.0 12-Jan-2006 rpalli Added this procedure spec --+
153: --------------------------------------------------------------------------+0
154:
155: PROCEDURE get_essential_insert_value
156: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
157: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
158: ,p_effective_date IN DATE
159: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
160: ,p_message_name OUT NOCOPY VARCHAR2

Line 157: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE

153: --------------------------------------------------------------------------+0
154:
155: PROCEDURE get_essential_insert_value
156: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
157: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
158: ,p_effective_date IN DATE
159: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
160: ,p_message_name OUT NOCOPY VARCHAR2
161: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type

Line 159: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE

155: PROCEDURE get_essential_insert_value
156: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
157: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
158: ,p_effective_date IN DATE
159: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
160: ,p_message_name OUT NOCOPY VARCHAR2
161: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
162: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
163:

Line 193: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE

189: -- 1.0 12-Jan-2006 rpalli Added this procedure spec --+
190: --------------------------------------------------------------------------+0
191:
192: PROCEDURE get_essential_update_value
193: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
194: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
195: ,p_effective_date IN DATE
196: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
197: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE

Line 194: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE

190: --------------------------------------------------------------------------+0
191:
192: PROCEDURE get_essential_update_value
193: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
194: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
195: ,p_effective_date IN DATE
196: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
197: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE
198: ,p_message_name OUT NOCOPY VARCHAR2

Line 196: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE

192: PROCEDURE get_essential_update_value
193: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
194: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
195: ,p_effective_date IN DATE
196: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
197: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE
198: ,p_message_name OUT NOCOPY VARCHAR2
199: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
200: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);

Line 197: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE

193: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
194: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
195: ,p_effective_date IN DATE
196: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
197: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE
198: ,p_message_name OUT NOCOPY VARCHAR2
199: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
200: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
201:

Line 227: PROCEDURE check_in_con_insert (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE

223: -- 1.0 31-Mar-2004 gaugupta Created this procedure --+
224: -- 1.1 16-May-2005 sukukuma Updated this procedure --+
225: --------------------------------------------------------------------------+
226:
227: PROCEDURE check_in_con_insert (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
228: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
229: ,p_effective_date IN DATE
230: ,p_information_type IN PER_CONTACT_EXTRA_INFO_F.information_type%TYPE
231: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE);

Line 228: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE

224: -- 1.1 16-May-2005 sukukuma Updated this procedure --+
225: --------------------------------------------------------------------------+
226:
227: PROCEDURE check_in_con_insert (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
228: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
229: ,p_effective_date IN DATE
230: ,p_information_type IN PER_CONTACT_EXTRA_INFO_F.information_type%TYPE
231: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE);
232:

Line 230: ,p_information_type IN PER_CONTACT_EXTRA_INFO_F.information_type%TYPE

226:
227: PROCEDURE check_in_con_insert (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
228: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
229: ,p_effective_date IN DATE
230: ,p_information_type IN PER_CONTACT_EXTRA_INFO_F.information_type%TYPE
231: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE);
232:
233:
234:

Line 231: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE);

227: PROCEDURE check_in_con_insert (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
228: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
229: ,p_effective_date IN DATE
230: ,p_information_type IN PER_CONTACT_EXTRA_INFO_F.information_type%TYPE
231: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE);
232:
233:
234:
235: -- -----------------------------------------------------------------------+

Line 261: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE

257: -- 1.0 31-Mar-2004 gaugupta Created this procedure --+
258: -- 1.1 16-May-2005 sukukuma Updated this procedure --+
259: --------------------------------------------------------------------------+
260: PROCEDURE check_in_con_update
261: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
262: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
263: ,p_effective_date IN DATE
264: ,p_information_type IN PER_CONTACT_EXTRA_INFO_F.information_type%TYPE
265: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE

Line 262: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE

258: -- 1.1 16-May-2005 sukukuma Updated this procedure --+
259: --------------------------------------------------------------------------+
260: PROCEDURE check_in_con_update
261: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
262: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
263: ,p_effective_date IN DATE
264: ,p_information_type IN PER_CONTACT_EXTRA_INFO_F.information_type%TYPE
265: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
266: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE);

Line 264: ,p_information_type IN PER_CONTACT_EXTRA_INFO_F.information_type%TYPE

260: PROCEDURE check_in_con_update
261: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
262: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
263: ,p_effective_date IN DATE
264: ,p_information_type IN PER_CONTACT_EXTRA_INFO_F.information_type%TYPE
265: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
266: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE);
267:
268:

Line 265: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE

261: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
262: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
263: ,p_effective_date IN DATE
264: ,p_information_type IN PER_CONTACT_EXTRA_INFO_F.information_type%TYPE
265: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
266: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE);
267:
268:
269:

Line 266: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE);

262: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
263: ,p_effective_date IN DATE
264: ,p_information_type IN PER_CONTACT_EXTRA_INFO_F.information_type%TYPE
265: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
266: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE);
267:
268:
269:
270: -- -----------------------------------------------------------------------+

Line 293: FUNCTION get_nomination_share(p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE

289: --------------------------------------------------------------------------+
290: -- 1.0 31-Mar-2004 gaugupta Created this procedure --+
291: -- 1.1 24-Jun-2004 vgsriniv Modified the logic.(Bug:3683622)--+
292: --------------------------------------------------------------------------+
293: FUNCTION get_nomination_share(p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
294: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
295: ,p_effective_date IN DATE) RETURN NUMBER ;
296: END per_in_con_leg_hook;

Line 294: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE

290: -- 1.0 31-Mar-2004 gaugupta Created this procedure --+
291: -- 1.1 24-Jun-2004 vgsriniv Modified the logic.(Bug:3683622)--+
292: --------------------------------------------------------------------------+
293: FUNCTION get_nomination_share(p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
294: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
295: ,p_effective_date IN DATE) RETURN NUMBER ;
296: END per_in_con_leg_hook;