228: l_clev_tbl_in(i).CLE_ID_RENEWED_TO := Null;
229: l_clev_tbl_in(i).CURRENCY_CODE_RENEWED := Null;
230: l_clev_tbl_in(i).PRICE_NEGOTIATED_RENEWED:= Null;
231:
232: l_clev_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;
233: l_clev_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;
234:
235: -- dbms_output.put_line('Before Insert');
236:
229: l_clev_tbl_in(i).CURRENCY_CODE_RENEWED := Null;
230: l_clev_tbl_in(i).PRICE_NEGOTIATED_RENEWED:= Null;
231:
232: l_clev_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;
233: l_clev_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;
234:
235: -- dbms_output.put_line('Before Insert');
236:
237: If l_validate_flag = 'Y' THEN
1217: l_clev_tbl_in(i).price_unit_percent :=NULL;
1218: l_clev_tbl_in(i).price_negotiated :=NULL;
1219: l_clev_tbl_in(i).price_level_ind :='N';
1220: l_clev_tbl_in(i).block23text :=NULL;
1221: l_clev_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;
1222: l_clev_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;
1223: -- -- dbms_output.put_line('Test5');
1224: IF COVERAGE_BUSS_PROCESS_ID_tbl(i) IS NOT NULL
1225: THEN
1218: l_clev_tbl_in(i).price_negotiated :=NULL;
1219: l_clev_tbl_in(i).price_level_ind :='N';
1220: l_clev_tbl_in(i).block23text :=NULL;
1221: l_clev_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;
1222: l_clev_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;
1223: -- -- dbms_output.put_line('Test5');
1224: IF COVERAGE_BUSS_PROCESS_ID_tbl(i) IS NOT NULL
1225: THEN
1226:
1243: l_cimv_tbl_in(i).CLE_ID_FOR := Null;
1244: l_cimv_tbl_in(i).PRICED_ITEM_YN := Null;
1245: l_cimv_tbl_in(i).UPG_ORIG_SYSTEM_REF := Null;
1246: l_cimv_tbl_in(i).UPG_ORIG_SYSTEM_REF_ID := Null;
1247: l_cimv_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;
1248: l_cimv_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;
1249: EnD if;
1250:
1251: ---- Creation For Rule_Groups in OKC_RULE_GROUPS_V
1244: l_cimv_tbl_in(i).PRICED_ITEM_YN := Null;
1245: l_cimv_tbl_in(i).UPG_ORIG_SYSTEM_REF := Null;
1246: l_cimv_tbl_in(i).UPG_ORIG_SYSTEM_REF_ID := Null;
1247: l_cimv_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;
1248: l_cimv_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;
1249: EnD if;
1250:
1251: ---- Creation For Rule_Groups in OKC_RULE_GROUPS_V
1252:
2089: l_clev_tbl_in(i+1000).price_unit_percent :=NULL;
2090: l_clev_tbl_in(i+1000).price_negotiated :=NULL;
2091: l_clev_tbl_in(i+1000).price_level_ind :='N';
2092: l_clev_tbl_in(i+1000).block23text :=NULL;
2093: l_clev_tbl_in(i+1000).program_application_id:= fnd_global.prog_appl_id;
2094: l_clev_tbl_in(i+1000).program_id:= fnd_global.CONC_PROGRAM_ID;
2095: -- -- dbms_output.put_line('Test5');
2096:
2097:
2090: l_clev_tbl_in(i+1000).price_negotiated :=NULL;
2091: l_clev_tbl_in(i+1000).price_level_ind :='N';
2092: l_clev_tbl_in(i+1000).block23text :=NULL;
2093: l_clev_tbl_in(i+1000).program_application_id:= fnd_global.prog_appl_id;
2094: l_clev_tbl_in(i+1000).program_id:= fnd_global.CONC_PROGRAM_ID;
2095: -- -- dbms_output.put_line('Test5');
2096:
2097:
2098: l_rgpv_tbl_in(i+1000).cle_id := l_clev_tbl_in(i+1000).id;
3555: l_clev_tbl_in(i).price_unit_percent :=NULL;
3556: l_clev_tbl_in(i).price_negotiated :=NULL;
3557: l_clev_tbl_in(i).price_level_ind :='N';
3558: l_clev_tbl_in(i).block23text :=NULL;
3559: l_clev_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;
3560: l_clev_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;
3561: -- -- dbms_output.put_line('Test');
3562:
3563: l_cimv_tbl_in(i).cle_id := l_clev_tbl_in(i).Id;
3556: l_clev_tbl_in(i).price_negotiated :=NULL;
3557: l_clev_tbl_in(i).price_level_ind :='N';
3558: l_clev_tbl_in(i).block23text :=NULL;
3559: l_clev_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;
3560: l_clev_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;
3561: -- -- dbms_output.put_line('Test');
3562:
3563: l_cimv_tbl_in(i).cle_id := l_clev_tbl_in(i).Id;
3564: l_cimv_tbl_in(i).chr_id := null;
3581: l_cimv_tbl_in(i).UPG_ORIG_SYSTEM_REF :=Null;
3582: l_cimv_tbl_in(i).UPG_ORIG_SYSTEM_REF_ID :=Null;
3583: l_cimv_tbl_in(i).uom_code := Null;
3584:
3585: l_cimv_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;
3586: l_cimv_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;
3587:
3588: l_rgpv_tbl_in(i).cle_id := l_clev_tbl_in(i).Id;
3589: l_rgpv_tbl_in(i).sfwt_flag := 'N';
3582: l_cimv_tbl_in(i).UPG_ORIG_SYSTEM_REF_ID :=Null;
3583: l_cimv_tbl_in(i).uom_code := Null;
3584:
3585: l_cimv_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;
3586: l_cimv_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;
3587:
3588: l_rgpv_tbl_in(i).cle_id := l_clev_tbl_in(i).Id;
3589: l_rgpv_tbl_in(i).sfwt_flag := 'N';
3590: l_rgpv_tbl_in(i).rgd_code := 'SVC_K';
4012: l_clev_tbl_in(i).price_unit_percent :=NULL;
4013: l_clev_tbl_in(i).price_negotiated :=NULL;
4014: l_clev_tbl_in(i).price_level_ind :='N';
4015: l_clev_tbl_in(i).block23text :=NULL;
4016: l_clev_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;
4017: l_clev_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;
4018:
4019: l_rgpv_tbl_in(i).cle_id := l_clev_tbl_in(i).Id;
4020: l_rgpv_tbl_in(i).sfwt_flag := 'N';
4013: l_clev_tbl_in(i).price_negotiated :=NULL;
4014: l_clev_tbl_in(i).price_level_ind :='N';
4015: l_clev_tbl_in(i).block23text :=NULL;
4016: l_clev_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;
4017: l_clev_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;
4018:
4019: l_rgpv_tbl_in(i).cle_id := l_clev_tbl_in(i).Id;
4020: l_rgpv_tbl_in(i).sfwt_flag := 'N';
4021: l_rgpv_tbl_in(i).rgd_code := 'SVC_K';