177:
178:
179: select qp_pricing_attr_group_no_s.nextval
180: into l_attr_grp_s
181: from dual;
182:
183: select (-1*PL.ROUNDING_FACTOR),
184: NVL(FC.MINIMUM_ACCOUNTABLE_UNIT,-1)
185: into l_rounding_factor, l_min_acct_unit
218: */
219: l_already_exists := 0;
220: Select 1
221: Into l_already_exists
222: From Dual
223: Where Exists
224: (Select Null
225: from qp_pricing_attributes qppa
226: where qppa.list_header_id = p_price_list_id
321: and mtl.organization_id = p_organization_id;
322:
323: select qp_list_lines_s.nextval
324: into l_list_line_id
325: from dual;
326:
327: insert
328: into qp_list_lines
329: (LIST_LINE_ID,
462: */
463: l_already_exists := 0;
464: Select 1
465: Into l_already_exists
466: From Dual
467: Where Exists
468: (Select Null
469: from qp_pricing_attributes qppa
470: where qppa.list_header_id = p_price_list_id