1069: l_olev_tbl_in(i).creation_date := SYSDATE;
1070: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1071: l_olev_tbl_in(i).last_update_date := SYSDATE;
1072: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1073: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1074: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1075: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1076: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1077: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1070: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1071: l_olev_tbl_in(i).last_update_date := SYSDATE;
1072: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1073: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1074: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1075: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1076: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1077: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1078: i := i + 1;
1071: l_olev_tbl_in(i).last_update_date := SYSDATE;
1072: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1073: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1074: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1075: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1076: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1077: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1078: i := i + 1;
1079: END IF;
1162: l_olev_tbl_in(i).creation_date := SYSDATE;
1163: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1164: l_olev_tbl_in(i).last_update_date := SYSDATE;
1165: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1166: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1167: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1168: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1169: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1170: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1163: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1164: l_olev_tbl_in(i).last_update_date := SYSDATE;
1165: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1166: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1167: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1168: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1169: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1170: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1171: i := i + 1;
1164: l_olev_tbl_in(i).last_update_date := SYSDATE;
1165: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1166: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1167: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1168: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1169: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1170: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1171: i := i + 1;
1172: END IF;
1241: l_olev_tbl_in(i).creation_date := SYSDATE;
1242: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1243: l_olev_tbl_in(i).last_update_date := SYSDATE;
1244: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1245: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1246: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1247: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1248: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1249: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1242: l_olev_tbl_in(i).last_updated_by := OKC_API.G_MISS_NUM;
1243: l_olev_tbl_in(i).last_update_date := SYSDATE;
1244: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1245: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1246: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1247: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1248: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1249: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1250: i := i + 1;
1243: l_olev_tbl_in(i).last_update_date := SYSDATE;
1244: l_olev_tbl_in(i).last_update_login := OKC_API.G_MISS_NUM;
1245: l_olev_tbl_in(i).request_id := FND_GLOBAL.CONC_REQUEST_ID;
1246: l_olev_tbl_in(i).program_application_id := FND_GLOBAL.PROG_APPL_ID;
1247: l_olev_tbl_in(i).program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1248: l_olev_tbl_in(i).program_update_date := OKC_API.G_MISS_DATE;
1249: l_olev_tbl_in(i).message_code := OKC_API.G_MISS_CHAR;
1250: i := i + 1;
1251: j := j + 1;
2550: END IF;
2551: END LOOP;
2552:
2553: l_update_date := sysdate;
2554: l_user_id := FND_GLOBAL.USER_ID;
2555: l_login_id := FND_GLOBAL.LOGIN_ID;
2556: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2557: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2558: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2551: END LOOP;
2552:
2553: l_update_date := sysdate;
2554: l_user_id := FND_GLOBAL.USER_ID;
2555: l_login_id := FND_GLOBAL.LOGIN_ID;
2556: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2557: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2558: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2559:
2552:
2553: l_update_date := sysdate;
2554: l_user_id := FND_GLOBAL.USER_ID;
2555: l_login_id := FND_GLOBAL.LOGIN_ID;
2556: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2557: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2558: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2559:
2560: log_messages('***** Number of Source Top Lines/Sublines processed : ***** '||l_opl_id_tbl.COUNT);
2553: l_update_date := sysdate;
2554: l_user_id := FND_GLOBAL.USER_ID;
2555: l_login_id := FND_GLOBAL.LOGIN_ID;
2556: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2557: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2558: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2559:
2560: log_messages('***** Number of Source Top Lines/Sublines processed : ***** '||l_opl_id_tbl.COUNT);
2561: LOG_MESSAGES(' ');
2554: l_user_id := FND_GLOBAL.USER_ID;
2555: l_login_id := FND_GLOBAL.LOGIN_ID;
2556: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2557: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2558: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2559:
2560: log_messages('***** Number of Source Top Lines/Sublines processed : ***** '||l_opl_id_tbl.COUNT);
2561: LOG_MESSAGES(' ');
2562:
2947:
2948: IF p_header_id IS NOT NULL THEN
2949:
2950: l_update_date := sysdate;
2951: l_user_id := FND_GLOBAL.USER_ID;
2952: l_login_id := FND_GLOBAL.LOGIN_ID;
2953: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2954: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2955: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2948: IF p_header_id IS NOT NULL THEN
2949:
2950: l_update_date := sysdate;
2951: l_user_id := FND_GLOBAL.USER_ID;
2952: l_login_id := FND_GLOBAL.LOGIN_ID;
2953: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2954: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2955: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2956:
2949:
2950: l_update_date := sysdate;
2951: l_user_id := FND_GLOBAL.USER_ID;
2952: l_login_id := FND_GLOBAL.LOGIN_ID;
2953: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2954: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2955: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2956:
2957: --update the topline price_negotiated(OKC) and tax_amount(OKS) columns
2950: l_update_date := sysdate;
2951: l_user_id := FND_GLOBAL.USER_ID;
2952: l_login_id := FND_GLOBAL.LOGIN_ID;
2953: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2954: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2955: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2956:
2957: --update the topline price_negotiated(OKC) and tax_amount(OKS) columns
2958: --no need for warranty(14 - cannot be renewed) and subscription (46 - no toplines)
2951: l_user_id := FND_GLOBAL.USER_ID;
2952: l_login_id := FND_GLOBAL.LOGIN_ID;
2953: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2954: l_prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
2955: l_prog_id := FND_GLOBAL.CONC_PROGRAM_ID;
2956:
2957: --update the topline price_negotiated(OKC) and tax_amount(OKS) columns
2958: --no need for warranty(14 - cannot be renewed) and subscription (46 - no toplines)
2959: OPEN c_top_lines(p_header_id);