DBA Data[Home] [Help]

APPS.OKC_CHR_PVT dependencies on FND_GLOBAL

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

4973: l_chr_rec.application_id,
4974: l_chr_rec.orig_system_source_code,
4975: l_chr_rec.orig_system_id1,
4976: l_chr_rec.orig_system_reference1,
4977: decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),
4978: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID),
4979: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE),
4980: decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID),
4981: l_chr_rec.price_list_id,

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

4974: l_chr_rec.orig_system_source_code,
4975: l_chr_rec.orig_system_id1,
4976: l_chr_rec.orig_system_reference1,
4977: decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),
4978: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID),
4979: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE),
4980: decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID),
4981: l_chr_rec.price_list_id,
4982: l_chr_rec.pricing_date,

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

4975: l_chr_rec.orig_system_id1,
4976: l_chr_rec.orig_system_reference1,
4977: decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),
4978: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID),
4979: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE),
4980: decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID),
4981: l_chr_rec.price_list_id,
4982: l_chr_rec.pricing_date,
4983: l_chr_rec.sign_by_date,

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

4976: l_chr_rec.orig_system_reference1,
4977: decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID),
4978: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID),
4979: decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE),
4980: decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID),
4981: l_chr_rec.price_list_id,
4982: l_chr_rec.pricing_date,
4983: l_chr_rec.sign_by_date,
4984: l_chr_rec.total_line_list_price,

Line 5285: l_chrv_rec.CREATED_BY := NVL(OKC_ASYNC_PVT.G_USER_ID, FND_GLOBAL.USER_ID);

5281: END IF;
5282:
5283: l_chrv_rec.CREATION_DATE := SYSDATE;
5284: /*Modified in bugfix for 13079117*/
5285: l_chrv_rec.CREATED_BY := NVL(OKC_ASYNC_PVT.G_USER_ID, FND_GLOBAL.USER_ID);
5286: l_chrv_rec.LAST_UPDATE_DATE := l_chrv_rec.CREATION_DATE;
5287: /*Modified in bugfix for 13079117*/
5288: l_chrv_rec.LAST_UPDATED_BY := NVL(OKC_ASYNC_PVT.G_USER_ID, FND_GLOBAL.USER_ID);
5289: l_chrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line 5288: l_chrv_rec.LAST_UPDATED_BY := NVL(OKC_ASYNC_PVT.G_USER_ID, FND_GLOBAL.USER_ID);

5284: /*Modified in bugfix for 13079117*/
5285: l_chrv_rec.CREATED_BY := NVL(OKC_ASYNC_PVT.G_USER_ID, FND_GLOBAL.USER_ID);
5286: l_chrv_rec.LAST_UPDATE_DATE := l_chrv_rec.CREATION_DATE;
5287: /*Modified in bugfix for 13079117*/
5288: l_chrv_rec.LAST_UPDATED_BY := NVL(OKC_ASYNC_PVT.G_USER_ID, FND_GLOBAL.USER_ID);
5289: l_chrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
5290: RETURN(l_chrv_rec);
5291:
5292: END fill_who_columns;

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

5285: l_chrv_rec.CREATED_BY := NVL(OKC_ASYNC_PVT.G_USER_ID, FND_GLOBAL.USER_ID);
5286: l_chrv_rec.LAST_UPDATE_DATE := l_chrv_rec.CREATION_DATE;
5287: /*Modified in bugfix for 13079117*/
5288: l_chrv_rec.LAST_UPDATED_BY := NVL(OKC_ASYNC_PVT.G_USER_ID, FND_GLOBAL.USER_ID);
5289: l_chrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
5290: RETURN(l_chrv_rec);
5291:
5292: END fill_who_columns;
5293: ----------------------------------------

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

6687: --------APPLICATION_ID = l_def_chr_rec.application_id,
6688: ORIG_SYSTEM_SOURCE_CODE = l_def_chr_rec.orig_system_source_code,
6689: ORIG_SYSTEM_ID1 = l_def_chr_rec.orig_system_id1,
6690: ORIG_SYSTEM_REFERENCE1 = l_def_chr_rec.orig_system_reference1,
6691: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID), l_def_chr_rec.program_id),
6692: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID), l_def_chr_rec.request_id),
6693: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE), NULL, l_def_chr_rec.program_update_date, SYSDATE),
6694: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID), l_def_chr_rec.program_application_id),
6695: PRICE_LIST_ID = l_def_chr_rec.price_list_id,

Line 6692: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID), l_def_chr_rec.request_id),

6688: ORIG_SYSTEM_SOURCE_CODE = l_def_chr_rec.orig_system_source_code,
6689: ORIG_SYSTEM_ID1 = l_def_chr_rec.orig_system_id1,
6690: ORIG_SYSTEM_REFERENCE1 = l_def_chr_rec.orig_system_reference1,
6691: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID), l_def_chr_rec.program_id),
6692: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID), l_def_chr_rec.request_id),
6693: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE), NULL, l_def_chr_rec.program_update_date, SYSDATE),
6694: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID), l_def_chr_rec.program_application_id),
6695: PRICE_LIST_ID = l_def_chr_rec.price_list_id,
6696: PRICING_DATE = l_def_chr_rec.pricing_date,

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

6689: ORIG_SYSTEM_ID1 = l_def_chr_rec.orig_system_id1,
6690: ORIG_SYSTEM_REFERENCE1 = l_def_chr_rec.orig_system_reference1,
6691: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID), l_def_chr_rec.program_id),
6692: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID), l_def_chr_rec.request_id),
6693: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE), NULL, l_def_chr_rec.program_update_date, SYSDATE),
6694: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID), l_def_chr_rec.program_application_id),
6695: PRICE_LIST_ID = l_def_chr_rec.price_list_id,
6696: PRICING_DATE = l_def_chr_rec.pricing_date,
6697: SIGN_BY_DATE = l_def_chr_rec.sign_by_date,

Line 6694: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID), l_def_chr_rec.program_application_id),

6690: ORIG_SYSTEM_REFERENCE1 = l_def_chr_rec.orig_system_reference1,
6691: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID, - 1, NULL, FND_GLOBAL.CONC_PROGRAM_ID), l_def_chr_rec.program_id),
6692: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, FND_GLOBAL.CONC_REQUEST_ID), l_def_chr_rec.request_id),
6693: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID, - 1, NULL, SYSDATE), NULL, l_def_chr_rec.program_update_date, SYSDATE),
6694: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID, - 1, NULL, FND_GLOBAL.PROG_APPL_ID), l_def_chr_rec.program_application_id),
6695: PRICE_LIST_ID = l_def_chr_rec.price_list_id,
6696: PRICING_DATE = l_def_chr_rec.pricing_date,
6697: SIGN_BY_DATE = l_def_chr_rec.sign_by_date,
6698: TOTAL_LINE_LIST_PRICE = l_def_chr_rec.total_line_list_price,

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

7071: okc_debug.LOG('20000: Entered fill_who_columns', 2);
7072: END IF;
7073:
7074: l_chrv_rec.LAST_UPDATE_DATE := SYSDATE;
7075: l_chrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
7076: l_chrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
7077: RETURN(l_chrv_rec);
7078:
7079: END fill_who_columns;

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

7072: END IF;
7073:
7074: l_chrv_rec.LAST_UPDATE_DATE := SYSDATE;
7075: l_chrv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
7076: l_chrv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
7077: RETURN(l_chrv_rec);
7078:
7079: END fill_who_columns;
7080: ----------------------------------