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:
128:
129: -- -----------------------------------------------------------------------+
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:
128:
129: -- -----------------------------------------------------------------------+
130: -- Name : get_essential_insert_value --+
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:
163:
164: -- -----------------------------------------------------------------------+
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:
163:
164: -- -----------------------------------------------------------------------+
165: -- Name : get_essential_update_value --+
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:
201: -- -----------------------------------------------------------------------+
202: -- Name : check_in_con_insert --+
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:
201: -- -----------------------------------------------------------------------+
202: -- Name : check_in_con_insert --+
203: -- Type : Procedure --+