DBA Data[Home] [Help]

APPS.QP_FORMULA_PRICE_CALC_PVT dependencies on QP_NUMBER

Line 564: qp_number.canonical_mask :=

560: END IF;
561:
562: END IF;
563: --Change flexible mask to mask below for formula pattern use (Bug2195879)
564: qp_number.canonical_mask :=
565: '00999999999999999999999.99999999999999999999999999999999999999';
566: --Begin more POSCO changes.
567: FOR l_rec IN formula_lines_cur(p_price_formula_id)
568: LOOP

Line 734: qp_number.canonical_to_number(l_pra_rec.value_from);

730: IF l_debug = FND_API.G_TRUE THEN
731: QP_PREQ_GRP.engine_debug('l_pra_rec.value_from = '||l_pra_rec.value_from);
732: END IF;
733: l_formula_line_tbl(l_rec.step_number).component_value :=
734: qp_number.canonical_to_number(l_pra_rec.value_from);
735:
736: l_Operand_Tbl(l_rec.step_number) := l_formula_line_tbl(l_rec.step_number).component_value;
737:
738: IF l_debug = FND_API.G_TRUE THEN

Line 870: qp_number.canonical_mask :=

866: END IF;
867: -- smbalara bug 7188211
868: END LOOP; --Loop over formula_lines_cur
869: -- Change mask back to flexible mask
870: qp_number.canonical_mask :=
871: 'FM999999999999999999999.9999999999999999999999999999999999999999';
872:
873: -- Now Process all Factor Lists in the formula
874:

Line 1110: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

1106: x_return_status := FND_API.G_RET_STS_ERROR;
1107: fnd_message.set_name('QP','QP_FORMULA_NOT_FOUND');
1108: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1109: -- Change mask back to flexible mask
1110: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1111: RETURN l_formula_value;
1112:
1113: WHEN E_INVALID_FORMULA THEN
1114: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1118: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: fnd_message.set_name('QP','QP_INVALID_FORMULA');
1116: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1117: -- Change mask back to flexible mask
1118: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1119: RETURN l_formula_value;
1120:
1121: WHEN E_FORMULA_COMPONENTS_REQ THEN
1122: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1126: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

1122: x_return_status := FND_API.G_RET_STS_ERROR;
1123: fnd_message.set_name('QP','QP_FORMULA_COMPONENTS_REQ');
1124: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1125: -- Change mask back to flexible mask
1126: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1127: RETURN l_formula_value;
1128:
1129: WHEN E_CUSTOMIZE_GET_CUSTOM_PRICE THEN
1130: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1134: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: fnd_message.set_name('QP','QP_CUSTOMIZE_GET_CUSTOM_PRICE');
1132: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1133: -- Change mask back to flexible mask
1134: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1135: RETURN l_formula_value;
1136:
1137: WHEN E_INVALID_NUMBER THEN
1138: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1142: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

1138: x_return_status := FND_API.G_RET_STS_ERROR;
1139: fnd_message.set_name('QP','QP_INVALID_NUMBER');
1140: fnd_message.set_token('FORMULA_NAME',l_formula_name);
1141: -- Change mask back to flexible mask
1142: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1143: RETURN l_formula_value;
1144:
1145: WHEN FND_API.G_EXC_ERROR THEN
1146:

Line 1162: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

1158:
1159: l_formula_line_tbl.DELETE; --Clear the temp table table
1160:
1161: -- Change mask back to flexible mask
1162: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1163:
1164: RETURN l_formula_value;
1165:
1166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1178: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

1174: END IF;
1175: l_formula_line_tbl.DELETE; --Clear the temp table table
1176:
1177: -- Change mask back to flexible mask
1178: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1179:
1180: RETURN l_formula_value;
1181:
1182: WHEN OTHERS THEN

Line 1201: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';

1197: END IF;
1198: l_formula_line_tbl.DELETE; --Clear the temp table table
1199:
1200: -- Change mask back to flexible mask
1201: qp_number.canonical_mask := 'FM999999999999999999999.9999999999999999999999999999999999999999';
1202:
1203: RETURN l_formula_value;
1204:
1205: END Calculate;