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_message_name OUT NOCOPY VARCHAR2
125: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
126: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
127:

Line 155: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE

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

Line 156: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE

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

Line 158: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE

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

Line 192: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE

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

Line 193: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE

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

Line 195: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE

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

Line 196: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE

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

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

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

Line 227: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE

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

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

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

Line 259: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE

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

Line 260: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE

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

Line 262: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE

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

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

259: (p_CEI_INFORMATION2 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION2%TYPE
260: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE
261: ,p_effective_date IN DATE
262: ,p_contact_relationship_id IN PER_CONTACT_EXTRA_INFO_F.contact_relationship_id%TYPE
263: ,p_contact_extra_info_id IN PER_CONTACT_EXTRA_INFO_F.contact_extra_info_id%TYPE);
264:
265:
266:
267: -- -----------------------------------------------------------------------+

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

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

Line 291: ,p_CEI_INFORMATION3 IN PER_CONTACT_EXTRA_INFO_F.CEI_INFORMATION3%TYPE

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