DBA Data[Home] [Help]

APPS.OKL_VIR_PVT dependencies on FND_GLOBAL

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

1543: ) RETURN virv_rec_type IS
1544: l_virv_rec virv_rec_type := p_virv_rec;
1545: BEGIN
1546: l_virv_rec.CREATION_DATE := SYSDATE;
1547: l_virv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1548: l_virv_rec.LAST_UPDATE_DATE := l_virv_rec.CREATION_DATE;
1549: l_virv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1550: l_virv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1551: RETURN(l_virv_rec);

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

1545: BEGIN
1546: l_virv_rec.CREATION_DATE := SYSDATE;
1547: l_virv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1548: l_virv_rec.LAST_UPDATE_DATE := l_virv_rec.CREATION_DATE;
1549: l_virv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1550: l_virv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1551: RETURN(l_virv_rec);
1552: END fill_who_columns;
1553: ---------------------------------------------

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

1546: l_virv_rec.CREATION_DATE := SYSDATE;
1547: l_virv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1548: l_virv_rec.LAST_UPDATE_DATE := l_virv_rec.CREATION_DATE;
1549: l_virv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1550: l_virv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1551: RETURN(l_virv_rec);
1552: END fill_who_columns;
1553: ---------------------------------------------
1554: -- Set_Attributes for:OKL_VAR_INT_PARAMS_V --

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

1563: x_virv_rec.OBJECT_VERSION_NUMBER := 1;
1564: --start code added by dkagrawa on 20 OCT 2005
1565: IF (x_virv_rec.request_id IS NULL OR x_virv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1566: SELECT
1567: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1568: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1569: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1570: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1571: INTO

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

1564: --start code added by dkagrawa on 20 OCT 2005
1565: IF (x_virv_rec.request_id IS NULL OR x_virv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1566: SELECT
1567: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1568: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1569: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1570: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1571: INTO
1572: x_virv_rec.request_id,

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

1565: IF (x_virv_rec.request_id IS NULL OR x_virv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1566: SELECT
1567: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1568: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1569: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1570: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1571: INTO
1572: x_virv_rec.request_id,
1573: x_virv_rec.program_application_id,

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

1566: SELECT
1567: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1568: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1569: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1570: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1571: INTO
1572: x_virv_rec.request_id,
1573: x_virv_rec.program_application_id,
1574: x_virv_rec.program_id,

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

2540: ) RETURN virv_rec_type IS
2541: l_virv_rec virv_rec_type := p_virv_rec;
2542: BEGIN
2543: l_virv_rec.LAST_UPDATE_DATE := SYSDATE;
2544: l_virv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2545: l_virv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2546: RETURN(l_virv_rec);
2547: END fill_who_columns;
2548: ----------------------------------

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

2541: l_virv_rec virv_rec_type := p_virv_rec;
2542: BEGIN
2543: l_virv_rec.LAST_UPDATE_DATE := SYSDATE;
2544: l_virv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2545: l_virv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2546: RETURN(l_virv_rec);
2547: END fill_who_columns;
2548: ----------------------------------
2549: -- FUNCTION populate_new_record --

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

2747: x_virv_rec := p_virv_rec;
2748: --start code added by dkagrawa on 20 OCT 2005
2749: IF (x_virv_rec.request_id IS NULL OR x_virv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2750: SELECT
2751: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2752: x_virv_rec.request_id),
2753: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2754: x_virv_rec.program_application_id),
2755: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

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

2749: IF (x_virv_rec.request_id IS NULL OR x_virv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2750: SELECT
2751: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2752: x_virv_rec.request_id),
2753: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2754: x_virv_rec.program_application_id),
2755: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2756: x_virv_rec.program_id),
2757: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),

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

2751: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2752: x_virv_rec.request_id),
2753: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2754: x_virv_rec.program_application_id),
2755: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2756: x_virv_rec.program_id),
2757: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
2758: NULL,x_virv_rec.program_update_date,SYSDATE)
2759: INTO

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

2753: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
2754: x_virv_rec.program_application_id),
2755: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
2756: x_virv_rec.program_id),
2757: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
2758: NULL,x_virv_rec.program_update_date,SYSDATE)
2759: INTO
2760: x_virv_rec.request_id,
2761: x_virv_rec.program_application_id,