DBA Data[Home] [Help]

APPS.OKC_CLE_PVT dependencies on FND_GLOBAL

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

5066: l_cle_rec.upg_orig_system_ref_id,
5067: l_cle_rec.orig_system_source_code,
5068: l_cle_rec.orig_system_id1,
5069: l_cle_rec.orig_system_reference1,
5070: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
5071: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
5072: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
5073: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
5074: l_cle_rec.price_list_id,

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

5067: l_cle_rec.orig_system_source_code,
5068: l_cle_rec.orig_system_id1,
5069: l_cle_rec.orig_system_reference1,
5070: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
5071: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
5072: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
5073: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
5074: l_cle_rec.price_list_id,
5075: l_cle_rec.pricing_date,

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

5068: l_cle_rec.orig_system_id1,
5069: l_cle_rec.orig_system_reference1,
5070: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
5071: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
5072: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
5073: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
5074: l_cle_rec.price_list_id,
5075: l_cle_rec.pricing_date,
5076: l_cle_rec.price_list_line_id,

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

5069: l_cle_rec.orig_system_reference1,
5070: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
5071: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
5072: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
5073: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
5074: l_cle_rec.price_list_id,
5075: l_cle_rec.pricing_date,
5076: l_cle_rec.price_list_line_id,
5077: l_cle_rec.line_list_price,

Line 5389: l_clev_rec.CREATED_BY := FND_GLOBAL.USER_ID;

5385: l_clev_rec clev_rec_type := p_clev_rec;
5386: BEGIN
5387:
5388: l_clev_rec.CREATION_DATE := SYSDATE;
5389: l_clev_rec.CREATED_BY := FND_GLOBAL.USER_ID;
5390: l_clev_rec.LAST_UPDATE_DATE := l_clev_rec.CREATION_DATE;
5391: l_clev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
5392: l_clev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
5393:

Line 5391: l_clev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

5387:
5388: l_clev_rec.CREATION_DATE := SYSDATE;
5389: l_clev_rec.CREATED_BY := FND_GLOBAL.USER_ID;
5390: l_clev_rec.LAST_UPDATE_DATE := l_clev_rec.CREATION_DATE;
5391: l_clev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
5392: l_clev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
5393:
5394: RETURN(l_clev_rec);
5395:

Line 5392: l_clev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

5388: l_clev_rec.CREATION_DATE := SYSDATE;
5389: l_clev_rec.CREATED_BY := FND_GLOBAL.USER_ID;
5390: l_clev_rec.LAST_UPDATE_DATE := l_clev_rec.CREATION_DATE;
5391: l_clev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
5392: l_clev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
5393:
5394: RETURN(l_clev_rec);
5395:
5396: END fill_who_columns;

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

6739: UPG_ORIG_SYSTEM_REF_ID = l_def_cle_rec.upg_orig_system_ref_id,
6740: ORIG_SYSTEM_SOURCE_CODE = l_def_cle_rec.orig_system_source_code,
6741: ORIG_SYSTEM_ID1 = l_def_cle_rec.orig_system_id1,
6742: ORIG_SYSTEM_REFERENCE1 = l_def_cle_rec.orig_system_reference1,
6743: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_cle_rec.program_id),
6744: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_cle_rec.request_id),
6745: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_cle_rec.program_update_date,SYSDATE),
6746: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_cle_rec.program_application_id),
6747: PRICE_LIST_ID = l_def_cle_rec.PRICE_LIST_ID,

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

6740: ORIG_SYSTEM_SOURCE_CODE = l_def_cle_rec.orig_system_source_code,
6741: ORIG_SYSTEM_ID1 = l_def_cle_rec.orig_system_id1,
6742: ORIG_SYSTEM_REFERENCE1 = l_def_cle_rec.orig_system_reference1,
6743: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_cle_rec.program_id),
6744: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_cle_rec.request_id),
6745: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_cle_rec.program_update_date,SYSDATE),
6746: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_cle_rec.program_application_id),
6747: PRICE_LIST_ID = l_def_cle_rec.PRICE_LIST_ID,
6748: PRICING_DATE = l_def_cle_rec.PRICING_DATE,

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

6741: ORIG_SYSTEM_ID1 = l_def_cle_rec.orig_system_id1,
6742: ORIG_SYSTEM_REFERENCE1 = l_def_cle_rec.orig_system_reference1,
6743: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_cle_rec.program_id),
6744: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_cle_rec.request_id),
6745: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_cle_rec.program_update_date,SYSDATE),
6746: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_cle_rec.program_application_id),
6747: PRICE_LIST_ID = l_def_cle_rec.PRICE_LIST_ID,
6748: PRICING_DATE = l_def_cle_rec.PRICING_DATE,
6749: PRICE_LIST_LINE_ID = l_def_cle_rec.PRICE_LIST_LINE_ID,

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

6742: ORIG_SYSTEM_REFERENCE1 = l_def_cle_rec.orig_system_reference1,
6743: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_cle_rec.program_id),
6744: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_cle_rec.request_id),
6745: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_cle_rec.program_update_date,SYSDATE),
6746: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_cle_rec.program_application_id),
6747: PRICE_LIST_ID = l_def_cle_rec.PRICE_LIST_ID,
6748: PRICING_DATE = l_def_cle_rec.PRICING_DATE,
6749: PRICE_LIST_LINE_ID = l_def_cle_rec.PRICE_LIST_LINE_ID,
6750: LINE_LIST_PRICE = l_def_cle_rec.LINE_LIST_PRICE,

Line 7135: l_clev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

7131: l_clev_rec clev_rec_type := p_clev_rec;
7132: BEGIN
7133:
7134: l_clev_rec.LAST_UPDATE_DATE := SYSDATE;
7135: l_clev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
7136: l_clev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
7137: RETURN(l_clev_rec);
7138:
7139: END fill_who_columns;

Line 7136: l_clev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

7132: BEGIN
7133:
7134: l_clev_rec.LAST_UPDATE_DATE := SYSDATE;
7135: l_clev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
7136: l_clev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
7137: RETURN(l_clev_rec);
7138:
7139: END fill_who_columns;
7140: ----------------------------------