eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PM_CONTROLS dependencies on PA_PM_CONTROL_ACTIONS

Line 29: FROM pa_pm_control_actions

25: l_dummy VARCHAR2(1);
26:
27: CURSOR l_control_actions_csr IS
28: SELECT NVL(field_value_allowed_flag,'N')
29: FROM pa_pm_control_actions
30: WHERE action = p_action;
31:
32:
33: CURSOR l_control_rules_csr IS

Line 36: pa_pm_control_actions pa

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
40: AND NVL(l_field_value_code,'N') = NVL(pc.field_value_code,'N')

Line 61: 'pa_pm_control_actions';

57: p_error_stage := 'PA_PM_PRODUCT_CODE_REQD';
58: RETURN;
59: END IF ;
60: p_error_stage := 'Select nvl(field_value_allowed_flag,N) from '||
61: 'pa_pm_control_actions';
62:
63: -- Check whether the passed action is a valid one and get the
64: -- field_value_allowed_flag
65:

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 149: TYPE actiontabtype IS TABLE OF pa_pm_control_actions.action%TYPE

145: -- whether such actions can be performed on a project that has been imported
146: -- from an external project management system
147:
148: l_old_stack varchar2(630);
149: TYPE actiontabtype IS TABLE OF pa_pm_control_actions.action%TYPE
150: INDEX BY BINARY_INTEGER;
151: l_action actiontabtype;
152: l_dummy VARCHAR2(1);
153:

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 202: pa_pm_control_actions pa

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
206: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE))

Line 308: TYPE actiontabtype IS TABLE OF pa_pm_control_actions.action%TYPE

304: -- from an external project management system
305: ***************************************************************************** */
306:
307: l_old_stack varchar2(630);
308: TYPE actiontabtype IS TABLE OF pa_pm_control_actions.action%TYPE
309: INDEX BY BINARY_INTEGER;
310: l_action actiontabtype;
311: l_dummy VARCHAR2(1);
312:

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 339: pa_pm_control_actions pa

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
343: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE))

Line 400: TYPE actiontabtype IS TABLE OF pa_pm_control_actions.action%TYPE INDEX BY BINARY_INTEGER;

396: P_ERROR_STACK IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
397: P_ERROR_STAGE IN OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
398: IS
399:
400: TYPE actiontabtype IS TABLE OF pa_pm_control_actions.action%TYPE INDEX BY BINARY_INTEGER;
401: l_action actiontabtype;
402: l_dummy VARCHAR2(1);
403:
404: Begin

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 419: pa_pm_control_actions pa

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
423: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,SYSDATE))