[Home] [Help]
PACKAGE BODY: APPS.ZX_DET_FACTOR_TEMPL_DTL_PKG
Source
1 package body ZX_DET_FACTOR_TEMPL_DTL_PKG as
2 /* $Header: zxddetfactordtlb.pls 120.3 2003/12/19 20:59:38 ssekuri ship $ */
3
4 procedure bulk_insert_df_templ_dtl (
5 X_DET_FACTOR_TEMPL_ID IN t_det_factor_templ_id,
6 X_Determining_Factor_Class_Co IN t_determining_factor_class,
7 X_Determining_Factor_Cq_Code IN t_determining_factor_cq,
8 X_DETERMINING_FACTOR_CODE IN t_determining_factor_code,
9 X_Required_Flag IN t_required_flg,
10 X_Record_Type_Code IN t_record_type) is
11
12 begin
13
14 if x_det_factor_templ_id.count <> 0 then
15 forall i in x_det_factor_templ_id.first..x_det_factor_templ_id.last
16 insert into ZX_DET_FACTOR_TEMPL_DTL (DET_FACTOR_TEMPL_DTL_ID,
17 DET_FACTOR_TEMPL_ID,
18 Determining_Factor_Class_Code,
19 Determining_Factor_Cq_Code,
20 DETERMINING_FACTOR_CODE,
21 Required_Flag,
22 Record_Type_Code,
23 CREATED_BY ,
24 CREATION_DATE ,
25 LAST_UPDATED_BY ,
26 LAST_UPDATE_DATE ,
27 LAST_UPDATE_LOGIN ,
28 REQUEST_ID ,
29 PROGRAM_APPLICATION_ID ,
30 PROGRAM_ID ,
31 PROGRAM_LOGIN_ID)
32 values (zx_det_factor_templ_dtl_s.nextval,
33 X_DET_FACTOR_TEMPL_ID(i),
34 X_Determining_Factor_Class_Co(i),
35 X_Determining_Factor_Cq_Code(i),
36 X_DETERMINING_FACTOR_CODE(i),
37 X_Required_Flag(i),
38 X_Record_Type_Code(i),
39 fnd_global.user_id ,
40 sysdate ,
41 fnd_global.user_id ,
42 sysdate ,
43 fnd_global.conc_login_id ,
44 fnd_global.conc_request_id ,
45 fnd_global.prog_appl_id ,
46 fnd_global.conc_program_id ,
47 fnd_global.conc_login_id
48 );
49
50 end if;
51
52 EXCEPTION
53 WHEN OTHERS THEN
54 APP_EXCEPTION.RAISE_EXCEPTION;
55
56 end bulk_insert_df_templ_dtl;
57
58 end ZX_DET_FACTOR_TEMPL_DTL_PKG;