DBA Data[Home] [Help]

APPS.OKL_AEL_PVT dependencies on FND_GLOBAL

Line 2105: l_aelv_rec.CREATED_BY := Fnd_Global.USER_ID;

2101: ) RETURN aelv_rec_type IS
2102: l_aelv_rec aelv_rec_type := p_aelv_rec;
2103: BEGIN
2104: l_aelv_rec.CREATION_DATE := SYSDATE;
2105: l_aelv_rec.CREATED_BY := Fnd_Global.USER_ID;
2106: l_aelv_rec.LAST_UPDATE_DATE := SYSDATE;
2107: l_aelv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
2108: l_aelv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2109: RETURN(l_aelv_rec);

Line 2107: l_aelv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

2103: BEGIN
2104: l_aelv_rec.CREATION_DATE := SYSDATE;
2105: l_aelv_rec.CREATED_BY := Fnd_Global.USER_ID;
2106: l_aelv_rec.LAST_UPDATE_DATE := SYSDATE;
2107: l_aelv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
2108: l_aelv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2109: RETURN(l_aelv_rec);
2110: END fill_who_columns;
2111: ---------------------------------------

Line 2108: l_aelv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

2104: l_aelv_rec.CREATION_DATE := SYSDATE;
2105: l_aelv_rec.CREATED_BY := Fnd_Global.USER_ID;
2106: l_aelv_rec.LAST_UPDATE_DATE := SYSDATE;
2107: l_aelv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
2108: l_aelv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
2109: RETURN(l_aelv_rec);
2110: END fill_who_columns;
2111: ---------------------------------------
2112: -- Set_Attributes for:OKL_AE_LINES_V --

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

2119: BEGIN
2120: x_aelv_rec := p_aelv_rec;
2121: x_aelv_rec.OBJECT_VERSION_NUMBER := 1;
2122: x_aelv_rec.ORG_ID := MO_GLOBAL.GET_CURRENT_ORG_ID();
2123: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
2124: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
2125: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
2126: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
2127: INTO x_aelv_rec.REQUEST_ID

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

2120: x_aelv_rec := p_aelv_rec;
2121: x_aelv_rec.OBJECT_VERSION_NUMBER := 1;
2122: x_aelv_rec.ORG_ID := MO_GLOBAL.GET_CURRENT_ORG_ID();
2123: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
2124: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
2125: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
2126: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
2127: INTO x_aelv_rec.REQUEST_ID
2128: ,x_aelv_rec.PROGRAM_APPLICATION_ID

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

2121: x_aelv_rec.OBJECT_VERSION_NUMBER := 1;
2122: x_aelv_rec.ORG_ID := MO_GLOBAL.GET_CURRENT_ORG_ID();
2123: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
2124: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
2125: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
2126: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
2127: INTO x_aelv_rec.REQUEST_ID
2128: ,x_aelv_rec.PROGRAM_APPLICATION_ID
2129: ,x_aelv_rec.PROGRAM_ID

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

2122: x_aelv_rec.ORG_ID := MO_GLOBAL.GET_CURRENT_ORG_ID();
2123: SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
2124: DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
2125: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
2126: DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
2127: INTO x_aelv_rec.REQUEST_ID
2128: ,x_aelv_rec.PROGRAM_APPLICATION_ID
2129: ,x_aelv_rec.PROGRAM_ID
2130: ,x_aelv_rec.PROGRAM_UPDATE_DATE

Line 3273: l_aelv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

3269: ) RETURN aelv_rec_type IS
3270: l_aelv_rec aelv_rec_type := p_aelv_rec;
3271: BEGIN
3272: l_aelv_rec.LAST_UPDATE_DATE := SYSDATE;
3273: l_aelv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
3274: l_aelv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
3275: RETURN(l_aelv_rec);
3276: END fill_who_columns;
3277: ----------------------------------

Line 3274: l_aelv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

3270: l_aelv_rec aelv_rec_type := p_aelv_rec;
3271: BEGIN
3272: l_aelv_rec.LAST_UPDATE_DATE := SYSDATE;
3273: l_aelv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
3274: l_aelv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
3275: RETURN(l_aelv_rec);
3276: END fill_who_columns;
3277: ----------------------------------
3278: -- FUNCTION populate_new_record --

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

3532: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
3533: BEGIN
3534: x_aelv_rec := p_aelv_rec;
3535:
3536: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3537: x_aelv_rec.REQUEST_ID),
3538: NVL(DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),
3539: x_aelv_rec.PROGRAM_APPLICATION_ID),
3540: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

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

3534: x_aelv_rec := p_aelv_rec;
3535:
3536: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3537: x_aelv_rec.REQUEST_ID),
3538: NVL(DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),
3539: x_aelv_rec.PROGRAM_APPLICATION_ID),
3540: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3541: x_aelv_rec.PROGRAM_ID),
3542: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),

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

3536: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
3537: x_aelv_rec.REQUEST_ID),
3538: NVL(DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),
3539: x_aelv_rec.PROGRAM_APPLICATION_ID),
3540: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3541: x_aelv_rec.PROGRAM_ID),
3542: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3543: NULL,x_aelv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
3544: INTO x_aelv_rec.REQUEST_ID

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

3538: NVL(DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.PROG_APPL_ID),
3539: x_aelv_rec.PROGRAM_APPLICATION_ID),
3540: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
3541: x_aelv_rec.PROGRAM_ID),
3542: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
3543: NULL,x_aelv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
3544: INTO x_aelv_rec.REQUEST_ID
3545: ,x_aelv_rec.PROGRAM_APPLICATION_ID
3546: ,x_aelv_rec.PROGRAM_ID