APPS.AHL_PRD_DF_PVT dependencies on FND_PROFILE

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

403: SELECT mr_header_id,cs_incident_id,repetitive_mr_flag,orig_deferral_ue_id,ue_status_code,
404: def_status_code,manually_planned_flag
405: FROM ahl_ue_deferral_details_v
406: WHERE unit_effectivity_id = p_unit_effectivity_id
407: AND APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))) ;
408:
409: l_mr_header_id NUMBER;
410: l_incident_id NUMBER;
411: l_orig_deferral_ue_id NUMBER;

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

4642: RETURN;
4643: END IF;
4644: -- Support for cancelled SRs.
4645: IF (p_new_status = 'CANCELLED' AND l_serial_number IS NULL) THEN
4646: l_status_id := FND_PROFILE.VALUE('AHL_PRD_SR_CANCELLED_STATUS');
4647: IF (l_status_id IS NULL) THEN
4648: l_status_id := 2; -- closed.
4649: END IF;
4650: ELSE -- Deferred

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

4901: x_attribute13 => ue_rec.ATTRIBUTE13,
4902: x_attribute14 => ue_rec.ATTRIBUTE14,
4903: x_attribute15 => ue_rec.ATTRIBUTE15,
4904: X_OBJECT_VERSION_NUMBER => 1,
4905: X_APPLICATION_USG_CODE => RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))),
4906: X_OBJECT_TYPE => ue_rec.object_type,
4907: X_MANUALLY_PLANNED_FLAG => ue_rec.manually_planned_flag,
4908: X_COUNTER_ID => ue_rec.counter_id,
4909: X_LOG_SERIES_CODE => ue_rec.log_series_code,

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

4999: x_defer_from_ue_id => ue_rec.defer_from_ue_id,
5000: x_qa_collection_id => ue_rec.qa_collection_id,
5001: x_cs_incident_id => ue_rec.cs_incident_id,
5002: x_orig_deferral_ue_id => ue_rec.orig_deferral_ue_id,
5003: X_APPLICATION_USG_CODE => RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))),
5004: X_COUNTER_ID => ue_rec.counter_id,
5005: X_OBJECT_TYPE => ue_rec.object_type,
5006: X_MANUALLY_PLANNED_FLAG => ue_rec.manually_planned_flag,
5007: X_LOG_SERIES_CODE => ue_rec.log_series_code,

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

5119: x_defer_from_ue_id => ue_rec.defer_from_ue_id,
5120: x_qa_collection_id => ue_rec.qa_collection_id,
5121: x_cs_incident_id => ue_rec.cs_incident_id,
5122: x_orig_deferral_ue_id => l_orig_deferral_ue_id,
5123: X_APPLICATION_USG_CODE => RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))),
5124: X_OBJECT_TYPE => ue_rec.object_type,
5125: X_MANUALLY_PLANNED_FLAG => ue_rec.manually_planned_flag,
5126: X_COUNTER_ID => ue_rec.counter_id,
5127: X_LOG_SERIES_CODE => ue_rec.log_series_code,

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

5294: x_defer_from_ue_id => ue_rec.defer_from_ue_id,
5295: x_qa_collection_id => ue_rec.qa_collection_id,
5296: x_cs_incident_id => ue_rec.cs_incident_id,
5297: x_orig_deferral_ue_id => ue_rec.orig_deferral_ue_id,
5298: X_APPLICATION_USG_CODE => RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))),
5299: X_OBJECT_TYPE => ue_rec.object_type,
5300: X_MANUALLY_PLANNED_FLAG => ue_rec.manually_planned_flag,
5301: X_COUNTER_ID => ue_rec.counter_id,
5302: X_LOG_SERIES_CODE => ue_rec.log_series_code,

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

5383: SELECT due_date, mr_header_id,title,description,repetitive_mr_flag,cs_incident_id,cs_incident_number,
5384: cs_incident_summary,manually_planned_flag
5385: FROM ahl_ue_deferral_details_v
5386: WHERE unit_effectivity_id = p_unit_effectivity_id
5387: AND APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE'))) ;--this takes care of app_usage changes
5388:
5389: -- mr status meaning has to be fecthed seperately because function returns only code
5390: CURSOR mr_status_meaning_csr(p_status_code IN VARCHAR2)IS
5391: SELECT meaning FROM FND_LOOKUP_VALUES_VL