eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_STM_PVT dependencies on FND_GLOBAL

Line 1915: l_stmv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1911: ) RETURN stmv_rec_type IS
1912: l_stmv_rec stmv_rec_type := p_stmv_rec;
1913: BEGIN
1914: l_stmv_rec.CREATION_DATE := SYSDATE;
1915: l_stmv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1916: l_stmv_rec.LAST_UPDATE_DATE := SYSDATE;
1917: l_stmv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1918: l_stmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1919: RETURN(l_stmv_rec);

Line 1917: l_stmv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1913: BEGIN
1914: l_stmv_rec.CREATION_DATE := SYSDATE;
1915: l_stmv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1916: l_stmv_rec.LAST_UPDATE_DATE := SYSDATE;
1917: l_stmv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1918: l_stmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1919: RETURN(l_stmv_rec);
1920: END fill_who_columns;
1921: --------------------------------------

Line 1918: l_stmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1914: l_stmv_rec.CREATION_DATE := SYSDATE;
1915: l_stmv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1916: l_stmv_rec.LAST_UPDATE_DATE := SYSDATE;
1917: l_stmv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1918: l_stmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1919: RETURN(l_stmv_rec);
1920: END fill_who_columns;
1921: --------------------------------------
1922: -- Set_Attributes for:OKL_STREAMS_V --

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

1928: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1929: BEGIN
1930: x_stmv_rec := p_stmv_rec;
1931: x_stmv_rec.OBJECT_VERSION_NUMBER := 1;
1932: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1933: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1934: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1935: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1936: INTO x_stmv_rec.REQUEST_ID

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

1929: BEGIN
1930: x_stmv_rec := p_stmv_rec;
1931: x_stmv_rec.OBJECT_VERSION_NUMBER := 1;
1932: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1933: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1934: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1935: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1936: INTO x_stmv_rec.REQUEST_ID
1937: ,x_stmv_rec.PROGRAM_APPLICATION_ID

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

1930: x_stmv_rec := p_stmv_rec;
1931: x_stmv_rec.OBJECT_VERSION_NUMBER := 1;
1932: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1933: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1934: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1935: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1936: INTO x_stmv_rec.REQUEST_ID
1937: ,x_stmv_rec.PROGRAM_APPLICATION_ID
1938: ,x_stmv_rec.PROGRAM_ID

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

1931: x_stmv_rec.OBJECT_VERSION_NUMBER := 1;
1932: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
1933: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
1934: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
1935: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
1936: INTO x_stmv_rec.REQUEST_ID
1937: ,x_stmv_rec.PROGRAM_APPLICATION_ID
1938: ,x_stmv_rec.PROGRAM_ID
1939: ,x_stmv_rec.PROGRAM_UPDATE_DATE

Line 2208: l_created_by := FND_GLOBAL.USER_ID;

2204: BEGIN
2205: x_return_Status := OKC_API.G_RET_STS_SUCCESS;
2206: i := p_stmv_tbl.FIRST; j:=0;
2207: --Assigning the values for the who columns
2208: l_created_by := FND_GLOBAL.USER_ID;
2209: l_last_updated_by := FND_GLOBAL.USER_ID;
2210: l_creation_date := SYSDATE;
2211: l_last_update_date := SYSDATE;
2212: l_last_update_login := FND_GLOBAL.LOGIN_ID;

Line 2209: l_last_updated_by := FND_GLOBAL.USER_ID;

2205: x_return_Status := OKC_API.G_RET_STS_SUCCESS;
2206: i := p_stmv_tbl.FIRST; j:=0;
2207: --Assigning the values for the who columns
2208: l_created_by := FND_GLOBAL.USER_ID;
2209: l_last_updated_by := FND_GLOBAL.USER_ID;
2210: l_creation_date := SYSDATE;
2211: l_last_update_date := SYSDATE;
2212: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2213: --Bug -End of Changes

Line 2212: l_last_update_login := FND_GLOBAL.LOGIN_ID;

2208: l_created_by := FND_GLOBAL.USER_ID;
2209: l_last_updated_by := FND_GLOBAL.USER_ID;
2210: l_creation_date := SYSDATE;
2211: l_last_update_date := SYSDATE;
2212: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2213: --Bug -End of Changes
2214:
2215: WHILE i is not null LOOP
2216: j:=j+1;

Line 2942: l_stmv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2938: ) RETURN stmv_rec_type IS
2939: l_stmv_rec stmv_rec_type := p_stmv_rec;
2940: BEGIN
2941: l_stmv_rec.LAST_UPDATE_DATE := SYSDATE;
2942: l_stmv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2943: l_stmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2944: RETURN(l_stmv_rec);
2945: END fill_who_columns;
2946: ----------------------------------

Line 2943: l_stmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2939: l_stmv_rec stmv_rec_type := p_stmv_rec;
2940: BEGIN
2941: l_stmv_rec.LAST_UPDATE_DATE := SYSDATE;
2942: l_stmv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2943: l_stmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2944: RETURN(l_stmv_rec);
2945: END fill_who_columns;
2946: ----------------------------------
2947: -- FUNCTION populate_new_record --

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

3133: x_stmv_rec := p_stmv_rec;
3134: x_stmv_rec.OBJECT_VERSION_NUMBER := NVL(x_stmv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
3135:
3136: /***** Concurrent Manager columns assignement ************/
3137: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID)
3138: ,p_stmv_rec.REQUEST_ID)
3139: ,NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID)
3140: ,p_stmv_rec.PROGRAM_APPLICATION_ID)
3141: ,NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID)

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

3135:
3136: /***** Concurrent Manager columns assignement ************/
3137: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID)
3138: ,p_stmv_rec.REQUEST_ID)
3139: ,NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID)
3140: ,p_stmv_rec.PROGRAM_APPLICATION_ID)
3141: ,NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID)
3142: ,p_stmv_rec.PROGRAM_ID)
3143: ,DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)

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

3137: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID)
3138: ,p_stmv_rec.REQUEST_ID)
3139: ,NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID)
3140: ,p_stmv_rec.PROGRAM_APPLICATION_ID)
3141: ,NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID)
3142: ,p_stmv_rec.PROGRAM_ID)
3143: ,DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
3144: ,NULL,p_stmv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
3145: INTO x_stmv_rec.REQUEST_ID

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

3139: ,NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID)
3140: ,p_stmv_rec.PROGRAM_APPLICATION_ID)
3141: ,NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID)
3142: ,p_stmv_rec.PROGRAM_ID)
3143: ,DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
3144: ,NULL,p_stmv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
3145: INTO x_stmv_rec.REQUEST_ID
3146: ,x_stmv_rec.PROGRAM_APPLICATION_ID
3147: ,x_stmv_rec.PROGRAM_ID