DBA Data[Home] [Help]

APPS.ENI_DBI_COR_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 997: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

993:
994: x_custom_sql := l_sql_stmt;
995:
996:
997: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
998: x_custom_output := bis_query_attributes_tbl();
999: x_custom_output.extend;
1000: l_custom_rec.attribute_name := ':STATUS_ID';
1001: l_custom_rec.attribute_value := REPLACE(l_status,'''');

Line 1002: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

998: x_custom_output := bis_query_attributes_tbl();
999: x_custom_output.extend;
1000: l_custom_rec.attribute_name := ':STATUS_ID';
1001: l_custom_rec.attribute_value := REPLACE(l_status,'''');
1002: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1003: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1004: x_custom_output(1) := l_custom_rec;
1005:
1006: x_custom_output.extend;

Line 1003: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

999: x_custom_output.extend;
1000: l_custom_rec.attribute_name := ':STATUS_ID';
1001: l_custom_rec.attribute_value := REPLACE(l_status,'''');
1002: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1003: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1004: x_custom_output(1) := l_custom_rec;
1005:
1006: x_custom_output.extend;
1007: l_custom_rec.attribute_name := ':PRIORITY_ID';

Line 1009: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1005:
1006: x_custom_output.extend;
1007: l_custom_rec.attribute_name := ':PRIORITY_ID';
1008: l_custom_rec.attribute_value := l_priority;
1009: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1010: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1011: x_custom_output(2) := l_custom_rec;
1012:
1013: x_custom_output.extend;

Line 1010: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1006: x_custom_output.extend;
1007: l_custom_rec.attribute_name := ':PRIORITY_ID';
1008: l_custom_rec.attribute_value := l_priority;
1009: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1010: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1011: x_custom_output(2) := l_custom_rec;
1012:
1013: x_custom_output.extend;
1014: l_custom_rec.attribute_name := ':TYPE_ID';

Line 1016: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1012:
1013: x_custom_output.extend;
1014: l_custom_rec.attribute_name := ':TYPE_ID';
1015: l_custom_rec.attribute_value := REPLACE(l_type,'''');
1016: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1017: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1018: x_custom_output(3) := l_custom_rec;
1019:
1020: x_custom_output.extend;

Line 1017: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1013: x_custom_output.extend;
1014: l_custom_rec.attribute_name := ':TYPE_ID';
1015: l_custom_rec.attribute_value := REPLACE(l_type,'''');
1016: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1017: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1018: x_custom_output(3) := l_custom_rec;
1019:
1020: x_custom_output.extend;
1021: l_custom_rec.attribute_name := ':REASON_ID';

Line 1023: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1019:
1020: x_custom_output.extend;
1021: l_custom_rec.attribute_name := ':REASON_ID';
1022: l_custom_rec.attribute_value := l_reason;
1023: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1024: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1025: x_custom_output(4) := l_custom_rec;
1026:
1027: x_custom_output.extend;

Line 1024: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1020: x_custom_output.extend;
1021: l_custom_rec.attribute_name := ':REASON_ID';
1022: l_custom_rec.attribute_value := l_reason;
1023: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1024: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1025: x_custom_output(4) := l_custom_rec;
1026:
1027: x_custom_output.extend;
1028: l_custom_rec.attribute_name := ':NVL_DATE';

Line 1030: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1026:
1027: x_custom_output.extend;
1028: l_custom_rec.attribute_name := ':NVL_DATE';
1029: l_custom_rec.attribute_value := '31/12/3000';
1030: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1031: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1032: x_custom_output(5) := l_custom_rec;
1033:
1034: x_custom_output.extend;

Line 1031: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

1027: x_custom_output.extend;
1028: l_custom_rec.attribute_name := ':NVL_DATE';
1029: l_custom_rec.attribute_value := '31/12/3000';
1030: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1031: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
1032: x_custom_output(5) := l_custom_rec;
1033:
1034: x_custom_output.extend;
1035: l_custom_rec.attribute_name := ':ITEM_ID';

Line 1037: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1033:
1034: x_custom_output.extend;
1035: l_custom_rec.attribute_name := ':ITEM_ID';
1036: l_custom_rec.attribute_value := l_item;
1037: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1038: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1039: x_custom_output(6) := l_custom_rec;
1040:
1041: --Bug 5083876 - Start Code

Line 1038: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1034: x_custom_output.extend;
1035: l_custom_rec.attribute_name := ':ITEM_ID';
1036: l_custom_rec.attribute_value := l_item;
1037: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1038: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1039: x_custom_output(6) := l_custom_rec;
1040:
1041: --Bug 5083876 - Start Code
1042: x_custom_output.extend;

Line 1045: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1041: --Bug 5083876 - Start Code
1042: x_custom_output.extend;
1043: l_custom_rec.attribute_name := ':ORGANIZATION_ID';
1044: l_custom_rec.attribute_value := REPLACE(l_org,'''');
1045: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1046: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1047: x_custom_output(7) := l_custom_rec;
1048:
1049: x_custom_output.extend;

Line 1046: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1042: x_custom_output.extend;
1043: l_custom_rec.attribute_name := ':ORGANIZATION_ID';
1044: l_custom_rec.attribute_value := REPLACE(l_org,'''');
1045: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1046: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1047: x_custom_output(7) := l_custom_rec;
1048:
1049: x_custom_output.extend;
1050: l_custom_rec.attribute_name := ':PERIODAND'; --Bug 5083652

Line 1052: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1048:
1049: x_custom_output.extend;
1050: l_custom_rec.attribute_name := ':PERIODAND'; --Bug 5083652
1051: l_custom_rec.attribute_value := REPLACE(l_period_bitand,'''');
1052: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1053: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1054: x_custom_output(8) := l_custom_rec;
1055: --Bug 5083876 - End Code
1056:

Line 1053: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1049: x_custom_output.extend;
1050: l_custom_rec.attribute_name := ':PERIODAND'; --Bug 5083652
1051: l_custom_rec.attribute_value := REPLACE(l_period_bitand,'''');
1052: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1053: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1054: x_custom_output(8) := l_custom_rec;
1055: --Bug 5083876 - End Code
1056:
1057: --Bug 5083652 -- Start Code

Line 1061: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1057: --Bug 5083652 -- Start Code
1058: x_custom_output.extend;
1059: l_custom_rec.attribute_name := ':PERIODTYPE';
1060: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
1061: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1062: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1063: x_custom_output(9) := l_custom_rec;
1064:
1065: x_custom_output.extend;

Line 1062: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1058: x_custom_output.extend;
1059: l_custom_rec.attribute_name := ':PERIODTYPE';
1060: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
1061: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1062: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1063: x_custom_output(9) := l_custom_rec;
1064:
1065: x_custom_output.extend;
1066: l_custom_rec.attribute_name := ':COMPARETYPE';

Line 1068: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1064:
1065: x_custom_output.extend;
1066: l_custom_rec.attribute_name := ':COMPARETYPE';
1067: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
1068: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1069: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1070: x_custom_output(10) := l_custom_rec;
1071:
1072: x_custom_output.extend;

Line 1069: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

1065: x_custom_output.extend;
1066: l_custom_rec.attribute_name := ':COMPARETYPE';
1067: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
1068: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1069: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
1070: x_custom_output(10) := l_custom_rec;
1071:
1072: x_custom_output.extend;
1073: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';

Line 1075: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

1071:
1072: x_custom_output.extend;
1073: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
1074: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
1075: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1076: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1077: x_custom_output(11) := l_custom_rec;
1078:
1079: --Bug 5083652 -- End Code

Line 1076: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

1072: x_custom_output.extend;
1073: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
1074: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
1075: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
1076: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
1077: x_custom_output(11) := l_custom_rec;
1078:
1079: --Bug 5083652 -- End Code
1080: