1: package body ZX_FORMULA_DETAILS_PKG as
2: /* $Header: zxdformuladtlb.pls 120.2 2003/12/19 03:51:25 ssekuri ship $ */
3:
4: procedure bulk_insert_formula_details (
5: X_FORMULA_ID IN t_formula_id,
32: begin
33:
34: if x_formula_id.count <> 0 then
35: forall i in x_formula_id.first..x_formula_id.last
36: INSERT INTO ZX_FORMULA_DETAILS (FORMULA_DETAIL_ID,
37: FORMULA_ID,
38: COMPOUNDING_TAX,
39: COMPOUNDING_TAX_REGIME_CODE,
40: Compounding_Type_Code,
68: REQUEST_ID ,
69: PROGRAM_APPLICATION_ID ,
70: PROGRAM_ID ,
71: PROGRAM_LOGIN_ID)
72: values (zx_formula_details_s.nextval,
73: X_FORMULA_ID(i),
74: X_COMPOUNDING_TAX(i),
75: X_COMPOUNDING_TAX_REGIME_CODE(i),
76: X_Compounding_Type_Code(i),
114: APP_EXCEPTION.RAISE_EXCEPTION;
115:
116: end bulk_insert_formula_details;
117:
118: end ZX_FORMULA_DETAILS_PKG;