GCP-8491
GCP-8588
GCP-8588 - get preferred name changes
GCP-8588 - added searchGermplasmByName
GCP-8588 - created stored procedures for getting records that checks the changes table as follows:
1. countGermplasmByName
2. countGermplasmListDataByListId
3. getGermplasmFieldFromChanges
4. getGermplasmListDataByListId
5. getGermplasmListDataByListIdAndEntryId
6. getGermplasmListDataByListIdAndLrecId
7. getNameFieldFromChanges
8. getNamesByGID
9. getPreferredNameByGid
10. getPreferredNameFromNamesByGid
11. getPreferredNamesRecordByGid
12. getReplacementGermplasm
13. getReplacementGermplasmFromChanges
14. getReplacementGID
15. getUpdatedAttributeByAID
16. getUpdatedGermplasmByID
17. getUpdatedGermplasmIDByID
18. getUpdatedNameByNID
19. searchGermplasmsByID
20. searchGermplasmsByName
GCP-8588 - removed duplicated stored procedures and added IN parameter v_search_public_data to limit search and improve performance
GCP-8588 - synch script with local\common-update\GermplasmAndChangesProcedures.sql
Merge branch 'master' into branch_update_from_changes
Merge branch 'master' into branch_update_from_changes
Changed folder to 20140710 so it can be executed by BMS for those whose schema_version is above 20140601
GCP-8816
To be reviewed by Darla
Merge branch 'master' into branch_update_from_changes
Corrected update statement to include commas before the column and add stored procedure progenitors_by_gid

Issue: GCP-8816

Reviewer: Darla (post-commit)
handle null preferred names for germplasms

Issue: GCP-8816

Reviewer: Darla (post-commit)
replace wrong variable name from n_aid to v_nid

Issue: GCP-8816

Reviewer: Darla (post-commit)
added stored procedure "getPreferredIDNamesRecordByGid"

Issue: GCP-8816

Reviewer: Darla (post-commit)
Create stored procedures that retrieve germplasm details related to pedigree and modify other stored procedures to reset the loop0_eof variable before each cursor fetch

Issue: GCP-9771

Reviewer: Darla (post-commit)
Tuned stored procedures and corrected limit to 0 in creating the temporary view

Issue: GCP-9711

Reviewer: Darla
Merge branch 'master' into branch_update_from_changes
1. changed stored procedure name from *Germplasms* to *Germplasm*
2. changed folder to 20140813

Issue: GCP-9711

Reviewer: Darla
Merge branch 'branch_update_from_changes'