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_UTIL_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 2075: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

2071:
2072: BEGIN
2073:
2074: p_bind_output_table := BIS_QUERY_ATTRIBUTES_TBL();
2075: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
2076: p_sql_output := p_sqlstmt;
2077:
2078: p_bind_output_table.EXTEND;
2079: l_bind_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

Line 2079: l_bind_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

2075: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
2076: p_sql_output := p_sqlstmt;
2077:
2078: p_bind_output_table.EXTEND;
2079: l_bind_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
2080: l_bind_rec.attribute_value := g_view_by;
2081: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
2082: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2083:

Line 2081: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

2077:
2078: p_bind_output_table.EXTEND;
2079: l_bind_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
2080: l_bind_rec.attribute_value := g_view_by;
2081: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
2082: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2083:
2084: p_bind_output_table.EXTEND;
2085: l_bind_rec.attribute_name := ':PREVIOUS_ASOF_DATE';

Line 2087: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2083:
2084: p_bind_output_table.EXTEND;
2085: l_bind_rec.attribute_name := ':PREVIOUS_ASOF_DATE';
2086: l_bind_rec.attribute_value := to_char(g_previous_asof_date, 'DD/MM/YYYY');
2087: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2088: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2089: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2090:
2091: p_bind_output_table.EXTEND;

Line 2088: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2084: p_bind_output_table.EXTEND;
2085: l_bind_rec.attribute_name := ':PREVIOUS_ASOF_DATE';
2086: l_bind_rec.attribute_value := to_char(g_previous_asof_date, 'DD/MM/YYYY');
2087: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2088: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2089: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2090:
2091: p_bind_output_table.EXTEND;
2092: l_bind_rec.attribute_name := ':ASOF_DATE';

Line 2094: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2090:
2091: p_bind_output_table.EXTEND;
2092: l_bind_rec.attribute_name := ':ASOF_DATE';
2093: l_bind_rec.attribute_value := to_char(g_as_of_date, 'DD/MM/YYYY');
2094: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2095: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2096: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2097:
2098: /* Bug 4439400: Added ASOF_BUD_DATE and PREVIOUS_BUD_ASOF_DATE */

Line 2095: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2091: p_bind_output_table.EXTEND;
2092: l_bind_rec.attribute_name := ':ASOF_DATE';
2093: l_bind_rec.attribute_value := to_char(g_as_of_date, 'DD/MM/YYYY');
2094: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2095: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2096: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2097:
2098: /* Bug 4439400: Added ASOF_BUD_DATE and PREVIOUS_BUD_ASOF_DATE */
2099: p_bind_output_table.EXTEND;

Line 2102: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2098: /* Bug 4439400: Added ASOF_BUD_DATE and PREVIOUS_BUD_ASOF_DATE */
2099: p_bind_output_table.EXTEND;
2100: l_bind_rec.attribute_name := ':BUD_ASOF_DATE';
2101: l_bind_rec.attribute_value := to_char(g_bud_as_of_date, 'DD/MM/YYYY');
2102: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2103: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2104: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2105:
2106: p_bind_output_table.EXTEND;

Line 2103: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2099: p_bind_output_table.EXTEND;
2100: l_bind_rec.attribute_name := ':BUD_ASOF_DATE';
2101: l_bind_rec.attribute_value := to_char(g_bud_as_of_date, 'DD/MM/YYYY');
2102: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2103: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2104: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2105:
2106: p_bind_output_table.EXTEND;
2107: l_bind_rec.attribute_name := ':PREVIOUS_BUD_ASOF_DATE';

Line 2109: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2105:
2106: p_bind_output_table.EXTEND;
2107: l_bind_rec.attribute_name := ':PREVIOUS_BUD_ASOF_DATE';
2108: l_bind_rec.attribute_value := to_char(g_previous_bud_asof_date, 'DD/MM/YYYY');
2109: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2110: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2111: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2112:
2113: p_bind_output_table.EXTEND;

Line 2110: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2106: p_bind_output_table.EXTEND;
2107: l_bind_rec.attribute_name := ':PREVIOUS_BUD_ASOF_DATE';
2108: l_bind_rec.attribute_value := to_char(g_previous_bud_asof_date, 'DD/MM/YYYY');
2109: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2110: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2111: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2112:
2113: p_bind_output_table.EXTEND;
2114: l_bind_rec.attribute_name := ':COMPANY_ID';

Line 2116: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2112:
2113: p_bind_output_table.EXTEND;
2114: l_bind_rec.attribute_name := ':COMPANY_ID';
2115: l_bind_rec.attribute_value := to_char(g_company_id);
2116: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2117: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2118: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2119:
2120: p_bind_output_table.EXTEND;

Line 2117: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2113: p_bind_output_table.EXTEND;
2114: l_bind_rec.attribute_name := ':COMPANY_ID';
2115: l_bind_rec.attribute_value := to_char(g_company_id);
2116: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2117: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2118: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2119:
2120: p_bind_output_table.EXTEND;
2121: l_bind_rec.attribute_name := ':PARENT_COMPANY_ID';

Line 2123: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2119:
2120: p_bind_output_table.EXTEND;
2121: l_bind_rec.attribute_name := ':PARENT_COMPANY_ID';
2122: l_bind_rec.attribute_value := to_char(g_parent_company_id);
2123: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2124: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2125: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2126:
2127: p_bind_output_table.EXTEND;

Line 2124: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2120: p_bind_output_table.EXTEND;
2121: l_bind_rec.attribute_name := ':PARENT_COMPANY_ID';
2122: l_bind_rec.attribute_value := to_char(g_parent_company_id);
2123: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2124: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2125: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2126:
2127: p_bind_output_table.EXTEND;
2128: l_bind_rec.attribute_name := ':TOP_COMPANY_ID';

Line 2130: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2126:
2127: p_bind_output_table.EXTEND;
2128: l_bind_rec.attribute_name := ':TOP_COMPANY_ID';
2129: l_bind_rec.attribute_value := to_char(g_top_company_id);
2130: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2131: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2132: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2133:
2134: p_bind_output_table.EXTEND;

Line 2131: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2127: p_bind_output_table.EXTEND;
2128: l_bind_rec.attribute_name := ':TOP_COMPANY_ID';
2129: l_bind_rec.attribute_value := to_char(g_top_company_id);
2130: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2131: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2132: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2133:
2134: p_bind_output_table.EXTEND;
2135: l_bind_rec.attribute_name := ':COST_CENTER_ID';

Line 2137: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2133:
2134: p_bind_output_table.EXTEND;
2135: l_bind_rec.attribute_name := ':COST_CENTER_ID';
2136: l_bind_rec.attribute_value := to_char(g_cost_center_id);
2137: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2138: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2139: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2140:
2141: p_bind_output_table.EXTEND;

Line 2138: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2134: p_bind_output_table.EXTEND;
2135: l_bind_rec.attribute_name := ':COST_CENTER_ID';
2136: l_bind_rec.attribute_value := to_char(g_cost_center_id);
2137: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2138: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2139: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2140:
2141: p_bind_output_table.EXTEND;
2142: l_bind_rec.attribute_name := ':PARENT_COST_CENTER_ID';

Line 2144: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2140:
2141: p_bind_output_table.EXTEND;
2142: l_bind_rec.attribute_name := ':PARENT_COST_CENTER_ID';
2143: l_bind_rec.attribute_value := to_char(g_parent_cost_center_id);
2144: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2145: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2146: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2147:
2148: p_bind_output_table.EXTEND;

Line 2145: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2141: p_bind_output_table.EXTEND;
2142: l_bind_rec.attribute_name := ':PARENT_COST_CENTER_ID';
2143: l_bind_rec.attribute_value := to_char(g_parent_cost_center_id);
2144: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2145: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2146: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2147:
2148: p_bind_output_table.EXTEND;
2149: l_bind_rec.attribute_name := ':TOP_COST_CENTER_ID';

Line 2151: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2147:
2148: p_bind_output_table.EXTEND;
2149: l_bind_rec.attribute_name := ':TOP_COST_CENTER_ID';
2150: l_bind_rec.attribute_value := to_char(g_top_cost_center_id);
2151: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2152: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2153: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2154:
2155: p_bind_output_table.EXTEND;

Line 2152: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2148: p_bind_output_table.EXTEND;
2149: l_bind_rec.attribute_name := ':TOP_COST_CENTER_ID';
2150: l_bind_rec.attribute_value := to_char(g_top_cost_center_id);
2151: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2152: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2153: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2154:
2155: p_bind_output_table.EXTEND;
2156: l_bind_rec.attribute_name := ':FIN_CATEGORY_ID';

Line 2158: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2154:
2155: p_bind_output_table.EXTEND;
2156: l_bind_rec.attribute_name := ':FIN_CATEGORY_ID';
2157: l_bind_rec.attribute_value := to_char(g_fin_category_id);
2158: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2159: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2160: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2161:
2162: p_bind_output_table.EXTEND;

Line 2159: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2155: p_bind_output_table.EXTEND;
2156: l_bind_rec.attribute_name := ':FIN_CATEGORY_ID';
2157: l_bind_rec.attribute_value := to_char(g_fin_category_id);
2158: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2159: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2160: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2161:
2162: p_bind_output_table.EXTEND;
2163: l_bind_rec.attribute_name := ':PARENT_FIN_CATEGORY_ID';

Line 2165: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2161:
2162: p_bind_output_table.EXTEND;
2163: l_bind_rec.attribute_name := ':PARENT_FIN_CATEGORY_ID';
2164: l_bind_rec.attribute_value := to_char(g_parent_fin_category_id);
2165: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2166: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2167: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2168:
2169: p_bind_output_table.EXTEND;

Line 2166: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2162: p_bind_output_table.EXTEND;
2163: l_bind_rec.attribute_name := ':PARENT_FIN_CATEGORY_ID';
2164: l_bind_rec.attribute_value := to_char(g_parent_fin_category_id);
2165: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2166: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2167: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2168:
2169: p_bind_output_table.EXTEND;
2170: l_bind_rec.attribute_name := ':FUD1_ID';

Line 2172: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2168:
2169: p_bind_output_table.EXTEND;
2170: l_bind_rec.attribute_name := ':FUD1_ID';
2171: l_bind_rec.attribute_value := to_char(g_fud1_id);
2172: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2173: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2174: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2175:
2176: p_bind_output_table.EXTEND;

Line 2173: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2169: p_bind_output_table.EXTEND;
2170: l_bind_rec.attribute_name := ':FUD1_ID';
2171: l_bind_rec.attribute_value := to_char(g_fud1_id);
2172: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2173: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2174: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2175:
2176: p_bind_output_table.EXTEND;
2177: l_bind_rec.attribute_name := ':PARENT_FUD1_ID';

Line 2179: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2175:
2176: p_bind_output_table.EXTEND;
2177: l_bind_rec.attribute_name := ':PARENT_FUD1_ID';
2178: l_bind_rec.attribute_value := to_char(g_parent_fud1_id);
2179: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2180: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2181: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2182:
2183: p_bind_output_table.EXTEND;

Line 2180: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2176: p_bind_output_table.EXTEND;
2177: l_bind_rec.attribute_name := ':PARENT_FUD1_ID';
2178: l_bind_rec.attribute_value := to_char(g_parent_fud1_id);
2179: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2180: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2181: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2182:
2183: p_bind_output_table.EXTEND;
2184: l_bind_rec.attribute_name := ':TOP_FUD1_ID';

Line 2186: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2182:
2183: p_bind_output_table.EXTEND;
2184: l_bind_rec.attribute_name := ':TOP_FUD1_ID';
2185: l_bind_rec.attribute_value := to_char(g_top_fud1_id);
2186: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2187: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2188: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2189:
2190: p_bind_output_table.EXTEND;

Line 2187: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2183: p_bind_output_table.EXTEND;
2184: l_bind_rec.attribute_name := ':TOP_FUD1_ID';
2185: l_bind_rec.attribute_value := to_char(g_top_fud1_id);
2186: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2187: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2188: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2189:
2190: p_bind_output_table.EXTEND;
2191: l_bind_rec.attribute_name := ':FUD2_ID';

Line 2193: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2189:
2190: p_bind_output_table.EXTEND;
2191: l_bind_rec.attribute_name := ':FUD2_ID';
2192: l_bind_rec.attribute_value := to_char(g_fud2_id);
2193: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2194: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2195: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2196:
2197: p_bind_output_table.EXTEND;

Line 2194: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2190: p_bind_output_table.EXTEND;
2191: l_bind_rec.attribute_name := ':FUD2_ID';
2192: l_bind_rec.attribute_value := to_char(g_fud2_id);
2193: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2194: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2195: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2196:
2197: p_bind_output_table.EXTEND;
2198: l_bind_rec.attribute_name := ':PARENT_FUD2_ID';

Line 2200: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2196:
2197: p_bind_output_table.EXTEND;
2198: l_bind_rec.attribute_name := ':PARENT_FUD2_ID';
2199: l_bind_rec.attribute_value := to_char(g_parent_fud2_id);
2200: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2201: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2202: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2203:
2204: p_bind_output_table.EXTEND;

Line 2201: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2197: p_bind_output_table.EXTEND;
2198: l_bind_rec.attribute_name := ':PARENT_FUD2_ID';
2199: l_bind_rec.attribute_value := to_char(g_parent_fud2_id);
2200: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2201: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2202: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2203:
2204: p_bind_output_table.EXTEND;
2205: l_bind_rec.attribute_name := ':TOP_FUD2_ID';

Line 2207: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2203:
2204: p_bind_output_table.EXTEND;
2205: l_bind_rec.attribute_name := ':TOP_FUD2_ID';
2206: l_bind_rec.attribute_value := to_char(g_top_fud2_id);
2207: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2208: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2209: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2210:
2211: p_bind_output_table.EXTEND;

Line 2208: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2204: p_bind_output_table.EXTEND;
2205: l_bind_rec.attribute_name := ':TOP_FUD2_ID';
2206: l_bind_rec.attribute_value := to_char(g_top_fud2_id);
2207: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2208: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2209: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2210:
2211: p_bind_output_table.EXTEND;
2212: l_bind_rec.attribute_name := ':LEDGER_ID';

Line 2214: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2210:
2211: p_bind_output_table.EXTEND;
2212: l_bind_rec.attribute_name := ':LEDGER_ID';
2213: l_bind_rec.attribute_value := to_char(g_ledger_id);
2214: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2215: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2216: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2217:
2218: p_bind_output_table.EXTEND;

Line 2215: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2211: p_bind_output_table.EXTEND;
2212: l_bind_rec.attribute_name := ':LEDGER_ID';
2213: l_bind_rec.attribute_value := to_char(g_ledger_id);
2214: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2215: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2216: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2217:
2218: p_bind_output_table.EXTEND;
2219: l_bind_rec.attribute_name := ':CURR_VIEW';

Line 2221: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2217:
2218: p_bind_output_table.EXTEND;
2219: l_bind_rec.attribute_name := ':CURR_VIEW';
2220: l_bind_rec.attribute_value := to_char(g_curr_view);
2221: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2222: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2223: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2224:
2225: p_bind_output_table.EXTEND;

Line 2222: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2218: p_bind_output_table.EXTEND;
2219: l_bind_rec.attribute_name := ':CURR_VIEW';
2220: l_bind_rec.attribute_value := to_char(g_curr_view);
2221: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2222: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2223: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2224:
2225: p_bind_output_table.EXTEND;
2226: l_bind_rec.attribute_name := ':CURRENCY';

Line 2228: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2224:
2225: p_bind_output_table.EXTEND;
2226: l_bind_rec.attribute_name := ':CURRENCY';
2227: l_bind_rec.attribute_value := to_char(g_currency);
2228: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2229: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2230: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2231:
2232: p_bind_output_table.EXTEND;

Line 2229: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2225: p_bind_output_table.EXTEND;
2226: l_bind_rec.attribute_name := ':CURRENCY';
2227: l_bind_rec.attribute_value := to_char(g_currency);
2228: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2229: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2230: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2231:
2232: p_bind_output_table.EXTEND;
2233: l_bind_rec.attribute_name := ':ACTUAL_BITAND';

Line 2235: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2231:
2232: p_bind_output_table.EXTEND;
2233: l_bind_rec.attribute_name := ':ACTUAL_BITAND';
2234: l_bind_rec.attribute_value := to_char(g_actual_bitand);
2235: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2236: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2237: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2238:
2239: p_bind_output_table.EXTEND;

Line 2236: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2232: p_bind_output_table.EXTEND;
2233: l_bind_rec.attribute_name := ':ACTUAL_BITAND';
2234: l_bind_rec.attribute_value := to_char(g_actual_bitand);
2235: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2236: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2237: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2238:
2239: p_bind_output_table.EXTEND;
2240: l_bind_rec.attribute_name := ':HIST_ACTUAL_BITAND';

Line 2242: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2238:
2239: p_bind_output_table.EXTEND;
2240: l_bind_rec.attribute_name := ':HIST_ACTUAL_BITAND';
2241: l_bind_rec.attribute_value := to_char(g_hist_actual_bitand);
2242: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2243: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2244: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2245:
2246: p_bind_output_table.EXTEND;

Line 2243: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2239: p_bind_output_table.EXTEND;
2240: l_bind_rec.attribute_name := ':HIST_ACTUAL_BITAND';
2241: l_bind_rec.attribute_value := to_char(g_hist_actual_bitand);
2242: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2243: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2244: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2245:
2246: p_bind_output_table.EXTEND;
2247: l_bind_rec.attribute_name := ':BUDGET_BITAND';

Line 2249: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2245:
2246: p_bind_output_table.EXTEND;
2247: l_bind_rec.attribute_name := ':BUDGET_BITAND';
2248: l_bind_rec.attribute_value := to_char(g_budget_bitand);
2249: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2250: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2251: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2252:
2253: p_bind_output_table.EXTEND;

Line 2250: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2246: p_bind_output_table.EXTEND;
2247: l_bind_rec.attribute_name := ':BUDGET_BITAND';
2248: l_bind_rec.attribute_value := to_char(g_budget_bitand);
2249: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2250: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2251: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2252:
2253: p_bind_output_table.EXTEND;
2254: l_bind_rec.attribute_name := ':HIST_BUDGET_BITAND';

Line 2256: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2252:
2253: p_bind_output_table.EXTEND;
2254: l_bind_rec.attribute_name := ':HIST_BUDGET_BITAND';
2255: l_bind_rec.attribute_value := to_char(g_hist_budget_bitand);
2256: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2257: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2258: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2259:
2260: p_bind_output_table.EXTEND;

Line 2257: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2253: p_bind_output_table.EXTEND;
2254: l_bind_rec.attribute_name := ':HIST_BUDGET_BITAND';
2255: l_bind_rec.attribute_value := to_char(g_hist_budget_bitand);
2256: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2257: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2258: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2259:
2260: p_bind_output_table.EXTEND;
2261: l_bind_rec.attribute_name := ':FORECAST_BITAND';

Line 2263: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2259:
2260: p_bind_output_table.EXTEND;
2261: l_bind_rec.attribute_name := ':FORECAST_BITAND';
2262: l_bind_rec.attribute_value := to_char(g_forecast_bitand);
2263: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2264: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2265: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2266:
2267: p_bind_output_table.EXTEND;

Line 2264: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2260: p_bind_output_table.EXTEND;
2261: l_bind_rec.attribute_name := ':FORECAST_BITAND';
2262: l_bind_rec.attribute_value := to_char(g_forecast_bitand);
2263: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2264: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2265: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2266:
2267: p_bind_output_table.EXTEND;
2268: l_bind_rec.attribute_name := ':PREVIOUS_ONE_END_DATE';

Line 2270: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2266:
2267: p_bind_output_table.EXTEND;
2268: l_bind_rec.attribute_name := ':PREVIOUS_ONE_END_DATE';
2269: l_bind_rec.attribute_value := to_char(g_previous_one_END_date, 'DD/MM/YYYY');
2270: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2271: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2272: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2273:
2274: p_bind_output_table.EXTEND;

Line 2271: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2267: p_bind_output_table.EXTEND;
2268: l_bind_rec.attribute_name := ':PREVIOUS_ONE_END_DATE';
2269: l_bind_rec.attribute_value := to_char(g_previous_one_END_date, 'DD/MM/YYYY');
2270: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2271: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2272: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2273:
2274: p_bind_output_table.EXTEND;
2275: l_bind_rec.attribute_name := ':PREVIOUS_TWO_END_DATE';

Line 2277: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2273:
2274: p_bind_output_table.EXTEND;
2275: l_bind_rec.attribute_name := ':PREVIOUS_TWO_END_DATE';
2276: l_bind_rec.attribute_value := to_char(g_previous_two_END_date, 'DD/MM/YYYY');
2277: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2278: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2279: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2280:
2281: p_bind_output_table.EXTEND;

Line 2278: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2274: p_bind_output_table.EXTEND;
2275: l_bind_rec.attribute_name := ':PREVIOUS_TWO_END_DATE';
2276: l_bind_rec.attribute_value := to_char(g_previous_two_END_date, 'DD/MM/YYYY');
2277: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2278: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2279: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2280:
2281: p_bind_output_table.EXTEND;
2282: l_bind_rec.attribute_name := ':PREVIOUS_THREE_END_DATE';

Line 2284: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2280:
2281: p_bind_output_table.EXTEND;
2282: l_bind_rec.attribute_name := ':PREVIOUS_THREE_END_DATE';
2283: l_bind_rec.attribute_value := to_char(g_previous_three_END_date, 'DD/MM/YYYY');
2284: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2285: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2286: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2287:
2288: p_bind_output_table.EXTEND;

Line 2285: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2281: p_bind_output_table.EXTEND;
2282: l_bind_rec.attribute_name := ':PREVIOUS_THREE_END_DATE';
2283: l_bind_rec.attribute_value := to_char(g_previous_three_END_date, 'DD/MM/YYYY');
2284: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2285: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2286: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2287:
2288: p_bind_output_table.EXTEND;
2289: l_bind_rec.attribute_name := ':YEAR_ID';

Line 2291: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2287:
2288: p_bind_output_table.EXTEND;
2289: l_bind_rec.attribute_name := ':YEAR_ID';
2290: l_bind_rec.attribute_value := to_char(g_year_id);
2291: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2292: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2293: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2294:
2295: p_bind_output_table.EXTEND;

Line 2292: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2288: p_bind_output_table.EXTEND;
2289: l_bind_rec.attribute_name := ':YEAR_ID';
2290: l_bind_rec.attribute_value := to_char(g_year_id);
2291: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2292: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2293: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2294:
2295: p_bind_output_table.EXTEND;
2296: l_bind_rec.attribute_name := ':PRIOR_YEAR_ID';

Line 2298: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2294:
2295: p_bind_output_table.EXTEND;
2296: l_bind_rec.attribute_name := ':PRIOR_YEAR_ID';
2297: l_bind_rec.attribute_value := to_char(g_prior_year_id);
2298: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2299: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2300: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2301:
2302: p_bind_output_table.EXTEND;

Line 2299: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2295: p_bind_output_table.EXTEND;
2296: l_bind_rec.attribute_name := ':PRIOR_YEAR_ID';
2297: l_bind_rec.attribute_value := to_char(g_prior_year_id);
2298: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2299: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2300: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2301:
2302: p_bind_output_table.EXTEND;
2303: l_bind_rec.attribute_name := ':COAID';

Line 2305: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2301:
2302: p_bind_output_table.EXTEND;
2303: l_bind_rec.attribute_name := ':COAID';
2304: l_bind_rec.attribute_value := to_char(g_coaid);
2305: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2306: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2307: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2308:
2309: p_bind_output_table.EXTEND;

Line 2306: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2302: p_bind_output_table.EXTEND;
2303: l_bind_rec.attribute_name := ':COAID';
2304: l_bind_rec.attribute_value := to_char(g_coaid);
2305: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2306: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2307: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2308:
2309: p_bind_output_table.EXTEND;
2310: l_bind_rec.attribute_name := ':SOURCE_GROUP';

Line 2312: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2308:
2309: p_bind_output_table.EXTEND;
2310: l_bind_rec.attribute_name := ':SOURCE_GROUP';
2311: l_bind_rec.attribute_value := to_char(g_je_source_group);
2312: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2313: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2314: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2315:
2316: p_bind_output_table.EXTEND;

Line 2313: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2309: p_bind_output_table.EXTEND;
2310: l_bind_rec.attribute_name := ':SOURCE_GROUP';
2311: l_bind_rec.attribute_value := to_char(g_je_source_group);
2312: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2313: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2314: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2315:
2316: p_bind_output_table.EXTEND;
2317: l_bind_rec.attribute_name := ':PERIOD_SET_NAME';

Line 2319: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2315:
2316: p_bind_output_table.EXTEND;
2317: l_bind_rec.attribute_name := ':PERIOD_SET_NAME';
2318: l_bind_rec.attribute_value := to_char(g_period_set_name);
2319: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2320: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2321: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2322:
2323: p_bind_output_table.EXTEND;

Line 2320: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2316: p_bind_output_table.EXTEND;
2317: l_bind_rec.attribute_name := ':PERIOD_SET_NAME';
2318: l_bind_rec.attribute_value := to_char(g_period_set_name);
2319: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2320: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2321: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2322:
2323: p_bind_output_table.EXTEND;
2324: l_bind_rec.attribute_name := ':ACCOUNTED_PERIOD_TYPE';

Line 2326: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2322:
2323: p_bind_output_table.EXTEND;
2324: l_bind_rec.attribute_name := ':ACCOUNTED_PERIOD_TYPE';
2325: l_bind_rec.attribute_value := to_char(g_accounted_period_type);
2326: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2327: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2328: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2329:
2330: p_bind_output_table.EXTEND;

Line 2327: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2323: p_bind_output_table.EXTEND;
2324: l_bind_rec.attribute_name := ':ACCOUNTED_PERIOD_TYPE';
2325: l_bind_rec.attribute_value := to_char(g_accounted_period_type);
2326: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2327: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2328: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2329:
2330: p_bind_output_table.EXTEND;
2331: l_bind_rec.attribute_name := ':UNASSIGNED_ID';

Line 2333: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2329:
2330: p_bind_output_table.EXTEND;
2331: l_bind_rec.attribute_name := ':UNASSIGNED_ID';
2332: l_bind_rec.attribute_value := to_char(g_unassigned_id);
2333: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2334: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2335: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2336:
2337: p_bind_output_table.EXTEND;

Line 2334: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2330: p_bind_output_table.EXTEND;
2331: l_bind_rec.attribute_name := ':UNASSIGNED_ID';
2332: l_bind_rec.attribute_value := to_char(g_unassigned_id);
2333: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2334: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2335: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2336:
2337: p_bind_output_table.EXTEND;
2338: l_bind_rec.attribute_name := ':CURR_PERIOD_START';

Line 2340: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2336:
2337: p_bind_output_table.EXTEND;
2338: l_bind_rec.attribute_name := ':CURR_PERIOD_START';
2339: l_bind_rec.attribute_value := to_char(g_curr_per_start, 'DD/MM/YYYY');
2340: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2341: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2342: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2343:
2344: p_bind_output_table.EXTEND;

Line 2341: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2337: p_bind_output_table.EXTEND;
2338: l_bind_rec.attribute_name := ':CURR_PERIOD_START';
2339: l_bind_rec.attribute_value := to_char(g_curr_per_start, 'DD/MM/YYYY');
2340: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2341: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2342: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2343:
2344: p_bind_output_table.EXTEND;
2345: l_bind_rec.attribute_name := ':CURR_PERIOD_END';

Line 2347: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2343:
2344: p_bind_output_table.EXTEND;
2345: l_bind_rec.attribute_name := ':CURR_PERIOD_END';
2346: l_bind_rec.attribute_value := to_char(g_curr_per_end, 'DD/MM/YYYY');
2347: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2348: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2349: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2350:
2351: p_bind_output_table.EXTEND;

Line 2348: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2344: p_bind_output_table.EXTEND;
2345: l_bind_rec.attribute_name := ':CURR_PERIOD_END';
2346: l_bind_rec.attribute_value := to_char(g_curr_per_end, 'DD/MM/YYYY');
2347: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2348: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2349: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2350:
2351: p_bind_output_table.EXTEND;
2352: l_bind_rec.attribute_name := ':PRIOR_PERIOD_START';

Line 2354: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2350:
2351: p_bind_output_table.EXTEND;
2352: l_bind_rec.attribute_name := ':PRIOR_PERIOD_START';
2353: l_bind_rec.attribute_value := to_char(g_prior_per_start, 'DD/MM/YYYY');
2354: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2355: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2356: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2357:
2358: p_bind_output_table.EXTEND;

Line 2355: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2351: p_bind_output_table.EXTEND;
2352: l_bind_rec.attribute_name := ':PRIOR_PERIOD_START';
2353: l_bind_rec.attribute_value := to_char(g_prior_per_start, 'DD/MM/YYYY');
2354: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2355: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2356: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2357:
2358: p_bind_output_table.EXTEND;
2359: l_bind_rec.attribute_name := ':PRIOR_PERIOD_END';

Line 2361: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2357:
2358: p_bind_output_table.EXTEND;
2359: l_bind_rec.attribute_name := ':PRIOR_PERIOD_END';
2360: l_bind_rec.attribute_value := to_char(g_prior_per_end, 'DD/MM/YYYY');
2361: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2362: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2363: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2364:
2365: p_bind_output_table.EXTEND;

Line 2362: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2358: p_bind_output_table.EXTEND;
2359: l_bind_rec.attribute_name := ':PRIOR_PERIOD_END';
2360: l_bind_rec.attribute_value := to_char(g_prior_per_end, 'DD/MM/YYYY');
2361: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2362: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2363: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2364:
2365: p_bind_output_table.EXTEND;
2366: l_bind_rec.attribute_name := ':CURR_MONTH_START';

Line 2368: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2364:
2365: p_bind_output_table.EXTEND;
2366: l_bind_rec.attribute_name := ':CURR_MONTH_START';
2367: l_bind_rec.attribute_value := to_char(g_curr_month_start, 'DD/MM/YYYY');
2368: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2369: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2370: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2371:
2372: p_bind_output_table.EXTEND;

Line 2369: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2365: p_bind_output_table.EXTEND;
2366: l_bind_rec.attribute_name := ':CURR_MONTH_START';
2367: l_bind_rec.attribute_value := to_char(g_curr_month_start, 'DD/MM/YYYY');
2368: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2369: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2370: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2371:
2372: p_bind_output_table.EXTEND;
2373: l_bind_rec.attribute_name := ':BOUNDARY_END';

Line 2375: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2371:
2372: p_bind_output_table.EXTEND;
2373: l_bind_rec.attribute_name := ':BOUNDARY_END';
2374: l_bind_rec.attribute_value := to_char(g_boundary_end, 'DD/MM/YYYY');
2375: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2376: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2377: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2378:
2379: p_bind_output_table.EXTEND;

Line 2376: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2372: p_bind_output_table.EXTEND;
2373: l_bind_rec.attribute_name := ':BOUNDARY_END';
2374: l_bind_rec.attribute_value := to_char(g_boundary_end, 'DD/MM/YYYY');
2375: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2376: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2377: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2378:
2379: p_bind_output_table.EXTEND;
2380: l_bind_rec.attribute_name := ':PRIOR_BOUNDARY_END';

Line 2382: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2378:
2379: p_bind_output_table.EXTEND;
2380: l_bind_rec.attribute_name := ':PRIOR_BOUNDARY_END';
2381: l_bind_rec.attribute_value := to_char(g_prior_boundary_end, 'DD/MM/YYYY');
2382: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2383: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2384: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2385:
2386: p_bind_output_table.EXTEND;

Line 2383: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2379: p_bind_output_table.EXTEND;
2380: l_bind_rec.attribute_name := ':PRIOR_BOUNDARY_END';
2381: l_bind_rec.attribute_value := to_char(g_prior_boundary_end, 'DD/MM/YYYY');
2382: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2383: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2384: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2385:
2386: p_bind_output_table.EXTEND;
2387: l_bind_rec.attribute_name := ':AMOUNT_TYPE_BITAND';

Line 2389: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2385:
2386: p_bind_output_table.EXTEND;
2387: l_bind_rec.attribute_name := ':AMOUNT_TYPE_BITAND';
2388: l_bind_rec.attribute_value := to_char(g_amount_type_bitand);
2389: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2390: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2391: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2392:
2393: p_bind_output_table.EXTEND;

Line 2390: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2386: p_bind_output_table.EXTEND;
2387: l_bind_rec.attribute_name := ':AMOUNT_TYPE_BITAND';
2388: l_bind_rec.attribute_value := to_char(g_amount_type_bitand);
2389: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2390: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2391: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2392:
2393: p_bind_output_table.EXTEND;
2394: l_bind_rec.attribute_name := ':DIR_MSG';

Line 2396: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2392:
2393: p_bind_output_table.EXTEND;
2394: l_bind_rec.attribute_name := ':DIR_MSG';
2395: l_bind_rec.attribute_value := to_char(g_dir_msg);
2396: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2397: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2398: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2399:
2400: p_bind_output_table.EXTEND;

Line 2397: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2393: p_bind_output_table.EXTEND;
2394: l_bind_rec.attribute_name := ':DIR_MSG';
2395: l_bind_rec.attribute_value := to_char(g_dir_msg);
2396: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2397: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2398: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2399:
2400: p_bind_output_table.EXTEND;
2401: l_bind_rec.attribute_name := ':SD_PRIOR';

Line 2403: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2399:
2400: p_bind_output_table.EXTEND;
2401: l_bind_rec.attribute_name := ':SD_PRIOR';
2402: l_bind_rec.attribute_value := to_char(g_sd_prior, 'DD/MM/YYYY');
2403: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2404: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2405: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2406:
2407: p_bind_output_table.EXTEND;

Line 2404: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2400: p_bind_output_table.EXTEND;
2401: l_bind_rec.attribute_name := ':SD_PRIOR';
2402: l_bind_rec.attribute_value := to_char(g_sd_prior, 'DD/MM/YYYY');
2403: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2404: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2405: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2406:
2407: p_bind_output_table.EXTEND;
2408: l_bind_rec.attribute_name := ':SD_PRIOR_PRIOR';

Line 2410: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2406:
2407: p_bind_output_table.EXTEND;
2408: l_bind_rec.attribute_name := ':SD_PRIOR_PRIOR';
2409: l_bind_rec.attribute_value := to_char(g_sd_prior_prior, 'DD/MM/YYYY');
2410: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2411: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2412: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2413:
2414: p_bind_output_table.EXTEND;

Line 2411: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2407: p_bind_output_table.EXTEND;
2408: l_bind_rec.attribute_name := ':SD_PRIOR_PRIOR';
2409: l_bind_rec.attribute_value := to_char(g_sd_prior_prior, 'DD/MM/YYYY');
2410: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2411: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2412: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2413:
2414: p_bind_output_table.EXTEND;
2415: l_bind_rec.attribute_name := ':MIN_CAT_ID';

Line 2417: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2413:
2414: p_bind_output_table.EXTEND;
2415: l_bind_rec.attribute_name := ':MIN_CAT_ID';
2416: l_bind_rec.attribute_value := to_char(g_min_cat_id);
2417: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2418: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2419: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2420:
2421: p_bind_output_table.EXTEND;

Line 2418: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2414: p_bind_output_table.EXTEND;
2415: l_bind_rec.attribute_name := ':MIN_CAT_ID';
2416: l_bind_rec.attribute_value := to_char(g_min_cat_id);
2417: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2418: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2419: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2420:
2421: p_bind_output_table.EXTEND;
2422: l_bind_rec.attribute_name := ':G_ID';

Line 2424: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2420:
2421: p_bind_output_table.EXTEND;
2422: l_bind_rec.attribute_name := ':G_ID';
2423: l_bind_rec.attribute_value := to_char(g_id);
2424: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2425: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2426: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2427:
2428: p_bind_output_table.EXTEND;

Line 2425: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2421: p_bind_output_table.EXTEND;
2422: l_bind_rec.attribute_name := ':G_ID';
2423: l_bind_rec.attribute_value := to_char(g_id);
2424: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2425: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2426: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2427:
2428: p_bind_output_table.EXTEND;
2429: l_bind_rec.attribute_name := ':TIME_ID';

Line 2431: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2427:
2428: p_bind_output_table.EXTEND;
2429: l_bind_rec.attribute_name := ':TIME_ID';
2430: l_bind_rec.attribute_value := to_char(g_time_id);
2431: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2432: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2433: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2434:
2435: p_bind_output_table.EXTEND;

Line 2432: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2428: p_bind_output_table.EXTEND;
2429: l_bind_rec.attribute_name := ':TIME_ID';
2430: l_bind_rec.attribute_value := to_char(g_time_id);
2431: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2432: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2433: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2434:
2435: p_bind_output_table.EXTEND;
2436: l_bind_rec.attribute_name := ':CATEGORY_ID';

Line 2438: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2434:
2435: p_bind_output_table.EXTEND;
2436: l_bind_rec.attribute_name := ':CATEGORY_ID';
2437: l_bind_rec.attribute_value := to_char(g_category_id);
2438: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2439: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2440: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2441:
2442: p_bind_output_table.EXTEND;

Line 2439: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2435: p_bind_output_table.EXTEND;
2436: l_bind_rec.attribute_name := ':CATEGORY_ID';
2437: l_bind_rec.attribute_value := to_char(g_category_id);
2438: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2439: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2440: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2441:
2442: p_bind_output_table.EXTEND;
2443: l_bind_rec.attribute_name := ':UDD1_ID';

Line 2445: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2441:
2442: p_bind_output_table.EXTEND;
2443: l_bind_rec.attribute_name := ':UDD1_ID';
2444: l_bind_rec.attribute_value := to_char(g_udd1_id);
2445: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2446: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2447: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2448:
2449: p_bind_output_table.EXTEND;

Line 2446: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2442: p_bind_output_table.EXTEND;
2443: l_bind_rec.attribute_name := ':UDD1_ID';
2444: l_bind_rec.attribute_value := to_char(g_udd1_id);
2445: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2446: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2447: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2448:
2449: p_bind_output_table.EXTEND;
2450: l_bind_rec.attribute_name := ':DISPLAY_SEQUENCE';

Line 2452: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2448:
2449: p_bind_output_table.EXTEND;
2450: l_bind_rec.attribute_name := ':DISPLAY_SEQUENCE';
2451: l_bind_rec.attribute_value := to_char(g_display_sequence);
2452: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2453: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2454: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2455:
2456:

Line 2453: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2449: p_bind_output_table.EXTEND;
2450: l_bind_rec.attribute_name := ':DISPLAY_SEQUENCE';
2451: l_bind_rec.attribute_value := to_char(g_display_sequence);
2452: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2453: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2454: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2455:
2456:
2457: p_bind_output_table.EXTEND;

Line 2460: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2456:
2457: p_bind_output_table.EXTEND;
2458: l_bind_rec.attribute_name := ':CURR_PERIOD_START_ID';
2459: l_bind_rec.attribute_value := to_char(g_curr_per_start_id);
2460: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2461: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2462: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2463:
2464: p_bind_output_table.EXTEND;

Line 2461: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2457: p_bind_output_table.EXTEND;
2458: l_bind_rec.attribute_name := ':CURR_PERIOD_START_ID';
2459: l_bind_rec.attribute_value := to_char(g_curr_per_start_id);
2460: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2461: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2462: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2463:
2464: p_bind_output_table.EXTEND;
2465: l_bind_rec.attribute_name := ':ASOF_DATE_ID';

Line 2467: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2463:
2464: p_bind_output_table.EXTEND;
2465: l_bind_rec.attribute_name := ':ASOF_DATE_ID';
2466: l_bind_rec.attribute_value := to_char(g_as_of_date_id);
2467: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2468: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2469: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2470:
2471: -- Added for P&L Analysis

Line 2468: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2464: p_bind_output_table.EXTEND;
2465: l_bind_rec.attribute_name := ':ASOF_DATE_ID';
2466: l_bind_rec.attribute_value := to_char(g_as_of_date_id);
2467: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2468: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2469: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2470:
2471: -- Added for P&L Analysis
2472: p_bind_output_table.EXTEND;

Line 2475: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2471: -- Added for P&L Analysis
2472: p_bind_output_table.EXTEND;
2473: l_bind_rec.attribute_name := ':FIVE_YR_BACK';
2474: l_bind_rec.attribute_value := to_char(g_five_yr_back, 'DD/MM/YYYY');
2475: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2476: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2477: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2478:
2479: p_bind_output_table.EXTEND;

Line 2476: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2472: p_bind_output_table.EXTEND;
2473: l_bind_rec.attribute_name := ':FIVE_YR_BACK';
2474: l_bind_rec.attribute_value := to_char(g_five_yr_back, 'DD/MM/YYYY');
2475: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2476: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2477: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2478:
2479: p_bind_output_table.EXTEND;
2480: l_bind_rec.attribute_name := ':PY_SAME_DAY';

Line 2482: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2478:
2479: p_bind_output_table.EXTEND;
2480: l_bind_rec.attribute_name := ':PY_SAME_DAY';
2481: l_bind_rec.attribute_value := to_char(g_py_sday, 'DD/MM/YYYY');
2482: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2483: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2484: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2485:
2486: p_bind_output_table.EXTEND;

Line 2483: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2479: p_bind_output_table.EXTEND;
2480: l_bind_rec.attribute_name := ':PY_SAME_DAY';
2481: l_bind_rec.attribute_value := to_char(g_py_sday, 'DD/MM/YYYY');
2482: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2483: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2484: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2485:
2486: p_bind_output_table.EXTEND;
2487: l_bind_rec.attribute_name := ':P_EXP_ASOF';

Line 2489: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2485:
2486: p_bind_output_table.EXTEND;
2487: l_bind_rec.attribute_name := ':P_EXP_ASOF';
2488: l_bind_rec.attribute_value := to_char(g_exp_asof_date, 'DD/MM/YYYY');
2489: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2490: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2491: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2492:
2493:

Line 2490: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2486: p_bind_output_table.EXTEND;
2487: l_bind_rec.attribute_name := ':P_EXP_ASOF';
2488: l_bind_rec.attribute_value := to_char(g_exp_asof_date, 'DD/MM/YYYY');
2489: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2490: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2491: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2492:
2493:
2494: p_bind_output_table.EXTEND;

Line 2497: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2493:
2494: p_bind_output_table.EXTEND;
2495: l_bind_rec.attribute_name := ':CY_PERIOD_END';
2496: l_bind_rec.attribute_value := to_char(g_cy_period_end, 'DD/MM/YYYY');
2497: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2498: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2499: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2500:
2501: p_bind_output_table.EXTEND;

Line 2498: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2494: p_bind_output_table.EXTEND;
2495: l_bind_rec.attribute_name := ':CY_PERIOD_END';
2496: l_bind_rec.attribute_value := to_char(g_cy_period_end, 'DD/MM/YYYY');
2497: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2498: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2499: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2500:
2501: p_bind_output_table.EXTEND;
2502: l_bind_rec.attribute_name := ':ENT_PYR_END';

Line 2504: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2500:
2501: p_bind_output_table.EXTEND;
2502: l_bind_rec.attribute_name := ':ENT_PYR_END';
2503: l_bind_rec.attribute_value := to_char(g_ent_pyr_end, 'DD/MM/YYYY');
2504: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2505: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2506: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2507:
2508: p_bind_output_table.EXTEND;

Line 2505: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2501: p_bind_output_table.EXTEND;
2502: l_bind_rec.attribute_name := ':ENT_PYR_END';
2503: l_bind_rec.attribute_value := to_char(g_ent_pyr_end, 'DD/MM/YYYY');
2504: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2505: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2506: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2507:
2508: p_bind_output_table.EXTEND;
2509: l_bind_rec.attribute_name := ':ACTUAL_PERIOD_TYPE';

Line 2511: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2507:
2508: p_bind_output_table.EXTEND;
2509: l_bind_rec.attribute_name := ':ACTUAL_PERIOD_TYPE';
2510: l_bind_rec.attribute_value := to_char(g_actual_period_type);
2511: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2512: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2513: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2514:
2515: p_bind_output_table.EXTEND;

Line 2512: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2508: p_bind_output_table.EXTEND;
2509: l_bind_rec.attribute_name := ':ACTUAL_PERIOD_TYPE';
2510: l_bind_rec.attribute_value := to_char(g_actual_period_type);
2511: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2512: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2513: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2514:
2515: p_bind_output_table.EXTEND;
2516: l_bind_rec.attribute_name := ':BUDGET_PERIOD_TYPE';

Line 2518: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2514:
2515: p_bind_output_table.EXTEND;
2516: l_bind_rec.attribute_name := ':BUDGET_PERIOD_TYPE';
2517: l_bind_rec.attribute_value := to_char(g_budget_period_type);
2518: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2519: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2520: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2521:
2522: p_bind_output_table.EXTEND;

Line 2519: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2515: p_bind_output_table.EXTEND;
2516: l_bind_rec.attribute_name := ':BUDGET_PERIOD_TYPE';
2517: l_bind_rec.attribute_value := to_char(g_budget_period_type);
2518: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2519: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2520: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2521:
2522: p_bind_output_table.EXTEND;
2523: l_bind_rec.attribute_name := ':FORECAST_PERIOD_TYPE';

Line 2525: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2521:
2522: p_bind_output_table.EXTEND;
2523: l_bind_rec.attribute_name := ':FORECAST_PERIOD_TYPE';
2524: l_bind_rec.attribute_value := to_char(g_forecast_period_type);
2525: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2526: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2527: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2528:
2529: p_bind_output_table.EXTEND;

Line 2526: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2522: p_bind_output_table.EXTEND;
2523: l_bind_rec.attribute_name := ':FORECAST_PERIOD_TYPE';
2524: l_bind_rec.attribute_value := to_char(g_forecast_period_type);
2525: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2526: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2527: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2528:
2529: p_bind_output_table.EXTEND;
2530: l_bind_rec.attribute_name := ':WHERE_PERIOD_TYPE';

Line 2532: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2528:
2529: p_bind_output_table.EXTEND;
2530: l_bind_rec.attribute_name := ':WHERE_PERIOD_TYPE';
2531: l_bind_rec.attribute_value := to_char(g_where_period_type);
2532: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2533: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2534: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2535:
2536: p_bind_output_table.EXTEND;

Line 2533: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2529: p_bind_output_table.EXTEND;
2530: l_bind_rec.attribute_name := ':WHERE_PERIOD_TYPE';
2531: l_bind_rec.attribute_value := to_char(g_where_period_type);
2532: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2533: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2534: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2535:
2536: p_bind_output_table.EXTEND;
2537: l_bind_rec.attribute_name := ':ENT_CYR_END';

Line 2539: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2535:
2536: p_bind_output_table.EXTEND;
2537: l_bind_rec.attribute_name := ':ENT_CYR_END';
2538: l_bind_rec.attribute_value := to_char(g_ent_cyr_end, 'DD/MM/YYYY');
2539: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2540: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2541: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2542:
2543: p_bind_output_table.EXTEND;

Line 2540: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2536: p_bind_output_table.EXTEND;
2537: l_bind_rec.attribute_name := ':ENT_CYR_END';
2538: l_bind_rec.attribute_value := to_char(g_ent_cyr_end, 'DD/MM/YYYY');
2539: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2540: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2541: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2542:
2543: p_bind_output_table.EXTEND;
2544: l_bind_rec.attribute_name := ':CURR_EFFECTIVE_SEQ';

Line 2546: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2542:
2543: p_bind_output_table.EXTEND;
2544: l_bind_rec.attribute_name := ':CURR_EFFECTIVE_SEQ';
2545: l_bind_rec.attribute_value := to_char(g_curr_per_sequence);
2546: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2547: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2548: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2549:
2550: p_bind_output_table.EXTEND;

Line 2547: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2543: p_bind_output_table.EXTEND;
2544: l_bind_rec.attribute_name := ':CURR_EFFECTIVE_SEQ';
2545: l_bind_rec.attribute_value := to_char(g_curr_per_sequence);
2546: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2547: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2548: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2549:
2550: p_bind_output_table.EXTEND;
2551: l_bind_rec.attribute_name := ':PERIOD_TYPE';

Line 2553: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2549:
2550: p_bind_output_table.EXTEND;
2551: l_bind_rec.attribute_name := ':PERIOD_TYPE';
2552: l_bind_rec.attribute_value := to_char(g_period_type);
2553: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2554: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2555: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2556:
2557: p_bind_output_table.EXTEND;

Line 2554: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

2550: p_bind_output_table.EXTEND;
2551: l_bind_rec.attribute_name := ':PERIOD_TYPE';
2552: l_bind_rec.attribute_value := to_char(g_period_type);
2553: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2554: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
2555: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2556:
2557: p_bind_output_table.EXTEND;
2558: l_bind_rec.attribute_name := ':P_EXP_START';

Line 2560: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2556:
2557: p_bind_output_table.EXTEND;
2558: l_bind_rec.attribute_name := ':P_EXP_START';
2559: l_bind_rec.attribute_value := to_char(g_exp_start, 'DD/MM/YYYY');
2560: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2561: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2562: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2563:
2564: p_bind_output_table.EXTEND;

Line 2561: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2557: p_bind_output_table.EXTEND;
2558: l_bind_rec.attribute_name := ':P_EXP_START';
2559: l_bind_rec.attribute_value := to_char(g_exp_start, 'DD/MM/YYYY');
2560: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2561: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2562: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2563:
2564: p_bind_output_table.EXTEND;
2565: l_bind_rec.attribute_name := ':P_EXP_BEGIN';

Line 2567: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2563:
2564: p_bind_output_table.EXTEND;
2565: l_bind_rec.attribute_name := ':P_EXP_BEGIN';
2566: l_bind_rec.attribute_value := to_char(g_exp_begin_date, 'DD/MM/YYYY');
2567: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2568: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2569: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2570:
2571: p_bind_output_table.EXTEND;

Line 2568: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

2564: p_bind_output_table.EXTEND;
2565: l_bind_rec.attribute_name := ':P_EXP_BEGIN';
2566: l_bind_rec.attribute_value := to_char(g_exp_begin_date, 'DD/MM/YYYY');
2567: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2568: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
2569: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2570:
2571: p_bind_output_table.EXTEND;
2572: l_bind_rec.attribute_name := ':FIN_TYPE';

Line 2574: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

2570:
2571: p_bind_output_table.EXTEND;
2572: l_bind_rec.attribute_name := ':FIN_TYPE';
2573: l_bind_rec.attribute_value := to_char(g_fin_type);
2574: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2575: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2576: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2577:
2578: END bind_variable;

Line 2575: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

2571: p_bind_output_table.EXTEND;
2572: l_bind_rec.attribute_name := ':FIN_TYPE';
2573: l_bind_rec.attribute_value := to_char(g_fin_type);
2574: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
2575: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
2576: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
2577:
2578: END bind_variable;
2579: