APPS.JTF_AK_QUERY dependencies on FND_GLOBAL

Line 7: p_appl_id IN NUMBER default fnd_global.resp_appl_id,

3: FUNCTION execute_query (
4: p_max_rows IN NUMBER default NULL,
5: p_range_low IN NUMBER default 0,
6: p_range_high IN NUMBER default NULL,
7: p_appl_id IN NUMBER default fnd_global.resp_appl_id,
8: p_flow_name IN VARCHAR2,
9: p_parent_page_name IN VARCHAR2,
10: p_primary_key_name IN VARCHAR2,
11: p_key_value1 IN VARCHAR2,

Line 27: C_APPLICATION_ID NUMBER := fnd_global.resp_appl_id;

23: RETURN ak_query_pkg.results_table_type IS
24: --
25: -- Static CRM Navigator Variables
26: --
27: C_APPLICATION_ID NUMBER := fnd_global.resp_appl_id;
28: C_RESP_ID NUMBER := fnd_global.resp_id;
29: C_USER_ID NUMBER := fnd_global.user_id;
30:
31: l_flow_code VARCHAR2(30);

Line 28: C_RESP_ID NUMBER := fnd_global.resp_id;

24: --
25: -- Static CRM Navigator Variables
26: --
27: C_APPLICATION_ID NUMBER := fnd_global.resp_appl_id;
28: C_RESP_ID NUMBER := fnd_global.resp_id;
29: C_USER_ID NUMBER := fnd_global.user_id;
30:
31: l_flow_code VARCHAR2(30);
32: l_page_application_id NUMBER(15);

Line 29: C_USER_ID NUMBER := fnd_global.user_id;

25: -- Static CRM Navigator Variables
26: --
27: C_APPLICATION_ID NUMBER := fnd_global.resp_appl_id;
28: C_RESP_ID NUMBER := fnd_global.resp_id;
29: C_USER_ID NUMBER := fnd_global.user_id;
30:
31: l_flow_code VARCHAR2(30);
32: l_page_application_id NUMBER(15);
33: l_page_code VARCHAR2(30);

Line 42: -- (APPLICATION ID is derived from FND_GLOBAL.RESP_APPL_ID)

38: BEGIN
39:
40: -- ====================================================================
41: -- Assumption : Developer needs to supply the following thru JTF tables
42: -- (APPLICATION ID is derived from FND_GLOBAL.RESP_APPL_ID)
43: -- FLOW NAME,
44: -- PARENT PAGE NAME,
45: -- PK NAME,
46: -- PK VALUE

Line 109: p_responsibility_id => FND_GLOBAL.RESP_ID,

105: p_parent_key_value8 => p_key_value8,
106: p_parent_key_value9 => p_key_value9,
107: p_parent_key_value10 => p_key_value10,
108: p_where_clause => p_where_clause,
109: p_responsibility_id => FND_GLOBAL.RESP_ID,
110: p_user_id => FND_GLOBAL.USER_ID,
111: p_return_parents => 'F',
112: p_return_children => 'T',
113: p_return_node_display_only=> 'F',

Line 110: p_user_id => FND_GLOBAL.USER_ID,

106: p_parent_key_value9 => p_key_value9,
107: p_parent_key_value10 => p_key_value10,
108: p_where_clause => p_where_clause,
109: p_responsibility_id => FND_GLOBAL.RESP_ID,
110: p_user_id => FND_GLOBAL.USER_ID,
111: p_return_parents => 'F',
112: p_return_children => 'T',
113: p_return_node_display_only=> 'F',
114: p_set_trace => 'F',