APPS.FND_REGISTRATION_PKG dependencies on FND_REGISTRATION_DETAILS

Line 6: FND_REGISTRATION_DETAILS rows. This is a Ref Cursor instead of

2: /* $Header: AFREGS.pls 120.3 2005/11/04 14:36:10 rsheh noship $ */
3:
4: /*
5: This Ref Cursor is used to move around collections of
6: FND_REGISTRATION_DETAILS rows. This is a Ref Cursor instead of
7: a row object to make it accessable from java, which it would not
8: be otherwise
9: */
10: TYPE fnd_reg_details_ref_cursor IS REF CURSOR RETURN fnd_registration_details%ROWTYPE;

Line 10: TYPE fnd_reg_details_ref_cursor IS REF CURSOR RETURN fnd_registration_details%ROWTYPE;

6: FND_REGISTRATION_DETAILS rows. This is a Ref Cursor instead of
7: a row object to make it accessable from java, which it would not
8: be otherwise
9: */
10: TYPE fnd_reg_details_ref_cursor IS REF CURSOR RETURN fnd_registration_details%ROWTYPE;
11:
12: /*
13: Insert row method for FND_REGISTRATIONS
14: RETURNS the new registration_id, generated from FND_REGISTRATIONS_S

Line 107: Insert method for FND_REGISTRATION_DETAILS

103: procedure delete_fnd_reg(
104: p_registration_id IN VARCHAR2);
105:
106: /*
107: Insert method for FND_REGISTRATION_DETAILS
108: */
109: procedure insert_fnd_reg_details(
110: p_registration_id IN NUMBER,
111: p_application_id IN NUMBER,

Line 121: Update Method for FND_REGISTRATION_DETAILS

117: p_field_value_number IN NUMBER default null,
118: p_field_value_date IN DATE default null);
119:
120: /*
121: Update Method for FND_REGISTRATION_DETAILS
122: Updates row specified by REGISTRATION_ID + FIELD_NAME
123: */
124: procedure update_fnd_reg_details(
125: p_registration_id IN NUMBER,

Line 134: Delete method for FND_REGISTRATION_DETAILS

130: p_field_value_number IN NUMBER default null,
131: p_field_value_date IN DATE default null);
132:
133: /*
134: Delete method for FND_REGISTRATION_DETAILS
135: Updates row specified by REGISTRATION_ID + FIELD_NAME
136: */
137: procedure delete_fnd_reg_details(
138: p_registration_id IN NUMBER,

Line 209: FND_REGISTRATION_DETAILS.

205: p_registration_key IN VARCHAR2);
206:
207: /*
208: Inserts a row in FND_REGISTRATIONS and some number of rows in
209: FND_REGISTRATION_DETAILS.
210: Caller needs to ensure that the cursor of details is not NULL
211: (it can be empty).
212: Returns the new registration_id generated from FND_REGISTRATIONS_S
213: */

Line 255: Updates both FND_REGISTRATIONS and FND_REGISTRATION_DETAILS

251: p_country IN VARCHAR2 default null)
252: return NUMBER;
253:
254: /*
255: Updates both FND_REGISTRATIONS and FND_REGISTRATION_DETAILS
256: The RefCursor should be not null
257: */
258: procedure update_reg(
259: p_registration_id IN VARCHAR2,

Line 299: Updates FND_REGISTRATIONS and FND_REGISTRATION_DETAILS

295: p_postal_code IN VARCHAR2 default null,
296: p_country IN VARCHAR2 default null);
297:
298: /*
299: Updates FND_REGISTRATIONS and FND_REGISTRATION_DETAILS
300: using the registration_key as the PK rather than the registration_id
301: */
302: procedure update_reg_by_key(
303: p_registration_key IN VARCHAR2,

Line 344: and FND_REGISTRATION_DETAILS, given a registration_id

340: p_country IN VARCHAR2 default null);
341:
342: /*
343: Deletes an entire registration, from both FND_REGISTRATIONS
344: and FND_REGISTRATION_DETAILS, given a registration_id
345: */
346: procedure delete_reg(
347: p_registration_id IN NUMBER);
348:

Line 351: and FND_REGISTRATION_DETAILS, given a registration_key

347: p_registration_id IN NUMBER);
348:
349: /*
350: Deletes an entire registration, from both FND_REGISTRATIONS
351: and FND_REGISTRATION_DETAILS, given a registration_key
352: */
353: procedure delete_reg_by_key(
354: p_registration_key IN VARCHAR2);
355:

Line 399: Retrieves a row from FND_REGISTRATION_DETAILS

395: x_postal_code OUT nocopy VARCHAR2,
396: x_country OUT nocopy VARCHAR2);
397:
398: /*
399: Retrieves a row from FND_REGISTRATION_DETAILS
400: */
401: procedure retrieve_fnd_reg_details(
402: p_registration_id IN NUMBER,
403: p_field_name IN VARCHAR2,

Line 456: FND_REGISTRATIONS and FND_REGISTRATION_DETAILS, but

452: x_reg_details OUT nocopy fnd_reg_details_ref_cursor);
453:
454: /*
455: Retrieves a registration including data from both
456: FND_REGISTRATIONS and FND_REGISTRATION_DETAILS, but
457: uses a registration_key instead of a registration_id
458: */
459: procedure retrieve_invited_reg(
460: p_registration_key IN VARCHAR2,