19:
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'pv_pg_mmbr_transitions_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvmbtb.pls';
22:
23: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
24: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
25: --
26: -- Foreward Procedure Declarations
27: --
20: G_PKG_NAME CONSTANT VARCHAR2(30):= 'pv_pg_mmbr_transitions_PVT';
21: G_FILE_NAME CONSTANT VARCHAR2(12) := 'pvxvmbtb.pls';
22:
23: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
24: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
25: --
26: -- Foreward Procedure Declarations
27: --
28:
137: -- =========================================================================
138: -- Validate Environment
139: -- =========================================================================
140:
141: IF FND_GLOBAL.USER_ID IS NULL
142: THEN
143: PVX_UTILITY_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
144: RAISE FND_API.G_EXC_ERROR;
145: END IF;
199: px_mmbr_transition_id => l_mmbr_transition_id,
200: p_from_membership_id => p_mmbr_tran_rec.from_membership_id,
201: p_to_membership_id => p_mmbr_tran_rec.to_membership_id,
202: px_object_version_number => l_object_version_number,
203: p_created_by => FND_GLOBAL.USER_ID,
204: p_creation_date => SYSDATE,
205: p_last_updated_by => FND_GLOBAL.USER_ID,
206: p_last_update_date => SYSDATE,
207: p_last_update_login => FND_GLOBAL.conc_login_id
201: p_to_membership_id => p_mmbr_tran_rec.to_membership_id,
202: px_object_version_number => l_object_version_number,
203: p_created_by => FND_GLOBAL.USER_ID,
204: p_creation_date => SYSDATE,
205: p_last_updated_by => FND_GLOBAL.USER_ID,
206: p_last_update_date => SYSDATE,
207: p_last_update_login => FND_GLOBAL.conc_login_id
208: );
209:
203: p_created_by => FND_GLOBAL.USER_ID,
204: p_creation_date => SYSDATE,
205: p_last_updated_by => FND_GLOBAL.USER_ID,
206: p_last_update_date => SYSDATE,
207: p_last_update_login => FND_GLOBAL.conc_login_id
208: );
209:
210: x_mmbr_transition_id := l_mmbr_transition_id;
211: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
450: p_mmbr_transition_id => p_mmbr_tran_rec.mmbr_transition_id,
451: p_from_membership_id => p_mmbr_tran_rec.from_membership_id,
452: p_to_membership_id => p_mmbr_tran_rec.to_membership_id,
453: p_object_version_number => p_mmbr_tran_rec.object_version_number,
454: p_last_updated_by => FND_GLOBAL.USER_ID,
455: p_last_update_date => SYSDATE,
456: p_last_update_login => FND_GLOBAL.conc_login_id
457: );
458: --
452: p_to_membership_id => p_mmbr_tran_rec.to_membership_id,
453: p_object_version_number => p_mmbr_tran_rec.object_version_number,
454: p_last_updated_by => FND_GLOBAL.USER_ID,
455: p_last_update_date => SYSDATE,
456: p_last_update_login => FND_GLOBAL.conc_login_id
457: );
458: --
459: -- End of API body.
460: --