DBA Data[Home] [Help]

APPS.OKL_ACD_PVT dependencies on FND_GLOBAL

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

1440: /* l_acd_rec.request_id,
1441: l_acd_rec.program_application_id,
1442: l_acd_rec.program_id,
1443: l_acd_rec.program_update_date,*/
1444: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1445: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1446: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1447: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1448: l_acd_rec.attribute_category,

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

1441: l_acd_rec.program_application_id,
1442: l_acd_rec.program_id,
1443: l_acd_rec.program_update_date,*/
1444: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1445: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1446: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1447: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1448: l_acd_rec.attribute_category,
1449: l_acd_rec.attribute1,

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

1442: l_acd_rec.program_id,
1443: l_acd_rec.program_update_date,*/
1444: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1445: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1446: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1447: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1448: l_acd_rec.attribute_category,
1449: l_acd_rec.attribute1,
1450: l_acd_rec.attribute2,

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

1443: l_acd_rec.program_update_date,*/
1444: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1445: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1446: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1447: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
1448: l_acd_rec.attribute_category,
1449: l_acd_rec.attribute1,
1450: l_acd_rec.attribute2,
1451: l_acd_rec.attribute3,

Line 1536: l_acdv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1532: ) RETURN acdv_rec_type IS
1533: l_acdv_rec acdv_rec_type := p_acdv_rec;
1534: BEGIN
1535: l_acdv_rec.CREATION_DATE := SYSDATE;
1536: l_acdv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1537: l_acdv_rec.LAST_UPDATE_DATE := l_acdv_rec.CREATION_DATE;
1538: l_acdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1539: l_acdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1540: RETURN(l_acdv_rec);

Line 1538: l_acdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1534: BEGIN
1535: l_acdv_rec.CREATION_DATE := SYSDATE;
1536: l_acdv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1537: l_acdv_rec.LAST_UPDATE_DATE := l_acdv_rec.CREATION_DATE;
1538: l_acdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1539: l_acdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1540: RETURN(l_acdv_rec);
1541: END fill_who_columns;
1542: -------------------------------------------

Line 1539: l_acdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1535: l_acdv_rec.CREATION_DATE := SYSDATE;
1536: l_acdv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1537: l_acdv_rec.LAST_UPDATE_DATE := l_acdv_rec.CREATION_DATE;
1538: l_acdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1539: l_acdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1540: RETURN(l_acdv_rec);
1541: END fill_who_columns;
1542: -------------------------------------------
1543: -- Set_Attributes for:OKL_ASSET_CNDTNS_V --

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

2256: /* REQUEST_ID = l_def_acd_rec.request_id,
2257: PROGRAM_APPLICATION_ID = l_def_acd_rec.program_application_id,
2258: PROGRAM_ID = l_def_acd_rec.program_id,
2259: PROGRAM_UPDATE_DATE = l_def_acd_rec.program_update_date,*/
2260: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_acd_rec.request_id),
2261: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_acd_rec.program_application_id),
2262: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_acd_rec.program_id),
2263: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_acd_rec.program_update_date,SYSDATE),
2264: ATTRIBUTE_CATEGORY = l_def_acd_rec.attribute_category,

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

2257: PROGRAM_APPLICATION_ID = l_def_acd_rec.program_application_id,
2258: PROGRAM_ID = l_def_acd_rec.program_id,
2259: PROGRAM_UPDATE_DATE = l_def_acd_rec.program_update_date,*/
2260: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_acd_rec.request_id),
2261: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_acd_rec.program_application_id),
2262: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_acd_rec.program_id),
2263: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_acd_rec.program_update_date,SYSDATE),
2264: ATTRIBUTE_CATEGORY = l_def_acd_rec.attribute_category,
2265: ATTRIBUTE1 = l_def_acd_rec.attribute1,

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

2258: PROGRAM_ID = l_def_acd_rec.program_id,
2259: PROGRAM_UPDATE_DATE = l_def_acd_rec.program_update_date,*/
2260: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_acd_rec.request_id),
2261: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_acd_rec.program_application_id),
2262: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_acd_rec.program_id),
2263: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_acd_rec.program_update_date,SYSDATE),
2264: ATTRIBUTE_CATEGORY = l_def_acd_rec.attribute_category,
2265: ATTRIBUTE1 = l_def_acd_rec.attribute1,
2266: ATTRIBUTE2 = l_def_acd_rec.attribute2,

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

2259: PROGRAM_UPDATE_DATE = l_def_acd_rec.program_update_date,*/
2260: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_acd_rec.request_id),
2261: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_acd_rec.program_application_id),
2262: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_acd_rec.program_id),
2263: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_acd_rec.program_update_date,SYSDATE),
2264: ATTRIBUTE_CATEGORY = l_def_acd_rec.attribute_category,
2265: ATTRIBUTE1 = l_def_acd_rec.attribute1,
2266: ATTRIBUTE2 = l_def_acd_rec.attribute2,
2267: ATTRIBUTE3 = l_def_acd_rec.attribute3,

Line 2353: l_acdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2349: ) RETURN acdv_rec_type IS
2350: l_acdv_rec acdv_rec_type := p_acdv_rec;
2351: BEGIN
2352: l_acdv_rec.LAST_UPDATE_DATE := SYSDATE;
2353: l_acdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2354: l_acdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2355: RETURN(l_acdv_rec);
2356: END fill_who_columns;
2357: ----------------------------------

Line 2354: l_acdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2350: l_acdv_rec acdv_rec_type := p_acdv_rec;
2351: BEGIN
2352: l_acdv_rec.LAST_UPDATE_DATE := SYSDATE;
2353: l_acdv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2354: l_acdv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2355: RETURN(l_acdv_rec);
2356: END fill_who_columns;
2357: ----------------------------------
2358: -- FUNCTION populate_new_record --