[Home] [Help]
PACKAGE BODY: APPS.ZX_CONDITIONS_PKG
Source
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,
7 X_TAX_PARAMETER_CODE IN t_tax_parameter_code,
8 X_DATA_TYPE_CODE IN t_data_type,
9 X_DETERMINING_FACTOR_CLASS_COD IN t_determining_factor_class,
10 X_DETERMINING_FACTOR_CQ_CODE IN t_determining_factor_cq,
11 X_OPERATOR_CODE IN t_operator,
12 X_RECORD_TYPE_CODE IN t_record_type,
13 X_IGNORE_FLAG IN t_ignore_flg,
14 X_NUMERIC_VALUE IN t_numeric_value,
15 X_DATE_VALUE IN t_date_value,
16 X_ALPHANUMERIC_VALUE IN t_alphanumeric_value,
17 X_VALUE_LOW IN t_value_low,
18 X_VALUE_HIGH IN t_value_high) is
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,
28 DETERMINING_FACTOR_CLASS_CODE,
29 DETERMINING_FACTOR_CQ_CODE,
30 OPERATOR_CODE,
31 RECORD_TYPE_CODE,
32 IGNORE_FLAG,
33 NUMERIC_VALUE,
34 DATE_VALUE,
35 ALPHANUMERIC_VALUE,
36 VALUE_LOW,
37 VALUE_HIGH,
38 CREATED_BY ,
39 CREATION_DATE ,
40 LAST_UPDATED_BY ,
41 LAST_UPDATE_DATE ,
42 LAST_UPDATE_LOGIN ,
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),
52 X_DETERMINING_FACTOR_CLASS_COD(i),
53 X_DETERMINING_FACTOR_CQ_CODE(i),
54 X_OPERATOR_CODE(i),
55 X_RECORD_TYPE_CODE(i),
56 X_IGNORE_FLAG(i),
57 X_NUMERIC_VALUE(i),
58 X_DATE_VALUE(i),
59 X_ALPHANUMERIC_VALUE(i),
60 X_VALUE_LOW(i),
61 X_VALUE_HIGH(i),
62 fnd_global.user_id ,
63 sysdate ,
64 fnd_global.user_id ,
65 sysdate ,
66 fnd_global.conc_login_id ,
67 fnd_global.conc_request_id ,
68 fnd_global.prog_appl_id ,
69 fnd_global.conc_program_id ,
70 fnd_global.conc_login_id
71 );
72
73 end if;
74
75 EXCEPTION
76 WHEN OTHERS THEN
77 APP_EXCEPTION.RAISE_EXCEPTION;
78
79 end bulk_insert_conditions;
80
81 end ZX_CONDITIONS_PKG;