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_OIA_PVT dependencies on FND_GLOBAL

Line 1506: l_oiav_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1502: ) RETURN oiav_rec_type AS
1503: l_oiav_rec oiav_rec_type := p_oiav_rec;
1504: BEGIN
1505: l_oiav_rec.CREATION_DATE := SYSDATE;
1506: l_oiav_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1507: l_oiav_rec.LAST_UPDATE_DATE := l_oiav_rec.CREATION_DATE;
1508: l_oiav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1509: l_oiav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1510: RETURN(l_oiav_rec);

Line 1508: l_oiav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1504: BEGIN
1505: l_oiav_rec.CREATION_DATE := SYSDATE;
1506: l_oiav_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1507: l_oiav_rec.LAST_UPDATE_DATE := l_oiav_rec.CREATION_DATE;
1508: l_oiav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1509: l_oiav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1510: RETURN(l_oiav_rec);
1511: END fill_who_columns;
1512: --------------------------------------------

Line 1509: l_oiav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1505: l_oiav_rec.CREATION_DATE := SYSDATE;
1506: l_oiav_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1507: l_oiav_rec.LAST_UPDATE_DATE := l_oiav_rec.CREATION_DATE;
1508: l_oiav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1509: l_oiav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1510: RETURN(l_oiav_rec);
1511: END fill_who_columns;
1512: --------------------------------------------
1513: -- Set_Attributes for:OKL_OPEN_INT_ASST_V --

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

1523:
1524: -- Begin Post-Generation Change
1525: IF (x_oiav_rec.request_id IS NULL OR x_oiav_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1526: SELECT
1527: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1528: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1529: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1530: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1531: INTO

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

1524: -- Begin Post-Generation Change
1525: IF (x_oiav_rec.request_id IS NULL OR x_oiav_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1526: SELECT
1527: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1528: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1529: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1530: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1531: INTO
1532: x_oiav_rec.request_id,

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

1525: IF (x_oiav_rec.request_id IS NULL OR x_oiav_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1526: SELECT
1527: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1528: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1529: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1530: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1531: INTO
1532: x_oiav_rec.request_id,
1533: x_oiav_rec.program_application_id,

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

1526: SELECT
1527: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1528: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1529: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1530: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1531: INTO
1532: x_oiav_rec.request_id,
1533: x_oiav_rec.program_application_id,
1534: x_oiav_rec.program_id,

Line 2602: l_oiav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2598: ) RETURN oiav_rec_type AS
2599: l_oiav_rec oiav_rec_type := p_oiav_rec;
2600: BEGIN
2601: l_oiav_rec.LAST_UPDATE_DATE := SYSDATE;
2602: l_oiav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2603: l_oiav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2604: RETURN(l_oiav_rec);
2605: END fill_who_columns;
2606: ----------------------------------

Line 2603: l_oiav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2599: l_oiav_rec oiav_rec_type := p_oiav_rec;
2600: BEGIN
2601: l_oiav_rec.LAST_UPDATE_DATE := SYSDATE;
2602: l_oiav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2603: l_oiav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2604: RETURN(l_oiav_rec);
2605: END fill_who_columns;
2606: ----------------------------------
2607: -- FUNCTION populate_new_record --

Line 2886: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oiav_rec.request_id),

2882: x_oiav_rec := p_oiav_rec;
2883:
2884: -- Begin Post-Generation Change
2885: IF (x_oiav_rec.request_id IS NULL OR x_oiav_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2886: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oiav_rec.request_id),
2887: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oiav_rec.program_application_id),
2888: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oiav_rec.program_id),
2889: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oiav_rec.program_update_date,SYSDATE)
2890: INTO

Line 2887: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oiav_rec.program_application_id),

2883:
2884: -- Begin Post-Generation Change
2885: IF (x_oiav_rec.request_id IS NULL OR x_oiav_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2886: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oiav_rec.request_id),
2887: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oiav_rec.program_application_id),
2888: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oiav_rec.program_id),
2889: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oiav_rec.program_update_date,SYSDATE)
2890: INTO
2891: x_oiav_rec.request_id,

Line 2888: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oiav_rec.program_id),

2884: -- Begin Post-Generation Change
2885: IF (x_oiav_rec.request_id IS NULL OR x_oiav_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2886: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oiav_rec.request_id),
2887: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oiav_rec.program_application_id),
2888: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oiav_rec.program_id),
2889: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oiav_rec.program_update_date,SYSDATE)
2890: INTO
2891: x_oiav_rec.request_id,
2892: x_oiav_rec.program_application_id,

Line 2889: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oiav_rec.program_update_date,SYSDATE)

2885: IF (x_oiav_rec.request_id IS NULL OR x_oiav_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2886: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oiav_rec.request_id),
2887: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oiav_rec.program_application_id),
2888: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oiav_rec.program_id),
2889: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oiav_rec.program_update_date,SYSDATE)
2890: INTO
2891: x_oiav_rec.request_id,
2892: x_oiav_rec.program_application_id,
2893: x_oiav_rec.program_id,