DBA Data[Home] [Help]

APPS.OKL_XPI_PVT dependencies on FND_GLOBAL

Line 1867: l_xpiv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1863: ) RETURN xpiv_rec_type IS
1864: l_xpiv_rec xpiv_rec_type := p_xpiv_rec;
1865: BEGIN
1866: l_xpiv_rec.CREATION_DATE := SYSDATE;
1867: l_xpiv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1868: l_xpiv_rec.LAST_UPDATE_DATE := l_xpiv_rec.CREATION_DATE; -- PostGen-10
1869: l_xpiv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1870: l_xpiv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1871: RETURN(l_xpiv_rec);

Line 1869: l_xpiv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1865: BEGIN
1866: l_xpiv_rec.CREATION_DATE := SYSDATE;
1867: l_xpiv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1868: l_xpiv_rec.LAST_UPDATE_DATE := l_xpiv_rec.CREATION_DATE; -- PostGen-10
1869: l_xpiv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1870: l_xpiv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1871: RETURN(l_xpiv_rec);
1872: END fill_who_columns;
1873: -------------------------------------------

Line 1870: l_xpiv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1866: l_xpiv_rec.CREATION_DATE := SYSDATE;
1867: l_xpiv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1868: l_xpiv_rec.LAST_UPDATE_DATE := l_xpiv_rec.CREATION_DATE; -- PostGen-10
1869: l_xpiv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1870: l_xpiv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1871: RETURN(l_xpiv_rec);
1872: END fill_who_columns;
1873: -------------------------------------------
1874: -- Set_Attributes for:OKL_EXT_PAY_INVS_V --

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

1884: x_xpiv_rec.SFWT_FLAG := 'N';
1885:
1886: -- Begin PostGen-7
1887: SELECT
1888: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1889: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
1890: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1891: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1892: INTO

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

1885:
1886: -- Begin PostGen-7
1887: SELECT
1888: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1889: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
1890: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1891: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1892: INTO
1893: x_xpiv_rec.request_id,

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

1886: -- Begin PostGen-7
1887: SELECT
1888: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1889: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
1890: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1891: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1892: INTO
1893: x_xpiv_rec.request_id,
1894: x_xpiv_rec.program_application_id,

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

1887: SELECT
1888: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1889: DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
1890: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1891: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1892: INTO
1893: x_xpiv_rec.request_id,
1894: x_xpiv_rec.program_application_id,
1895: x_xpiv_rec.program_id,

Line 3051: l_xpiv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

3047: ) RETURN xpiv_rec_type IS
3048: l_xpiv_rec xpiv_rec_type := p_xpiv_rec;
3049: BEGIN
3050: l_xpiv_rec.LAST_UPDATE_DATE := SYSDATE;
3051: l_xpiv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3052: l_xpiv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3053: RETURN(l_xpiv_rec);
3054: END fill_who_columns;
3055: ----------------------------------

Line 3052: l_xpiv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

3048: l_xpiv_rec xpiv_rec_type := p_xpiv_rec;
3049: BEGIN
3050: l_xpiv_rec.LAST_UPDATE_DATE := SYSDATE;
3051: l_xpiv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3052: l_xpiv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3053: RETURN(l_xpiv_rec);
3054: END fill_who_columns;
3055: ----------------------------------
3056: -- FUNCTION populate_new_record --

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

3320: x_xpiv_rec.OBJECT_VERSION_NUMBER := NVL(x_xpiv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
3321:
3322: -- Begin PostGen-7
3323: SELECT
3324: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3325: x_xpiv_rec.request_id),
3326: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3327: x_xpiv_rec.program_application_id),
3328: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

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

3322: -- Begin PostGen-7
3323: SELECT
3324: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3325: x_xpiv_rec.request_id),
3326: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3327: x_xpiv_rec.program_application_id),
3328: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3329: x_xpiv_rec.program_id),
3330: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),

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

3324: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3325: x_xpiv_rec.request_id),
3326: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3327: x_xpiv_rec.program_application_id),
3328: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3329: x_xpiv_rec.program_id),
3330: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3331: NULL,x_xpiv_rec.program_update_date,SYSDATE)
3332: INTO

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

3326: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID),
3327: x_xpiv_rec.program_application_id),
3328: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3329: x_xpiv_rec.program_id),
3330: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3331: NULL,x_xpiv_rec.program_update_date,SYSDATE)
3332: INTO
3333: x_xpiv_rec.request_id,
3334: x_xpiv_rec.program_application_id,