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.FII_EA_DPRN_EXP_PKG dependencies on FII_EA_UTIL_PKG

Line 20: l_company_id fii_ea_util_pkg.g_company_id%TYPE;

16: l_trunc_sql VARCHAR2(100);
17: l_sqlstmt VARCHAR2(2000);
18: l_sqlstmt2 VARCHAR2(5000);
19:
20: l_company_id fii_ea_util_pkg.g_company_id%TYPE;
21: l_cost_center_id fii_ea_util_pkg.g_cost_center_id%TYPE;
22: l_fin_category_id fii_ea_util_pkg.g_fin_category_id%TYPE;
23: l_ledger_id fii_ea_util_pkg.g_ledger_id%TYPE;
24: l_actual_bitand fii_ea_util_pkg.g_actual_bitand%TYPE;

Line 21: l_cost_center_id fii_ea_util_pkg.g_cost_center_id%TYPE;

17: l_sqlstmt VARCHAR2(2000);
18: l_sqlstmt2 VARCHAR2(5000);
19:
20: l_company_id fii_ea_util_pkg.g_company_id%TYPE;
21: l_cost_center_id fii_ea_util_pkg.g_cost_center_id%TYPE;
22: l_fin_category_id fii_ea_util_pkg.g_fin_category_id%TYPE;
23: l_ledger_id fii_ea_util_pkg.g_ledger_id%TYPE;
24: l_actual_bitand fii_ea_util_pkg.g_actual_bitand%TYPE;
25: l_fud1_id fii_ea_util_pkg.g_fud1_id%TYPE;

Line 22: l_fin_category_id fii_ea_util_pkg.g_fin_category_id%TYPE;

18: l_sqlstmt2 VARCHAR2(5000);
19:
20: l_company_id fii_ea_util_pkg.g_company_id%TYPE;
21: l_cost_center_id fii_ea_util_pkg.g_cost_center_id%TYPE;
22: l_fin_category_id fii_ea_util_pkg.g_fin_category_id%TYPE;
23: l_ledger_id fii_ea_util_pkg.g_ledger_id%TYPE;
24: l_actual_bitand fii_ea_util_pkg.g_actual_bitand%TYPE;
25: l_fud1_id fii_ea_util_pkg.g_fud1_id%TYPE;
26: l_fud2_id fii_ea_util_pkg.g_fud2_id%TYPE;

Line 23: l_ledger_id fii_ea_util_pkg.g_ledger_id%TYPE;

19:
20: l_company_id fii_ea_util_pkg.g_company_id%TYPE;
21: l_cost_center_id fii_ea_util_pkg.g_cost_center_id%TYPE;
22: l_fin_category_id fii_ea_util_pkg.g_fin_category_id%TYPE;
23: l_ledger_id fii_ea_util_pkg.g_ledger_id%TYPE;
24: l_actual_bitand fii_ea_util_pkg.g_actual_bitand%TYPE;
25: l_fud1_id fii_ea_util_pkg.g_fud1_id%TYPE;
26: l_fud2_id fii_ea_util_pkg.g_fud2_id%TYPE;
27: l_asof_date fii_ea_util_pkg.g_as_of_date%TYPE;

Line 24: l_actual_bitand fii_ea_util_pkg.g_actual_bitand%TYPE;

20: l_company_id fii_ea_util_pkg.g_company_id%TYPE;
21: l_cost_center_id fii_ea_util_pkg.g_cost_center_id%TYPE;
22: l_fin_category_id fii_ea_util_pkg.g_fin_category_id%TYPE;
23: l_ledger_id fii_ea_util_pkg.g_ledger_id%TYPE;
24: l_actual_bitand fii_ea_util_pkg.g_actual_bitand%TYPE;
25: l_fud1_id fii_ea_util_pkg.g_fud1_id%TYPE;
26: l_fud2_id fii_ea_util_pkg.g_fud2_id%TYPE;
27: l_asof_date fii_ea_util_pkg.g_as_of_date%TYPE;
28: l_prev_asof_date fii_ea_util_pkg.g_previous_asof_date%TYPE;

Line 25: l_fud1_id fii_ea_util_pkg.g_fud1_id%TYPE;

21: l_cost_center_id fii_ea_util_pkg.g_cost_center_id%TYPE;
22: l_fin_category_id fii_ea_util_pkg.g_fin_category_id%TYPE;
23: l_ledger_id fii_ea_util_pkg.g_ledger_id%TYPE;
24: l_actual_bitand fii_ea_util_pkg.g_actual_bitand%TYPE;
25: l_fud1_id fii_ea_util_pkg.g_fud1_id%TYPE;
26: l_fud2_id fii_ea_util_pkg.g_fud2_id%TYPE;
27: l_asof_date fii_ea_util_pkg.g_as_of_date%TYPE;
28: l_prev_asof_date fii_ea_util_pkg.g_previous_asof_date%TYPE;
29: l_curr fii_ea_util_pkg.g_currency%TYPE;

Line 26: l_fud2_id fii_ea_util_pkg.g_fud2_id%TYPE;

22: l_fin_category_id fii_ea_util_pkg.g_fin_category_id%TYPE;
23: l_ledger_id fii_ea_util_pkg.g_ledger_id%TYPE;
24: l_actual_bitand fii_ea_util_pkg.g_actual_bitand%TYPE;
25: l_fud1_id fii_ea_util_pkg.g_fud1_id%TYPE;
26: l_fud2_id fii_ea_util_pkg.g_fud2_id%TYPE;
27: l_asof_date fii_ea_util_pkg.g_as_of_date%TYPE;
28: l_prev_asof_date fii_ea_util_pkg.g_previous_asof_date%TYPE;
29: l_curr fii_ea_util_pkg.g_currency%TYPE;
30:

Line 27: l_asof_date fii_ea_util_pkg.g_as_of_date%TYPE;

23: l_ledger_id fii_ea_util_pkg.g_ledger_id%TYPE;
24: l_actual_bitand fii_ea_util_pkg.g_actual_bitand%TYPE;
25: l_fud1_id fii_ea_util_pkg.g_fud1_id%TYPE;
26: l_fud2_id fii_ea_util_pkg.g_fud2_id%TYPE;
27: l_asof_date fii_ea_util_pkg.g_as_of_date%TYPE;
28: l_prev_asof_date fii_ea_util_pkg.g_previous_asof_date%TYPE;
29: l_curr fii_ea_util_pkg.g_currency%TYPE;
30:
31: l_fud1_where VARCHAR2(240);

Line 28: l_prev_asof_date fii_ea_util_pkg.g_previous_asof_date%TYPE;

24: l_actual_bitand fii_ea_util_pkg.g_actual_bitand%TYPE;
25: l_fud1_id fii_ea_util_pkg.g_fud1_id%TYPE;
26: l_fud2_id fii_ea_util_pkg.g_fud2_id%TYPE;
27: l_asof_date fii_ea_util_pkg.g_as_of_date%TYPE;
28: l_prev_asof_date fii_ea_util_pkg.g_previous_asof_date%TYPE;
29: l_curr fii_ea_util_pkg.g_currency%TYPE;
30:
31: l_fud1_where VARCHAR2(240);
32: l_fud2_where VARCHAR2(240);

Line 29: l_curr fii_ea_util_pkg.g_currency%TYPE;

25: l_fud1_id fii_ea_util_pkg.g_fud1_id%TYPE;
26: l_fud2_id fii_ea_util_pkg.g_fud2_id%TYPE;
27: l_asof_date fii_ea_util_pkg.g_as_of_date%TYPE;
28: l_prev_asof_date fii_ea_util_pkg.g_previous_asof_date%TYPE;
29: l_curr fii_ea_util_pkg.g_currency%TYPE;
30:
31: l_fud1_where VARCHAR2(240);
32: l_fud2_where VARCHAR2(240);
33: l_asset_url VARCHAR2(240);

Line 44: fii_ea_util_pkg.reset_globals;

40:
41: BEGIN
42:
43: -- reset the global variables
44: fii_ea_util_pkg.reset_globals;
45:
46: -- read the paramaters and populate the global variables
47: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
48:

Line 47: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);

43: -- reset the global variables
44: fii_ea_util_pkg.reset_globals;
45:
46: -- read the paramaters and populate the global variables
47: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
48:
49: -- copy values to local variables
50: l_company_id := fii_ea_util_pkg.g_company_id;
51: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;

Line 50: l_company_id := fii_ea_util_pkg.g_company_id;

46: -- read the paramaters and populate the global variables
47: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
48:
49: -- copy values to local variables
50: l_company_id := fii_ea_util_pkg.g_company_id;
51: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
52: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
53: l_actual_bitand := fii_ea_util_pkg.g_actual_bitand;
54: l_asof_date := fii_ea_util_pkg.g_as_of_date;

Line 51: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;

47: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
48:
49: -- copy values to local variables
50: l_company_id := fii_ea_util_pkg.g_company_id;
51: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
52: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
53: l_actual_bitand := fii_ea_util_pkg.g_actual_bitand;
54: l_asof_date := fii_ea_util_pkg.g_as_of_date;
55: l_prev_asof_date := fii_ea_util_pkg.g_previous_asof_date;

Line 52: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;

48:
49: -- copy values to local variables
50: l_company_id := fii_ea_util_pkg.g_company_id;
51: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
52: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
53: l_actual_bitand := fii_ea_util_pkg.g_actual_bitand;
54: l_asof_date := fii_ea_util_pkg.g_as_of_date;
55: l_prev_asof_date := fii_ea_util_pkg.g_previous_asof_date;
56: l_ledger_id := fii_ea_util_pkg.g_ledger_id;

Line 53: l_actual_bitand := fii_ea_util_pkg.g_actual_bitand;

49: -- copy values to local variables
50: l_company_id := fii_ea_util_pkg.g_company_id;
51: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
52: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
53: l_actual_bitand := fii_ea_util_pkg.g_actual_bitand;
54: l_asof_date := fii_ea_util_pkg.g_as_of_date;
55: l_prev_asof_date := fii_ea_util_pkg.g_previous_asof_date;
56: l_ledger_id := fii_ea_util_pkg.g_ledger_id;
57: l_fud1_id := fii_ea_util_pkg.g_fud1_id;

Line 54: l_asof_date := fii_ea_util_pkg.g_as_of_date;

50: l_company_id := fii_ea_util_pkg.g_company_id;
51: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
52: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
53: l_actual_bitand := fii_ea_util_pkg.g_actual_bitand;
54: l_asof_date := fii_ea_util_pkg.g_as_of_date;
55: l_prev_asof_date := fii_ea_util_pkg.g_previous_asof_date;
56: l_ledger_id := fii_ea_util_pkg.g_ledger_id;
57: l_fud1_id := fii_ea_util_pkg.g_fud1_id;
58: l_fud2_id := fii_ea_util_pkg.g_fud2_id;

Line 55: l_prev_asof_date := fii_ea_util_pkg.g_previous_asof_date;

51: l_cost_center_id := fii_ea_util_pkg.g_cost_center_id;
52: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
53: l_actual_bitand := fii_ea_util_pkg.g_actual_bitand;
54: l_asof_date := fii_ea_util_pkg.g_as_of_date;
55: l_prev_asof_date := fii_ea_util_pkg.g_previous_asof_date;
56: l_ledger_id := fii_ea_util_pkg.g_ledger_id;
57: l_fud1_id := fii_ea_util_pkg.g_fud1_id;
58: l_fud2_id := fii_ea_util_pkg.g_fud2_id;
59:

Line 56: l_ledger_id := fii_ea_util_pkg.g_ledger_id;

52: l_fin_category_id := fii_ea_util_pkg.g_fin_category_id;
53: l_actual_bitand := fii_ea_util_pkg.g_actual_bitand;
54: l_asof_date := fii_ea_util_pkg.g_as_of_date;
55: l_prev_asof_date := fii_ea_util_pkg.g_previous_asof_date;
56: l_ledger_id := fii_ea_util_pkg.g_ledger_id;
57: l_fud1_id := fii_ea_util_pkg.g_fud1_id;
58: l_fud2_id := fii_ea_util_pkg.g_fud2_id;
59:
60: -- Company Id will always be passed

Line 57: l_fud1_id := fii_ea_util_pkg.g_fud1_id;

53: l_actual_bitand := fii_ea_util_pkg.g_actual_bitand;
54: l_asof_date := fii_ea_util_pkg.g_as_of_date;
55: l_prev_asof_date := fii_ea_util_pkg.g_previous_asof_date;
56: l_ledger_id := fii_ea_util_pkg.g_ledger_id;
57: l_fud1_id := fii_ea_util_pkg.g_fud1_id;
58: l_fud2_id := fii_ea_util_pkg.g_fud2_id;
59:
60: -- Company Id will always be passed
61: -- Cost Center Id will always be passed

Line 58: l_fud2_id := fii_ea_util_pkg.g_fud2_id;

54: l_asof_date := fii_ea_util_pkg.g_as_of_date;
55: l_prev_asof_date := fii_ea_util_pkg.g_previous_asof_date;
56: l_ledger_id := fii_ea_util_pkg.g_ledger_id;
57: l_fud1_id := fii_ea_util_pkg.g_fud1_id;
58: l_fud2_id := fii_ea_util_pkg.g_fud2_id;
59:
60: -- Company Id will always be passed
61: -- Cost Center Id will always be passed
62: -- Financial Category Id will always be passed

Line 67: -- instead of calling fii_ea_util_pkg.get_fud1_for_detail

63: -- Ledger Id will always be passed
64:
65: -- fud1 may be either All or specific
66: -- We need to build the where clause this way
67: -- instead of calling fii_ea_util_pkg.get_fud1_for_detail
68: -- so that it can also be used for the insert SQL below
69: if (l_fud1_id IS NOT NULL AND l_fud1_id <> 'All') THEN
70: l_fud1_where := ' and f.user_dim1_id = :l_fud1_id';
71: else

Line 77: -- instead of calling fii_ea_util_pkg.get_fud2_for_detail

73: end if;
74:
75: --fud2 may be either All or specific
76: -- We need to build the where clause this way
77: -- instead of calling fii_ea_util_pkg.get_fud2_for_detail
78: -- so that it can also be used for the insert SQL below
79: if (l_fud2_id IS NOT NULL AND l_fud2_id <> 'All') THEN
80: l_fud2_where := ' and f.user_dim2_id = :l_fud2_id';
81: else

Line 129: l_fud1_where := replace(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');

125: ELSE EXECUTE IMMEDIATE l_sqlstmt using l_asof_date,l_prev_asof_date,l_actual_bitand,l_actual_bitand,l_ledger_id,l_company_id,l_cost_center_id,l_fin_category_id;
126: END IF;
127:
128: -- reinitialize to use the API whereclause
129: l_fud1_where := replace(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');
130: l_fud2_where := replace(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');
131:
132: l_asset_url := 'pFunctionName=FII_EA_DPRN_EXP_LIST&pParamIds=Y&FII_EA_ASSET_CAT_MAJOR=FII_EA_ASSET_CAT_MAJ_ID';
133: l_minor_url := 'pFunctionName=FII_EA_DPRN_EXP_MIN&pParamIds=Y&FII_EA_ASSET_CAT_MAJOR=FII_EA_ASSET_CAT_MAJ_ID';

Line 130: l_fud2_where := replace(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');

126: END IF;
127:
128: -- reinitialize to use the API whereclause
129: l_fud1_where := replace(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');
130: l_fud2_where := replace(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');
131:
132: l_asset_url := 'pFunctionName=FII_EA_DPRN_EXP_LIST&pParamIds=Y&FII_EA_ASSET_CAT_MAJOR=FII_EA_ASSET_CAT_MAJ_ID';
133: l_minor_url := 'pFunctionName=FII_EA_DPRN_EXP_MIN&pParamIds=Y&FII_EA_ASSET_CAT_MAJOR=FII_EA_ASSET_CAT_MAJ_ID';
134:

Line 178: fii_ea_util_pkg.bind_variable(l_sqlstmt2, p_page_parameter_tbl, get_dprn_exp_maj_sql, get_dprn_exp_maj_output);

174: FII_EA_MAJ_CAT_GT gtemp
175: where gtemp.asset_cat_major_id = maj.fii_ea_major_cat_id
176: order by maj.fii_xtd_amount DESC ';
177:
178: fii_ea_util_pkg.bind_variable(l_sqlstmt2, p_page_parameter_tbl, get_dprn_exp_maj_sql, get_dprn_exp_maj_output);
179:
180: end GET_DPRN_EXP_MAJ;
181:
182:

Line 190: l_asset_cat_maj_id fii_ea_util_pkg.g_maj_cat_id%TYPE;

186: get_dprn_exp_min_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) is
187:
188: l_sqlstmt VARCHAR2(5000);
189:
190: l_asset_cat_maj_id fii_ea_util_pkg.g_maj_cat_id%TYPE;
191:
192: l_fud1_where VARCHAR2(1000);
193: l_fud2_where VARCHAR2(1000);
194: l_asset_url VARCHAR2(240);

Line 204: fii_ea_util_pkg.reset_globals;

200:
201: BEGIN
202:
203: -- reset the global variables
204: fii_ea_util_pkg.reset_globals;
205:
206: -- read the paramaters and populate the global variables
207: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
208:

Line 207: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);

203: -- reset the global variables
204: fii_ea_util_pkg.reset_globals;
205:
206: -- read the paramaters and populate the global variables
207: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
208:
209: -- Company Id will always be passed
210: -- Cost Center Id will always be passed
211: -- Financial Category Id will always be passed

Line 216: l_asset_cat_maj_id:= fii_ea_util_pkg.g_maj_cat_id;

212: -- Ledger Id will always be passed
213: -- Asset Category Major Id will always be passed
214:
215: -- copy values to local variables
216: l_asset_cat_maj_id:= fii_ea_util_pkg.g_maj_cat_id;
217: l_fud1_where := replace(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');
218: l_fud2_where := replace(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');
219:
220: -- get the flex segment column name used for the Minor Category segment

Line 217: l_fud1_where := replace(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');

213: -- Asset Category Major Id will always be passed
214:
215: -- copy values to local variables
216: l_asset_cat_maj_id:= fii_ea_util_pkg.g_maj_cat_id;
217: l_fud1_where := replace(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');
218: l_fud2_where := replace(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');
219:
220: -- get the flex segment column name used for the Minor Category segment
221: -- This value determines which column is being used in fa_categories to store Minor Category

Line 218: l_fud2_where := replace(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');

214:
215: -- copy values to local variables
216: l_asset_cat_maj_id:= fii_ea_util_pkg.g_maj_cat_id;
217: l_fud1_where := replace(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');
218: l_fud2_where := replace(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');
219:
220: -- get the flex segment column name used for the Minor Category segment
221: -- This value determines which column is being used in fa_categories to store Minor Category
222: open C1;

Line 270: fii_ea_util_pkg.bind_variable(l_sqlstmt, p_page_parameter_tbl, get_dprn_exp_min_sql, get_dprn_exp_min_output);

266: ||l_fud1_where||' '||l_fud2_where||
267: ' group by f.asset_cat_minor_id, cat.'||l_min_seg_name||' ) min
268: order by min.fii_xtd_amount DESC ';
269:
270: fii_ea_util_pkg.bind_variable(l_sqlstmt, p_page_parameter_tbl, get_dprn_exp_min_sql, get_dprn_exp_min_output);
271:
272: END GET_DPRN_EXP_MIN;
273:
274:

Line 282: l_cat_maj_id fii_ea_util_pkg.g_maj_cat_id%TYPE;

278: get_dprn_exp_list_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
279:
280: l_sqlstmt VARCHAR2(5000);
281:
282: l_cat_maj_id fii_ea_util_pkg.g_maj_cat_id%TYPE;
283: l_cat_min_id fii_ea_util_pkg.g_maj_cat_id%TYPE;
284:
285: l_fud1_where VARCHAR2(240);
286: l_fud2_where VARCHAR2(240);

Line 283: l_cat_min_id fii_ea_util_pkg.g_maj_cat_id%TYPE;

279:
280: l_sqlstmt VARCHAR2(5000);
281:
282: l_cat_maj_id fii_ea_util_pkg.g_maj_cat_id%TYPE;
283: l_cat_min_id fii_ea_util_pkg.g_maj_cat_id%TYPE;
284:
285: l_fud1_where VARCHAR2(240);
286: l_fud2_where VARCHAR2(240);
287: l_cat_min_where VARCHAR2(100);

Line 289: l_period_type fii_ea_util_pkg.g_page_period_type%TYPE;

285: l_fud1_where VARCHAR2(240);
286: l_fud2_where VARCHAR2(240);
287: l_cat_min_where VARCHAR2(100);
288: l_asset_url VARCHAR2(240);
289: l_period_type fii_ea_util_pkg.g_page_period_type%TYPE;
290:
291: BEGIN
292:
293: -- reset the global variables

Line 294: fii_ea_util_pkg.reset_globals;

290:
291: BEGIN
292:
293: -- reset the global variables
294: fii_ea_util_pkg.reset_globals;
295:
296: -- read the paramaters and populate the global variables
297: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
298:

Line 297: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);

293: -- reset the global variables
294: fii_ea_util_pkg.reset_globals;
295:
296: -- read the paramaters and populate the global variables
297: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
298:
299: -- copy values to local variables
300: l_cat_maj_id:= fii_ea_util_pkg.g_maj_cat_id;
301: l_cat_min_id:= fii_ea_util_pkg.g_min_cat_id;

Line 300: l_cat_maj_id:= fii_ea_util_pkg.g_maj_cat_id;

296: -- read the paramaters and populate the global variables
297: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
298:
299: -- copy values to local variables
300: l_cat_maj_id:= fii_ea_util_pkg.g_maj_cat_id;
301: l_cat_min_id:= fii_ea_util_pkg.g_min_cat_id;
302: l_fud1_where := replace(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');
303: l_fud2_where := replace(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');
304:

Line 301: l_cat_min_id:= fii_ea_util_pkg.g_min_cat_id;

297: fii_ea_util_pkg.get_parameters(p_page_parameter_tbl);
298:
299: -- copy values to local variables
300: l_cat_maj_id:= fii_ea_util_pkg.g_maj_cat_id;
301: l_cat_min_id:= fii_ea_util_pkg.g_min_cat_id;
302: l_fud1_where := replace(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');
303: l_fud2_where := replace(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');
304:
305: -- Min cat may be All or Specific

Line 302: l_fud1_where := replace(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');

298:
299: -- copy values to local variables
300: l_cat_maj_id:= fii_ea_util_pkg.g_maj_cat_id;
301: l_cat_min_id:= fii_ea_util_pkg.g_min_cat_id;
302: l_fud1_where := replace(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');
303: l_fud2_where := replace(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');
304:
305: -- Min cat may be All or Specific
306: if ( l_cat_min_id IS NOT NULL AND l_cat_min_id <> 'All') then

Line 303: l_fud2_where := replace(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');

299: -- copy values to local variables
300: l_cat_maj_id:= fii_ea_util_pkg.g_maj_cat_id;
301: l_cat_min_id:= fii_ea_util_pkg.g_min_cat_id;
302: l_fud1_where := replace(fii_ea_util_pkg.get_fud1_for_detail, 'fud1_id', 'user_dim1_id');
303: l_fud2_where := replace(fii_ea_util_pkg.get_fud2_for_detail, 'fud2_id', 'user_dim2_id');
304:
305: -- Min cat may be All or Specific
306: if ( l_cat_min_id IS NOT NULL AND l_cat_min_id <> 'All') then
307: l_cat_min_where := 'and f.asset_cat_minor_id = :MIN_CAT_ID';

Line 367: fii_ea_util_pkg.bind_variable(l_sqlstmt, p_page_parameter_tbl, get_dprn_exp_list_sql, get_dprn_exp_list_output);

363: av.description,
364: '''||l_asset_url||'''
365: order by 4 DESC ';
366:
367: fii_ea_util_pkg.bind_variable(l_sqlstmt, p_page_parameter_tbl, get_dprn_exp_list_sql, get_dprn_exp_list_output);
368:
369: END GET_DPRN_EXP_LIST;
370:
371: