APPS.ISC_DBI_SHIP_LATE_TP_D_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 90: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

86: l_cust_where :='
87: AND f.customer_id in (&CUSTOMER+FII_CUSTOMERS)';
88: END IF;
89:
90: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
91: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
92:
93: l_stmt := 'SELECT ISC_ATTRIBUTE_2,
94: ISC_MEASURE_1,

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

124: x_custom_sql := l_stmt;
125:
126: l_custom_rec.attribute_name := ':ISC_LATE_PROMISE_FLAG';
127: l_custom_rec.attribute_value := to_char(l_late_promise_flag);
128: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
129: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
130: x_custom_output.EXTEND;
131: x_custom_output(1) := l_custom_rec;
132:

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

125:
126: l_custom_rec.attribute_name := ':ISC_LATE_PROMISE_FLAG';
127: l_custom_rec.attribute_value := to_char(l_late_promise_flag);
128: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
129: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
130: x_custom_output.EXTEND;
131: x_custom_output(1) := l_custom_rec;
132:
133: l_custom_rec.attribute_name := ':ISC_LANG';

Line 135: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

131: x_custom_output(1) := l_custom_rec;
132:
133: l_custom_rec.attribute_name := ':ISC_LANG';
134: l_custom_rec.attribute_value := l_lang;
135: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
136: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
137: x_custom_output.EXTEND;
138: x_custom_output(2) := l_custom_rec;
139:

Line 136: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

132:
133: l_custom_rec.attribute_name := ':ISC_LANG';
134: l_custom_rec.attribute_value := l_lang;
135: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
136: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
137: x_custom_output.EXTEND;
138: x_custom_output(2) := l_custom_rec;
139:
140: END get_sql;