DBA Data[Home] [Help]

APPS.OKL_VIR_PVT dependencies on FND_GLOBAL

Line 1513: l_virv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1509: ) RETURN virv_rec_type IS
1510: l_virv_rec virv_rec_type := p_virv_rec;
1511: BEGIN
1512: l_virv_rec.CREATION_DATE := SYSDATE;
1513: l_virv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1514: l_virv_rec.LAST_UPDATE_DATE := l_virv_rec.CREATION_DATE;
1515: l_virv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1516: l_virv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1517: RETURN(l_virv_rec);

Line 1515: l_virv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1511: BEGIN
1512: l_virv_rec.CREATION_DATE := SYSDATE;
1513: l_virv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1514: l_virv_rec.LAST_UPDATE_DATE := l_virv_rec.CREATION_DATE;
1515: l_virv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1516: l_virv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1517: RETURN(l_virv_rec);
1518: END fill_who_columns;
1519: ---------------------------------------------

Line 1516: l_virv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1512: l_virv_rec.CREATION_DATE := SYSDATE;
1513: l_virv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1514: l_virv_rec.LAST_UPDATE_DATE := l_virv_rec.CREATION_DATE;
1515: l_virv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1516: l_virv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1517: RETURN(l_virv_rec);
1518: END fill_who_columns;
1519: ---------------------------------------------
1520: -- Set_Attributes for:OKL_VAR_INT_PARAMS_V --

Line 1533: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),

1529: x_virv_rec.OBJECT_VERSION_NUMBER := 1;
1530: --start code added by dkagrawa on 20 OCT 2005
1531: IF (x_virv_rec.request_id IS NULL OR x_virv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1532: SELECT
1533: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1534: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1535: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1536: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1537: INTO

Line 1534: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),

1530: --start code added by dkagrawa on 20 OCT 2005
1531: IF (x_virv_rec.request_id IS NULL OR x_virv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1532: SELECT
1533: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1534: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1535: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1536: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1537: INTO
1538: x_virv_rec.request_id,

Line 1535: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

1531: IF (x_virv_rec.request_id IS NULL OR x_virv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1532: SELECT
1533: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1534: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1535: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1536: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1537: INTO
1538: x_virv_rec.request_id,
1539: x_virv_rec.program_application_id,

Line 1536: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)

1532: SELECT
1533: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1534: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1535: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1536: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1537: INTO
1538: x_virv_rec.request_id,
1539: x_virv_rec.program_application_id,
1540: x_virv_rec.program_id,

Line 2496: l_virv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2492: ) RETURN virv_rec_type IS
2493: l_virv_rec virv_rec_type := p_virv_rec;
2494: BEGIN
2495: l_virv_rec.LAST_UPDATE_DATE := SYSDATE;
2496: l_virv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2497: l_virv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2498: RETURN(l_virv_rec);
2499: END fill_who_columns;
2500: ----------------------------------

Line 2497: l_virv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2493: l_virv_rec virv_rec_type := p_virv_rec;
2494: BEGIN
2495: l_virv_rec.LAST_UPDATE_DATE := SYSDATE;
2496: l_virv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2497: l_virv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2498: RETURN(l_virv_rec);
2499: END fill_who_columns;
2500: ----------------------------------
2501: -- FUNCTION populate_new_record --

Line 2691: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),

2687: x_virv_rec := p_virv_rec;
2688: --start code added by dkagrawa on 20 OCT 2005
2689: IF (x_virv_rec.request_id IS NULL OR x_virv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2690: SELECT
2691: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2692: x_virv_rec.request_id),
2693: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2694: x_virv_rec.program_application_id),
2695: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

Line 2693: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),

2689: IF (x_virv_rec.request_id IS NULL OR x_virv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2690: SELECT
2691: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2692: x_virv_rec.request_id),
2693: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2694: x_virv_rec.program_application_id),
2695: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2696: x_virv_rec.program_id),
2697: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),

Line 2695: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

2691: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2692: x_virv_rec.request_id),
2693: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2694: x_virv_rec.program_application_id),
2695: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2696: x_virv_rec.program_id),
2697: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
2698: NULL,x_virv_rec.program_update_date,SYSDATE)
2699: INTO

Line 2697: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),

2693: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2694: x_virv_rec.program_application_id),
2695: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2696: x_virv_rec.program_id),
2697: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
2698: NULL,x_virv_rec.program_update_date,SYSDATE)
2699: INTO
2700: x_virv_rec.request_id,
2701: x_virv_rec.program_application_id,