[Home] [Help]
1004: --
1005:
1006: --
1007: -- removed parameter default values. default values should only be
1008: -- put in spec per new coding standard
1009: -- jezheng
1010: -- Wed Nov 27 15:13:11 PST 2002
1011: --
1012: procedure eval_rcv_sampling_plan (
1175:
1176: --
1177: --This checks the QA_SAMPLING_CUSTOM_RULES table based on sampling plan id
1178: --and lot size and return the custom sample size if found. Otherwise, it
1179: --checks QA_SAMPLING_PLANS table and gets the standard code, c number
1180: --and AQL and checks the QA_SAMPLING_STD_RULES table and return the std.
1181: --sample size
1182: --Note: Some alterations to the table columns were being made
1183: --Please refer to detail design for more information
1290: and plan_id = p_collection_plan_id;
1291: */
1292:
1293: p_sample_size := l_sample_size;--set out param
1294: else --use standard sampling plan
1295: open lot_code_cur(l_insp_level);
1296: fetch lot_code_cur into l_lot_size_code;
1297: close lot_code_cur;
1298: