APPS.AHL_PRD_DF_PVT dependencies on FND_PROFILE

Line 400: AND APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))) ;

396: SELECT mr_header_id,cs_incident_id,repetitive_mr_flag,orig_deferral_ue_id,ue_status_code,
397: def_status_code,manually_planned_flag
398: FROM ahl_ue_deferral_details_v
399: WHERE unit_effectivity_id = p_unit_effectivity_id
400: AND APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))) ;
401:
402: l_mr_header_id NUMBER;
403: l_incident_id NUMBER;
404: l_orig_deferral_ue_id NUMBER;

Line 4479: X_APPLICATION_USG_CODE => RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))),

4475: X_ATTRIBUTE13 => null,
4476: X_ATTRIBUTE14 => null,
4477: X_ATTRIBUTE15 => null,
4478: X_OBJECT_VERSION_NUMBER => 1,
4479: X_APPLICATION_USG_CODE => RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))),
4480: X_OBJECT_TYPE => ue_rec.object_type,
4481: X_MANUALLY_PLANNED_FLAG => ue_rec.manually_planned_flag,
4482: X_COUNTER_ID => ue_rec.counter_id,
4483: X_LOG_SERIES_CODE => ue_rec.log_series_code,

Line 4546: X_APPLICATION_USG_CODE => RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))),

4542: x_defer_from_ue_id => ue_rec.defer_from_ue_id,
4543: x_qa_collection_id => ue_rec.qa_collection_id,
4544: x_cs_incident_id => ue_rec.cs_incident_id,
4545: x_orig_deferral_ue_id => ue_rec.orig_deferral_ue_id,
4546: X_APPLICATION_USG_CODE => RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))),
4547: X_COUNTER_ID => ue_rec.counter_id,
4548: X_OBJECT_TYPE => ue_rec.object_type,
4549: X_MANUALLY_PLANNED_FLAG => ue_rec.manually_planned_flag,
4550: X_LOG_SERIES_CODE => ue_rec.log_series_code,

Line 4615: l_status_id := FND_PROFILE.VALUE('AHL_PRD_SR_CANCELLED_STATUS');

4611: END IF;
4612:
4613: -- Support for cancelled SRs.
4614: IF (p_new_status = 'CANCELLED') THEN
4615: l_status_id := FND_PROFILE.VALUE('AHL_PRD_SR_CANCELLED_STATUS');
4616: IF (l_status_id IS NULL) THEN
4617: l_status_id := 2; -- closed.
4618: END IF;
4619: ELSE -- Deferred

Line 4745: X_APPLICATION_USG_CODE => RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))),

4741: x_defer_from_ue_id => ue_rec.defer_from_ue_id,
4742: x_qa_collection_id => ue_rec.qa_collection_id,
4743: x_cs_incident_id => ue_rec.cs_incident_id,
4744: x_orig_deferral_ue_id => l_orig_deferral_ue_id,
4745: X_APPLICATION_USG_CODE => RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))),
4746: X_OBJECT_TYPE => ue_rec.object_type,
4747: X_MANUALLY_PLANNED_FLAG => ue_rec.manually_planned_flag,
4748: X_COUNTER_ID => ue_rec.counter_id,
4749: X_LOG_SERIES_CODE => ue_rec.log_series_code,

Line 4920: X_APPLICATION_USG_CODE => RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))),

4916: x_defer_from_ue_id => ue_rec.defer_from_ue_id,
4917: x_qa_collection_id => ue_rec.qa_collection_id,
4918: x_cs_incident_id => ue_rec.cs_incident_id,
4919: x_orig_deferral_ue_id => ue_rec.orig_deferral_ue_id,
4920: X_APPLICATION_USG_CODE => RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))),
4921: X_OBJECT_TYPE => ue_rec.object_type,
4922: X_MANUALLY_PLANNED_FLAG => ue_rec.manually_planned_flag,
4923: X_COUNTER_ID => ue_rec.counter_id,
4924: X_LOG_SERIES_CODE => ue_rec.log_series_code,

Line 5009: AND APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))) ;--this takes care of app_usage changes

5005: SELECT due_date, mr_header_id,title,description,repetitive_mr_flag,cs_incident_id,cs_incident_number,
5006: cs_incident_summary,manually_planned_flag
5007: FROM ahl_ue_deferral_details_v
5008: WHERE unit_effectivity_id = p_unit_effectivity_id
5009: AND APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))) ;--this takes care of app_usage changes
5010:
5011: -- mr status meaning has to be fecthed seperately because function returns only code
5012: CURSOR mr_status_meaning_csr(p_status_code IN VARCHAR2)IS
5013: SELECT meaning FROM FND_LOOKUP_VALUES_VL