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.PQH_CONTEXT dependencies on PQH_COPY_ENTITY_CONTEXTS

Line 5: v_global_context pqh_copy_entity_contexts.context%type;

1: package body pqh_context as
2: /* $Header: pqhcntxt.pkb 120.0 2005/05/29 02:02:26 appldev noship $ */
3: function get_global_context (p_context in varchar2) return varchar2
4: is
5: v_global_context pqh_copy_entity_contexts.context%type;
6: v_global_app pqh_copy_entity_contexts.application_short_name%type;
7: v_global_txn pqh_copy_entity_contexts.transaction_short_name%type;
8: v_global_resp pqh_copy_entity_contexts.responsibility_key%type;
9: v_global_legis pqh_copy_entity_contexts.legislation_code%type;

Line 6: v_global_app pqh_copy_entity_contexts.application_short_name%type;

2: /* $Header: pqhcntxt.pkb 120.0 2005/05/29 02:02:26 appldev noship $ */
3: function get_global_context (p_context in varchar2) return varchar2
4: is
5: v_global_context pqh_copy_entity_contexts.context%type;
6: v_global_app pqh_copy_entity_contexts.application_short_name%type;
7: v_global_txn pqh_copy_entity_contexts.transaction_short_name%type;
8: v_global_resp pqh_copy_entity_contexts.responsibility_key%type;
9: v_global_legis pqh_copy_entity_contexts.legislation_code%type;
10: --

Line 7: v_global_txn pqh_copy_entity_contexts.transaction_short_name%type;

3: function get_global_context (p_context in varchar2) return varchar2
4: is
5: v_global_context pqh_copy_entity_contexts.context%type;
6: v_global_app pqh_copy_entity_contexts.application_short_name%type;
7: v_global_txn pqh_copy_entity_contexts.transaction_short_name%type;
8: v_global_resp pqh_copy_entity_contexts.responsibility_key%type;
9: v_global_legis pqh_copy_entity_contexts.legislation_code%type;
10: --
11: v_local_context pqh_copy_entity_contexts.context%type;

Line 8: v_global_resp pqh_copy_entity_contexts.responsibility_key%type;

4: is
5: v_global_context pqh_copy_entity_contexts.context%type;
6: v_global_app pqh_copy_entity_contexts.application_short_name%type;
7: v_global_txn pqh_copy_entity_contexts.transaction_short_name%type;
8: v_global_resp pqh_copy_entity_contexts.responsibility_key%type;
9: v_global_legis pqh_copy_entity_contexts.legislation_code%type;
10: --
11: v_local_context pqh_copy_entity_contexts.context%type;
12: v_local_app pqh_copy_entity_contexts.application_short_name%type;

Line 9: v_global_legis pqh_copy_entity_contexts.legislation_code%type;

5: v_global_context pqh_copy_entity_contexts.context%type;
6: v_global_app pqh_copy_entity_contexts.application_short_name%type;
7: v_global_txn pqh_copy_entity_contexts.transaction_short_name%type;
8: v_global_resp pqh_copy_entity_contexts.responsibility_key%type;
9: v_global_legis pqh_copy_entity_contexts.legislation_code%type;
10: --
11: v_local_context pqh_copy_entity_contexts.context%type;
12: v_local_app pqh_copy_entity_contexts.application_short_name%type;
13: v_local_txn pqh_copy_entity_contexts.transaction_short_name%type;

Line 11: v_local_context pqh_copy_entity_contexts.context%type;

7: v_global_txn pqh_copy_entity_contexts.transaction_short_name%type;
8: v_global_resp pqh_copy_entity_contexts.responsibility_key%type;
9: v_global_legis pqh_copy_entity_contexts.legislation_code%type;
10: --
11: v_local_context pqh_copy_entity_contexts.context%type;
12: v_local_app pqh_copy_entity_contexts.application_short_name%type;
13: v_local_txn pqh_copy_entity_contexts.transaction_short_name%type;
14: v_local_resp pqh_copy_entity_contexts.responsibility_key%type;
15: v_local_legis pqh_copy_entity_contexts.legislation_code%type;

Line 12: v_local_app pqh_copy_entity_contexts.application_short_name%type;

8: v_global_resp pqh_copy_entity_contexts.responsibility_key%type;
9: v_global_legis pqh_copy_entity_contexts.legislation_code%type;
10: --
11: v_local_context pqh_copy_entity_contexts.context%type;
12: v_local_app pqh_copy_entity_contexts.application_short_name%type;
13: v_local_txn pqh_copy_entity_contexts.transaction_short_name%type;
14: v_local_resp pqh_copy_entity_contexts.responsibility_key%type;
15: v_local_legis pqh_copy_entity_contexts.legislation_code%type;
16: --

Line 13: v_local_txn pqh_copy_entity_contexts.transaction_short_name%type;

9: v_global_legis pqh_copy_entity_contexts.legislation_code%type;
10: --
11: v_local_context pqh_copy_entity_contexts.context%type;
12: v_local_app pqh_copy_entity_contexts.application_short_name%type;
13: v_local_txn pqh_copy_entity_contexts.transaction_short_name%type;
14: v_local_resp pqh_copy_entity_contexts.responsibility_key%type;
15: v_local_legis pqh_copy_entity_contexts.legislation_code%type;
16: --
17: cursor c_current_context (p_context varchar2 default null

Line 14: v_local_resp pqh_copy_entity_contexts.responsibility_key%type;

10: --
11: v_local_context pqh_copy_entity_contexts.context%type;
12: v_local_app pqh_copy_entity_contexts.application_short_name%type;
13: v_local_txn pqh_copy_entity_contexts.transaction_short_name%type;
14: v_local_resp pqh_copy_entity_contexts.responsibility_key%type;
15: v_local_legis pqh_copy_entity_contexts.legislation_code%type;
16: --
17: cursor c_current_context (p_context varchar2 default null
18: )

Line 15: v_local_legis pqh_copy_entity_contexts.legislation_code%type;

11: v_local_context pqh_copy_entity_contexts.context%type;
12: v_local_app pqh_copy_entity_contexts.application_short_name%type;
13: v_local_txn pqh_copy_entity_contexts.transaction_short_name%type;
14: v_local_resp pqh_copy_entity_contexts.responsibility_key%type;
15: v_local_legis pqh_copy_entity_contexts.legislation_code%type;
16: --
17: cursor c_current_context (p_context varchar2 default null
18: )
19: is

Line 25: from pqh_copy_entity_contexts cec

21: , transaction_short_name
22: , application_short_name
23: , responsibility_key
24: , legislation_code
25: from pqh_copy_entity_contexts cec
26: where context = p_context
27: ;
28: cursor c_global_context (p_txn_short_name varchar2 default null
29: , p_current_context varchar2 default null

Line 33: from pqh_copy_entity_contexts cec

29: , p_current_context varchar2 default null
30: )
31: is
32: select context
33: from pqh_copy_entity_contexts cec
34: where transaction_short_name = p_txn_short_name
35: and context <> p_current_context
36: and application_short_name IS NULL
37: and responsibility_key IS NULL

Line 46: from pqh_copy_entity_contexts cec

42: , p_current_context varchar2 default null
43: )
44: is
45: select context
46: from pqh_copy_entity_contexts cec
47: where transaction_short_name = p_txn_short_name
48: and application_short_name = p_app_short_name
49: and context <> p_current_context
50: and responsibility_key IS NULL

Line 60: from pqh_copy_entity_contexts cec

56: , p_current_context varchar2 default null
57: )
58: is
59: select context
60: from pqh_copy_entity_contexts cec
61: where transaction_short_name = p_txn_short_name
62: and application_short_name = p_app_short_name
63: and responsibility_key = p_resp_key
64: and context <> p_current_context

Line 74: from pqh_copy_entity_contexts cec

70: , p_current_context varchar2 default null
71: )
72: is
73: select context
74: from pqh_copy_entity_contexts cec
75: where transaction_short_name = p_txn_short_name
76: and application_short_name = p_app_short_name
77: and legislation_code = p_legis_code
78: and context <> p_current_context