APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on FND_PROFILE

Line 546: l_bindvar_tbl(l_bind_index) := ltrim(rtrim(fnd_profile.value('AHL_APPLN_USAGE')));

542: l_select_sql_string := l_select_sql_string || 'WHERE UMP.application_usg_code= :APPL_USG_CODE AND AAI1.csi_item_instance_id = UMP.csi_item_instance_id ';
543: l_mr_select_sql_string := 'SELECT /*+ dynamic_sampling(AAI1 4) */ UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_B UMP, AHL_APPLICABLE_INSTANCES AAI1, AHL_MR_HEADERS_B MR';
544: l_mr_select_sql_string := l_mr_select_sql_string || ' WHERE UMP.application_usg_code= :APPL_USG_CODE AND AAI1.csi_item_instance_id = UMP.csi_item_instance_id AND UMP.mr_header_id = MR.mr_header_id ';
545:
546: l_bindvar_tbl(l_bind_index) := ltrim(rtrim(fnd_profile.value('AHL_APPLN_USAGE')));
547: l_bind_index := l_bind_index + 1;
548:
549: IF p_search_mr_instance_rec.INCIDENT_TYPE_ID IS NOT NULL THEN
550: IF nvl(p_search_mr_instance_rec.SERVICE_REQ_NUM, '%') <> '%' THEN

Line 585: l_bindvar_tbl(l_bind_index) := ltrim(rtrim(fnd_profile.value('AHL_APPLN_USAGE')));

581: ELSE -- p_search_mr_instance_rec.unit_name
582: l_select_sql_string := 'SELECT UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_B UMP WHERE UMP.application_usg_code= :APPL_USG_CODE ';
583:
584: l_mr_select_sql_string := 'SELECT UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_B UMP, AHL_MR_HEADERS_B MR WHERE UMP.application_usg_code= :APPL_USG_CODE AND UMP.mr_header_id = MR.mr_header_id ';
585: l_bindvar_tbl(l_bind_index) := ltrim(rtrim(fnd_profile.value('AHL_APPLN_USAGE')));
586: l_bind_index := l_bind_index + 1;
587: IF p_search_mr_instance_rec.INCIDENT_TYPE_ID IS NOT NULL THEN
588: IF nvl(p_search_mr_instance_rec.SERVICE_REQ_NUM, '%') <> '%' THEN
589: l_nr_select_sql_string := 'SELECT UMP.unit_effectivity_id FROM AHL_UNIT_EFFECTIVITIES_B UMP, CS_INCIDENTS_ALL_B CI, CS_INCIDENT_TYPES_VL CIT WHERE UMP.application_usg_code= :APPL_USG_CODE ';

Line 1962: AND B.APPLICATION_USG_CODE = FND_PROFILE.VALUE(''AHL_APPLN_USAGE'')

1958: 'where b.mr_header_id = mrb.mr_header_id
1959: AND B.CSI_ITEM_INSTANCE_ID = csib.INSTANCE_ID
1960: AND csib.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID
1961: and csib.inv_master_organization_id = mtl.organization_id
1962: AND B.APPLICATION_USG_CODE = FND_PROFILE.VALUE(''AHL_APPLN_USAGE'')
1963: and b.object_type = ''MR''
1964: and b.preceding_ue_id IS NULL
1965: and NVL(B.status_code,''INIT-DUE'' ) = ''INIT-DUE'' and MAINTTORG.unit_effectivity_id = b.unit_effectivity_id ';
1966: IF (P_SEARCH_UMP_REC.UNIT_NAME IS NOT NULL OR NVL(P_SEARCH_UMP_REC.ITEM,'%')

Line 2260: and b.application_usg_code = fnd_profile.value(''AHL_APPLN_USAGE'')

2256: AND B.CS_INCIDENT_ID = CSB.INCIDENT_ID
2257: and citb.incident_type_id = csb.incident_type_id
2258: and citb.incident_type_id = citt.incident_type_id
2259: and citt.language = userenv(''lang'')
2260: and b.application_usg_code = fnd_profile.value(''AHL_APPLN_USAGE'')
2261: and b.object_type = ''SR''
2262: and b.preceding_ue_id IS NULL
2263: and NVL(B.status_code,''INIT-DUE'' ) = ''INIT-DUE'' ';
2264: