APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on FND_PROFILE

Line 615: AND QPCT.low_value = (FND_PROFILE.VALUE('AHL_MRB_DISP_PLAN_TYPE'));

611: AND QPT.plan_transaction_id = QPCT.plan_transaction_id
612: AND QP.organization_id = c_org_id
613: AND QPT.transaction_number = 2004 -- MRB_TRANSACTION_NUMBER
614: AND QPCT.collection_trigger_id = 87 -- Inspection_Type
615: AND QPCT.low_value = (FND_PROFILE.VALUE('AHL_MRB_DISP_PLAN_TYPE'));
616:
617: -- Cursor to get part change details for last removal or install of the instance at given UC position
618: CURSOR get_last_part_chg_dtls_csr (c_path_position_id NUMBER,
619: c_instance_id NUMBER,

Line 720: l_mrb_profile_condition := FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB');

716: -- MRB Quality
717: OPEN get_MRB_Quality_csr(l_org_id);
718: FETCH get_MRB_Quality_csr INTO l_plan_id;
719: CLOSE get_MRB_Quality_csr;
720: l_mrb_profile_condition := FND_PROFILE.VALUE('AHL_MTL_MAT_STATUS_MRB');
721:
722: IF(l_plan_id IS NOT NULL AND l_mrb_profile_condition IS NOT NULL) THEN
723: l_quality_setup := 'Y';
724: END IF;