DBA Data[Home] [Help]

APPS.PV_PARTNER_PROGRAM_PVT dependencies on FND_GLOBAL

Line 1070: IF FND_GLOBAL.User_Id IS NULL THEN

1066: x_return_status := FND_API.G_RET_STS_SUCCESS;
1067:
1068: --------------- validate -------------------------
1069:
1070: IF FND_GLOBAL.User_Id IS NULL THEN
1071: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
1072: FND_MSG_PUB.add;
1073: RAISE FND_API.G_EXC_ERROR;
1074: END IF;

Line 1095: OPEN c_resource_id(FND_GLOBAL.USER_ID);

1091: END LOOP;
1092: END IF;
1093:
1094:
1095: OPEN c_resource_id(FND_GLOBAL.USER_ID);
1096: FETCH c_resource_id into l_rules_rec.owner_resource_id;
1097: CLOSE c_resource_id;
1098:
1099: --get the currency of the logged in user

Line 1128: l_rules_rec.last_updated_by := FND_GLOBAL.USER_ID;

1124: l_rules_rec.process_type := 'PARTNER_PROGRAM';
1125: l_rules_rec.rank := 0;
1126: l_rules_rec.object_version_number := l_object_version_number;
1127: l_rules_rec.last_update_date := SYSDATE;
1128: l_rules_rec.last_updated_by := FND_GLOBAL.USER_ID;
1129: l_rules_rec.creation_date := SYSDATE;
1130: l_rules_rec.created_by := FND_GLOBAL.USER_ID;
1131: l_rules_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
1132: l_rules_rec.start_date := sysdate;

Line 1130: l_rules_rec.created_by := FND_GLOBAL.USER_ID;

1126: l_rules_rec.object_version_number := l_object_version_number;
1127: l_rules_rec.last_update_date := SYSDATE;
1128: l_rules_rec.last_updated_by := FND_GLOBAL.USER_ID;
1129: l_rules_rec.creation_date := SYSDATE;
1130: l_rules_rec.created_by := FND_GLOBAL.USER_ID;
1131: l_rules_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
1132: l_rules_rec.start_date := sysdate;
1133: l_rules_rec.status_code := 'ACTIVE';
1134: l_rules_rec.end_date := null;

Line 1131: l_rules_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

1127: l_rules_rec.last_update_date := SYSDATE;
1128: l_rules_rec.last_updated_by := FND_GLOBAL.USER_ID;
1129: l_rules_rec.creation_date := SYSDATE;
1130: l_rules_rec.created_by := FND_GLOBAL.USER_ID;
1131: l_rules_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
1132: l_rules_rec.start_date := sysdate;
1133: l_rules_rec.status_code := 'ACTIVE';
1134: l_rules_rec.end_date := null;
1135: l_rules_rec.currency_code := l_currency;

Line 1208: l_ptr_prgm_rec.last_updated_by := FND_GLOBAL.USER_ID;

1204: END IF;
1205:
1206: -- Populate the default required items
1207: l_ptr_prgm_rec.last_update_date := SYSDATE;
1208: l_ptr_prgm_rec.last_updated_by := FND_GLOBAL.USER_ID;
1209: l_ptr_prgm_rec.creation_date := SYSDATE;
1210: l_ptr_prgm_rec.created_by := FND_GLOBAL.USER_ID;
1211: l_ptr_prgm_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
1212: l_ptr_prgm_rec.object_version_number := l_object_version_number;

Line 1210: l_ptr_prgm_rec.created_by := FND_GLOBAL.USER_ID;

1206: -- Populate the default required items
1207: l_ptr_prgm_rec.last_update_date := SYSDATE;
1208: l_ptr_prgm_rec.last_updated_by := FND_GLOBAL.USER_ID;
1209: l_ptr_prgm_rec.creation_date := SYSDATE;
1210: l_ptr_prgm_rec.created_by := FND_GLOBAL.USER_ID;
1211: l_ptr_prgm_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
1212: l_ptr_prgm_rec.object_version_number := l_object_version_number;
1213:
1214: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 1211: l_ptr_prgm_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

1207: l_ptr_prgm_rec.last_update_date := SYSDATE;
1208: l_ptr_prgm_rec.last_updated_by := FND_GLOBAL.USER_ID;
1209: l_ptr_prgm_rec.creation_date := SYSDATE;
1210: l_ptr_prgm_rec.created_by := FND_GLOBAL.USER_ID;
1211: l_ptr_prgm_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
1212: l_ptr_prgm_rec.object_version_number := l_object_version_number;
1213:
1214: IF ( p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1215: -- Debug message

Line 2072: ,p_last_updated_by => FND_GLOBAL.USER_ID

2068: ,p_attribute13 => l_tar_ptr_prgm_rec.attribute13
2069: ,p_attribute14 => l_tar_ptr_prgm_rec.attribute14
2070: ,p_attribute15 => l_tar_ptr_prgm_rec.attribute15
2071: ,p_last_update_date => SYSDATE
2072: ,p_last_updated_by => FND_GLOBAL.USER_ID
2073: ,p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
2074: ,p_object_version_number => l_tar_ptr_prgm_rec.object_version_number
2075: ,p_program_name => l_tar_ptr_prgm_rec.program_name
2076: ,p_program_description => l_tar_ptr_prgm_rec.program_description

Line 2073: ,p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID

2069: ,p_attribute14 => l_tar_ptr_prgm_rec.attribute14
2070: ,p_attribute15 => l_tar_ptr_prgm_rec.attribute15
2071: ,p_last_update_date => SYSDATE
2072: ,p_last_updated_by => FND_GLOBAL.USER_ID
2073: ,p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
2074: ,p_object_version_number => l_tar_ptr_prgm_rec.object_version_number
2075: ,p_program_name => l_tar_ptr_prgm_rec.program_name
2076: ,p_program_description => l_tar_ptr_prgm_rec.program_description
2077: ,p_qsnr_title => l_tar_ptr_prgm_rec.qsnr_title

Line 4066: AND res.user_id = fnd_global.user_id;

4062: CURSOR C_get_current_resource IS
4063: SELECT res.resource_id resource_id
4064: FROM jtf_rs_resource_extns res
4065: WHERE res.category IN ('EMPLOYEE', 'PARTY')
4066: AND res.user_id = fnd_global.user_id;
4067:
4068: l_src_ptr_pgrm_rec c_get_ptr_prgm_rec%ROWTYPE;
4069: l_new_ptr_pgrm_rec ptr_prgm_rec_type;
4070: l_new_program_id NUMBER;

Line 5622: OPEN c_resource_id(FND_GLOBAL.USER_ID);

5618: -- Initialize API return status to SUCCESS
5619: x_return_status := FND_API.G_RET_STS_SUCCESS;
5620:
5621:
5622: OPEN c_resource_id(FND_GLOBAL.USER_ID);
5623: FETCH c_resource_id into l_rules_rec.owner_resource_id;
5624: CLOSE c_resource_id;
5625:
5626: --get the currency of the logged in user

Line 5647: l_rules_rec.last_updated_by := FND_GLOBAL.USER_ID;

5643: l_rules_rec.process_type := 'PARTNER_PROGRAM';
5644: l_rules_rec.rank := 0;
5645: l_rules_rec.object_version_number := l_object_version_number;
5646: l_rules_rec.last_update_date := SYSDATE;
5647: l_rules_rec.last_updated_by := FND_GLOBAL.USER_ID;
5648: l_rules_rec.creation_date := SYSDATE;
5649: l_rules_rec.created_by := FND_GLOBAL.USER_ID;
5650: l_rules_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
5651: l_rules_rec.start_date := sysdate;

Line 5649: l_rules_rec.created_by := FND_GLOBAL.USER_ID;

5645: l_rules_rec.object_version_number := l_object_version_number;
5646: l_rules_rec.last_update_date := SYSDATE;
5647: l_rules_rec.last_updated_by := FND_GLOBAL.USER_ID;
5648: l_rules_rec.creation_date := SYSDATE;
5649: l_rules_rec.created_by := FND_GLOBAL.USER_ID;
5650: l_rules_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
5651: l_rules_rec.start_date := sysdate;
5652: l_rules_rec.status_code := 'ACTIVE';
5653: l_rules_rec.end_date := null;

Line 5650: l_rules_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;

5646: l_rules_rec.last_update_date := SYSDATE;
5647: l_rules_rec.last_updated_by := FND_GLOBAL.USER_ID;
5648: l_rules_rec.creation_date := SYSDATE;
5649: l_rules_rec.created_by := FND_GLOBAL.USER_ID;
5650: l_rules_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
5651: l_rules_rec.start_date := sysdate;
5652: l_rules_rec.status_code := 'ACTIVE';
5653: l_rules_rec.end_date := null;
5654: l_rules_rec.currency_code := l_currency;