DBA Data[Home] [Help]

APPS.OKL_TCL_PVT dependencies on FND_GLOBAL

Line 2867: l_tclv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

2863: ) RETURN tclv_rec_type IS
2864: l_tclv_rec tclv_rec_type := p_tclv_rec;
2865: BEGIN
2866: l_tclv_rec.CREATION_DATE := SYSDATE;
2867: l_tclv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2868: l_tclv_rec.LAST_UPDATE_DATE := SYSDATE;
2869: l_tclv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2870: l_tclv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2871: RETURN(l_tclv_rec);

Line 2869: l_tclv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2865: BEGIN
2866: l_tclv_rec.CREATION_DATE := SYSDATE;
2867: l_tclv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2868: l_tclv_rec.LAST_UPDATE_DATE := SYSDATE;
2869: l_tclv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2870: l_tclv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2871: RETURN(l_tclv_rec);
2872: END fill_who_columns;
2873: ---------------------------------------------

Line 2870: l_tclv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2866: l_tclv_rec.CREATION_DATE := SYSDATE;
2867: l_tclv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2868: l_tclv_rec.LAST_UPDATE_DATE := SYSDATE;
2869: l_tclv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2870: l_tclv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2871: RETURN(l_tclv_rec);
2872: END fill_who_columns;
2873: ---------------------------------------------
2874: -- Set_Attributes for:OKL_TXL_CNTRCT_LNS_V --

Line 2881: l_request_id NUMBER := Fnd_Global.CONC_REQUEST_ID;

2877: p_tclv_rec IN tclv_rec_type,
2878: x_tclv_rec OUT NOCOPY tclv_rec_type
2879: ) RETURN VARCHAR2 IS
2880: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2881: l_request_id NUMBER := Fnd_Global.CONC_REQUEST_ID;
2882: l_prog_app_id NUMBER := Fnd_Global.PROG_APPL_ID;
2883: l_program_id NUMBER := Fnd_Global.CONC_PROGRAM_ID;
2884:
2885:

Line 2882: l_prog_app_id NUMBER := Fnd_Global.PROG_APPL_ID;

2878: x_tclv_rec OUT NOCOPY tclv_rec_type
2879: ) RETURN VARCHAR2 IS
2880: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2881: l_request_id NUMBER := Fnd_Global.CONC_REQUEST_ID;
2882: l_prog_app_id NUMBER := Fnd_Global.PROG_APPL_ID;
2883: l_program_id NUMBER := Fnd_Global.CONC_PROGRAM_ID;
2884:
2885:
2886: -- Added by Santonyr on 25-Nov-2002

Line 2883: l_program_id NUMBER := Fnd_Global.CONC_PROGRAM_ID;

2879: ) RETURN VARCHAR2 IS
2880: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2881: l_request_id NUMBER := Fnd_Global.CONC_REQUEST_ID;
2882: l_prog_app_id NUMBER := Fnd_Global.PROG_APPL_ID;
2883: l_program_id NUMBER := Fnd_Global.CONC_PROGRAM_ID;
2884:
2885:
2886: -- Added by Santonyr on 25-Nov-2002
2887: -- Cursor to fetch the currency code of a transaction

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

2898: x_tclv_rec.ORG_ID := MO_GLOBAL.GET_CURRENT_ORG_ID();
2899:
2900: SELECT DECODE(l_request_id, -1, NULL, l_request_id),
2901: DECODE(l_prog_app_id, -1, NULL, l_prog_app_id),
2902: DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
2903: DECODE(l_request_id, -1, NULL, SYSDATE)
2904: INTO x_tclv_rec.REQUEST_ID
2905: ,x_tclv_rec.PROGRAM_APPLICATION_ID
2906: ,x_tclv_rec.PROGRAM_ID

Line 3815: l_tclv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

3811: ) RETURN tclv_rec_type IS
3812: l_tclv_rec tclv_rec_type := p_tclv_rec;
3813: BEGIN
3814: l_tclv_rec.LAST_UPDATE_DATE := SYSDATE;
3815: l_tclv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3816: l_tclv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3817: RETURN(l_tclv_rec);
3818: END fill_who_columns;
3819: ----------------------------------

Line 3816: l_tclv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

3812: l_tclv_rec tclv_rec_type := p_tclv_rec;
3813: BEGIN
3814: l_tclv_rec.LAST_UPDATE_DATE := SYSDATE;
3815: l_tclv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3816: l_tclv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3817: RETURN(l_tclv_rec);
3818: END fill_who_columns;
3819: ----------------------------------
3820: -- FUNCTION populate_new_record --

Line 4082: l_request_id NUMBER := Fnd_Global.CONC_REQUEST_ID;

4078: p_tclv_rec IN tclv_rec_type,
4079: x_tclv_rec OUT NOCOPY tclv_rec_type
4080: ) RETURN VARCHAR2 IS
4081: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4082: l_request_id NUMBER := Fnd_Global.CONC_REQUEST_ID;
4083: l_prog_app_id NUMBER := Fnd_Global.PROG_APPL_ID;
4084: l_program_id NUMBER := Fnd_Global.CONC_PROGRAM_ID;
4085: BEGIN
4086: x_tclv_rec := p_tclv_rec;

Line 4083: l_prog_app_id NUMBER := Fnd_Global.PROG_APPL_ID;

4079: x_tclv_rec OUT NOCOPY tclv_rec_type
4080: ) RETURN VARCHAR2 IS
4081: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4082: l_request_id NUMBER := Fnd_Global.CONC_REQUEST_ID;
4083: l_prog_app_id NUMBER := Fnd_Global.PROG_APPL_ID;
4084: l_program_id NUMBER := Fnd_Global.CONC_PROGRAM_ID;
4085: BEGIN
4086: x_tclv_rec := p_tclv_rec;
4087:

Line 4084: l_program_id NUMBER := Fnd_Global.CONC_PROGRAM_ID;

4080: ) RETURN VARCHAR2 IS
4081: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4082: l_request_id NUMBER := Fnd_Global.CONC_REQUEST_ID;
4083: l_prog_app_id NUMBER := Fnd_Global.PROG_APPL_ID;
4084: l_program_id NUMBER := Fnd_Global.CONC_PROGRAM_ID;
4085: BEGIN
4086: x_tclv_rec := p_tclv_rec;
4087:
4088: SELECT NVL(DECODE(l_request_id, -1, NULL, l_request_id) ,p_tclv_rec.REQUEST_ID)