APPS.GMD_QC_MIG12 dependencies on GMD_SAMPLING_PLANS_B

Line 95: p_param1 => 'gmd_sampling_plans_b',

91: p_token2 => 'PRO',
92: p_token3 => 'UPD',
93: p_token4 => 'INS',
94: p_token5 => 'ERR',
95: p_param1 => 'gmd_sampling_plans_b',
96: p_param2 => to_char(GMD_QC_MIG12.g_sampling_plan_pro_count),
97: p_param3 => to_char(GMD_QC_MIG12.g_sampling_plan_upd_count),
98: p_param4 => 0,
99: p_param5 => to_char(GMD_QC_MIG12.g_sampling_plan_err_count),

Line 1256: Cursor to get gmd_sampling_plans_b

1252: l_p_assign_type gmd_quality_config.sample_assignment_type%TYPE;
1253: l_p_last_assign gmd_quality_config.sample_last_assigned%TYPE;
1254:
1255: /*=======================================
1256: Cursor to get gmd_sampling_plans_b
1257: =======================================*/
1258:
1259: CURSOR get_sampling_plan IS
1260: SELECT sampling_plan_id, frequency_type, frequency_per

Line 1261: FROM gmd_sampling_plans_b

1257: =======================================*/
1258:
1259: CURSOR get_sampling_plan IS
1260: SELECT sampling_plan_id, frequency_type, frequency_per
1261: FROM gmd_sampling_plans_b
1262: WHERE migrated_ind IS NULL;
1263:
1264: l_sample_plan get_sampling_plan%ROWTYPE;
1265: l_sampling_uom gmd_sampling_plans_b.frequency_per%TYPE;

Line 1265: l_sampling_uom gmd_sampling_plans_b.frequency_per%TYPE;

1261: FROM gmd_sampling_plans_b
1262: WHERE migrated_ind IS NULL;
1263:
1264: l_sample_plan get_sampling_plan%ROWTYPE;
1265: l_sampling_uom gmd_sampling_plans_b.frequency_per%TYPE;
1266:
1267: /*=======================================
1268: Cursor to check if gmd_quality_config
1269: record exists.

Line 2297: UPDATE gmd_sampling_plans_b

2293: ELSE
2294: l_sampling_uom := l_sampling_plan.frequency_per; -- retain same value
2295: END IF;
2296:
2297: UPDATE gmd_sampling_plans_b
2298: SET frequency_per = l_sampling_uom,
2299: migrated_ind = 1
2300: WHERE sampling_plan_id = l_sampling_plan.sampling_plan_id;
2301: