DBA Data[Home] [Help]

APPS.AHL_RA_SETUPS_PVT dependencies on AHL_RA_FCT_ASSOCIATIONS_S

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 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 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