APPS.GMD_QC_MIG12 dependencies on GMD_SAMPLING_PLANS_B

Line 103: p_param1 => 'gmd_sampling_plans_b',

99: p_token2 => 'PRO',
100: p_token3 => 'UPD',
101: p_token4 => 'INS',
102: p_token5 => 'ERR',
103: p_param1 => 'gmd_sampling_plans_b',
104: p_param2 => to_char(GMD_QC_MIG12.g_sampling_plan_pro_count),
105: p_param3 => to_char(GMD_QC_MIG12.g_sampling_plan_upd_count),
106: p_param4 => 0,
107: p_param5 => to_char(GMD_QC_MIG12.g_sampling_plan_err_count),

Line 1264: Cursor to get gmd_sampling_plans_b

1260: l_p_assign_type gmd_quality_config.sample_assignment_type%TYPE;
1261: l_p_last_assign gmd_quality_config.sample_last_assigned%TYPE;
1262:
1263: /*=======================================
1264: Cursor to get gmd_sampling_plans_b
1265: =======================================*/
1266:
1267: CURSOR get_sampling_plan IS
1268: SELECT sampling_plan_id, frequency_type, frequency_per

Line 1269: FROM gmd_sampling_plans_b

1265: =======================================*/
1266:
1267: CURSOR get_sampling_plan IS
1268: SELECT sampling_plan_id, frequency_type, frequency_per
1269: FROM gmd_sampling_plans_b
1270: WHERE migrated_ind IS NULL;
1271:
1272: l_sample_plan get_sampling_plan%ROWTYPE;
1273: l_sampling_uom gmd_sampling_plans_b.frequency_per%TYPE;

Line 1273: l_sampling_uom gmd_sampling_plans_b.frequency_per%TYPE;

1269: FROM gmd_sampling_plans_b
1270: WHERE migrated_ind IS NULL;
1271:
1272: l_sample_plan get_sampling_plan%ROWTYPE;
1273: l_sampling_uom gmd_sampling_plans_b.frequency_per%TYPE;
1274:
1275: /*=======================================
1276: Cursor to check if gmd_quality_config
1277: record exists.

Line 2305: UPDATE gmd_sampling_plans_b

2301: ELSE
2302: l_sampling_uom := l_sampling_plan.frequency_per; -- retain same value
2303: END IF;
2304:
2305: UPDATE gmd_sampling_plans_b
2306: SET frequency_per = l_sampling_uom,
2307: migrated_ind = 1
2308: WHERE sampling_plan_id = l_sampling_plan.sampling_plan_id;
2309: