APPS.AHL_PRD_DISPOSITION_PVT dependencies on QA_RESULTS

Line 2067: AHL_QA_RESULTS_PVT.get_qa_plan( p_api_version => 1.0,

2063:
2064: --COLLECTION ID
2065: -- Added by jaramana on March 25, 2005 to fix bug 4243200
2066: -- First check if a QA PLan is defined in the workorder Org.
2067: AHL_QA_RESULTS_PVT.get_qa_plan( p_api_version => 1.0,
2068: p_init_msg_list => FND_API.G_False,
2069: p_commit => FND_API.G_FALSE,
2070: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2071: p_default => FND_API.G_FALSE,

Line 3329: SELECT 'x' FROM qa_results WHERE collection_id = p_collection_id;

3325: )
3326: and uom_code = p_uom_code;
3327:
3328: CURSOR val_Collection_id_csr(p_collection_id IN NUMBER) IS
3329: SELECT 'x' FROM qa_results WHERE collection_id = p_collection_id;
3330:
3331: CURSOR get_item_id_csr(p_instance_id IN NUMBER) IS
3332: SELECT inventory_item_id from csi_item_instances WHERE instance_id = p_instance_id;
3333:

Line 3860: AHL_QA_RESULTS_PVT.get_qa_plan( p_api_version => 1.0,

3856:
3857: --COLLECTION ID-------------------------------------------------------------
3858: -- Added by jaramana on March 25, 2005 to fix bug 4243200
3859: -- First check if a QA Plan is defined in the workorder Org.
3860: AHL_QA_RESULTS_PVT.get_qa_plan( p_api_version => 1.0,
3861: p_init_msg_list => FND_API.G_False,
3862: p_commit => FND_API.G_FALSE,
3863: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3864: p_default => FND_API.G_FALSE,

Line 4135: SELECT 'x' FROM qa_results WHERE collection_id = p_collection_id;

4131:
4132: --------------------------------------------------------------------------------
4133: PROCEDURE validate_collection_id(p_collection_id IN NUMBER) IS
4134: CURSOR val_Collection_id_csr(p_collection_id IN NUMBER) IS
4135: SELECT 'x' FROM qa_results WHERE collection_id = p_collection_id;
4136:
4137: l_exist VARCHAR(1);
4138:
4139: BEGIN