DBA Data[Home] [Help]

APPS.OKC_CHR_PVT dependencies on FND_GLOBAL

Line 4972: decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),

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,

Line 4973: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_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,

Line 4974: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE),

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,

Line 4975: decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID),

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,

Line 5279: l_chrv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

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

Line 5281: l_chrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

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;

Line 5282: l_chrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

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: ----------------------------------------

Line 6675: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID), l_def_chr_rec.program_id),

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,

Line 6676: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID), l_def_chr_rec.request_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,

Line 6677: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE), NULL, l_def_chr_rec.program_update_date, SYSDATE),

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,

Line 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),

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,

Line 7059: l_chrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

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;

Line 7060: l_chrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

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: ----------------------------------