APPS.AHL_PRD_DISPOSITION_PVT dependencies on QA_RESULTS

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

1875:
1876: --COLLECTION ID
1877: -- Added by jaramana on March 25, 2005 to fix bug 4243200
1878: -- First check if a QA PLan is defined in the workorder Org.
1879: AHL_QA_RESULTS_PVT.get_qa_plan( p_api_version => 1.0,
1880: p_init_msg_list => FND_API.G_False,
1881: p_commit => FND_API.G_FALSE,
1882: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1883: p_default => FND_API.G_FALSE,

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

2902: )
2903: and uom_code = p_uom_code;
2904:
2905: CURSOR val_Collection_id_csr(p_collection_id IN NUMBER) IS
2906: SELECT 'x' FROM qa_results WHERE collection_id = p_collection_id;
2907:
2908: CURSOR get_item_id_csr(p_instance_id IN NUMBER) IS
2909: SELECT inventory_item_id from csi_item_instances WHERE instance_id = p_instance_id;
2910:

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

3428:
3429: --COLLECTION ID-------------------------------------------------------------
3430: -- Added by jaramana on March 25, 2005 to fix bug 4243200
3431: -- First check if a QA Plan is defined in the workorder Org.
3432: AHL_QA_RESULTS_PVT.get_qa_plan( p_api_version => 1.0,
3433: p_init_msg_list => FND_API.G_False,
3434: p_commit => FND_API.G_FALSE,
3435: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3436: p_default => FND_API.G_FALSE,

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

3671:
3672: --------------------------------------------------------------------------------
3673: PROCEDURE validate_collection_id(p_collection_id IN NUMBER) IS
3674: CURSOR val_Collection_id_csr(p_collection_id IN NUMBER) IS
3675: SELECT 'x' FROM qa_results WHERE collection_id = p_collection_id;
3676:
3677: l_exist VARCHAR(1);
3678:
3679: BEGIN