DBA Data[Home] [Help]

APPS.OKL_POX_PVT dependencies on FND_GLOBAL

Line 1586: l_poxv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1582: ) RETURN poxv_rec_type IS
1583: l_poxv_rec poxv_rec_type := p_poxv_rec;
1584: BEGIN
1585: l_poxv_rec.CREATION_DATE := SYSDATE;
1586: l_poxv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1587: l_poxv_rec.LAST_UPDATE_DATE := l_poxv_rec.CREATION_DATE;
1588: l_poxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1589: l_poxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1590: RETURN(l_poxv_rec);

Line 1588: l_poxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1584: BEGIN
1585: l_poxv_rec.CREATION_DATE := SYSDATE;
1586: l_poxv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1587: l_poxv_rec.LAST_UPDATE_DATE := l_poxv_rec.CREATION_DATE;
1588: l_poxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1589: l_poxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1590: RETURN(l_poxv_rec);
1591: END fill_who_columns;
1592: ----------------------------------------------

Line 1589: l_poxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1585: l_poxv_rec.CREATION_DATE := SYSDATE;
1586: l_poxv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1587: l_poxv_rec.LAST_UPDATE_DATE := l_poxv_rec.CREATION_DATE;
1588: l_poxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1589: l_poxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1590: RETURN(l_poxv_rec);
1591: END fill_who_columns;
1592: ----------------------------------------------
1593: -- Set_Attributes for:OKL_POOL_TRANSACTIONS_V --

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

1601: x_poxv_rec := p_poxv_rec;
1602: x_poxv_rec.OBJECT_VERSION_NUMBER := 1;
1603:
1604: -- concurrent program columns
1605: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),
1606: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),
1607: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),
1608: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1609: INTO x_poxv_rec.REQUEST_ID

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

1602: x_poxv_rec.OBJECT_VERSION_NUMBER := 1;
1603:
1604: -- concurrent program columns
1605: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),
1606: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),
1607: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),
1608: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1609: INTO x_poxv_rec.REQUEST_ID
1610: ,x_poxv_rec.PROGRAM_APPLICATION_ID

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

1603:
1604: -- concurrent program columns
1605: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),
1606: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),
1607: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),
1608: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1609: INTO x_poxv_rec.REQUEST_ID
1610: ,x_poxv_rec.PROGRAM_APPLICATION_ID
1611: ,x_poxv_rec.PROGRAM_ID

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

1604: -- concurrent program columns
1605: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),
1606: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),
1607: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),
1608: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1609: INTO x_poxv_rec.REQUEST_ID
1610: ,x_poxv_rec.PROGRAM_APPLICATION_ID
1611: ,x_poxv_rec.PROGRAM_ID
1612: ,x_poxv_rec.PROGRAM_UPDATE_DATE

Line 2568: l_poxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2564: ) RETURN poxv_rec_type IS
2565: l_poxv_rec poxv_rec_type := p_poxv_rec;
2566: BEGIN
2567: l_poxv_rec.LAST_UPDATE_DATE := SYSDATE;
2568: l_poxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2569: l_poxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2570: RETURN(l_poxv_rec);
2571: END fill_who_columns;
2572: ----------------------------------

Line 2569: l_poxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2565: l_poxv_rec poxv_rec_type := p_poxv_rec;
2566: BEGIN
2567: l_poxv_rec.LAST_UPDATE_DATE := SYSDATE;
2568: l_poxv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2569: l_poxv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2570: RETURN(l_poxv_rec);
2571: END fill_who_columns;
2572: ----------------------------------
2573: -- FUNCTION populate_new_record --