APPS.FND_REGISTRATION_PKG dependencies on FND_REGISTRATIONS

Line 47: select fnd_registrations_s.nextval

43: l_registration_id NUMBER;
44:
45: BEGIN
46:
47: select fnd_registrations_s.nextval
48: into l_registration_id
49: from dual;
50:
51: -- Note that this does not set the registration_key field.

Line 54: INSERT INTO fnd_registrations(

50:
51: -- Note that this does not set the registration_key field.
52: -- For now this can only be set in the middle tier.
53:
54: INSERT INTO fnd_registrations(
55: registration_id,
56: registration_key,
57: application_id,
58: party_id,

Line 191: UPDATE fnd_registrations

187: p_postal_code IN VARCHAR2 default null,
188: p_country IN VARCHAR2 default null)
189: IS
190: BEGIN
191: UPDATE fnd_registrations
192: SET application_id = p_application_id,
193: party_id = p_party_id,
194: registration_type = p_registration_type,
195: requested_user_name = p_requested_user_name,

Line 240: DELETE from fnd_registrations

236: procedure delete_fnd_reg(
237: p_registration_id IN VARCHAR2)
238: IS
239: BEGIN
240: DELETE from fnd_registrations
241: WHERE registration_id = p_registration_id;
242:
243: END delete_fnd_reg;
244:

Line 330: UPDATE fnd_registrations

326: p_registration_id IN NUMBER,
327: p_new_status IN VARCHAR2)
328: IS
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;

Line 503: -- For fnd_registrations

499: l_field_value_number NUMBER;
500: l_field_value_date DATE;
501: BEGIN
502:
503: -- For fnd_registrations
504: -- Remember registration_key is not set this way
505:
506: l_registration_id := insert_fnd_reg(
507: p_application_id,

Line 642: -- Do update_fnd_registrations first

638: l_field_value_number NUMBER;
639: l_field_value_date DATE;
640: BEGIN
641:
642: -- Do update_fnd_registrations first
643:
644: update_fnd_reg(
645: p_registration_id,
646: p_application_id,

Line 811: DELETE FROM fnd_registrations

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;
813: END;
814:
815: procedure delete_reg_by_key(

Line 936: FROM fnd_registrations

932: x_province,
933: x_zip,
934: x_postal_code,
935: x_country
936: FROM fnd_registrations
937: WHERE registration_id = p_registration_id;
938:
939: END retrieve_fnd_reg;
940:

Line 1008: -- populate from fnd_registrations first

1004: x_reg_details OUT nocopy fnd_reg_details_ref_cursor)
1005: IS
1006: BEGIN
1007:
1008: -- populate from fnd_registrations first
1009:
1010: retrieve_fnd_reg(
1011: p_registration_id,
1012: x_application_id,

Line 1202: FROM fnd_registrations

1198: l_assigned_user_name VARCHAR2(100);
1199: BEGIN
1200: SELECT registration_id
1201: INTO l_registration_id
1202: FROM fnd_registrations
1203: WHERE assigned_user_name = p_assigned_user_name
1204: AND application_id = p_application_id
1205: AND registration_type = p_registration_type;
1206:

Line 1296: FROM fnd_registrations

1292: l_registration_type VARCHAR2(255);
1293: BEGIN
1294: SELECT registration_id
1295: INTO l_registration_id
1296: FROM fnd_registrations
1297: WHERE registration_type = p_registration_type
1298: AND application_id = p_application_id
1299: AND party_id = p_party_id;
1300:

Line 1351: FROM fnd_registrations

1347: l_registration_id NUMBER;
1348: BEGIN
1349: SELECT registration_id
1350: INTO l_registration_id
1351: FROM fnd_registrations
1352: WHERE registration_key = p_registration_key;
1353: return l_registration_id;
1354:
1355: END get_registration_id_from_key;

Line 1366: FROM fnd_registrations

1362: BEGIN
1363:
1364: SELECT registration_key
1365: INTO l_registration_key
1366: FROM fnd_registrations
1367: WHERE registration_id = p_registration_id;
1368:
1369: return l_registration_key;
1370: