APPS.FND_REGISTRATION_PKG dependencies on FND_REGISTRATION_DETAILS

Line 257: INSERT INTO fnd_registration_details(

253: p_field_value_number IN NUMBER default null,
254: p_field_value_date IN DATE default null)
255: IS
256: BEGIN
257: INSERT INTO fnd_registration_details(
258: registration_id,
259: application_id,
260: registration_type,
261: field_name,

Line 300: UPDATE fnd_registration_details

296: p_field_value_number IN NUMBER default null,
297: p_field_value_date IN DATE default null)
298: IS
299: BEGIN
300: UPDATE fnd_registration_details
301: SET field_type = p_field_type,
302: field_format = p_field_format,
303: field_value_string = p_field_value_string,
304: field_value_number = p_field_value_number,

Line 318: DELETE FROM fnd_registration_details

314: p_registration_id IN NUMBER,
315: p_field_name IN VARCHAR2)
316: IS
317: BEGIN
318: DELETE FROM fnd_registration_details
319: WHERE registration_id = p_registration_id
320: AND field_name = p_field_name;
321:
322: END delete_fnd_reg_details;

Line 544: -- for fnd_registration_details

540: p_zip,
541: p_postal_code,
542: p_country);
543:
544: -- for fnd_registration_details
545: -- loops through the ref_cursor
546: -- Note this is primarily a REF Cursor because
547: -- Java cannot support records and tables
548:

Line 683: -- Now do update fnd_registration_details

679: p_zip,
680: p_postal_code,
681: p_country);
682:
683: -- Now do update fnd_registration_details
684:
685: LOOP
686: FETCH p_reg_details
687: INTO l_ri_cur,

Line 808: DELETE FROM fnd_registration_details

804: procedure delete_reg(
805: p_registration_id IN NUMBER)
806: IS
807: BEGIN
808: DELETE FROM fnd_registration_details
809: WHERE registration_id = p_registration_id;
810:
811: DELETE FROM fnd_registrations
812: WHERE registration_id = p_registration_id;

Line 961: FROM fnd_registration_details

957: x_field_format,
958: x_field_value_string,
959: x_field_value_number,
960: x_field_value_date
961: FROM fnd_registration_details
962: WHERE registration_id = p_registration_id
963: AND field_name = p_field_name;
964: END retrieve_fnd_reg_details;
965:

Line 1066: FROM fnd_registration_details

1062: last_updated_by,
1063: created_by,
1064: creation_date,
1065: last_update_login
1066: FROM fnd_registration_details
1067: WHERE registration_id = p_registration_id;
1068:
1069: END retrieve_reg;
1070: