DBA Data[Home] [Help]

APPS.QP_UPDATE_FORMULAPRICE_PVT dependencies on QP_NUMBER

Line 80: Qp_Number.canonical_mask :=

76:
77: l_sysdate := SYSDATE;
78:
79: --Change flexible mask to mask below for formula pattern use.
80: Qp_Number.canonical_mask :=
81: '00999999999999999999999.99999999999999999999999999999999999999';
82:
83: /* Select the Price Formulas which are to be used to update list prices. */
84: /* Select all or a specific formula depending on the option selected. */

Line 123: Qp_Number.canonical_mask :=

119:
120: --DBMS_OUTPUT.PUT_LINE ('>>>>>>>>>>>> inside qp_list_lines_cursor loop list_line_id: '||l_lines_rec.list_line_id);
121:
122:
123: Qp_Number.canonical_mask :=
124: '00999999999999999999999.99999999999999999999999999999999999999'; --Added for 2884567
125: l_req_line_attrs_tbl.DELETE; /* Empty the plsql table for each list line */
126:
127: --Delete already existing rows from formula tmp table

Line 161: Qp_Number.number_to_canonical(TO_NUMBER(l_attributes_rec.product_attr_value)),

157: 0,
158: 'PRODUCT',
159: l_attributes_rec.product_attribute_context,
160: l_attributes_rec.product_attribute,
161: Qp_Number.number_to_canonical(TO_NUMBER(l_attributes_rec.product_attr_value)),
162: Qp_Preq_Grp.G_STATUS_UNCHANGED
163: );
164:
165:

Line 224: Qp_Number.number_to_canonical(TO_NUMBER(l_attributes_rec.pricing_attr_value_from)),

220: 0,
221: 'PRICING',
222: l_attributes_rec.pricing_attribute_context,
223: l_attributes_rec.pricing_attribute,
224: Qp_Number.number_to_canonical(TO_NUMBER(l_attributes_rec.pricing_attr_value_from)),
225: Qp_Preq_Grp.G_STATUS_UNCHANGED
226: );
227:
228:

Line 326: Qp_Number.canonical_mask :=

322:
323: END LOOP; /* loop through formulas cur */
324:
325: --Change mask back to flexible mask.
326: Qp_Number.canonical_mask :=
327: 'FM999999999999999999999.9999999999999999999999999999999999999999';
328:
329: COMMIT;
330: