APPS.PA_PM_CONTROLS dependencies on PA_PM_PRODUCT_CONTROL_RULES

Line 35: FROM pa_pm_product_control_rules pc,

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

Line 87: 'Select x from pa_pm_product_control_rules,pa_pm_control_actions';

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;

Line 198: 'Select x from pa_pm_product_control_rules,pa_pm_control_actions';

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

Line 201: FROM pa_pm_product_control_rules pc,

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

Line 335: 'Select x from pa_pm_product_control_rules,pa_pm_control_actions';

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

Line 338: FROM pa_pm_product_control_rules pc,

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

Line 415: P_ERROR_STAGE := 'SELECT x INTO l_dummy FROM pa_pm_product_control_rules pc,pa_pm_control_actions pa' ; --4537865

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

Line 418: FROM pa_pm_product_control_rules pc,

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