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.AHL_RA_SETUPS_PVT dependencies on AHL_RA_FCT_ASSOCIATIONS

Line 2656: -- Function : This API would create the setup data for Reliability Framework in AHL_RA_FCT_ASSOCIATIONS

2652: -- Start of Comments --
2653: --
2654: -- Procedure name : CREATE_FCT_ASSOC_DATA
2655: -- Type : Private
2656: -- Function : This API would create the setup data for Reliability Framework in AHL_RA_FCT_ASSOCIATIONS
2657: -- Pre-reqs :
2658: --
2659: -- Standard IN Parameters :
2660: -- p_api_version IN NUMBER Required

Line 2826: -- 3. records with Overlapping values of probablities should not exist for the Org Id and forecast designator in AHL_RA_FCT_ASSOCIATIONS

2822: -- When ASSOCIATION_TYPE_CODE = 'ASSOC_HISTORICAL'
2823: -- Validate PROBABILITY_FROM and PROBABILITY_TO passed
2824: -- 1. Neither PROBABILITY_FROM nor PROBABILITY_TO can be passed less than zero or greater than 100
2825: -- 2. PROBABILITY_TO should be >= PROBABILITY_FROM
2826: -- 3. records with Overlapping values of probablities should not exist for the Org Id and forecast designator in AHL_RA_FCT_ASSOCIATIONS
2827: IF (l_fct_assoc_rec.ASSOCIATION_TYPE_CODE = 'ASSOC_HISTORICAL') THEN
2828:
2829: -- 1. Neither PROBABILITY_FROM nor PROBABILITY_TO can be passed less than zero or greater than 100
2830: IF (l_fct_assoc_rec.PROBABILITY_FROM < 0 OR

Line 2860: -- 3. records with Overlapping values of probablities should not exist for the Org Id in AHL_RA_FCT_ASSOCIATIONS

2856: FND_MSG_PUB.ADD;
2857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2858: END IF;
2859:
2860: -- 3. records with Overlapping values of probablities should not exist for the Org Id in AHL_RA_FCT_ASSOCIATIONS
2861: BEGIN
2862: SELECT 'Y'
2863: INTO l_dummy
2864: FROM DUAL

Line 2866: FROM AHL_RA_FCT_ASSOCIATIONS

2862: SELECT 'Y'
2863: INTO l_dummy
2864: FROM DUAL
2865: WHERE EXISTS (SELECT 'X'
2866: FROM AHL_RA_FCT_ASSOCIATIONS
2867: WHERE ORGANIZATION_ID = l_fct_assoc_rec.ORGANIZATION_ID
2868: -- Bug 4998568 :: Probability Values Should not overlap irrespective of the Fct Designator
2869: -- AND FORECAST_DESIGNATOR = l_fct_assoc_rec.FORECAST_DESIGNATOR
2870: AND ASSOCIATION_TYPE_CODE = l_fct_assoc_rec.ASSOCIATION_TYPE_CODE

Line 2898: -- Validate for Duplicate records in AHL_RA_FCT_ASSOCIATIONS since only one MTBF Association

2894: END;
2895:
2896: ELSIF (l_fct_assoc_rec.ASSOCIATION_TYPE_CODE = 'ASSOC_MTBF') THEN
2897: -- Elsif When ASSOCIATION_TYPE_CODE = 'ASSOC_MTBF'
2898: -- Validate for Duplicate records in AHL_RA_FCT_ASSOCIATIONS since only one MTBF Association
2899: -- Record can be created for each Organization - irrespective of the Forecast Selected.
2900: BEGIN
2901: SELECT 'Y'
2902: INTO l_dummy

Line 2905: FROM AHL_RA_FCT_ASSOCIATIONS

2901: SELECT 'Y'
2902: INTO l_dummy
2903: FROM DUAL
2904: WHERE EXISTS (SELECT 'X'
2905: FROM AHL_RA_FCT_ASSOCIATIONS
2906: WHERE ORGANIZATION_ID = l_fct_assoc_rec.ORGANIZATION_ID
2907: AND ASSOCIATION_TYPE_CODE = l_fct_assoc_rec.ASSOCIATION_TYPE_CODE);
2908:
2909: IF (fnd_log.leVEL_STATEMENT >= fnd_log.g_current_runtime_level)THEN

Line 2933: SELECT AHL_RA_FCT_ASSOCIATIONS_S.NEXTVAL INTO l_fct_assoc_rec.RA_FCT_ASSOCIATION_ID FROM DUAL;

2929:
2930: END IF;
2931:
2932: -- Initialize RA_FCT_ASSOCIATION_ID to sequence next val for insert
2933: SELECT AHL_RA_FCT_ASSOCIATIONS_S.NEXTVAL INTO l_fct_assoc_rec.RA_FCT_ASSOCIATION_ID FROM DUAL;
2934:
2935: -- Initialize object version number to 1
2936: l_fct_assoc_rec.OBJECT_VERSION_NUMBER := 1;
2937:

Line 2952: -- INSERT Forecast Associations Data in AHL_RA_FCT_ASSOCIATIONS

2948: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2949: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Derived RA_FCT_ASSOCIATION_ID -- ' || l_fct_assoc_rec.RA_FCT_ASSOCIATION_ID);
2950: END IF;
2951:
2952: -- INSERT Forecast Associations Data in AHL_RA_FCT_ASSOCIATIONS
2953: INSERT INTO AHL_RA_FCT_ASSOCIATIONS(RA_FCT_ASSOCIATION_ID,FORECAST_DESIGNATOR,ASSOCIATION_TYPE_CODE,ORGANIZATION_ID,PROBABILITY_FROM, PROBABILITY_TO,
2954: OBJECT_VERSION_NUMBER,SECURITY_GROUP_ID,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,
2955: LAST_UPDATE_LOGIN,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,
2956: ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15)

Line 2953: INSERT INTO AHL_RA_FCT_ASSOCIATIONS(RA_FCT_ASSOCIATION_ID,FORECAST_DESIGNATOR,ASSOCIATION_TYPE_CODE,ORGANIZATION_ID,PROBABILITY_FROM, PROBABILITY_TO,

2949: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Derived RA_FCT_ASSOCIATION_ID -- ' || l_fct_assoc_rec.RA_FCT_ASSOCIATION_ID);
2950: END IF;
2951:
2952: -- INSERT Forecast Associations Data in AHL_RA_FCT_ASSOCIATIONS
2953: INSERT INTO AHL_RA_FCT_ASSOCIATIONS(RA_FCT_ASSOCIATION_ID,FORECAST_DESIGNATOR,ASSOCIATION_TYPE_CODE,ORGANIZATION_ID,PROBABILITY_FROM, PROBABILITY_TO,
2954: OBJECT_VERSION_NUMBER,SECURITY_GROUP_ID,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,
2955: LAST_UPDATE_LOGIN,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,
2956: ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15)
2957: VALUES(

Line 3046: -- Function : This API would update the setup data for Reliability Framework in AHL_RA_FCT_ASSOCIATIONS

3042: -- Start of Comments --
3043: --
3044: -- Procedure name : UPDATE_FCT_ASSOC_DATA
3045: -- Type : Private
3046: -- Function : This API would update the setup data for Reliability Framework in AHL_RA_FCT_ASSOCIATIONS
3047: -- Update Logic to be used - NULL : Do not update
3048: -- G_MISS_XXXX : Nullify
3049: -- Valid Values : Update
3050: -- Pre-reqs :

Line 3086: l_obj_version_num AHL_RA_FCT_ASSOCIATIONS.OBJECT_VERSION_NUMBER%TYPE;

3082: l_api_version CONSTANT NUMBER := 1.0;
3083: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;
3084:
3085: l_fct_assoc_rec AHL_RA_SETUPS_PVT.RA_FCT_ASSOC_REC_TYPE DEFAULT p_x_fct_assoc_rec;
3086: l_obj_version_num AHL_RA_FCT_ASSOCIATIONS.OBJECT_VERSION_NUMBER%TYPE;
3087: l_dummy varchar2(1);
3088:
3089: BEGIN
3090:

Line 3172: FROM AHL_RA_FCT_ASSOCIATIONS

3168: ,l_fct_assoc_rec.ASSOCIATION_TYPE_CODE
3169: ,l_fct_assoc_rec.ORGANIZATION_ID
3170: ,l_fct_assoc_rec.PROBABILITY_FROM
3171: ,l_fct_assoc_rec.PROBABILITY_TO
3172: FROM AHL_RA_FCT_ASSOCIATIONS
3173: WHERE RA_FCT_ASSOCIATION_ID = l_fct_assoc_rec.RA_FCT_ASSOCIATION_ID
3174: FOR UPDATE OF object_version_number NOWAIT;
3175:
3176: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 3309: -- 3. records with Overlapping values of probablities should not exist for the Org Id in AHL_RA_FCT_ASSOCIATIONS

3305: -- When ASSOCIATION_TYPE_CODE = 'ASSOC_HISTORICAL'
3306: -- Validate PROBABILITY_FROM and PROBABILITY_TO passed
3307: -- 1. Neither PROBABILITY_FROM nor PROBABILITY_TO can be passed less than zero or greater than 100
3308: -- 2. PROBABILITY_TO should be >= PROBABILITY_FROM
3309: -- 3. records with Overlapping values of probablities should not exist for the Org Id in AHL_RA_FCT_ASSOCIATIONS
3310: IF (l_fct_assoc_rec.ASSOCIATION_TYPE_CODE = 'ASSOC_HISTORICAL') THEN
3311:
3312: -- 1. Neither PROBABILITY_FROM nor PROBABILITY_TO can be passed less than zero or greater than 100
3313: IF (l_fct_assoc_rec.PROBABILITY_FROM < 0 OR

Line 3343: -- 3. records with Overlapping values of probablities should not exist for the Org Id and forecast designator in AHL_RA_FCT_ASSOCIATIONS

3339: FND_MSG_PUB.ADD;
3340: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
3341: END IF;
3342:
3343: -- 3. records with Overlapping values of probablities should not exist for the Org Id and forecast designator in AHL_RA_FCT_ASSOCIATIONS
3344: BEGIN
3345: SELECT 'Y'
3346: INTO l_dummy
3347: FROM DUAL

Line 3349: FROM AHL_RA_FCT_ASSOCIATIONS

3345: SELECT 'Y'
3346: INTO l_dummy
3347: FROM DUAL
3348: WHERE EXISTS (SELECT 'X'
3349: FROM AHL_RA_FCT_ASSOCIATIONS
3350: WHERE ORGANIZATION_ID = l_fct_assoc_rec.ORGANIZATION_ID
3351: -- Bug 4998568 :: Probability Values Should not overlap irrespective of the Fct Designator
3352: -- AND FORECAST_DESIGNATOR = l_fct_assoc_rec.FORECAST_DESIGNATOR
3353: AND ASSOCIATION_TYPE_CODE = l_fct_assoc_rec.ASSOCIATION_TYPE_CODE

Line 3382: -- Validate for Duplicate records in AHL_RA_FCT_ASSOCIATIONS since only one MTBF Association

3378: END;
3379:
3380: ELSIF (l_fct_assoc_rec.ASSOCIATION_TYPE_CODE = 'ASSOC_MTBF') THEN
3381: -- Elsif When ASSOCIATION_TYPE_CODE = 'ASSOC_MTBF'
3382: -- Validate for Duplicate records in AHL_RA_FCT_ASSOCIATIONS since only one MTBF Association
3383: -- Record can be created for each Organization - irrespective of the Forecast Selected.
3384: BEGIN
3385: SELECT 'Y'
3386: INTO l_dummy

Line 3389: FROM AHL_RA_FCT_ASSOCIATIONS

3385: SELECT 'Y'
3386: INTO l_dummy
3387: FROM DUAL
3388: WHERE EXISTS (SELECT 'X'
3389: FROM AHL_RA_FCT_ASSOCIATIONS
3390: WHERE ORGANIZATION_ID = l_fct_assoc_rec.ORGANIZATION_ID
3391: AND ASSOCIATION_TYPE_CODE = l_fct_assoc_rec.ASSOCIATION_TYPE_CODE
3392: AND RA_FCT_ASSOCIATION_ID <> l_fct_assoc_rec.RA_FCT_ASSOCIATION_ID); -- Update of the ame record to bump OVN is allowed
3393:

Line 3428: -- INSERT Forecast Associations Data in AHL_RA_FCT_ASSOCIATIONS

3424: l_fct_assoc_rec.LAST_UPDATE_DATE := sysdate;
3425: l_fct_assoc_rec.CREATED_BY := fnd_global.user_id;
3426: l_fct_assoc_rec.CREATION_DATE := sysdate;
3427:
3428: -- INSERT Forecast Associations Data in AHL_RA_FCT_ASSOCIATIONS
3429: UPDATE AHL_RA_FCT_ASSOCIATIONS
3430: SET FORECAST_DESIGNATOR = l_fct_assoc_rec.FORECAST_DESIGNATOR -- FORECAST_DESIGNATOR
3431: ,ASSOCIATION_TYPE_CODE = l_fct_assoc_rec.ASSOCIATION_TYPE_CODE -- ASSOCIATION_TYPE_CODE
3432: ,ORGANIZATION_ID = l_fct_assoc_rec.ORGANIZATION_ID -- ORGANIZATION_ID

Line 3429: UPDATE AHL_RA_FCT_ASSOCIATIONS

3425: l_fct_assoc_rec.CREATED_BY := fnd_global.user_id;
3426: l_fct_assoc_rec.CREATION_DATE := sysdate;
3427:
3428: -- INSERT Forecast Associations Data in AHL_RA_FCT_ASSOCIATIONS
3429: UPDATE AHL_RA_FCT_ASSOCIATIONS
3430: SET FORECAST_DESIGNATOR = l_fct_assoc_rec.FORECAST_DESIGNATOR -- FORECAST_DESIGNATOR
3431: ,ASSOCIATION_TYPE_CODE = l_fct_assoc_rec.ASSOCIATION_TYPE_CODE -- ASSOCIATION_TYPE_CODE
3432: ,ORGANIZATION_ID = l_fct_assoc_rec.ORGANIZATION_ID -- ORGANIZATION_ID
3433: ,PROBABILITY_FROM = l_fct_assoc_rec.PROBABILITY_FROM -- PROBABILITY_FROM

Line 3515: -- Function : This API would delete the setup data for Reliability Framework in AHL_RA_FCT_ASSOCIATIONS

3511: -- Start of Comments --
3512: --
3513: -- Procedure name : DELETE_FCT_ASSOC_DATA
3514: -- Type : Private
3515: -- Function : This API would delete the setup data for Reliability Framework in AHL_RA_FCT_ASSOCIATIONS
3516: -- Pre-reqs :
3517: --
3518: -- Standard IN Parameters :
3519: -- p_api_version IN NUMBER Required

Line 3551: l_obj_version_num AHL_RA_FCT_ASSOCIATIONS.OBJECT_VERSION_NUMBER%TYPE;

3547: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_FCT_ASSOC_DATA';
3548: l_api_version CONSTANT NUMBER := 1.0;
3549: L_FULL_NAME CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME || '.' || L_API_NAME;
3550:
3551: l_obj_version_num AHL_RA_FCT_ASSOCIATIONS.OBJECT_VERSION_NUMBER%TYPE;
3552:
3553: BEGIN
3554:
3555: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 3600: FROM AHL_RA_FCT_ASSOCIATIONS

3596: -- Check for existence of record and fetch OVN for change record validation
3597: BEGIN
3598: SELECT OBJECT_VERSION_NUMBER
3599: INTO l_obj_version_num
3600: FROM AHL_RA_FCT_ASSOCIATIONS
3601: WHERE RA_FCT_ASSOCIATION_ID = p_fct_assoc_rec.RA_FCT_ASSOCIATION_ID
3602: FOR UPDATE OF object_version_number NOWAIT;
3603:
3604: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 3629: -- Delete Record from AHL_RA_FCT_ASSOCIATIONS

3625: FND_MSG_PUB.ADD;
3626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3627: END IF;
3628:
3629: -- Delete Record from AHL_RA_FCT_ASSOCIATIONS
3630: DELETE AHL_RA_FCT_ASSOCIATIONS
3631: WHERE RA_FCT_ASSOCIATION_ID = p_fct_assoc_rec.RA_FCT_ASSOCIATION_ID;
3632:
3633: -- Standard check for p_commit

Line 3630: DELETE AHL_RA_FCT_ASSOCIATIONS

3626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3627: END IF;
3628:
3629: -- Delete Record from AHL_RA_FCT_ASSOCIATIONS
3630: DELETE AHL_RA_FCT_ASSOCIATIONS
3631: WHERE RA_FCT_ASSOCIATION_ID = p_fct_assoc_rec.RA_FCT_ASSOCIATION_ID;
3632:
3633: -- Standard check for p_commit
3634: IF FND_API.To_Boolean (p_commit) THEN