eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PG_MEMBERSHIPS_PVT dependencies on FND_API

Line 107: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

103: -- Parameters
104: --
105: -- IN
106: -- p_api_version_number IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
108: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
109: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
110: -- p_memb_rec IN memb_rec_type Required
111: --

Line 108: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

104: --
105: -- IN
106: -- p_api_version_number IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
108: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
109: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
110: -- p_memb_rec IN memb_rec_type Required
111: --
112: -- OUT

Line 109: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

105: -- IN
106: -- p_api_version_number IN NUMBER Required
107: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
108: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
109: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
110: -- p_memb_rec IN memb_rec_type Required
111: --
112: -- OUT
113: -- x_return_status OUT VARCHAR2

Line 129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

125: -- ==============================================================================
126:
127: PROCEDURE Create_Pg_Memberships(
128: p_api_version_number IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: x_return_status OUT NOCOPY VARCHAR2,

Line 130: p_commit IN VARCHAR2 := FND_API.G_FALSE,

126:
127: PROCEDURE Create_Pg_Memberships(
128: p_api_version_number IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,

Line 131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

127: PROCEDURE Create_Pg_Memberships(
128: p_api_version_number IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132:
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,

Line 154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

150: -- Parameters
151: --
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_memb_rec IN memb_rec_type Required
158: --

Line 155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

151: --
152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_memb_rec IN memb_rec_type Required
158: --
159: -- OUT

Line 156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

152: -- IN
153: -- p_api_version_number IN NUMBER Required
154: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_memb_rec IN memb_rec_type Required
158: --
159: -- OUT
160: -- x_return_status OUT VARCHAR2

Line 176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

172: -- ==============================================================================
173:
174: PROCEDURE Update_Pg_Memberships(
175: p_api_version_number IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: p_commit IN VARCHAR2 := FND_API.G_FALSE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179:
180: x_return_status OUT NOCOPY VARCHAR2,

Line 177: p_commit IN VARCHAR2 := FND_API.G_FALSE,

173:
174: PROCEDURE Update_Pg_Memberships(
175: p_api_version_number IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: p_commit IN VARCHAR2 := FND_API.G_FALSE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179:
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,

Line 178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

174: PROCEDURE Update_Pg_Memberships(
175: p_api_version_number IN NUMBER,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
177: p_commit IN VARCHAR2 := FND_API.G_FALSE,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
179:
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,

Line 200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

196: -- Parameters
197: --
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_membership_id IN NUMBER
204: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

197: --
198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_membership_id IN NUMBER
204: -- p_object_version_number IN NUMBER Optional Default = NULL
205: --

Line 202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

198: -- IN
199: -- p_api_version_number IN NUMBER Required
200: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
201: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
202: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
203: -- p_membership_id IN NUMBER
204: -- p_object_version_number IN NUMBER Optional Default = NULL
205: --
206: -- OUT

Line 223: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

219: -- ==============================================================================
220:
221: PROCEDURE Delete_Pg_Memberships(
222: p_api_version_number IN NUMBER,
223: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
224: p_commit IN VARCHAR2 := FND_API.G_FALSE,
225: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,

Line 224: p_commit IN VARCHAR2 := FND_API.G_FALSE,

220:
221: PROCEDURE Delete_Pg_Memberships(
222: p_api_version_number IN NUMBER,
223: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
224: p_commit IN VARCHAR2 := FND_API.G_FALSE,
225: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,

Line 225: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

221: PROCEDURE Delete_Pg_Memberships(
222: p_api_version_number IN NUMBER,
223: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
224: p_commit IN VARCHAR2 := FND_API.G_FALSE,
225: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: p_membership_id IN NUMBER,

Line 246: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

242: -- Parameters
243: --
244: -- IN
245: -- p_api_version_number IN NUMBER Required
246: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
247: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
248: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_memb_rec IN memb_rec_type Required
250: --

Line 247: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

243: --
244: -- IN
245: -- p_api_version_number IN NUMBER Required
246: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
247: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
248: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_memb_rec IN memb_rec_type Required
250: --
251: -- OUT

Line 248: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

244: -- IN
245: -- p_api_version_number IN NUMBER Required
246: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
247: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
248: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_memb_rec IN memb_rec_type Required
250: --
251: -- OUT
252: -- x_return_status OUT VARCHAR2

Line 268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

264: -- ==============================================================================
265:
266: PROCEDURE Lock_Pg_Memberships(
267: p_api_version_number IN NUMBER,
268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
269:
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,
272: x_msg_data OUT NOCOPY VARCHAR2,

Line 302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

298:
299:
300: PROCEDURE Validate_Pg_Memberships(
301: p_api_version_number IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
304: p_memb_rec IN memb_rec_type,
305: p_validation_mode IN VARCHAR2,
306: x_return_status OUT NOCOPY VARCHAR2,

Line 303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

299:
300: PROCEDURE Validate_Pg_Memberships(
301: p_api_version_number IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
303: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
304: p_memb_rec IN memb_rec_type,
305: p_validation_mode IN VARCHAR2,
306: x_return_status OUT NOCOPY VARCHAR2,
307: x_msg_count OUT NOCOPY NUMBER,

Line 361: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

357:
358:
359: PROCEDURE Validate_Memb_Rec (
360: p_api_version_number IN NUMBER,
361: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
362: x_return_status OUT NOCOPY VARCHAR2,
363: x_msg_count OUT NOCOPY NUMBER,
364: x_msg_data OUT NOCOPY VARCHAR2,
365: p_memb_rec IN memb_rec_type

Line 388: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

384:
385: PROCEDURE Terminate_ptr_memberships
386: (
387: p_api_version_number IN NUMBER
388: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
389: , p_commit IN VARCHAR2 := FND_API.G_FALSE
390: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
391: , p_partner_id IN NUMBER -- partner id for which all memberships need to be terminated
392: , p_memb_type IN VARCHAR -- if not given, will get from profile, should be 'SUBSIDIARY','GLOBAL','STANDARD'

Line 389: , p_commit IN VARCHAR2 := FND_API.G_FALSE

385: PROCEDURE Terminate_ptr_memberships
386: (
387: p_api_version_number IN NUMBER
388: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
389: , p_commit IN VARCHAR2 := FND_API.G_FALSE
390: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
391: , p_partner_id IN NUMBER -- partner id for which all memberships need to be terminated
392: , p_memb_type IN VARCHAR -- if not given, will get from profile, should be 'SUBSIDIARY','GLOBAL','STANDARD'
393: , p_status_reason_code IN VARCHAR2 -- pass 'MEMBER_TYPE_CHANGE' if it is happening because of member type change -- it validates against PV_MEMB_STATUS_REASON_CODE

Line 390: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

386: (
387: p_api_version_number IN NUMBER
388: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
389: , p_commit IN VARCHAR2 := FND_API.G_FALSE
390: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
391: , p_partner_id IN NUMBER -- partner id for which all memberships need to be terminated
392: , p_memb_type IN VARCHAR -- if not given, will get from profile, should be 'SUBSIDIARY','GLOBAL','STANDARD'
393: , p_status_reason_code IN VARCHAR2 -- pass 'MEMBER_TYPE_CHANGE' if it is happening because of member type change -- it validates against PV_MEMB_STATUS_REASON_CODE
394: , p_comments IN VARCHAR2 DEFAULT NULL -- pass 'Membership terminated by system as member type is changed' if it is changed because of member type change

Line 416: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

412: --------------------------------------------------------------------------
413: PROCEDURE Terminate_membership
414: (
415: p_api_version_number IN NUMBER
416: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
417: , p_commit IN VARCHAR2 := FND_API.G_FALSE
418: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
419: , p_membership_id IN NUMBER
420: , p_event_code IN VARCHAR2

Line 417: , p_commit IN VARCHAR2 := FND_API.G_FALSE

413: PROCEDURE Terminate_membership
414: (
415: p_api_version_number IN NUMBER
416: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
417: , p_commit IN VARCHAR2 := FND_API.G_FALSE
418: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
419: , p_membership_id IN NUMBER
420: , p_event_code IN VARCHAR2
421: , p_memb_type IN VARCHAR

Line 418: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

414: (
415: p_api_version_number IN NUMBER
416: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
417: , p_commit IN VARCHAR2 := FND_API.G_FALSE
418: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
419: , p_membership_id IN NUMBER
420: , p_event_code IN VARCHAR2
421: , p_memb_type IN VARCHAR
422: , p_status_reason_code IN VARCHAR2

Line 445: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

441:
442: PROCEDURE Update_membership_end_date
443: (
444: p_api_version_number IN NUMBER
445: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
446: , p_commit IN VARCHAR2 := FND_API.G_FALSE
447: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
448: , p_membership_id IN NUMBER -- membership_id for which end date needs to be updated
449: , p_new_date IN DATE

Line 446: , p_commit IN VARCHAR2 := FND_API.G_FALSE

442: PROCEDURE Update_membership_end_date
443: (
444: p_api_version_number IN NUMBER
445: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
446: , p_commit IN VARCHAR2 := FND_API.G_FALSE
447: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
448: , p_membership_id IN NUMBER -- membership_id for which end date needs to be updated
449: , p_new_date IN DATE
450: , p_comments IN VARCHAR2 DEFAULT NULL

Line 447: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

443: (
444: p_api_version_number IN NUMBER
445: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
446: , p_commit IN VARCHAR2 := FND_API.G_FALSE
447: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
448: , p_membership_id IN NUMBER -- membership_id for which end date needs to be updated
449: , p_new_date IN DATE
450: , p_comments IN VARCHAR2 DEFAULT NULL
451: , x_return_status OUT NOCOPY VARCHAR2

Line 459: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

455:
456: PROCEDURE downgrade_membership
457: (
458: p_api_version_number IN NUMBER
459: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
460: , p_commit IN VARCHAR2 := FND_API.G_FALSE
461: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
462: , p_membership_id IN NUMBER -- membership id of the program that you are dwongrading
463: , p_status_reason_code IN VARCHAR2 -- reason for termoination or downgrade

Line 460: , p_commit IN VARCHAR2 := FND_API.G_FALSE

456: PROCEDURE downgrade_membership
457: (
458: p_api_version_number IN NUMBER
459: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
460: , p_commit IN VARCHAR2 := FND_API.G_FALSE
461: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
462: , p_membership_id IN NUMBER -- membership id of the program that you are dwongrading
463: , p_status_reason_code IN VARCHAR2 -- reason for termoination or downgrade
464: , p_comments IN VARCHAR2 DEFAULT NULL

Line 461: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

457: (
458: p_api_version_number IN NUMBER
459: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
460: , p_commit IN VARCHAR2 := FND_API.G_FALSE
461: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
462: , p_membership_id IN NUMBER -- membership id of the program that you are dwongrading
463: , p_status_reason_code IN VARCHAR2 -- reason for termoination or downgrade
464: , p_comments IN VARCHAR2 DEFAULT NULL
465: , p_program_id_downgraded_to IN NUMBER --programid into which the partner is downgraded to.