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_SRC_INV_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 4: PROCEDURE get_exp_source (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

1: PACKAGE BODY FII_GL_SRC_INV_PKG AS
2: /* $Header: FIIGLSRB.pls 120.46 2006/08/04 07:38:11 sajgeo noship $ */
3:
4: PROCEDURE get_exp_source (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
5: exp_source_sql out NOCOPY VARCHAR2, exp_source_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL, fin_type IN VARCHAR2)
6: IS
7: sqlstmt VARCHAR2(32000);
8: sqlstmt2 VARCHAR2(500);

Line 198: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_src_sql out NOCOPY VARCHAR2, rev_src_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

194:
195: END get_exp_source;
196:
197: PROCEDURE get_rev_src (
198: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, rev_src_sql out NOCOPY VARCHAR2, rev_src_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
199: l_fin_type VARCHAR2(1);
200: BEGIN
201: l_fin_type := 'R';
202: fii_gl_src_inv_pkg.get_exp_source(p_page_parameter_tbl, rev_src_sql, rev_src_output, l_fin_type );

Line 207: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_src_sql out NOCOPY VARCHAR2, exp_src_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

203:
204: END get_rev_src;
205:
206: PROCEDURE get_exp_src (
207: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, exp_src_sql out NOCOPY VARCHAR2, exp_src_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
208: l_fin_type VARCHAR2(2);
209: BEGIN
210: l_fin_type := 'OE';
211: fii_gl_src_inv_pkg.get_exp_source(p_page_parameter_tbl, exp_src_sql, exp_src_output, l_fin_type );

Line 216: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, cogs_src_sql out NOCOPY VARCHAR2,cogs_src_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

212:
213: END get_exp_src;
214:
215: PROCEDURE get_cogs_src (
216: p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL, cogs_src_sql out NOCOPY VARCHAR2,cogs_src_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
217: l_fin_type VARCHAR2(3);
218: BEGIN
219: l_fin_type := 'CGS';
220: fii_gl_src_inv_pkg.get_exp_source(p_page_parameter_tbl, cogs_src_sql, cogs_src_output, l_fin_type );

Line 224: PROCEDURE get_inv_exp_det (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

220: fii_gl_src_inv_pkg.get_exp_source(p_page_parameter_tbl, cogs_src_sql, cogs_src_output, l_fin_type );
221:
222: END get_cogs_src;
223:
224: PROCEDURE get_inv_exp_det (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,
225: inv_exp_det_sql out NOCOPY VARCHAR2, inv_exp_det_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
226: IS
227: inv_exp_det_rec BIS_QUERY_ATTRIBUTES;
228: sqlstmt VARCHAR2(32000);

Line 332: PROCEDURE get_inv_rev_det (p_page_parameter_tbl in BIS_PMV_PAGE_PARAMETER_TBL,

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,
333: inv_rev_det_sql out NOCOPY VARCHAR2, inv_rev_det_output out NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
334: IS
335: sqlstmt VARCHAR2(32000);
336: l_ccc_join VARCHAR2(500) := NULL;