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_GL_PROFIT_AND_LOSS dependencies on BIS_QUERY_ATTRIBUTES

Line 8: oper_profit_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

4:
5:
6: PROCEDURE GET_OPER_PROFIT1 (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
7: oper_profit_sql out NOCOPY VARCHAR2,
8: oper_profit_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
9: IS
10: oper_profit_rec BIS_QUERY_ATTRIBUTES;
11: sqlstmt VARCHAR2(32000);
12: comp_amt VARCHAR2(500);

Line 10: oper_profit_rec BIS_QUERY_ATTRIBUTES;

6: PROCEDURE GET_OPER_PROFIT1 (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
7: oper_profit_sql out NOCOPY VARCHAR2,
8: oper_profit_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
9: IS
10: oper_profit_rec BIS_QUERY_ATTRIBUTES;
11: sqlstmt VARCHAR2(32000);
12: comp_amt VARCHAR2(500);
13:
14: BEGIN

Line 77: oper_profit_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

73: END get_oper_profit1;
74:
75: PROCEDURE GET_OPER_PROFIT (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
76: oper_profit_sql out NOCOPY VARCHAR2,
77: oper_profit_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
78: IS
79: oper_profit_rec BIS_QUERY_ATTRIBUTES;
80: sqlstmt VARCHAR2(32000);
81: l_prior_or_budget1 VARCHAR2(1000);

Line 79: oper_profit_rec BIS_QUERY_ATTRIBUTES;

75: PROCEDURE GET_OPER_PROFIT (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
76: oper_profit_sql out NOCOPY VARCHAR2,
77: oper_profit_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
78: IS
79: oper_profit_rec BIS_QUERY_ATTRIBUTES;
80: sqlstmt VARCHAR2(32000);
81: l_prior_or_budget1 VARCHAR2(1000);
82: l_prior_or_budget2 VARCHAR2(1000);
83: l_prior_or_budget3 VARCHAR2(4000);

Line 234: rev_by_channel_sql out NOCOPY VARCHAR2, rev_by_channel_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

230: fii_gl_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, oper_profit_sql, oper_profit_output);
231: END get_oper_profit;
232:
233: PROCEDURE GET_REV_BY_CHANNEL (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
234: rev_by_channel_sql out NOCOPY VARCHAR2, rev_by_channel_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
235: IS
236: rev_by_channel_rec BIS_QUERY_ATTRIBUTES;
237: sqlstmt VARCHAR2(32000);
238:

Line 236: rev_by_channel_rec BIS_QUERY_ATTRIBUTES;

232:
233: PROCEDURE GET_REV_BY_CHANNEL (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
234: rev_by_channel_sql out NOCOPY VARCHAR2, rev_by_channel_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
235: IS
236: rev_by_channel_rec BIS_QUERY_ATTRIBUTES;
237: sqlstmt VARCHAR2(32000);
238:
239: BEGIN
240: fii_gl_util_pkg.reset_globals;