DBA Data[Home] [Help]

APPS.OKL_POC_PVT dependencies on FND_GLOBAL

Line 1686: l_pocv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1682: ) RETURN pocv_rec_type IS
1683: l_pocv_rec pocv_rec_type := p_pocv_rec;
1684: BEGIN
1685: l_pocv_rec.CREATION_DATE := SYSDATE;
1686: l_pocv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1687: l_pocv_rec.LAST_UPDATE_DATE := l_pocv_rec.CREATION_DATE;
1688: l_pocv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1689: l_pocv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1690: RETURN(l_pocv_rec);

Line 1688: l_pocv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1684: BEGIN
1685: l_pocv_rec.CREATION_DATE := SYSDATE;
1686: l_pocv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1687: l_pocv_rec.LAST_UPDATE_DATE := l_pocv_rec.CREATION_DATE;
1688: l_pocv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1689: l_pocv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1690: RETURN(l_pocv_rec);
1691: END fill_who_columns;
1692: ----------------------------------------------

Line 1689: l_pocv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1685: l_pocv_rec.CREATION_DATE := SYSDATE;
1686: l_pocv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1687: l_pocv_rec.LAST_UPDATE_DATE := l_pocv_rec.CREATION_DATE;
1688: l_pocv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1689: l_pocv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1690: RETURN(l_pocv_rec);
1691: END fill_who_columns;
1692: ----------------------------------------------
1693: -- Set_Attributes for:OKL_POOL_CONTENTS_V --

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

1701: x_pocv_rec := p_pocv_rec;
1702: x_pocv_rec.OBJECT_VERSION_NUMBER := 1;
1703:
1704: -- concurrent program columns
1705: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),
1706: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),
1707: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),
1708: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1709: INTO x_pocv_rec.REQUEST_ID

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

1702: x_pocv_rec.OBJECT_VERSION_NUMBER := 1;
1703:
1704: -- concurrent program columns
1705: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),
1706: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),
1707: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),
1708: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1709: INTO x_pocv_rec.REQUEST_ID
1710: ,x_pocv_rec.PROGRAM_APPLICATION_ID

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

1703:
1704: -- concurrent program columns
1705: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),
1706: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),
1707: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),
1708: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1709: INTO x_pocv_rec.REQUEST_ID
1710: ,x_pocv_rec.PROGRAM_APPLICATION_ID
1711: ,x_pocv_rec.PROGRAM_ID

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

1704: -- concurrent program columns
1705: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL,Fnd_Global.CONC_REQUEST_ID),
1706: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL,Fnd_Global.PROG_APPL_ID),
1707: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL,Fnd_Global.CONC_PROGRAM_ID),
1708: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1709: INTO x_pocv_rec.REQUEST_ID
1710: ,x_pocv_rec.PROGRAM_APPLICATION_ID
1711: ,x_pocv_rec.PROGRAM_ID
1712: ,x_pocv_rec.PROGRAM_UPDATE_DATE

Line 2667: l_pocv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2663: ) RETURN pocv_rec_type IS
2664: l_pocv_rec pocv_rec_type := p_pocv_rec;
2665: BEGIN
2666: l_pocv_rec.LAST_UPDATE_DATE := SYSDATE;
2667: l_pocv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2668: l_pocv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2669: RETURN(l_pocv_rec);
2670: END fill_who_columns;
2671: ----------------------------------

Line 2668: l_pocv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2664: l_pocv_rec pocv_rec_type := p_pocv_rec;
2665: BEGIN
2666: l_pocv_rec.LAST_UPDATE_DATE := SYSDATE;
2667: l_pocv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2668: l_pocv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2669: RETURN(l_pocv_rec);
2670: END fill_who_columns;
2671: ----------------------------------
2672: -- FUNCTION populate_new_record --