31:
32:
33: CURSOR l_control_rules_csr IS
34: Select 'x'
35: FROM pa_pm_product_control_rules pc,
36: pa_pm_control_actions pa
37: WHERE pa.action = p_action
38: AND pa.control_rule_id = pc.control_rule_id
39: AND pc.pm_product_code = p_pm_product_code
83: l_field_value_code := p_field_value_code;
84: END IF;
85:
86: p_error_stage :=
87: 'Select x from pa_pm_product_control_rules,pa_pm_control_actions';
88:
89: -- If a record is found , then return 'N' else return 'Y'
90:
91: OPEN l_control_rules_csr;
194: FOR i IN 1..16 LOOP
195:
196: BEGIN
197: p_error_stage :=
198: 'Select x from pa_pm_product_control_rules,pa_pm_control_actions';
199:
200: SELECT 'x' INTO l_dummy
201: FROM pa_pm_product_control_rules pc,
202: pa_pm_control_actions pa
197: p_error_stage :=
198: 'Select x from pa_pm_product_control_rules,pa_pm_control_actions';
199:
200: SELECT 'x' INTO l_dummy
201: FROM pa_pm_product_control_rules pc,
202: pa_pm_control_actions pa
203: WHERE pa.action = l_action(i)
204: AND pa.control_rule_id = pc.control_rule_id
205: AND pc.pm_product_code = p_pm_product_code
331: FOR i IN 1..5 LOOP
332:
333: BEGIN
334: p_error_stage :=
335: 'Select x from pa_pm_product_control_rules,pa_pm_control_actions';
336:
337: SELECT 'x' INTO l_dummy
338: FROM pa_pm_product_control_rules pc,
339: pa_pm_control_actions pa
334: p_error_stage :=
335: 'Select x from pa_pm_product_control_rules,pa_pm_control_actions';
336:
337: SELECT 'x' INTO l_dummy
338: FROM pa_pm_product_control_rules pc,
339: pa_pm_control_actions pa
340: WHERE pa.action = l_action(i)
341: AND pa.control_rule_id = pc.control_rule_id
342: AND pc.pm_product_code = p_pm_product_code
411: --4537865
412: P_ERROR_STAGE := P_ERROR_STAGE || '-> Inside GET_EVENT_ACTIONS_ALLOWED ' ;
413: FOR I IN 1..3 LOOP
414: BEGIN
415: P_ERROR_STAGE := 'SELECT x INTO l_dummy FROM pa_pm_product_control_rules pc,pa_pm_control_actions pa' ; --4537865
416:
417: SELECT 'x' INTO l_dummy
418: FROM pa_pm_product_control_rules pc,
419: pa_pm_control_actions pa
414: BEGIN
415: P_ERROR_STAGE := 'SELECT x INTO l_dummy FROM pa_pm_product_control_rules pc,pa_pm_control_actions pa' ; --4537865
416:
417: SELECT 'x' INTO l_dummy
418: FROM pa_pm_product_control_rules pc,
419: pa_pm_control_actions pa
420: WHERE pa.action = l_action(i)
421: AND pa.control_rule_id = pc.control_rule_id
422: AND pc.pm_product_code = p_pm_product_code