448: l_isev_ext_tbl_in(i).LAST_UPDATE_DATE := sysdate;
449: l_isev_ext_tbl_in(i).LAST_UPDATED_BY := -1;
450: l_isev_ext_tbl_in(i).LAST_UPDATE_LOGIN := -1;
451:
452: okc_time_pvt.Insert_ise_Row_Upg( l_isev_ext_tbl_in);
453:
454: l_rulv_tbl_in.delete;
455: l_isev_ext_tbl_in.delete;
456: --UGE Rule
3126: /*----------------------------------------*/
3127:
3128: IF l_isev_rel_tbl_in.count > 0
3129: THEN
3130: l_error_message := 'okc_time_pvt.Insert_ise_Row_Upg -';
3131: okc_time_pvt.Insert_ise_Row_Upg(l_isev_rel_tbl_in);
3132: END IF;
3133: l_isev_rel_tbl_in.delete;
3134: /*-----------------------------------------*/
3127:
3128: IF l_isev_rel_tbl_in.count > 0
3129: THEN
3130: l_error_message := 'okc_time_pvt.Insert_ise_Row_Upg -';
3131: okc_time_pvt.Insert_ise_Row_Upg(l_isev_rel_tbl_in);
3132: END IF;
3133: l_isev_rel_tbl_in.delete;
3134: /*-----------------------------------------*/
3135: IF l_isev_ext_tbl_In.COUNT>0
3133: l_isev_rel_tbl_in.delete;
3134: /*-----------------------------------------*/
3135: IF l_isev_ext_tbl_In.COUNT>0
3136: THEN
3137: l_error_message := 'okc_time_pvt.Insert_ise_Row_Upg -';
3138: okc_time_pvt.Insert_ise_Row_Upg(l_isev_ext_tbl_in);
3139: END IF;
3140: l_isev_ext_Tbl_In.DELETE;
3141:
3134: /*-----------------------------------------*/
3135: IF l_isev_ext_tbl_In.COUNT>0
3136: THEN
3137: l_error_message := 'okc_time_pvt.Insert_ise_Row_Upg -';
3138: okc_time_pvt.Insert_ise_Row_Upg(l_isev_ext_tbl_in);
3139: END IF;
3140: l_isev_ext_Tbl_In.DELETE;
3141:
3142: IF l_igsv_ext_tbl_In.COUNT>0
3140: l_isev_ext_Tbl_In.DELETE;
3141:
3142: IF l_igsv_ext_tbl_In.COUNT>0
3143: THEN
3144: l_error_message := 'okc_time_pvt.Insert_igs_Row_Upg -';
3145: okc_time_pvt.Insert_igs_Row_Upg( l_igsv_ext_tbl_in);
3146: END IF;
3147: l_igsv_ext_Tbl_In.DELETE;
3148:
3141:
3142: IF l_igsv_ext_tbl_In.COUNT>0
3143: THEN
3144: l_error_message := 'okc_time_pvt.Insert_igs_Row_Upg -';
3145: okc_time_pvt.Insert_igs_Row_Upg( l_igsv_ext_tbl_in);
3146: END IF;
3147: l_igsv_ext_Tbl_In.DELETE;
3148:
3149:
3165: END IF;
3166: l_ctiv_Tbl_In.DELETE;
3167: IF l_tgdv_ext_tbl_in.COUNT>0
3168: THEN
3169: l_error_message := 'okc_Time_pvt -';
3170: okc_Time_pvt.Insert_Tgd_Row_Upg( l_tgdv_ext_tbl_in);
3171: END IF;
3172: l_tgdv_ext_tbl_in.DELETE;
3173:
3166: l_ctiv_Tbl_In.DELETE;
3167: IF l_tgdv_ext_tbl_in.COUNT>0
3168: THEN
3169: l_error_message := 'okc_Time_pvt -';
3170: okc_Time_pvt.Insert_Tgd_Row_Upg( l_tgdv_ext_tbl_in);
3171: END IF;
3172: l_tgdv_ext_tbl_in.DELETE;
3173:
3174: IF l_rilv_tbl_in.COUNT>0
3189: l_rilv_tbl_in.DELETE;
3190:
3191: IF l_tgdv_rcn_tbl_in.COUNT>0
3192: THEN
3193: l_error_message := 'okc_Time_pvt -';
3194: okc_Time_pvt.Insert_Tgd_Row_Upg( l_tgdv_rcn_tbl_in);
3195: END IF;
3196: l_tgdv_rcn_tbl_in.DELETE;
3197:
3190:
3191: IF l_tgdv_rcn_tbl_in.COUNT>0
3192: THEN
3193: l_error_message := 'okc_Time_pvt -';
3194: okc_Time_pvt.Insert_Tgd_Row_Upg( l_tgdv_rcn_tbl_in);
3195: END IF;
3196: l_tgdv_rcn_tbl_in.DELETE;
3197:
3198: IF l_rilt_tbl_in.COUNT>0
3265: l_ctcv_Tbl_In.DELETE;
3266: /*----------------------------------------*/
3267: IF l_isev_rel_tbl_in.count > 0
3268: THEN
3269: l_error_message := 'okc_time_pvt.Insert_ise_Row_Upg -';
3270: okc_time_pvt.Insert_ise_Row_Upg(l_isev_rel_tbl_in);
3271: END IF;
3272: l_isev_rel_tbl_in.delete;
3273: /*-----------------------------------------*/
3266: /*----------------------------------------*/
3267: IF l_isev_rel_tbl_in.count > 0
3268: THEN
3269: l_error_message := 'okc_time_pvt.Insert_ise_Row_Upg -';
3270: okc_time_pvt.Insert_ise_Row_Upg(l_isev_rel_tbl_in);
3271: END IF;
3272: l_isev_rel_tbl_in.delete;
3273: /*-----------------------------------------*/
3274: IF l_isev_ext_tbl_In.COUNT>0
3272: l_isev_rel_tbl_in.delete;
3273: /*-----------------------------------------*/
3274: IF l_isev_ext_tbl_In.COUNT>0
3275: THEN
3276: l_error_message := 'okc_time_pvt.Insert_ise_Row_Upg -';
3277: okc_time_pvt.Insert_ise_Row_Upg(l_isev_ext_tbl_in);
3278: END IF;
3279: l_isev_ext_Tbl_In.DELETE;
3280:
3273: /*-----------------------------------------*/
3274: IF l_isev_ext_tbl_In.COUNT>0
3275: THEN
3276: l_error_message := 'okc_time_pvt.Insert_ise_Row_Upg -';
3277: okc_time_pvt.Insert_ise_Row_Upg(l_isev_ext_tbl_in);
3278: END IF;
3279: l_isev_ext_Tbl_In.DELETE;
3280:
3281: IF l_igsv_ext_tbl_In.COUNT>0
3279: l_isev_ext_Tbl_In.DELETE;
3280:
3281: IF l_igsv_ext_tbl_In.COUNT>0
3282: THEN
3283: l_error_message := 'okc_time_pvt.Insert_igs_Row_Upg -';
3284: okc_time_pvt.Insert_igs_Row_Upg( l_igsv_ext_tbl_in);
3285: END IF;
3286: l_igsv_ext_Tbl_In.DELETE;
3287:
3280:
3281: IF l_igsv_ext_tbl_In.COUNT>0
3282: THEN
3283: l_error_message := 'okc_time_pvt.Insert_igs_Row_Upg -';
3284: okc_time_pvt.Insert_igs_Row_Upg( l_igsv_ext_tbl_in);
3285: END IF;
3286: l_igsv_ext_Tbl_In.DELETE;
3287:
3288:
3293: END IF;
3294: l_ctiv_Tbl_In.DELETE;
3295: IF l_tgdv_ext_tbl_in.COUNT>0
3296: THEN
3297: l_error_message := 'okc_Time_pvt -';
3298: okc_Time_pvt.Insert_Tgd_Row_Upg( l_tgdv_ext_tbl_in);
3299: END IF;
3300: l_tgdv_ext_tbl_in.DELETE;
3301:
3294: l_ctiv_Tbl_In.DELETE;
3295: IF l_tgdv_ext_tbl_in.COUNT>0
3296: THEN
3297: l_error_message := 'okc_Time_pvt -';
3298: okc_Time_pvt.Insert_Tgd_Row_Upg( l_tgdv_ext_tbl_in);
3299: END IF;
3300: l_tgdv_ext_tbl_in.DELETE;
3301:
3302: IF l_rilv_tbl_in.COUNT>0
3307: l_rilv_tbl_in.DELETE;
3308:
3309: IF l_tgdv_rcn_tbl_in.COUNT>0
3310: THEN
3311: l_error_message := 'okc_Time_pvt -';
3312: okc_Time_pvt.Insert_Tgd_Row_Upg( l_tgdv_rcn_tbl_in);
3313: END IF;
3314: l_tgdv_rcn_tbl_in.DELETE;
3315:
3308:
3309: IF l_tgdv_rcn_tbl_in.COUNT>0
3310: THEN
3311: l_error_message := 'okc_Time_pvt -';
3312: okc_Time_pvt.Insert_Tgd_Row_Upg( l_tgdv_rcn_tbl_in);
3313: END IF;
3314: l_tgdv_rcn_tbl_in.DELETE;
3315:
3316: IF l_rilt_tbl_in.COUNT>0