DBA Data[Home] [Help]

APPS.OKL_VIP_PVT dependencies on FND_GLOBAL

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

835: x_vip_rec.OBJECT_VERSION_NUMBER := 1;
836:
837: IF (x_vip_rec.request_id IS NULL OR x_vip_rec.request_id = Okl_Api.G_MISS_NUM) THEN
838: SELECT
839: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
840: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
841: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
842: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
843: INTO

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

836:
837: IF (x_vip_rec.request_id IS NULL OR x_vip_rec.request_id = Okl_Api.G_MISS_NUM) THEN
838: SELECT
839: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
840: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
841: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
842: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
843: INTO
844: x_vip_rec.request_id,

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

837: IF (x_vip_rec.request_id IS NULL OR x_vip_rec.request_id = Okl_Api.G_MISS_NUM) THEN
838: SELECT
839: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
840: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
841: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
842: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
843: INTO
844: x_vip_rec.request_id,
845: x_vip_rec.program_application_id,

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

838: SELECT
839: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
840: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
841: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
842: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
843: INTO
844: x_vip_rec.request_id,
845: x_vip_rec.program_application_id,
846: x_vip_rec.program_id,

Line 1002: l_vipv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

998: ) RETURN vipv_rec_type IS
999: l_vipv_rec vipv_rec_type := p_vipv_rec;
1000: BEGIN
1001: l_vipv_rec.CREATION_DATE := SYSDATE;
1002: l_vipv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1003: l_vipv_rec.LAST_UPDATE_DATE := l_vipv_rec.CREATION_DATE;
1004: l_vipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1005: l_vipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1006: RETURN(l_vipv_rec);

Line 1004: l_vipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1000: BEGIN
1001: l_vipv_rec.CREATION_DATE := SYSDATE;
1002: l_vipv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1003: l_vipv_rec.LAST_UPDATE_DATE := l_vipv_rec.CREATION_DATE;
1004: l_vipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1005: l_vipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1006: RETURN(l_vipv_rec);
1007: END fill_who_columns;
1008: ----------------------------------------------

Line 1005: l_vipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1001: l_vipv_rec.CREATION_DATE := SYSDATE;
1002: l_vipv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1003: l_vipv_rec.LAST_UPDATE_DATE := l_vipv_rec.CREATION_DATE;
1004: l_vipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1005: l_vipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1006: RETURN(l_vipv_rec);
1007: END fill_who_columns;
1008: ----------------------------------------------
1009: -- Set_Attributes for:OKL_VAR_INT_PROCESS_V --

Line 1764: l_vipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1760: ) RETURN vipv_rec_type IS
1761: l_vipv_rec vipv_rec_type := p_vipv_rec;
1762: BEGIN
1763: l_vipv_rec.LAST_UPDATE_DATE := SYSDATE;
1764: l_vipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1765: l_vipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1766: RETURN(l_vipv_rec);
1767: END fill_who_columns;
1768: ----------------------------------

Line 1765: l_vipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1761: l_vipv_rec vipv_rec_type := p_vipv_rec;
1762: BEGIN
1763: l_vipv_rec.LAST_UPDATE_DATE := SYSDATE;
1764: l_vipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1765: l_vipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1766: RETURN(l_vipv_rec);
1767: END fill_who_columns;
1768: ----------------------------------
1769: -- FUNCTION populate_new_record --