23:
24: PROCEDURE get_je_tran (
25: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
26: jrnl_dtl_sql OUT NOCOPY VARCHAR2,
27: jrnl_dtl_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
28: IS
29: l_as_of_date DATE;
30: l_currency VARCHAR2(240);
31: sqlstmt VARCHAR2(14000);
158:
159: PROCEDURE get_je_line_tran (
160: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
161: jrnl_dtl_sql OUT NOCOPY VARCHAR2,
162: jrnl_dtl_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
163: IS
164: l_as_of_date DATE;
165: l_currency VARCHAR2(240);
166: sqlstmt VARCHAR2(14000);