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