DBA Data[Home] [Help]

APPS.OKS_COVERAGES_MIGRATION dependencies on FND_GLOBAL

Line 232: l_clev_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;

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:

Line 233: l_clev_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;

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

Line 1221: l_clev_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;

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

Line 1222: l_clev_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;

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:

Line 1247: l_cimv_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;

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

Line 1248: l_cimv_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;

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:

Line 2093: l_clev_tbl_in(i+1000).program_application_id:= fnd_global.prog_appl_id;

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:

Line 2094: l_clev_tbl_in(i+1000).program_id:= fnd_global.CONC_PROGRAM_ID;

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;

Line 3559: l_clev_tbl_in(i).program_application_id:= fnd_global.prog_appl_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;

Line 3560: l_clev_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_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;

Line 3585: l_cimv_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;

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';

Line 3586: l_cimv_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;

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';

Line 4016: l_clev_tbl_in(i).program_application_id:= fnd_global.prog_appl_id;

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';

Line 4017: l_clev_tbl_in(i).program_id:= fnd_global.CONC_PROGRAM_ID;

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';