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.

[Home] [Help]

APPS.FII_GL_SRC_INV_PKG dependencies on FII_GL_UTIL_PKG

Line 22: fii_gl_util_pkg.reset_globals;

18:
19:
20: BEGIN
21:
22: fii_gl_util_pkg.reset_globals;
23: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
24: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
25: fii_gl_util_pkg.get_bitmasks;
26: fii_gl_util_pkg.g_fin_type := fin_type;

Line 23: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);

19:
20: BEGIN
21:
22: fii_gl_util_pkg.reset_globals;
23: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
24: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
25: fii_gl_util_pkg.get_bitmasks;
26: fii_gl_util_pkg.g_fin_type := fin_type;
27: fii_gl_util_pkg.get_mgr_pmv_sql;

Line 24: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';

20: BEGIN
21:
22: fii_gl_util_pkg.reset_globals;
23: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
24: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
25: fii_gl_util_pkg.get_bitmasks;
26: fii_gl_util_pkg.g_fin_type := fin_type;
27: fii_gl_util_pkg.get_mgr_pmv_sql;
28: fii_gl_util_pkg.get_lob_pmv_sql;

Line 25: fii_gl_util_pkg.get_bitmasks;

21:
22: fii_gl_util_pkg.reset_globals;
23: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
24: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
25: fii_gl_util_pkg.get_bitmasks;
26: fii_gl_util_pkg.g_fin_type := fin_type;
27: fii_gl_util_pkg.get_mgr_pmv_sql;
28: fii_gl_util_pkg.get_lob_pmv_sql;
29: fii_gl_util_pkg.get_non_ag_cat_pmv_sql;

Line 26: fii_gl_util_pkg.g_fin_type := fin_type;

22: fii_gl_util_pkg.reset_globals;
23: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
24: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
25: fii_gl_util_pkg.get_bitmasks;
26: fii_gl_util_pkg.g_fin_type := fin_type;
27: fii_gl_util_pkg.get_mgr_pmv_sql;
28: fii_gl_util_pkg.get_lob_pmv_sql;
29: fii_gl_util_pkg.get_non_ag_cat_pmv_sql;
30: fii_gl_util_pkg.get_ccc_pmv_sql;

Line 27: fii_gl_util_pkg.get_mgr_pmv_sql;

23: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
24: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
25: fii_gl_util_pkg.get_bitmasks;
26: fii_gl_util_pkg.g_fin_type := fin_type;
27: fii_gl_util_pkg.get_mgr_pmv_sql;
28: fii_gl_util_pkg.get_lob_pmv_sql;
29: fii_gl_util_pkg.get_non_ag_cat_pmv_sql;
30: fii_gl_util_pkg.get_ccc_pmv_sql;
31:

Line 28: fii_gl_util_pkg.get_lob_pmv_sql;

24: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
25: fii_gl_util_pkg.get_bitmasks;
26: fii_gl_util_pkg.g_fin_type := fin_type;
27: fii_gl_util_pkg.get_mgr_pmv_sql;
28: fii_gl_util_pkg.get_lob_pmv_sql;
29: fii_gl_util_pkg.get_non_ag_cat_pmv_sql;
30: fii_gl_util_pkg.get_ccc_pmv_sql;
31:
32:

Line 29: fii_gl_util_pkg.get_non_ag_cat_pmv_sql;

25: fii_gl_util_pkg.get_bitmasks;
26: fii_gl_util_pkg.g_fin_type := fin_type;
27: fii_gl_util_pkg.get_mgr_pmv_sql;
28: fii_gl_util_pkg.get_lob_pmv_sql;
29: fii_gl_util_pkg.get_non_ag_cat_pmv_sql;
30: fii_gl_util_pkg.get_ccc_pmv_sql;
31:
32:
33: /* -------------------------------------------------------------------------

Line 30: fii_gl_util_pkg.get_ccc_pmv_sql;

26: fii_gl_util_pkg.g_fin_type := fin_type;
27: fii_gl_util_pkg.get_mgr_pmv_sql;
28: fii_gl_util_pkg.get_lob_pmv_sql;
29: fii_gl_util_pkg.get_non_ag_cat_pmv_sql;
30: fii_gl_util_pkg.get_ccc_pmv_sql;
31:
32:
33: /* -------------------------------------------------------------------------
34: * Check if we are looking at the current month. If so, we need PTD amounts.

Line 39: select nvl(to_char(min(ent_period_id)),fii_gl_util_pkg.g_month_id) into l_time_parameter

35: * Otherwise, we need to find out the amounts for the whole month
36: * -------------------------------------------------------------------------
37: Commented for bug 5002688. Calculation of l_bitmask was already being done in util pkg. so, picking it from util now
38:
39: select nvl(to_char(min(ent_period_id)),fii_gl_util_pkg.g_month_id) into l_time_parameter
40: from fii_time_ent_period
41: where fii_gl_util_pkg.g_as_of_date between start_date and end_date;
42:
43: IF (fii_gl_util_pkg.g_month_id <> l_time_parameter) THEN

Line 41: where fii_gl_util_pkg.g_as_of_date between start_date and end_date;

37: Commented for bug 5002688. Calculation of l_bitmask was already being done in util pkg. so, picking it from util now
38:
39: select nvl(to_char(min(ent_period_id)),fii_gl_util_pkg.g_month_id) into l_time_parameter
40: from fii_time_ent_period
41: where fii_gl_util_pkg.g_as_of_date between start_date and end_date;
42:
43: IF (fii_gl_util_pkg.g_month_id <> l_time_parameter) THEN
44: l_bitmask := 256;
45: ELSE

Line 43: IF (fii_gl_util_pkg.g_month_id <> l_time_parameter) THEN

39: select nvl(to_char(min(ent_period_id)),fii_gl_util_pkg.g_month_id) into l_time_parameter
40: from fii_time_ent_period
41: where fii_gl_util_pkg.g_as_of_date between start_date and end_date;
42:
43: IF (fii_gl_util_pkg.g_month_id <> l_time_parameter) THEN
44: l_bitmask := 256;
45: ELSE
46: l_bitmask := 23;
47: END IF; */

Line 60: IF fii_gl_util_pkg.g_ccc_join IS NOT NULL THEN

56: * FII_MEASURE3 = Source Name, display in the report *
57: * FII_MEASURE2 = Actual Amount *
58: ************************************************************/
59:
60: IF fii_gl_util_pkg.g_ccc_join IS NOT NULL THEN
61: l_ccc_join :=
62: REPLACE(fii_gl_util_pkg.g_ccc_join,'f.cost_center_org_id','m.company_cost_center_org_id');
63: END IF;
64:

Line 62: REPLACE(fii_gl_util_pkg.g_ccc_join,'f.cost_center_org_id','m.company_cost_center_org_id');

58: ************************************************************/
59:
60: IF fii_gl_util_pkg.g_ccc_join IS NOT NULL THEN
61: l_ccc_join :=
62: REPLACE(fii_gl_util_pkg.g_ccc_join,'f.cost_center_org_id','m.company_cost_center_org_id');
63: END IF;
64:
65: IF fii_gl_util_pkg.g_lob_join IS NOT NULL THEN
66:

Line 65: IF fii_gl_util_pkg.g_lob_join IS NOT NULL THEN

61: l_ccc_join :=
62: REPLACE(fii_gl_util_pkg.g_ccc_join,'f.cost_center_org_id','m.company_cost_center_org_id');
63: END IF;
64:
65: IF fii_gl_util_pkg.g_lob_join IS NOT NULL THEN
66:
67: l_lob_join :=
68: REPLACE(fii_gl_util_pkg.g_lob_join,'f.line_of_business_id','m.parent_lob_id');
69:

Line 68: REPLACE(fii_gl_util_pkg.g_lob_join,'f.line_of_business_id','m.parent_lob_id');

64:
65: IF fii_gl_util_pkg.g_lob_join IS NOT NULL THEN
66:
67: l_lob_join :=
68: REPLACE(fii_gl_util_pkg.g_lob_join,'f.line_of_business_id','m.parent_lob_id');
69:
70: END IF ;
71:
72:

Line 73: IF fii_gl_util_pkg.g_fin_type <> 'R' THEN

69:
70: END IF ;
71:
72:
73: IF fii_gl_util_pkg.g_fin_type <> 'R' THEN
74: l_sign := '-';
75: END IF;
76:
77: IF fii_gl_util_pkg.g_currency = 'FII_GLOBAL1' THEN

Line 77: IF fii_gl_util_pkg.g_currency = 'FII_GLOBAL1' THEN

73: IF fii_gl_util_pkg.g_fin_type <> 'R' THEN
74: l_sign := '-';
75: END IF;
76:
77: IF fii_gl_util_pkg.g_currency = 'FII_GLOBAL1' THEN
78: l_amount_col := 'prim_amount_g';
79: ELSIF fii_gl_util_pkg.g_currency = 'FII_GLOBAL2' THEN
80: l_amount_col := 'sec_amount_g';
81: ELSE

Line 79: ELSIF fii_gl_util_pkg.g_currency = 'FII_GLOBAL2' THEN

75: END IF;
76:
77: IF fii_gl_util_pkg.g_currency = 'FII_GLOBAL1' THEN
78: l_amount_col := 'prim_amount_g';
79: ELSIF fii_gl_util_pkg.g_currency = 'FII_GLOBAL2' THEN
80: l_amount_col := 'sec_amount_g';
81: ELSE
82: l_amount_col := 'prim_amount_g';
83: END IF;

Line 129: '||fii_gl_util_pkg.g_lob_from_clause||'

125: fii_fin_cat_mappings c,
126: fii_time_rpt_struct cal,
127: gl_je_sources_tl src,
128: fii_cc_mgr_hierarchies h
129: '||fii_gl_util_pkg.g_lob_from_clause||'
130: WHERE f.company_id = m.company_id
131: AND f.cost_center_id = m.cost_center_id
132: AND m.valid_mgr_flag = ''Y''
133: AND c.child_fin_cat_id = f.fin_category_id

Line 175: from fii_gl_base_v'|| fii_gl_util_pkg.g_global_curr_view ||' f,

171: ''''
172: end
173: end
174: end FII_URL
175: from fii_gl_base_v'|| fii_gl_util_pkg.g_global_curr_view ||' f,
176: fii_time_rpt_struct cal,
177: gl_je_sources_tl src,
178: fii_cc_mgr_hierarchies h
179: '||fii_gl_util_pkg.g_non_ag_cat_from_clause||fii_gl_util_pkg.g_lob_from_clause||'

Line 179: '||fii_gl_util_pkg.g_non_ag_cat_from_clause||fii_gl_util_pkg.g_lob_from_clause||'

175: from fii_gl_base_v'|| fii_gl_util_pkg.g_global_curr_view ||' f,
176: fii_time_rpt_struct cal,
177: gl_je_sources_tl src,
178: fii_cc_mgr_hierarchies h
179: '||fii_gl_util_pkg.g_non_ag_cat_from_clause||fii_gl_util_pkg.g_lob_from_clause||'
180: where src.je_source_name = f.je_source
181: and h.mgr_id = &HRI_PERSON+HRI_PER_USRDR_H
182: and h.emp_id = f.manager_id
183: and f.period_type_id = cal.period_type_id

Line 187: '||fii_gl_util_pkg.g_non_ag_cat_join||fii_gl_util_pkg.g_ccc_join||fii_gl_util_pkg.g_lob_join||'

183: and f.period_type_id = cal.period_type_id
184: and cal.time_id = f.time_id
185: and cal.report_date = to_date(:P_AS_OF, ''DD-MM-YYYY'')
186: and bitand(cal.record_type_id, :BITMASK)= cal.record_type_id
187: '||fii_gl_util_pkg.g_non_ag_cat_join||fii_gl_util_pkg.g_ccc_join||fii_gl_util_pkg.g_lob_join||'
188: and src.language = userenv(''LANG'')
189: group by f.je_source, src.user_je_source_name, src.je_source_name';
190: */
191:

Line 193: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, exp_source_sql, exp_source_output);

189: group by f.je_source, src.user_je_source_name, src.je_source_name';
190: */
191:
192:
193: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, exp_source_sql, exp_source_output);
194:
195: END get_exp_source;
196:
197: PROCEDURE get_rev_src (

Line 237: fii_gl_util_pkg.reset_globals;

233: l_prim_sec VARCHAR2(30);
234:
235:
236: BEGIN
237: fii_gl_util_pkg.reset_globals;
238: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
239: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
240: fii_gl_util_pkg.get_bitmasks;
241: IF ((fii_gl_util_pkg.g_ccc_id IS NOT NULL) AND (fii_gl_util_pkg.g_ccc_id <> -999)) THEN

Line 238: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);

234:
235:
236: BEGIN
237: fii_gl_util_pkg.reset_globals;
238: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
239: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
240: fii_gl_util_pkg.get_bitmasks;
241: IF ((fii_gl_util_pkg.g_ccc_id IS NOT NULL) AND (fii_gl_util_pkg.g_ccc_id <> -999)) THEN
242: IF (fii_gl_util_pkg.ccc_within_mgr_lob(fii_gl_util_pkg.g_ccc_id, fii_gl_util_pkg.g_lob_id, fii_gl_util_pkg.g_mgr_id) = 'Y') THEN

Line 239: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';

235:
236: BEGIN
237: fii_gl_util_pkg.reset_globals;
238: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
239: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
240: fii_gl_util_pkg.get_bitmasks;
241: IF ((fii_gl_util_pkg.g_ccc_id IS NOT NULL) AND (fii_gl_util_pkg.g_ccc_id <> -999)) THEN
242: IF (fii_gl_util_pkg.ccc_within_mgr_lob(fii_gl_util_pkg.g_ccc_id, fii_gl_util_pkg.g_lob_id, fii_gl_util_pkg.g_mgr_id) = 'Y') THEN
243: l_ccc_join := ' and com.company_cost_center_org_id = &ORGANIZATION+HRI_CL_ORGCC

Line 240: fii_gl_util_pkg.get_bitmasks;

236: BEGIN
237: fii_gl_util_pkg.reset_globals;
238: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
239: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
240: fii_gl_util_pkg.get_bitmasks;
241: IF ((fii_gl_util_pkg.g_ccc_id IS NOT NULL) AND (fii_gl_util_pkg.g_ccc_id <> -999)) THEN
242: IF (fii_gl_util_pkg.ccc_within_mgr_lob(fii_gl_util_pkg.g_ccc_id, fii_gl_util_pkg.g_lob_id, fii_gl_util_pkg.g_mgr_id) = 'Y') THEN
243: l_ccc_join := ' and com.company_cost_center_org_id = &ORGANIZATION+HRI_CL_ORGCC
244: and com.company_id = f.company_id

Line 241: IF ((fii_gl_util_pkg.g_ccc_id IS NOT NULL) AND (fii_gl_util_pkg.g_ccc_id <> -999)) THEN

237: fii_gl_util_pkg.reset_globals;
238: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
239: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
240: fii_gl_util_pkg.get_bitmasks;
241: IF ((fii_gl_util_pkg.g_ccc_id IS NOT NULL) AND (fii_gl_util_pkg.g_ccc_id <> -999)) THEN
242: IF (fii_gl_util_pkg.ccc_within_mgr_lob(fii_gl_util_pkg.g_ccc_id, fii_gl_util_pkg.g_lob_id, fii_gl_util_pkg.g_mgr_id) = 'Y') THEN
243: l_ccc_join := ' and com.company_cost_center_org_id = &ORGANIZATION+HRI_CL_ORGCC
244: and com.company_id = f.company_id
245: and com.cost_center_id = f.cost_center_id ';

Line 242: IF (fii_gl_util_pkg.ccc_within_mgr_lob(fii_gl_util_pkg.g_ccc_id, fii_gl_util_pkg.g_lob_id, fii_gl_util_pkg.g_mgr_id) = 'Y') THEN

238: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
239: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
240: fii_gl_util_pkg.get_bitmasks;
241: IF ((fii_gl_util_pkg.g_ccc_id IS NOT NULL) AND (fii_gl_util_pkg.g_ccc_id <> -999)) THEN
242: IF (fii_gl_util_pkg.ccc_within_mgr_lob(fii_gl_util_pkg.g_ccc_id, fii_gl_util_pkg.g_lob_id, fii_gl_util_pkg.g_mgr_id) = 'Y') THEN
243: l_ccc_join := ' and com.company_cost_center_org_id = &ORGANIZATION+HRI_CL_ORGCC
244: and com.company_id = f.company_id
245: and com.cost_center_id = f.cost_center_id ';
246: l_from_clause := ', fii_com_cc_mappings com';

Line 250: ELSIF (fii_gl_util_pkg.g_lob_id IS NOT NULL) AND (fii_gl_util_pkg.g_lob_is_top_node <> 'Y') THEN

246: l_from_clause := ', fii_com_cc_mappings com';
247: ELSE
248: l_ccc_join := ' and 1 = 2 ';
249: END IF;
250: ELSIF (fii_gl_util_pkg.g_lob_id IS NOT NULL) AND (fii_gl_util_pkg.g_lob_is_top_node <> 'Y') THEN
251:
252:
253: l_lob_join := ' and lob.parent_lob_id = :LOB_ID
254: and lob.child_lob_id = com.parent_lob_id

Line 263: ELSIF (fii_gl_util_pkg.g_lob_id IS NULL) OR (fii_gl_util_pkg.g_lob_is_top_node = 'Y') THEN

259: l_from_clause := ', fii_com_cc_mappings com ,
260: fii_lob_hierarchies lob,
261: fii_cc_mgr_hierarchies mgr';
262: l_hint := '/*+leading(lob) */';
263: ELSIF (fii_gl_util_pkg.g_lob_id IS NULL) OR (fii_gl_util_pkg.g_lob_is_top_node = 'Y') THEN
264:
265:
266: l_lob_join := ' and com.company_id = f.company_id
267: and com.cost_center_id = f.cost_center_id

Line 276: IF fii_gl_util_pkg.g_global_curr_view = '1' THEN

272: l_hint := '/*+ leading(mgr) index(fi, fii_fin_cat_mappings_n1) */';
273:
274: END IF;
275:
276: IF fii_gl_util_pkg.g_global_curr_view = '1' THEN
277: l_prim_sec := 'prim_amount_g';
278: ELSE
279: l_prim_sec := 'sec_amount_g';
280: END IF;

Line 328: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, inv_exp_det_sql, inv_exp_det_output);

324: AND inline.invoice_id=ai.invoice_id';
325:
326:
327:
328: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, inv_exp_det_sql, inv_exp_det_output);
329:
330: END get_inv_exp_det;
331:
332: PROCEDURE get_inv_rev_det (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

Line 343: fii_gl_util_pkg.reset_globals;

339: l_hint VARCHAR2(100) := NULL;
340:
341: BEGIN
342:
343: fii_gl_util_pkg.reset_globals;
344: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
345: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
346: fii_gl_util_pkg.get_bitmasks;
347: IF ((fii_gl_util_pkg.g_ccc_id IS NOT NULL) AND (fii_gl_util_pkg.g_ccc_id <> -999)) THEN

Line 344: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);

340:
341: BEGIN
342:
343: fii_gl_util_pkg.reset_globals;
344: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
345: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
346: fii_gl_util_pkg.get_bitmasks;
347: IF ((fii_gl_util_pkg.g_ccc_id IS NOT NULL) AND (fii_gl_util_pkg.g_ccc_id <> -999)) THEN
348: IF (fii_gl_util_pkg.ccc_within_mgr_lob(fii_gl_util_pkg.g_ccc_id, fii_gl_util_pkg.g_lob_id, fii_gl_util_pkg.g_mgr_id) = 'Y') THEN

Line 345: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';

341: BEGIN
342:
343: fii_gl_util_pkg.reset_globals;
344: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
345: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
346: fii_gl_util_pkg.get_bitmasks;
347: IF ((fii_gl_util_pkg.g_ccc_id IS NOT NULL) AND (fii_gl_util_pkg.g_ccc_id <> -999)) THEN
348: IF (fii_gl_util_pkg.ccc_within_mgr_lob(fii_gl_util_pkg.g_ccc_id, fii_gl_util_pkg.g_lob_id, fii_gl_util_pkg.g_mgr_id) = 'Y') THEN
349: l_ccc_join := ' and com.company_cost_center_org_id = &ORGANIZATION+HRI_CL_ORGCC

Line 346: fii_gl_util_pkg.get_bitmasks;

342:
343: fii_gl_util_pkg.reset_globals;
344: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
345: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
346: fii_gl_util_pkg.get_bitmasks;
347: IF ((fii_gl_util_pkg.g_ccc_id IS NOT NULL) AND (fii_gl_util_pkg.g_ccc_id <> -999)) THEN
348: IF (fii_gl_util_pkg.ccc_within_mgr_lob(fii_gl_util_pkg.g_ccc_id, fii_gl_util_pkg.g_lob_id, fii_gl_util_pkg.g_mgr_id) = 'Y') THEN
349: l_ccc_join := ' and com.company_cost_center_org_id = &ORGANIZATION+HRI_CL_ORGCC
350: and com.company_id = f.company_id

Line 347: IF ((fii_gl_util_pkg.g_ccc_id IS NOT NULL) AND (fii_gl_util_pkg.g_ccc_id <> -999)) THEN

343: fii_gl_util_pkg.reset_globals;
344: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
345: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
346: fii_gl_util_pkg.get_bitmasks;
347: IF ((fii_gl_util_pkg.g_ccc_id IS NOT NULL) AND (fii_gl_util_pkg.g_ccc_id <> -999)) THEN
348: IF (fii_gl_util_pkg.ccc_within_mgr_lob(fii_gl_util_pkg.g_ccc_id, fii_gl_util_pkg.g_lob_id, fii_gl_util_pkg.g_mgr_id) = 'Y') THEN
349: l_ccc_join := ' and com.company_cost_center_org_id = &ORGANIZATION+HRI_CL_ORGCC
350: and com.company_id = f.company_id
351: and com.cost_center_id = f.cost_center_id ';

Line 348: IF (fii_gl_util_pkg.ccc_within_mgr_lob(fii_gl_util_pkg.g_ccc_id, fii_gl_util_pkg.g_lob_id, fii_gl_util_pkg.g_mgr_id) = 'Y') THEN

344: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
345: fii_gl_util_pkg.g_page_period_type := 'FII_TIME_ENT_PERIOD';
346: fii_gl_util_pkg.get_bitmasks;
347: IF ((fii_gl_util_pkg.g_ccc_id IS NOT NULL) AND (fii_gl_util_pkg.g_ccc_id <> -999)) THEN
348: IF (fii_gl_util_pkg.ccc_within_mgr_lob(fii_gl_util_pkg.g_ccc_id, fii_gl_util_pkg.g_lob_id, fii_gl_util_pkg.g_mgr_id) = 'Y') THEN
349: l_ccc_join := ' and com.company_cost_center_org_id = &ORGANIZATION+HRI_CL_ORGCC
350: and com.company_id = f.company_id
351: and com.cost_center_id = f.cost_center_id ';
352: l_from_clause := ', fii_com_cc_mappings com';

Line 356: ELSIF (fii_gl_util_pkg.g_lob_id IS NOT NULL) AND (fii_gl_util_pkg.g_lob_is_top_node <> 'Y') THEN

352: l_from_clause := ', fii_com_cc_mappings com';
353: ELSE
354: l_ccc_join := ' and 1 = 2 ';
355: END IF;
356: ELSIF (fii_gl_util_pkg.g_lob_id IS NOT NULL) AND (fii_gl_util_pkg.g_lob_is_top_node <> 'Y') THEN
357: l_lob_join := ' and lob.parent_lob_id = :LOB_ID
358: and lob.child_lob_id = com.parent_lob_id
359: and com.company_id = f.company_id
360: and com.cost_center_id = f.cost_center_id

Line 367: ELSIF (fii_gl_util_pkg.g_lob_id IS NULL) OR (fii_gl_util_pkg.g_lob_is_top_node = 'Y') THEN

363: l_from_clause := ', fii_com_cc_mappings com,
364: fii_lob_hierarchies lob,
365: fii_cc_mgr_hierarchies mgr';
366: l_hint := '/*+leading(lob) */';
367: ELSIF (fii_gl_util_pkg.g_lob_id IS NULL) OR (fii_gl_util_pkg.g_lob_is_top_node = 'Y') THEN
368: l_lob_join := ' and com.company_id = f.company_id
369: and com.cost_center_id = f.cost_center_id
370: and mgr.mgr_id = &HRI_PERSON+HRI_PER_USRDR_H
371: and mgr.emp_id = com.parent_manager_id';

Line 410: from fii_ar_revenue_b_v'||fii_gl_util_pkg.g_global_curr_view||' f,

406: to_char(f.invoice_date,''DD-MON-YYYY'') invoice_date,
407: sum(f.actual_g) sum_actual_g,
408: sum(sum(f.actual_g)) over() gt_actual_g,
409: f.bill_to_party_id bill_to_party_id
410: from fii_ar_revenue_b_v'||fii_gl_util_pkg.g_global_curr_view||' f,
411: fii_fin_cat_mappings cat,
412: fii_fin_item_hierarchies hier'||l_from_clause||'
413: where f.posted_flag = ''Y'''||l_ccc_join||l_lob_join||'
414: and f.gl_date between to_date(:P_DET_START, ''DD-MM-YYYY'') and to_date(:P_DET_END, ''DD-MM-YYYY'')

Line 430: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, inv_rev_det_sql, inv_rev_det_output);

426: and fnd.flex_value_id = inline.fin_category_id
427: and fnd.language = userenv(''Lang'')';
428:
429:
430: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, inv_rev_det_sql, inv_rev_det_output);
431:
432:
433: END get_inv_rev_det;
434: