1: package body ZX_CONDITIONS_PKG as
2: /* $Header: zxdconditionsb.pls 120.3 2003/12/19 20:28:52 ssekuri ship $ */
3:
4: procedure bulk_insert_conditions (
5: X_DETERMINING_FACTOR_CODE IN t_determining_factor_code,
1: package body ZX_CONDITIONS_PKG as
2: /* $Header: zxdconditionsb.pls 120.3 2003/12/19 20:28:52 ssekuri ship $ */
3:
4: procedure bulk_insert_conditions (
5: X_DETERMINING_FACTOR_CODE IN t_determining_factor_code,
6: X_CONDITION_GROUP_CODE IN t_condition_group_code,
19:
20: begin
21: If x_determining_factor_code.count <> 0 then
22: forall i in x_determining_factor_code.first..x_determining_factor_code.last
23: INSERT INTO ZX_CONDITIONS (CONDITION_ID,
24: DETERMINING_FACTOR_CODE,
25: CONDITION_GROUP_CODE,
26: TAX_PARAMETER_CODE,
27: DATA_TYPE_CODE,
43: REQUEST_ID ,
44: PROGRAM_APPLICATION_ID ,
45: PROGRAM_ID ,
46: PROGRAM_LOGIN_ID)
47: VALUES (zx_conditions_s.nextval,
48: X_DETERMINING_FACTOR_CODE(i),
49: X_CONDITION_GROUP_CODE(i),
50: X_TAX_PARAMETER_CODE(i),
51: X_DATA_TYPE_CODE(i),
77: APP_EXCEPTION.RAISE_EXCEPTION;
78:
79: end bulk_insert_conditions;
80:
81: end ZX_CONDITIONS_PKG;