136: p_postal_code,
137: p_country,
138: sysdate,
139: sysdate,
140: fnd_global.user_id,
141: fnd_global.user_id,
142: sysdate,
143: fnd_global.login_id
144: );
137: p_country,
138: sysdate,
139: sysdate,
140: fnd_global.user_id,
141: fnd_global.user_id,
142: sysdate,
143: fnd_global.login_id
144: );
145: return l_registration_id;
139: sysdate,
140: fnd_global.user_id,
141: fnd_global.user_id,
142: sysdate,
143: fnd_global.login_id
144: );
145: return l_registration_id;
146:
147: END insert_fnd_reg;
225: zip = p_zip,
226: postal_code = p_postal_code,
227: country = p_country,
228: last_update_date = sysdate,
229: last_updated_by = fnd_global.user_id
230: WHERE
231: registration_id = p_registration_id;
232:
233: END update_fnd_reg;
279: p_field_value_string,
280: p_field_value_number,
281: p_field_value_date,
282: sysdate,
283: fnd_global.user_id,
284: fnd_global.user_id,
285: sysdate,
286: fnd_global.login_id
287: );
280: p_field_value_number,
281: p_field_value_date,
282: sysdate,
283: fnd_global.user_id,
284: fnd_global.user_id,
285: sysdate,
286: fnd_global.login_id
287: );
288: END insert_fnd_reg_details;
282: sysdate,
283: fnd_global.user_id,
284: fnd_global.user_id,
285: sysdate,
286: fnd_global.login_id
287: );
288: END insert_fnd_reg_details;
289:
290: procedure update_fnd_reg_details(
303: field_value_string = p_field_value_string,
304: field_value_number = p_field_value_number,
305: field_value_date = p_field_value_date,
306: last_update_date = sysdate,
307: last_updated_by = fnd_global.user_id
308: WHERE registration_id = p_registration_id
309: AND field_name = p_field_name;
310:
311: END update_fnd_reg_details;
329: BEGIN
330: UPDATE fnd_registrations
331: SET registration_status = p_new_status,
332: last_update_date = sysdate,
333: last_updated_by = fnd_global.user_id
334: WHERE registration_id = p_registration_id;
335:
336: END update_reg_status;
337: