APPS.FII_GL_UTIL_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 1263: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

1259:
1260: BEGIN
1261:
1262: p_bind_output_table := BIS_QUERY_ATTRIBUTES_TBL();
1263: l_bind_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1264: p_sql_output := p_sqlstmt;
1265:
1266: fii_gl_util_pkg.get_parameters(p_page_parameter_tbl);
1267:

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

1267:
1268: IF (g_viewby_type IS NOT NULL) THEN
1269:
1270: p_bind_output_table.EXTEND;
1271: l_bind_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1272: l_bind_rec.attribute_value := g_viewby_type;
1273: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1274: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1275: END IF;

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

1269:
1270: p_bind_output_table.EXTEND;
1271: l_bind_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
1272: l_bind_rec.attribute_value := g_viewby_type;
1273: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
1274: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1275: END IF;
1276:
1277: -- RYLIU2, let's clean out any binds not really used

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

1277: -- RYLIU2, let's clean out any binds not really used
1278: p_bind_output_table.EXTEND;
1279: l_bind_rec.attribute_name := ':PERIOD_TYPE';
1280: l_bind_rec.attribute_value := to_char(g_period_type);
1281: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1282: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1283: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1284: p_bind_output_table.EXTEND;
1285: l_bind_rec.attribute_name := ':WHERE_PERIOD_TYPE';

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

1278: p_bind_output_table.EXTEND;
1279: l_bind_rec.attribute_name := ':PERIOD_TYPE';
1280: l_bind_rec.attribute_value := to_char(g_period_type);
1281: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1282: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1283: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1284: p_bind_output_table.EXTEND;
1285: l_bind_rec.attribute_name := ':WHERE_PERIOD_TYPE';
1286: l_bind_rec.attribute_value := to_char(g_where_period_type);

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

1283: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1284: p_bind_output_table.EXTEND;
1285: l_bind_rec.attribute_name := ':WHERE_PERIOD_TYPE';
1286: l_bind_rec.attribute_value := to_char(g_where_period_type);
1287: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1288: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1289: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1290: p_bind_output_table.EXTEND;
1291: l_bind_rec.attribute_name := ':ACT_WHERE_PERIOD_TYPE';

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

1284: p_bind_output_table.EXTEND;
1285: l_bind_rec.attribute_name := ':WHERE_PERIOD_TYPE';
1286: l_bind_rec.attribute_value := to_char(g_where_period_type);
1287: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1288: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1289: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1290: p_bind_output_table.EXTEND;
1291: l_bind_rec.attribute_name := ':ACT_WHERE_PERIOD_TYPE';
1292: l_bind_rec.attribute_value := to_char(g_act_where_period_type);

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

1289: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1290: p_bind_output_table.EXTEND;
1291: l_bind_rec.attribute_name := ':ACT_WHERE_PERIOD_TYPE';
1292: l_bind_rec.attribute_value := to_char(g_act_where_period_type);
1293: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1294: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1295: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1296: p_bind_output_table.EXTEND;
1297: l_bind_rec.attribute_name := ':ENT_PERIOD_TYPE';

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

1290: p_bind_output_table.EXTEND;
1291: l_bind_rec.attribute_name := ':ACT_WHERE_PERIOD_TYPE';
1292: l_bind_rec.attribute_value := to_char(g_act_where_period_type);
1293: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1294: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1295: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1296: p_bind_output_table.EXTEND;
1297: l_bind_rec.attribute_name := ':ENT_PERIOD_TYPE';
1298: l_bind_rec.attribute_value := to_char(g_ent_period_type);

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

1295: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1296: p_bind_output_table.EXTEND;
1297: l_bind_rec.attribute_name := ':ENT_PERIOD_TYPE';
1298: l_bind_rec.attribute_value := to_char(g_ent_period_type);
1299: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1300: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1301: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1302: p_bind_output_table.EXTEND;
1303: l_bind_rec.attribute_name := ':ACTUAL_PERIOD_TYPE';

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

1296: p_bind_output_table.EXTEND;
1297: l_bind_rec.attribute_name := ':ENT_PERIOD_TYPE';
1298: l_bind_rec.attribute_value := to_char(g_ent_period_type);
1299: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1300: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1301: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1302: p_bind_output_table.EXTEND;
1303: l_bind_rec.attribute_name := ':ACTUAL_PERIOD_TYPE';
1304: l_bind_rec.attribute_value := to_char(g_actual_period_type);

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

1301: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1302: p_bind_output_table.EXTEND;
1303: l_bind_rec.attribute_name := ':ACTUAL_PERIOD_TYPE';
1304: l_bind_rec.attribute_value := to_char(g_actual_period_type);
1305: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1306: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1307: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1308: p_bind_output_table.EXTEND;
1309: l_bind_rec.attribute_name := ':BUDGET_PERIOD_TYPE';

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

1302: p_bind_output_table.EXTEND;
1303: l_bind_rec.attribute_name := ':ACTUAL_PERIOD_TYPE';
1304: l_bind_rec.attribute_value := to_char(g_actual_period_type);
1305: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1306: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1307: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1308: p_bind_output_table.EXTEND;
1309: l_bind_rec.attribute_name := ':BUDGET_PERIOD_TYPE';
1310: l_bind_rec.attribute_value := to_char(g_budget_period_type);

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

1307: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1308: p_bind_output_table.EXTEND;
1309: l_bind_rec.attribute_name := ':BUDGET_PERIOD_TYPE';
1310: l_bind_rec.attribute_value := to_char(g_budget_period_type);
1311: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1312: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1313: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1314: p_bind_output_table.EXTEND;
1315: l_bind_rec.attribute_name := ':FORECAST_PERIOD_TYPE';

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

1308: p_bind_output_table.EXTEND;
1309: l_bind_rec.attribute_name := ':BUDGET_PERIOD_TYPE';
1310: l_bind_rec.attribute_value := to_char(g_budget_period_type);
1311: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1312: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1313: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1314: p_bind_output_table.EXTEND;
1315: l_bind_rec.attribute_name := ':FORECAST_PERIOD_TYPE';
1316: l_bind_rec.attribute_value := to_char(g_forecast_period_type);

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

1313: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1314: p_bind_output_table.EXTEND;
1315: l_bind_rec.attribute_name := ':FORECAST_PERIOD_TYPE';
1316: l_bind_rec.attribute_value := to_char(g_forecast_period_type);
1317: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1318: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1319: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1320: p_bind_output_table.EXTEND;
1321: l_bind_rec.attribute_name := ':GLOBAL_CURR_VIEW';

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

1314: p_bind_output_table.EXTEND;
1315: l_bind_rec.attribute_name := ':FORECAST_PERIOD_TYPE';
1316: l_bind_rec.attribute_value := to_char(g_forecast_period_type);
1317: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1318: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1319: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1320: p_bind_output_table.EXTEND;
1321: l_bind_rec.attribute_name := ':GLOBAL_CURR_VIEW';
1322: l_bind_rec.attribute_value := to_char(g_global_curr_view);

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

1319: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1320: p_bind_output_table.EXTEND;
1321: l_bind_rec.attribute_name := ':GLOBAL_CURR_VIEW';
1322: l_bind_rec.attribute_value := to_char(g_global_curr_view);
1323: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1324: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1325: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1326: p_bind_output_table.EXTEND;
1327: l_bind_rec.attribute_name := ':VIEW_BY';

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

1320: p_bind_output_table.EXTEND;
1321: l_bind_rec.attribute_name := ':GLOBAL_CURR_VIEW';
1322: l_bind_rec.attribute_value := to_char(g_global_curr_view);
1323: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1324: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1325: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1326: p_bind_output_table.EXTEND;
1327: l_bind_rec.attribute_name := ':VIEW_BY';
1328: l_bind_rec.attribute_value := to_char(g_view_by);

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

1325: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1326: p_bind_output_table.EXTEND;
1327: l_bind_rec.attribute_name := ':VIEW_BY';
1328: l_bind_rec.attribute_value := to_char(g_view_by);
1329: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1330: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1331: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1332: p_bind_output_table.EXTEND;
1333: l_bind_rec.attribute_name := ':LOB_ID';

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

1326: p_bind_output_table.EXTEND;
1327: l_bind_rec.attribute_name := ':VIEW_BY';
1328: l_bind_rec.attribute_value := to_char(g_view_by);
1329: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1330: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1331: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1332: p_bind_output_table.EXTEND;
1333: l_bind_rec.attribute_name := ':LOB_ID';
1334: l_bind_rec.attribute_value := to_char(g_lob_id);

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

1331: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1332: p_bind_output_table.EXTEND;
1333: l_bind_rec.attribute_name := ':LOB_ID';
1334: l_bind_rec.attribute_value := to_char(g_lob_id);
1335: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1336: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1337: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1338: IF (g_ccc_id = -999) THEN
1339: p_bind_output_table.EXTEND;

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

1332: p_bind_output_table.EXTEND;
1333: l_bind_rec.attribute_name := ':LOB_ID';
1334: l_bind_rec.attribute_value := to_char(g_lob_id);
1335: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1336: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1337: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1338: IF (g_ccc_id = -999) THEN
1339: p_bind_output_table.EXTEND;
1340: l_bind_rec.attribute_name := ':CCC_ID';

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

1338: IF (g_ccc_id = -999) THEN
1339: p_bind_output_table.EXTEND;
1340: l_bind_rec.attribute_name := ':CCC_ID';
1341: l_bind_rec.attribute_value := 'All';
1342: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1343: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1344: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1345: ELSE
1346: p_bind_output_table.EXTEND;

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

1339: p_bind_output_table.EXTEND;
1340: l_bind_rec.attribute_name := ':CCC_ID';
1341: l_bind_rec.attribute_value := 'All';
1342: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1343: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1344: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1345: ELSE
1346: p_bind_output_table.EXTEND;
1347: l_bind_rec.attribute_name := ':CCC_ID';

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

1345: ELSE
1346: p_bind_output_table.EXTEND;
1347: l_bind_rec.attribute_name := ':CCC_ID';
1348: l_bind_rec.attribute_value := to_char(g_ccc_id);
1349: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1350: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1351: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1352: END IF;
1353: p_bind_output_table.EXTEND;

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

1346: p_bind_output_table.EXTEND;
1347: l_bind_rec.attribute_name := ':CCC_ID';
1348: l_bind_rec.attribute_value := to_char(g_ccc_id);
1349: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1350: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1351: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1352: END IF;
1353: p_bind_output_table.EXTEND;
1354: l_bind_rec.attribute_name := ':PREVIOUS_ASOF_DATE';

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

1352: END IF;
1353: p_bind_output_table.EXTEND;
1354: l_bind_rec.attribute_name := ':PREVIOUS_ASOF_DATE';
1355: l_bind_rec.attribute_value := to_char(g_previous_asof_date, 'DD/MM/YYYY');
1356: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1357: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1358: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1359: p_bind_output_table.EXTEND;
1360: l_bind_rec.attribute_name := ':ASOF_DATE';

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

1353: p_bind_output_table.EXTEND;
1354: l_bind_rec.attribute_name := ':PREVIOUS_ASOF_DATE';
1355: l_bind_rec.attribute_value := to_char(g_previous_asof_date, 'DD/MM/YYYY');
1356: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1357: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1358: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1359: p_bind_output_table.EXTEND;
1360: l_bind_rec.attribute_name := ':ASOF_DATE';
1361: l_bind_rec.attribute_value := to_char(g_as_of_date, 'DD/MM/YYYY');

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

1358: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1359: p_bind_output_table.EXTEND;
1360: l_bind_rec.attribute_name := ':ASOF_DATE';
1361: l_bind_rec.attribute_value := to_char(g_as_of_date, 'DD/MM/YYYY');
1362: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1363: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1364: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1365: p_bind_output_table.EXTEND;
1366: l_bind_rec.attribute_name := ':MGR_ID';

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

1359: p_bind_output_table.EXTEND;
1360: l_bind_rec.attribute_name := ':ASOF_DATE';
1361: l_bind_rec.attribute_value := to_char(g_as_of_date, 'DD/MM/YYYY');
1362: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1363: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1364: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1365: p_bind_output_table.EXTEND;
1366: l_bind_rec.attribute_name := ':MGR_ID';
1367: l_bind_rec.attribute_value := to_char(g_mgr_id);

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

1364: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1365: p_bind_output_table.EXTEND;
1366: l_bind_rec.attribute_name := ':MGR_ID';
1367: l_bind_rec.attribute_value := to_char(g_mgr_id);
1368: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1369: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1370: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1371: p_bind_output_table.EXTEND;
1372: l_bind_rec.attribute_name := ':MGR_MGR_ID';

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

1365: p_bind_output_table.EXTEND;
1366: l_bind_rec.attribute_name := ':MGR_ID';
1367: l_bind_rec.attribute_value := to_char(g_mgr_id);
1368: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1369: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1370: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1371: p_bind_output_table.EXTEND;
1372: l_bind_rec.attribute_name := ':MGR_MGR_ID';
1373: l_bind_rec.attribute_value := to_char(g_mgr_mgr_id);

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

1370: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1371: p_bind_output_table.EXTEND;
1372: l_bind_rec.attribute_name := ':MGR_MGR_ID';
1373: l_bind_rec.attribute_value := to_char(g_mgr_mgr_id);
1374: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1375: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1376: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1377: p_bind_output_table.EXTEND;
1378: l_bind_rec.attribute_name := ':FIN_ID';

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

1371: p_bind_output_table.EXTEND;
1372: l_bind_rec.attribute_name := ':MGR_MGR_ID';
1373: l_bind_rec.attribute_value := to_char(g_mgr_mgr_id);
1374: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1375: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1376: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1377: p_bind_output_table.EXTEND;
1378: l_bind_rec.attribute_name := ':FIN_ID';
1379: l_bind_rec.attribute_value := to_char(g_fin_id);

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

1376: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1377: p_bind_output_table.EXTEND;
1378: l_bind_rec.attribute_name := ':FIN_ID';
1379: l_bind_rec.attribute_value := to_char(g_fin_id);
1380: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1381: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1382: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1383: p_bind_output_table.EXTEND;
1384: l_bind_rec.attribute_name := ':PARENT_FIN_ID';

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

1377: p_bind_output_table.EXTEND;
1378: l_bind_rec.attribute_name := ':FIN_ID';
1379: l_bind_rec.attribute_value := to_char(g_fin_id);
1380: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1381: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1382: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1383: p_bind_output_table.EXTEND;
1384: l_bind_rec.attribute_name := ':PARENT_FIN_ID';
1385: l_bind_rec.attribute_value := to_char(g_parent_fin_id);

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

1382: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1383: p_bind_output_table.EXTEND;
1384: l_bind_rec.attribute_name := ':PARENT_FIN_ID';
1385: l_bind_rec.attribute_value := to_char(g_parent_fin_id);
1386: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1387: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1388: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1389: p_bind_output_table.EXTEND;
1390: l_bind_rec.attribute_name := ':PY_SPER_END';

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

1383: p_bind_output_table.EXTEND;
1384: l_bind_rec.attribute_name := ':PARENT_FIN_ID';
1385: l_bind_rec.attribute_value := to_char(g_parent_fin_id);
1386: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1387: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1388: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1389: p_bind_output_table.EXTEND;
1390: l_bind_rec.attribute_name := ':PY_SPER_END';
1391: l_bind_rec.attribute_value := to_char(g_py_sper_end, 'DD/MM/YYYY');

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

1388: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1389: p_bind_output_table.EXTEND;
1390: l_bind_rec.attribute_name := ':PY_SPER_END';
1391: l_bind_rec.attribute_value := to_char(g_py_sper_end, 'DD/MM/YYYY');
1392: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1393: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1394: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1395: p_bind_output_table.EXTEND;
1396: l_bind_rec.attribute_name := ':CURR_EFFECTIVE_SEQ';

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

1389: p_bind_output_table.EXTEND;
1390: l_bind_rec.attribute_name := ':PY_SPER_END';
1391: l_bind_rec.attribute_value := to_char(g_py_sper_end, 'DD/MM/YYYY');
1392: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1393: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1394: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1395: p_bind_output_table.EXTEND;
1396: l_bind_rec.attribute_name := ':CURR_EFFECTIVE_SEQ';
1397: l_bind_rec.attribute_value := to_char(g_curr_per_sequence);

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

1394: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1395: p_bind_output_table.EXTEND;
1396: l_bind_rec.attribute_name := ':CURR_EFFECTIVE_SEQ';
1397: l_bind_rec.attribute_value := to_char(g_curr_per_sequence);
1398: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1399: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1400: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1401: p_bind_output_table.EXTEND;
1402: l_bind_rec.attribute_name := ':P_PERIOD_END';

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

1395: p_bind_output_table.EXTEND;
1396: l_bind_rec.attribute_name := ':CURR_EFFECTIVE_SEQ';
1397: l_bind_rec.attribute_value := to_char(g_curr_per_sequence);
1398: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1399: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1400: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1401: p_bind_output_table.EXTEND;
1402: l_bind_rec.attribute_name := ':P_PERIOD_END';
1403: l_bind_rec.attribute_value := to_char(g_p_period_end, 'DD/MM/YYYY');

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

1400: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1401: p_bind_output_table.EXTEND;
1402: l_bind_rec.attribute_name := ':P_PERIOD_END';
1403: l_bind_rec.attribute_value := to_char(g_p_period_end, 'DD/MM/YYYY');
1404: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1405: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1406: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1407: p_bind_output_table.EXTEND;
1408: l_bind_rec.attribute_name := ':P_P_PERIOD_END';

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

1401: p_bind_output_table.EXTEND;
1402: l_bind_rec.attribute_name := ':P_PERIOD_END';
1403: l_bind_rec.attribute_value := to_char(g_p_period_end, 'DD/MM/YYYY');
1404: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1405: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1406: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1407: p_bind_output_table.EXTEND;
1408: l_bind_rec.attribute_name := ':P_P_PERIOD_END';
1409: l_bind_rec.attribute_value := to_char(g_p_p_period_end, 'DD/MM/YYYY');

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

1406: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1407: p_bind_output_table.EXTEND;
1408: l_bind_rec.attribute_name := ':P_P_PERIOD_END';
1409: l_bind_rec.attribute_value := to_char(g_p_p_period_end, 'DD/MM/YYYY');
1410: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1411: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1412: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1413: p_bind_output_table.EXTEND;
1414: l_bind_rec.attribute_name := ':CURRENCY';

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

1407: p_bind_output_table.EXTEND;
1408: l_bind_rec.attribute_name := ':P_P_PERIOD_END';
1409: l_bind_rec.attribute_value := to_char(g_p_p_period_end, 'DD/MM/YYYY');
1410: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1411: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1412: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1413: p_bind_output_table.EXTEND;
1414: l_bind_rec.attribute_name := ':CURRENCY';
1415: l_bind_rec.attribute_value := to_char(g_currency);

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

1412: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1413: p_bind_output_table.EXTEND;
1414: l_bind_rec.attribute_name := ':CURRENCY';
1415: l_bind_rec.attribute_value := to_char(g_currency);
1416: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1417: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1418: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1419: p_bind_output_table.EXTEND;
1420: l_bind_rec.attribute_name := ':GID';

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

1413: p_bind_output_table.EXTEND;
1414: l_bind_rec.attribute_name := ':CURRENCY';
1415: l_bind_rec.attribute_value := to_char(g_currency);
1416: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1417: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1418: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1419: p_bind_output_table.EXTEND;
1420: l_bind_rec.attribute_name := ':GID';
1421: l_bind_rec.attribute_value := to_char(g_gid);

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

1418: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1419: p_bind_output_table.EXTEND;
1420: l_bind_rec.attribute_name := ':GID';
1421: l_bind_rec.attribute_value := to_char(g_gid);
1422: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1423: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1424: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1425: p_bind_output_table.EXTEND;
1426: l_bind_rec.attribute_name := ':MONTH_ID';

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

1419: p_bind_output_table.EXTEND;
1420: l_bind_rec.attribute_name := ':GID';
1421: l_bind_rec.attribute_value := to_char(g_gid);
1422: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1423: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1424: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1425: p_bind_output_table.EXTEND;
1426: l_bind_rec.attribute_name := ':MONTH_ID';
1427: l_bind_rec.attribute_value := to_char(g_month_id);

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

1424: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1425: p_bind_output_table.EXTEND;
1426: l_bind_rec.attribute_name := ':MONTH_ID';
1427: l_bind_rec.attribute_value := to_char(g_month_id);
1428: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1429: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1430: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1431: p_bind_output_table.EXTEND;
1432: l_bind_rec.attribute_name := ':CY_PERIOD_END';

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

1425: p_bind_output_table.EXTEND;
1426: l_bind_rec.attribute_name := ':MONTH_ID';
1427: l_bind_rec.attribute_value := to_char(g_month_id);
1428: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1429: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1430: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1431: p_bind_output_table.EXTEND;
1432: l_bind_rec.attribute_name := ':CY_PERIOD_END';
1433: l_bind_rec.attribute_value := to_char(g_cy_period_end, 'DD/MM/YYYY');

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

1430: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1431: p_bind_output_table.EXTEND;
1432: l_bind_rec.attribute_name := ':CY_PERIOD_END';
1433: l_bind_rec.attribute_value := to_char(g_cy_period_end, 'DD/MM/YYYY');
1434: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1435: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1436: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1437: p_bind_output_table.EXTEND;
1438: l_bind_rec.attribute_name := ':ENT_PYR_START';

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

1431: p_bind_output_table.EXTEND;
1432: l_bind_rec.attribute_name := ':CY_PERIOD_END';
1433: l_bind_rec.attribute_value := to_char(g_cy_period_end, 'DD/MM/YYYY');
1434: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1435: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1436: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1437: p_bind_output_table.EXTEND;
1438: l_bind_rec.attribute_name := ':ENT_PYR_START';
1439: l_bind_rec.attribute_value := to_char(g_ent_pyr_start, 'DD/MM/YYYY');

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

1436: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1437: p_bind_output_table.EXTEND;
1438: l_bind_rec.attribute_name := ':ENT_PYR_START';
1439: l_bind_rec.attribute_value := to_char(g_ent_pyr_start, 'DD/MM/YYYY');
1440: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1441: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1442: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1443: p_bind_output_table.EXTEND;
1444: l_bind_rec.attribute_name := ':ENT_PYR_END';

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

1437: p_bind_output_table.EXTEND;
1438: l_bind_rec.attribute_name := ':ENT_PYR_START';
1439: l_bind_rec.attribute_value := to_char(g_ent_pyr_start, 'DD/MM/YYYY');
1440: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1441: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1442: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1443: p_bind_output_table.EXTEND;
1444: l_bind_rec.attribute_name := ':ENT_PYR_END';
1445: l_bind_rec.attribute_value := to_char(g_ent_pyr_end, 'DD/MM/YYYY');

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

1442: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1443: p_bind_output_table.EXTEND;
1444: l_bind_rec.attribute_name := ':ENT_PYR_END';
1445: l_bind_rec.attribute_value := to_char(g_ent_pyr_end, 'DD/MM/YYYY');
1446: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1447: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1448: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1449: p_bind_output_table.EXTEND;
1450: l_bind_rec.attribute_name := ':ENT_CYR_START';

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

1443: p_bind_output_table.EXTEND;
1444: l_bind_rec.attribute_name := ':ENT_PYR_END';
1445: l_bind_rec.attribute_value := to_char(g_ent_pyr_end, 'DD/MM/YYYY');
1446: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1447: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1448: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1449: p_bind_output_table.EXTEND;
1450: l_bind_rec.attribute_name := ':ENT_CYR_START';
1451: l_bind_rec.attribute_value := to_char(g_ent_cyr_start, 'DD/MM/YYYY');

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

1448: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1449: p_bind_output_table.EXTEND;
1450: l_bind_rec.attribute_name := ':ENT_CYR_START';
1451: l_bind_rec.attribute_value := to_char(g_ent_cyr_start, 'DD/MM/YYYY');
1452: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1453: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1454: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1455: p_bind_output_table.EXTEND;
1456: l_bind_rec.attribute_name := ':PY_SAME_DAY';

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

1449: p_bind_output_table.EXTEND;
1450: l_bind_rec.attribute_name := ':ENT_CYR_START';
1451: l_bind_rec.attribute_value := to_char(g_ent_cyr_start, 'DD/MM/YYYY');
1452: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1453: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1454: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1455: p_bind_output_table.EXTEND;
1456: l_bind_rec.attribute_name := ':PY_SAME_DAY';
1457: l_bind_rec.attribute_value := to_char(g_py_sday, 'DD/MM/YYYY');

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

1454: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1455: p_bind_output_table.EXTEND;
1456: l_bind_rec.attribute_name := ':PY_SAME_DAY';
1457: l_bind_rec.attribute_value := to_char(g_py_sday, 'DD/MM/YYYY');
1458: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1459: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1460: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1461: p_bind_output_table.EXTEND;
1462: l_bind_rec.attribute_name := ':FIVE_YR_BACK';

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

1455: p_bind_output_table.EXTEND;
1456: l_bind_rec.attribute_name := ':PY_SAME_DAY';
1457: l_bind_rec.attribute_value := to_char(g_py_sday, 'DD/MM/YYYY');
1458: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1459: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1460: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1461: p_bind_output_table.EXTEND;
1462: l_bind_rec.attribute_name := ':FIVE_YR_BACK';
1463: l_bind_rec.attribute_value := to_char(g_five_yr_back, 'DD/MM/YYYY');

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

1460: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1461: p_bind_output_table.EXTEND;
1462: l_bind_rec.attribute_name := ':FIVE_YR_BACK';
1463: l_bind_rec.attribute_value := to_char(g_five_yr_back, 'DD/MM/YYYY');
1464: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1465: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1466: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1467: p_bind_output_table.EXTEND;
1468: l_bind_rec.attribute_name := ':RPT_BEGIN_DATE';

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

1461: p_bind_output_table.EXTEND;
1462: l_bind_rec.attribute_name := ':FIVE_YR_BACK';
1463: l_bind_rec.attribute_value := to_char(g_five_yr_back, 'DD/MM/YYYY');
1464: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1465: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1466: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1467: p_bind_output_table.EXTEND;
1468: l_bind_rec.attribute_name := ':RPT_BEGIN_DATE';
1469: l_bind_rec.attribute_value := to_char(g_rpt_begin_date, 'DD/MM/YYYY');

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

1466: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1467: p_bind_output_table.EXTEND;
1468: l_bind_rec.attribute_name := ':RPT_BEGIN_DATE';
1469: l_bind_rec.attribute_value := to_char(g_rpt_begin_date, 'DD/MM/YYYY');
1470: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1471: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1472: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1473: p_bind_output_table.EXTEND;
1474: l_bind_rec.attribute_name := ':BEGIN_DATE';

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

1467: p_bind_output_table.EXTEND;
1468: l_bind_rec.attribute_name := ':RPT_BEGIN_DATE';
1469: l_bind_rec.attribute_value := to_char(g_rpt_begin_date, 'DD/MM/YYYY');
1470: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1471: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1472: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1473: p_bind_output_table.EXTEND;
1474: l_bind_rec.attribute_name := ':BEGIN_DATE';
1475: l_bind_rec.attribute_value := to_char(g_begin_date, 'DD/MM/YYYY');

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

1472: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1473: p_bind_output_table.EXTEND;
1474: l_bind_rec.attribute_name := ':BEGIN_DATE';
1475: l_bind_rec.attribute_value := to_char(g_begin_date, 'DD/MM/YYYY');
1476: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1477: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1478: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1479: p_bind_output_table.EXTEND;
1480: l_bind_rec.attribute_name := ':ENT_CYR_END';

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

1473: p_bind_output_table.EXTEND;
1474: l_bind_rec.attribute_name := ':BEGIN_DATE';
1475: l_bind_rec.attribute_value := to_char(g_begin_date, 'DD/MM/YYYY');
1476: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1477: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1478: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1479: p_bind_output_table.EXTEND;
1480: l_bind_rec.attribute_name := ':ENT_CYR_END';
1481: l_bind_rec.attribute_value := to_char(g_ent_cyr_end, 'DD/MM/YYYY');

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

1478: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1479: p_bind_output_table.EXTEND;
1480: l_bind_rec.attribute_name := ':ENT_CYR_END';
1481: l_bind_rec.attribute_value := to_char(g_ent_cyr_end, 'DD/MM/YYYY');
1482: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1483: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1484: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1485: p_bind_output_table.EXTEND;
1486: l_bind_rec.attribute_name := ':P_CURR_START';

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

1479: p_bind_output_table.EXTEND;
1480: l_bind_rec.attribute_name := ':ENT_CYR_END';
1481: l_bind_rec.attribute_value := to_char(g_ent_cyr_end, 'DD/MM/YYYY');
1482: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1483: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1484: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1485: p_bind_output_table.EXTEND;
1486: l_bind_rec.attribute_name := ':P_CURR_START';
1487: l_bind_rec.attribute_value := to_char(g_curr_start, 'DD-MM-YYYY');

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

1484: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1485: p_bind_output_table.EXTEND;
1486: l_bind_rec.attribute_name := ':P_CURR_START';
1487: l_bind_rec.attribute_value := to_char(g_curr_start, 'DD-MM-YYYY');
1488: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1489: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1490: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1491: p_bind_output_table.EXTEND;
1492: l_bind_rec.attribute_name := ':P_CURR_END';

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

1485: p_bind_output_table.EXTEND;
1486: l_bind_rec.attribute_name := ':P_CURR_START';
1487: l_bind_rec.attribute_value := to_char(g_curr_start, 'DD-MM-YYYY');
1488: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1489: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1490: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1491: p_bind_output_table.EXTEND;
1492: l_bind_rec.attribute_name := ':P_CURR_END';
1493: l_bind_rec.attribute_value := to_char(g_curr_end, 'DD-MM-YYYY');

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

1490: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1491: p_bind_output_table.EXTEND;
1492: l_bind_rec.attribute_name := ':P_CURR_END';
1493: l_bind_rec.attribute_value := to_char(g_curr_end, 'DD-MM-YYYY');
1494: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1495: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1496: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1497: p_bind_output_table.EXTEND;
1498: l_bind_rec.attribute_name := ':P_PRIOR_START';

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

1491: p_bind_output_table.EXTEND;
1492: l_bind_rec.attribute_name := ':P_CURR_END';
1493: l_bind_rec.attribute_value := to_char(g_curr_end, 'DD-MM-YYYY');
1494: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1495: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1496: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1497: p_bind_output_table.EXTEND;
1498: l_bind_rec.attribute_name := ':P_PRIOR_START';
1499: l_bind_rec.attribute_value := to_char(g_prior_start, 'DD-MM-YYYY');

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

1496: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1497: p_bind_output_table.EXTEND;
1498: l_bind_rec.attribute_name := ':P_PRIOR_START';
1499: l_bind_rec.attribute_value := to_char(g_prior_start, 'DD-MM-YYYY');
1500: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1501: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1502: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1503: p_bind_output_table.EXTEND;
1504: l_bind_rec.attribute_name := ':P_PRIOR_END';

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

1497: p_bind_output_table.EXTEND;
1498: l_bind_rec.attribute_name := ':P_PRIOR_START';
1499: l_bind_rec.attribute_value := to_char(g_prior_start, 'DD-MM-YYYY');
1500: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1501: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1502: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1503: p_bind_output_table.EXTEND;
1504: l_bind_rec.attribute_name := ':P_PRIOR_END';
1505: l_bind_rec.attribute_value := to_char(g_prior_end, 'DD-MM-YYYY');

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

1502: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1503: p_bind_output_table.EXTEND;
1504: l_bind_rec.attribute_name := ':P_PRIOR_END';
1505: l_bind_rec.attribute_value := to_char(g_prior_end, 'DD-MM-YYYY');
1506: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1507: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1508: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1509: p_bind_output_table.EXTEND;
1510: l_bind_rec.attribute_name := ':P_TEMP';

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

1503: p_bind_output_table.EXTEND;
1504: l_bind_rec.attribute_name := ':P_PRIOR_END';
1505: l_bind_rec.attribute_value := to_char(g_prior_end, 'DD-MM-YYYY');
1506: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1507: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1508: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1509: p_bind_output_table.EXTEND;
1510: l_bind_rec.attribute_name := ':P_TEMP';
1511: l_bind_rec.attribute_value := to_char(g_temp, 'DD-MM-YYYY');

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

1508: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1509: p_bind_output_table.EXTEND;
1510: l_bind_rec.attribute_name := ':P_TEMP';
1511: l_bind_rec.attribute_value := to_char(g_temp, 'DD-MM-YYYY');
1512: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1513: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1514: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1515: p_bind_output_table.EXTEND;
1516: l_bind_rec.attribute_name := ':REV_MSG';

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

1509: p_bind_output_table.EXTEND;
1510: l_bind_rec.attribute_name := ':P_TEMP';
1511: l_bind_rec.attribute_value := to_char(g_temp, 'DD-MM-YYYY');
1512: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1513: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1514: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1515: p_bind_output_table.EXTEND;
1516: l_bind_rec.attribute_name := ':REV_MSG';
1517: l_bind_rec.attribute_value := to_char(g_rev_msg);

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

1514: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1515: p_bind_output_table.EXTEND;
1516: l_bind_rec.attribute_name := ':REV_MSG';
1517: l_bind_rec.attribute_value := to_char(g_rev_msg);
1518: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1519: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1520: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1521: p_bind_output_table.EXTEND;
1522: l_bind_rec.attribute_name := ':EXP_MSG';

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

1515: p_bind_output_table.EXTEND;
1516: l_bind_rec.attribute_name := ':REV_MSG';
1517: l_bind_rec.attribute_value := to_char(g_rev_msg);
1518: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1519: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1520: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1521: p_bind_output_table.EXTEND;
1522: l_bind_rec.attribute_name := ':EXP_MSG';
1523: l_bind_rec.attribute_value := to_char(g_exp_msg);

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

1520: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1521: p_bind_output_table.EXTEND;
1522: l_bind_rec.attribute_name := ':EXP_MSG';
1523: l_bind_rec.attribute_value := to_char(g_exp_msg);
1524: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1525: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1526: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1527: p_bind_output_table.EXTEND;
1528: l_bind_rec.attribute_name := ':COG_MSG';

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

1521: p_bind_output_table.EXTEND;
1522: l_bind_rec.attribute_name := ':EXP_MSG';
1523: l_bind_rec.attribute_value := to_char(g_exp_msg);
1524: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1525: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1526: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1527: p_bind_output_table.EXTEND;
1528: l_bind_rec.attribute_name := ':COG_MSG';
1529: l_bind_rec.attribute_value := to_char(g_cog_msg);

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

1526: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1527: p_bind_output_table.EXTEND;
1528: l_bind_rec.attribute_name := ':COG_MSG';
1529: l_bind_rec.attribute_value := to_char(g_cog_msg);
1530: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1531: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1532: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1533: p_bind_output_table.EXTEND;
1534: l_bind_rec.attribute_name := ':DIR_MSG';

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

1527: p_bind_output_table.EXTEND;
1528: l_bind_rec.attribute_name := ':COG_MSG';
1529: l_bind_rec.attribute_value := to_char(g_cog_msg);
1530: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1531: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1532: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1533: p_bind_output_table.EXTEND;
1534: l_bind_rec.attribute_name := ':DIR_MSG';
1535: l_bind_rec.attribute_value := to_char(g_dir_msg);

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

1532: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1533: p_bind_output_table.EXTEND;
1534: l_bind_rec.attribute_name := ':DIR_MSG';
1535: l_bind_rec.attribute_value := to_char(g_dir_msg);
1536: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1537: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1538: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1539: p_bind_output_table.EXTEND;
1540: l_bind_rec.attribute_name := ':CCC_OWNER';

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

1533: p_bind_output_table.EXTEND;
1534: l_bind_rec.attribute_name := ':DIR_MSG';
1535: l_bind_rec.attribute_value := to_char(g_dir_msg);
1536: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1537: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1538: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1539: p_bind_output_table.EXTEND;
1540: l_bind_rec.attribute_name := ':CCC_OWNER';
1541: l_bind_rec.attribute_value := to_char(g_cc_owner);

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

1538: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1539: p_bind_output_table.EXTEND;
1540: l_bind_rec.attribute_name := ':CCC_OWNER';
1541: l_bind_rec.attribute_value := to_char(g_cc_owner);
1542: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1543: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1544: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1545: p_bind_output_table.EXTEND;
1546:

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

1539: p_bind_output_table.EXTEND;
1540: l_bind_rec.attribute_name := ':CCC_OWNER';
1541: l_bind_rec.attribute_value := to_char(g_cc_owner);
1542: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1543: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1544: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1545: p_bind_output_table.EXTEND;
1546:
1547: l_bind_rec.attribute_name := ':PPY_SAME_DAY';

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

1545: p_bind_output_table.EXTEND;
1546:
1547: l_bind_rec.attribute_name := ':PPY_SAME_DAY';
1548: l_bind_rec.attribute_value := to_char(g_ppy_sday, 'DD/MM/YYYY');
1549: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1550: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1551: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1552: p_bind_output_table.EXTEND;
1553:

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

1546:
1547: l_bind_rec.attribute_name := ':PPY_SAME_DAY';
1548: l_bind_rec.attribute_value := to_char(g_ppy_sday, 'DD/MM/YYYY');
1549: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1550: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1551: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1552: p_bind_output_table.EXTEND;
1553:
1554: l_bind_rec.attribute_name := ':P_AS_OF';

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

1552: p_bind_output_table.EXTEND;
1553:
1554: l_bind_rec.attribute_name := ':P_AS_OF';
1555: l_bind_rec.attribute_value := to_char(g_new_date, 'DD/MM/YYYY');
1556: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1557: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1558: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1559: p_bind_output_table.EXTEND;
1560:

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

1553:
1554: l_bind_rec.attribute_name := ':P_AS_OF';
1555: l_bind_rec.attribute_value := to_char(g_new_date, 'DD/MM/YYYY');
1556: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1557: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1558: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1559: p_bind_output_table.EXTEND;
1560:
1561: l_bind_rec.attribute_name := ':P_PREV_AS_OF';

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

1559: p_bind_output_table.EXTEND;
1560:
1561: l_bind_rec.attribute_name := ':P_PREV_AS_OF';
1562: l_bind_rec.attribute_value := to_char(g_new_date2, 'DD/MM/YYYY');
1563: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1564: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1565: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1566: p_bind_output_table.EXTEND;
1567:

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

1560:
1561: l_bind_rec.attribute_name := ':P_PREV_AS_OF';
1562: l_bind_rec.attribute_value := to_char(g_new_date2, 'DD/MM/YYYY');
1563: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1564: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1565: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1566: p_bind_output_table.EXTEND;
1567:
1568: l_bind_rec.attribute_name := ':P_DET_START';

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

1566: p_bind_output_table.EXTEND;
1567:
1568: l_bind_rec.attribute_name := ':P_DET_START';
1569: l_bind_rec.attribute_value := to_char(g_detail_start, 'DD/MM/YYYY');
1570: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1571: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1572: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1573: p_bind_output_table.EXTEND;
1574:

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

1567:
1568: l_bind_rec.attribute_name := ':P_DET_START';
1569: l_bind_rec.attribute_value := to_char(g_detail_start, 'DD/MM/YYYY');
1570: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1571: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1572: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1573: p_bind_output_table.EXTEND;
1574:
1575: l_bind_rec.attribute_name := ':P_DET_END';

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

1573: p_bind_output_table.EXTEND;
1574:
1575: l_bind_rec.attribute_name := ':P_DET_END';
1576: l_bind_rec.attribute_value := to_char(g_detail_end, 'DD/MM/YYYY');
1577: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1578: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1579: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1580: p_bind_output_table.EXTEND;
1581:

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

1574:
1575: l_bind_rec.attribute_name := ':P_DET_END';
1576: l_bind_rec.attribute_value := to_char(g_detail_end, 'DD/MM/YYYY');
1577: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1578: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1579: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1580: p_bind_output_table.EXTEND;
1581:
1582: l_bind_rec.attribute_name := ':P_TOP_SPEND_START';

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

1580: p_bind_output_table.EXTEND;
1581:
1582: l_bind_rec.attribute_name := ':P_TOP_SPEND_START';
1583: l_bind_rec.attribute_value := to_char(g_top_spend_start, 'DD/MM/YYYY');
1584: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1585: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1586: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1587: p_bind_output_table.EXTEND;
1588:

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

1581:
1582: l_bind_rec.attribute_name := ':P_TOP_SPEND_START';
1583: l_bind_rec.attribute_value := to_char(g_top_spend_start, 'DD/MM/YYYY');
1584: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1585: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1586: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1587: p_bind_output_table.EXTEND;
1588:
1589: l_bind_rec.attribute_name := ':P_TOP_SPEND_END';

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

1587: p_bind_output_table.EXTEND;
1588:
1589: l_bind_rec.attribute_name := ':P_TOP_SPEND_END';
1590: l_bind_rec.attribute_value := to_char(g_top_spend_end, 'DD/MM/YYYY');
1591: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1592: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1593: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1594: p_bind_output_table.EXTEND;
1595:

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

1588:
1589: l_bind_rec.attribute_name := ':P_TOP_SPEND_END';
1590: l_bind_rec.attribute_value := to_char(g_top_spend_end, 'DD/MM/YYYY');
1591: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1592: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1593: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1594: p_bind_output_table.EXTEND;
1595:
1596: l_bind_rec.attribute_name := ':P_EXP_ASOF';

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

1594: p_bind_output_table.EXTEND;
1595:
1596: l_bind_rec.attribute_name := ':P_EXP_ASOF';
1597: l_bind_rec.attribute_value := to_char(g_exp_asof_date, 'DD/MM/YYYY');
1598: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1599: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1600: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1601: p_bind_output_table.EXTEND;
1602:

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

1595:
1596: l_bind_rec.attribute_name := ':P_EXP_ASOF';
1597: l_bind_rec.attribute_value := to_char(g_exp_asof_date, 'DD/MM/YYYY');
1598: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1599: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1600: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1601: p_bind_output_table.EXTEND;
1602:
1603: l_bind_rec.attribute_name := ':P_EXP_START';

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

1601: p_bind_output_table.EXTEND;
1602:
1603: l_bind_rec.attribute_name := ':P_EXP_START';
1604: l_bind_rec.attribute_value := to_char(g_exp_start, 'DD/MM/YYYY');
1605: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1606: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1607: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1608: p_bind_output_table.EXTEND;
1609:

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

1602:
1603: l_bind_rec.attribute_name := ':P_EXP_START';
1604: l_bind_rec.attribute_value := to_char(g_exp_start, 'DD/MM/YYYY');
1605: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1606: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1607: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1608: p_bind_output_table.EXTEND;
1609:
1610: l_bind_rec.attribute_name := ':P_EXP_BEGIN';

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

1608: p_bind_output_table.EXTEND;
1609:
1610: l_bind_rec.attribute_name := ':P_EXP_BEGIN';
1611: l_bind_rec.attribute_value := to_char(g_exp_begin_date, 'DD/MM/YYYY');
1612: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1613: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1614: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1615: p_bind_output_table.EXTEND;
1616:

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

1609:
1610: l_bind_rec.attribute_name := ':P_EXP_BEGIN';
1611: l_bind_rec.attribute_value := to_char(g_exp_begin_date, 'DD/MM/YYYY');
1612: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1613: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1614: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1615: p_bind_output_table.EXTEND;
1616:
1617: l_bind_rec.attribute_name := ':P_SD_LYR';

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

1615: p_bind_output_table.EXTEND;
1616:
1617: l_bind_rec.attribute_name := ':P_SD_LYR';
1618: l_bind_rec.attribute_value := to_char(g_sd_lyr, 'DD/MM/YYYY');
1619: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1620: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1621: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1622: p_bind_output_table.EXTEND;
1623:

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

1616:
1617: l_bind_rec.attribute_name := ':P_SD_LYR';
1618: l_bind_rec.attribute_value := to_char(g_sd_lyr, 'DD/MM/YYYY');
1619: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1620: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1621: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1622: p_bind_output_table.EXTEND;
1623:
1624: --added by vkazhipu for bug fix 5002238

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

1624: --added by vkazhipu for bug fix 5002238
1625:
1626: l_bind_rec.attribute_name := ':L_ID';
1627: l_bind_rec.attribute_value := to_char(g_l_id);
1628: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1629: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1630: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1631: p_bind_output_table.EXTEND;
1632:

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

1625:
1626: l_bind_rec.attribute_name := ':L_ID';
1627: l_bind_rec.attribute_value := to_char(g_l_id);
1628: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1629: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1630: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1631: p_bind_output_table.EXTEND;
1632:
1633: l_bind_rec.attribute_name := ':DIM_FLAG';

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

1631: p_bind_output_table.EXTEND;
1632:
1633: l_bind_rec.attribute_name := ':DIM_FLAG';
1634: l_bind_rec.attribute_value := to_char(g_dim_flag);
1635: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1636: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1637: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1638:
1639: p_bind_output_table.EXTEND;

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

1632:
1633: l_bind_rec.attribute_name := ':DIM_FLAG';
1634: l_bind_rec.attribute_value := to_char(g_dim_flag);
1635: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1636: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1637: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1638:
1639: p_bind_output_table.EXTEND;
1640: l_bind_rec.attribute_name := ':FIN_TYPE';

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

1638:
1639: p_bind_output_table.EXTEND;
1640: l_bind_rec.attribute_name := ':FIN_TYPE';
1641: l_bind_rec.attribute_value := to_char(g_fin_type);
1642: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1643: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1644: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1645:
1646: p_bind_output_table.EXTEND;

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

1639: p_bind_output_table.EXTEND;
1640: l_bind_rec.attribute_name := ':FIN_TYPE';
1641: l_bind_rec.attribute_value := to_char(g_fin_type);
1642: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1643: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1644: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1645:
1646: p_bind_output_table.EXTEND;
1647: l_bind_rec.attribute_name := ':BITMASK';

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

1645:
1646: p_bind_output_table.EXTEND;
1647: l_bind_rec.attribute_name := ':BITMASK';
1648: l_bind_rec.attribute_value := to_char(g_bitmask);
1649: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1650: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1651: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1652:
1653: --added by hpoddar for bug fix 4969910

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

1646: p_bind_output_table.EXTEND;
1647: l_bind_rec.attribute_name := ':BITMASK';
1648: l_bind_rec.attribute_value := to_char(g_bitmask);
1649: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1650: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1651: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1652:
1653: --added by hpoddar for bug fix 4969910
1654:

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

1654:
1655: p_bind_output_table.EXTEND;
1656: l_bind_rec.attribute_name := ':START_ID';
1657: l_bind_rec.attribute_value := to_char(g_start_id);
1658: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1659: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1660: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1661:
1662: p_bind_output_table.EXTEND;

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

1655: p_bind_output_table.EXTEND;
1656: l_bind_rec.attribute_name := ':START_ID';
1657: l_bind_rec.attribute_value := to_char(g_start_id);
1658: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1659: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1660: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1661:
1662: p_bind_output_table.EXTEND;
1663: l_bind_rec.attribute_name := ':END_ID';

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

1661:
1662: p_bind_output_table.EXTEND;
1663: l_bind_rec.attribute_name := ':END_ID';
1664: l_bind_rec.attribute_value := to_char(g_end_id);
1665: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1666: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1667: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1668:
1669: p_bind_output_table.EXTEND;

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

1662: p_bind_output_table.EXTEND;
1663: l_bind_rec.attribute_name := ':END_ID';
1664: l_bind_rec.attribute_value := to_char(g_end_id);
1665: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1666: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1667: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1668:
1669: p_bind_output_table.EXTEND;
1670: l_bind_rec.attribute_name := ':SLICE_TYPE_FLAG';

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

1668:
1669: p_bind_output_table.EXTEND;
1670: l_bind_rec.attribute_name := ':SLICE_TYPE_FLAG';
1671: l_bind_rec.attribute_value := to_char(g_slice_type_flag);
1672: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1673: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1674: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1675:
1676: p_bind_output_table.EXTEND;

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

1669: p_bind_output_table.EXTEND;
1670: l_bind_rec.attribute_name := ':SLICE_TYPE_FLAG';
1671: l_bind_rec.attribute_value := to_char(g_slice_type_flag);
1672: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1673: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1674: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1675:
1676: p_bind_output_table.EXTEND;
1677: l_bind_rec.attribute_name := ':PREV_MGR_ID';

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

1675:
1676: p_bind_output_table.EXTEND;
1677: l_bind_rec.attribute_name := ':PREV_MGR_ID';
1678: l_bind_rec.attribute_value := to_char(g_prev_mgr_id);
1679: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1680: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1681: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1682:
1683: p_bind_output_table.EXTEND;

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

1676: p_bind_output_table.EXTEND;
1677: l_bind_rec.attribute_name := ':PREV_MGR_ID';
1678: l_bind_rec.attribute_value := to_char(g_prev_mgr_id);
1679: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1680: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1681: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1682:
1683: p_bind_output_table.EXTEND;
1684: l_bind_rec.attribute_name := ':EMP_ID';

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

1682:
1683: p_bind_output_table.EXTEND;
1684: l_bind_rec.attribute_name := ':EMP_ID';
1685: l_bind_rec.attribute_value := to_char(g_emp_id);
1686: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1687: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1688: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1689:
1690: --added by hpoddar for bug fix 5002661

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

1683: p_bind_output_table.EXTEND;
1684: l_bind_rec.attribute_name := ':EMP_ID';
1685: l_bind_rec.attribute_value := to_char(g_emp_id);
1686: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1687: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1688: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1689:
1690: --added by hpoddar for bug fix 5002661
1691:

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

1691:
1692: p_bind_output_table.EXTEND;
1693: l_bind_rec.attribute_name := ':TOTAL_HC';
1694: l_bind_rec.attribute_value := to_char(g_total_hc);
1695: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1696: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1697: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1698:
1699: p_bind_output_table.EXTEND;

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

1692: p_bind_output_table.EXTEND;
1693: l_bind_rec.attribute_name := ':TOTAL_HC';
1694: l_bind_rec.attribute_value := to_char(g_total_hc);
1695: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1696: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1697: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1698:
1699: p_bind_output_table.EXTEND;
1700: l_bind_rec.attribute_name := ':CURR_START_PERIOD_ID';

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

1698:
1699: p_bind_output_table.EXTEND;
1700: l_bind_rec.attribute_name := ':CURR_START_PERIOD_ID';
1701: l_bind_rec.attribute_value := to_char(g_curr_start_period_id);
1702: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1703: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1704: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1705:
1706: p_bind_output_table.EXTEND;

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

1699: p_bind_output_table.EXTEND;
1700: l_bind_rec.attribute_name := ':CURR_START_PERIOD_ID';
1701: l_bind_rec.attribute_value := to_char(g_curr_start_period_id);
1702: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1703: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1704: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1705:
1706: p_bind_output_table.EXTEND;
1707: l_bind_rec.attribute_name := ':CURR_END_PERIOD_ID';

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

1705:
1706: p_bind_output_table.EXTEND;
1707: l_bind_rec.attribute_name := ':CURR_END_PERIOD_ID';
1708: l_bind_rec.attribute_value := to_char(g_curr_end_period_id);
1709: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1710: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1711: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1712:
1713: --added by hpoddar for bug fix 5002564

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

1706: p_bind_output_table.EXTEND;
1707: l_bind_rec.attribute_name := ':CURR_END_PERIOD_ID';
1708: l_bind_rec.attribute_value := to_char(g_curr_end_period_id);
1709: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1710: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1711: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1712:
1713: --added by hpoddar for bug fix 5002564
1714:

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

1714:
1715: p_bind_output_table.EXTEND;
1716: l_bind_rec.attribute_name := ':CURR_START_DAY_ID';
1717: l_bind_rec.attribute_value := to_char(g_curr_start_day_id);
1718: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1719: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1720: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1721:
1722: p_bind_output_table.EXTEND;

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

1715: p_bind_output_table.EXTEND;
1716: l_bind_rec.attribute_name := ':CURR_START_DAY_ID';
1717: l_bind_rec.attribute_value := to_char(g_curr_start_day_id);
1718: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1719: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1720: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1721:
1722: p_bind_output_table.EXTEND;
1723: l_bind_rec.attribute_name := ':CURR_END_DAY_ID';

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

1721:
1722: p_bind_output_table.EXTEND;
1723: l_bind_rec.attribute_name := ':CURR_END_DAY_ID';
1724: l_bind_rec.attribute_value := to_char(g_curr_end_day_id);
1725: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1726: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1727: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1728:
1729: p_bind_output_table.EXTEND;

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

1722: p_bind_output_table.EXTEND;
1723: l_bind_rec.attribute_name := ':CURR_END_DAY_ID';
1724: l_bind_rec.attribute_value := to_char(g_curr_end_day_id);
1725: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1726: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1727: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1728:
1729: p_bind_output_table.EXTEND;
1730: l_bind_rec.attribute_name := ':PRIOR_START_DAY_ID';

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

1728:
1729: p_bind_output_table.EXTEND;
1730: l_bind_rec.attribute_name := ':PRIOR_START_DAY_ID';
1731: l_bind_rec.attribute_value := to_char(g_prior_start_day_id);
1732: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1733: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1734: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1735:
1736: p_bind_output_table.EXTEND;

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

1729: p_bind_output_table.EXTEND;
1730: l_bind_rec.attribute_name := ':PRIOR_START_DAY_ID';
1731: l_bind_rec.attribute_value := to_char(g_prior_start_day_id);
1732: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1733: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1734: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1735:
1736: p_bind_output_table.EXTEND;
1737: l_bind_rec.attribute_name := ':PRIOR_END_DAY_ID';

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

1735:
1736: p_bind_output_table.EXTEND;
1737: l_bind_rec.attribute_name := ':PRIOR_END_DAY_ID';
1738: l_bind_rec.attribute_value := to_char(g_prior_end_day_id);
1739: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1740: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1741: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1742:
1743: END bind_variable;

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

1736: p_bind_output_table.EXTEND;
1737: l_bind_rec.attribute_name := ':PRIOR_END_DAY_ID';
1738: l_bind_rec.attribute_value := to_char(g_prior_end_day_id);
1739: l_bind_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1740: l_bind_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
1741: p_bind_output_table(p_bind_output_table.COUNT) := l_bind_rec;
1742:
1743: END bind_variable;
1744: