APPS.QA_SAMPLING_PKG dependencies on QA_SAMPLING_PLANS

Line 1118: --checks QA_SAMPLING_PLANS table and gets the standard code, c number

1114:
1115: --
1116: --This checks the QA_SAMPLING_CUSTOM_RULES table based on sampling plan id
1117: --and lot size and return the custom sample size if found. Otherwise, it
1118: --checks QA_SAMPLING_PLANS table and gets the standard code, c number
1119: --and AQL and checks the QA_SAMPLING_STD_RULES table and return the std.
1120: --sample size
1121: --Note: Some alterations to the table columns were being made
1122: --Please refer to detail design for more information

Line 1142: from QA_SAMPLING_PLANS qsp

1138:
1139: cursor sampling_plan_cur
1140: is
1141: select sampling_std_code, AQL, insp_level_code
1142: from QA_SAMPLING_PLANS qsp
1143: where sampling_plan_id = p_sampling_plan_id;
1144:
1145: cursor custom_sample_cur
1146: is

Line 1313: l_sampling_std_code qa_sampling_plans.sampling_std_code%type;

1309: l_c_num number := 0;
1310: l_rej_num number := 1;
1311: l_criteria_id number;
1312: l_sampling_plan_id number;
1313: l_sampling_std_code qa_sampling_plans.sampling_std_code%type;
1314: out_wf_item_key number;
1315:
1316: cursor sampling_flag_cur
1317: is

Line 1333: from qa_sampling_plans

1329:
1330: cursor sampling_std_code_cur (x_sampling_plan_id number)
1331: is
1332: select sampling_std_code
1333: from qa_sampling_plans
1334: where sampling_plan_id = x_sampling_plan_id;
1335:
1336: begin
1337: open sampling_flag_cur;