DBA Data[Home] [Help]

APPS.PV_TAP_ACCESS_TERRS_PVT dependencies on FND_GLOBAL

Line 27: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

23: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
24: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
25: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
26:
27: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
28: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
29: --
30: -- Foreward Procedure Declarations
31: --

Line 28: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

24: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
25: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
26:
27: -- G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
28: -- G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
29: --
30: -- Foreward Procedure Declarations
31: --
32:

Line 121: IF FND_GLOBAL.USER_ID IS NULL

117: -- =========================================================================
118: -- Validate Environment
119: -- =========================================================================
120:
121: IF FND_GLOBAL.USER_ID IS NULL
122: THEN
123: PVX_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
124: RAISE FND_API.G_EXC_ERROR;
125: END IF;

Line 165: p_last_updated_by => FND_GLOBAL.USER_ID,

161: Pv_Tap_Access_Terrs_Pkg.Insert_Row(
162: p_partner_access_id => p_tap_access_terrs_rec.partner_access_id,
163: p_terr_id => p_tap_access_terrs_rec.terr_id,
164: p_last_update_date => SYSDATE,
165: p_last_updated_by => FND_GLOBAL.USER_ID,
166: p_creation_date => SYSDATE,
167: p_created_by => FND_GLOBAL.USER_ID,
168: p_last_update_login => FND_GLOBAL.conc_login_id,
169: p_object_version_number => l_object_version_number,

Line 167: p_created_by => FND_GLOBAL.USER_ID,

163: p_terr_id => p_tap_access_terrs_rec.terr_id,
164: p_last_update_date => SYSDATE,
165: p_last_updated_by => FND_GLOBAL.USER_ID,
166: p_creation_date => SYSDATE,
167: p_created_by => FND_GLOBAL.USER_ID,
168: p_last_update_login => FND_GLOBAL.conc_login_id,
169: p_object_version_number => l_object_version_number,
170: p_request_id => p_tap_access_terrs_rec.request_id,
171: p_program_application_id => p_tap_access_terrs_rec.program_application_id,

Line 168: p_last_update_login => FND_GLOBAL.conc_login_id,

164: p_last_update_date => SYSDATE,
165: p_last_updated_by => FND_GLOBAL.USER_ID,
166: p_creation_date => SYSDATE,
167: p_created_by => FND_GLOBAL.USER_ID,
168: p_last_update_login => FND_GLOBAL.conc_login_id,
169: p_object_version_number => l_object_version_number,
170: p_request_id => p_tap_access_terrs_rec.request_id,
171: p_program_application_id => p_tap_access_terrs_rec.program_application_id,
172: p_program_id => p_tap_access_terrs_rec.program_id,

Line 424: p_last_updated_by => FND_GLOBAL.USER_ID,

420: Pv_Tap_Access_Terrs_Pkg.Update_Row(
421: p_partner_access_id => p_tap_access_terrs_rec.partner_access_id,
422: p_terr_id => p_tap_access_terrs_rec.terr_id,
423: p_last_update_date => SYSDATE,
424: p_last_updated_by => FND_GLOBAL.USER_ID,
425: p_last_update_login => FND_GLOBAL.conc_login_id,
426: p_object_version_number => p_tap_access_terrs_rec.object_version_number,
427: p_request_id => p_tap_access_terrs_rec.request_id,
428: p_program_application_id => p_tap_access_terrs_rec.program_application_id,

Line 425: p_last_update_login => FND_GLOBAL.conc_login_id,

421: p_partner_access_id => p_tap_access_terrs_rec.partner_access_id,
422: p_terr_id => p_tap_access_terrs_rec.terr_id,
423: p_last_update_date => SYSDATE,
424: p_last_updated_by => FND_GLOBAL.USER_ID,
425: p_last_update_login => FND_GLOBAL.conc_login_id,
426: p_object_version_number => p_tap_access_terrs_rec.object_version_number,
427: p_request_id => p_tap_access_terrs_rec.request_id,
428: p_program_application_id => p_tap_access_terrs_rec.program_application_id,
429: p_program_id => p_tap_access_terrs_rec.program_id,

Line 1086: l_tap_access_terrs_rec.last_update_login := FND_GLOBAL.user_id ;

1082: l_tap_access_terrs_rec tap_access_terrs_rec_type := p_tap_access_terrs_rec;
1083: BEGIN
1084:
1085: IF p_tap_access_terrs_rec.last_update_login IS NULL OR p_tap_access_terrs_rec.last_update_login = FND_API.G_MISS_NUM THEN
1086: l_tap_access_terrs_rec.last_update_login := FND_GLOBAL.user_id ;
1087: END IF ;
1088:
1089: IF p_tap_access_terrs_rec.last_update_date IS NULL OR p_tap_access_terrs_rec.last_update_date = FND_API.G_MISS_DATE THEN
1090: l_tap_access_terrs_rec.last_update_date := sysdate;

Line 1094: l_tap_access_terrs_rec.last_updated_by := FND_GLOBAL.user_id ;

1090: l_tap_access_terrs_rec.last_update_date := sysdate;
1091: END IF ;
1092:
1093: IF p_tap_access_terrs_rec.last_updated_by IS NULL OR p_tap_access_terrs_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1094: l_tap_access_terrs_rec.last_updated_by := FND_GLOBAL.user_id ;
1095: END IF ;
1096:
1097: IF p_tap_access_terrs_rec.creation_date IS NULL OR p_tap_access_terrs_rec.creation_date = FND_API.G_MISS_DATE THEN
1098: l_tap_access_terrs_rec.creation_date := sysdate ;

Line 1102: l_tap_access_terrs_rec.created_by := FND_GLOBAL.user_id ;

1098: l_tap_access_terrs_rec.creation_date := sysdate ;
1099: END IF ;
1100:
1101: IF p_tap_access_terrs_rec.created_by IS NULL OR p_tap_access_terrs_rec.created_by = FND_API.G_MISS_NUM THEN
1102: l_tap_access_terrs_rec.created_by := FND_GLOBAL.user_id ;
1103: END IF ;
1104:
1105: IF p_tap_access_terrs_rec.object_version_number IS NULL OR p_tap_access_terrs_rec.object_version_number = FND_API.G_MISS_NUM THEN
1106: l_tap_access_terrs_rec.object_version_number := 1 ;