4968: l_chr_rec.application_id,
4969: l_chr_rec.orig_system_source_code,
4970: l_chr_rec.orig_system_id1,
4971: l_chr_rec.orig_system_reference1,
4972: decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),
4973: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID),
4974: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE),
4975: decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID),
4976: l_chr_rec.price_list_id,
4969: l_chr_rec.orig_system_source_code,
4970: l_chr_rec.orig_system_id1,
4971: l_chr_rec.orig_system_reference1,
4972: decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),
4973: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID),
4974: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE),
4975: decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID),
4976: l_chr_rec.price_list_id,
4977: l_chr_rec.pricing_date,
4970: l_chr_rec.orig_system_id1,
4971: l_chr_rec.orig_system_reference1,
4972: decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),
4973: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID),
4974: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE),
4975: decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID),
4976: l_chr_rec.price_list_id,
4977: l_chr_rec.pricing_date,
4978: l_chr_rec.sign_by_date,
4971: l_chr_rec.orig_system_reference1,
4972: decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),
4973: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID),
4974: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE),
4975: decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID),
4976: l_chr_rec.price_list_id,
4977: l_chr_rec.pricing_date,
4978: l_chr_rec.sign_by_date,
4979: l_chr_rec.total_line_list_price,
5275: okc_debug.LOG('14800: Entered fill_who_columns', 2);
5276: END IF;
5277:
5278: l_chrv_rec.CREATION_DATE := SYSDATE;
5279: l_chrv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
5280: l_chrv_rec.LAST_UPDATE_DATE := l_chrv_rec.CREATION_DATE;
5281: l_chrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
5282: l_chrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
5283: RETURN(l_chrv_rec);
5277:
5278: l_chrv_rec.CREATION_DATE := SYSDATE;
5279: l_chrv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
5280: l_chrv_rec.LAST_UPDATE_DATE := l_chrv_rec.CREATION_DATE;
5281: l_chrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
5282: l_chrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
5283: RETURN(l_chrv_rec);
5284:
5285: END fill_who_columns;
5278: l_chrv_rec.CREATION_DATE := SYSDATE;
5279: l_chrv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
5280: l_chrv_rec.LAST_UPDATE_DATE := l_chrv_rec.CREATION_DATE;
5281: l_chrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
5282: l_chrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
5283: RETURN(l_chrv_rec);
5284:
5285: END fill_who_columns;
5286: ----------------------------------------
6671: --------APPLICATION_ID = l_def_chr_rec.application_id,
6672: ORIG_SYSTEM_SOURCE_CODE = l_def_chr_rec.orig_system_source_code,
6673: ORIG_SYSTEM_ID1 = l_def_chr_rec.orig_system_id1,
6674: ORIG_SYSTEM_REFERENCE1 = l_def_chr_rec.orig_system_reference1,
6675: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID), l_def_chr_rec.program_id),
6676: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID), l_def_chr_rec.request_id),
6677: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE), NULL, l_def_chr_rec.program_update_date, SYSDATE),
6678: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID), l_def_chr_rec.program_application_id),
6679: PRICE_LIST_ID = l_def_chr_rec.price_list_id,
6672: ORIG_SYSTEM_SOURCE_CODE = l_def_chr_rec.orig_system_source_code,
6673: ORIG_SYSTEM_ID1 = l_def_chr_rec.orig_system_id1,
6674: ORIG_SYSTEM_REFERENCE1 = l_def_chr_rec.orig_system_reference1,
6675: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID), l_def_chr_rec.program_id),
6676: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID), l_def_chr_rec.request_id),
6677: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE), NULL, l_def_chr_rec.program_update_date, SYSDATE),
6678: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID), l_def_chr_rec.program_application_id),
6679: PRICE_LIST_ID = l_def_chr_rec.price_list_id,
6680: PRICING_DATE = l_def_chr_rec.pricing_date,
6673: ORIG_SYSTEM_ID1 = l_def_chr_rec.orig_system_id1,
6674: ORIG_SYSTEM_REFERENCE1 = l_def_chr_rec.orig_system_reference1,
6675: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID), l_def_chr_rec.program_id),
6676: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID), l_def_chr_rec.request_id),
6677: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE), NULL, l_def_chr_rec.program_update_date, SYSDATE),
6678: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID), l_def_chr_rec.program_application_id),
6679: PRICE_LIST_ID = l_def_chr_rec.price_list_id,
6680: PRICING_DATE = l_def_chr_rec.pricing_date,
6681: SIGN_BY_DATE = l_def_chr_rec.sign_by_date,
6674: ORIG_SYSTEM_REFERENCE1 = l_def_chr_rec.orig_system_reference1,
6675: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID), l_def_chr_rec.program_id),
6676: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID), l_def_chr_rec.request_id),
6677: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE), NULL, l_def_chr_rec.program_update_date, SYSDATE),
6678: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID), l_def_chr_rec.program_application_id),
6679: PRICE_LIST_ID = l_def_chr_rec.price_list_id,
6680: PRICING_DATE = l_def_chr_rec.pricing_date,
6681: SIGN_BY_DATE = l_def_chr_rec.sign_by_date,
6682: TOTAL_LINE_LIST_PRICE = l_def_chr_rec.total_line_list_price,
7055: okc_debug.LOG('20000: Entered fill_who_columns', 2);
7056: END IF;
7057:
7058: l_chrv_rec.LAST_UPDATE_DATE := SYSDATE;
7059: l_chrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
7060: l_chrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
7061: RETURN(l_chrv_rec);
7062:
7063: END fill_who_columns;
7056: END IF;
7057:
7058: l_chrv_rec.LAST_UPDATE_DATE := SYSDATE;
7059: l_chrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
7060: l_chrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
7061: RETURN(l_chrv_rec);
7062:
7063: END fill_who_columns;
7064: ----------------------------------