DBA Data[Home] [Help]

APPS.OKL_OIN_PVT dependencies on FND_GLOBAL

Line 1961: l_oinv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1957: ) RETURN oinv_rec_type AS
1958: l_oinv_rec oinv_rec_type := p_oinv_rec;
1959: BEGIN
1960: l_oinv_rec.CREATION_DATE := SYSDATE;
1961: l_oinv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1962: l_oinv_rec.LAST_UPDATE_DATE := l_oinv_rec.CREATION_DATE;
1963: l_oinv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1964: l_oinv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1965: RETURN(l_oinv_rec);

Line 1963: l_oinv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1959: BEGIN
1960: l_oinv_rec.CREATION_DATE := SYSDATE;
1961: l_oinv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1962: l_oinv_rec.LAST_UPDATE_DATE := l_oinv_rec.CREATION_DATE;
1963: l_oinv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1964: l_oinv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1965: RETURN(l_oinv_rec);
1966: END fill_who_columns;
1967: ---------------------------------------

Line 1964: l_oinv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1960: l_oinv_rec.CREATION_DATE := SYSDATE;
1961: l_oinv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1962: l_oinv_rec.LAST_UPDATE_DATE := l_oinv_rec.CREATION_DATE;
1963: l_oinv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1964: l_oinv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1965: RETURN(l_oinv_rec);
1966: END fill_who_columns;
1967: ---------------------------------------
1968: -- Set_Attributes for:OKL_OPEN_INT_V --

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

1978:
1979: -- Begin Post-Generation Change
1980: IF (x_oinv_rec.request_id IS NULL OR x_oinv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1981: SELECT
1982: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1983: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1984: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1985: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1986: INTO

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

1979: -- Begin Post-Generation Change
1980: IF (x_oinv_rec.request_id IS NULL OR x_oinv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1981: SELECT
1982: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1983: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1984: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1985: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1986: INTO
1987: x_oinv_rec.request_id,

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

1980: IF (x_oinv_rec.request_id IS NULL OR x_oinv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1981: SELECT
1982: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1983: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1984: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1985: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1986: INTO
1987: x_oinv_rec.request_id,
1988: x_oinv_rec.program_application_id,

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

1981: SELECT
1982: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1983: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1984: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1985: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1986: INTO
1987: x_oinv_rec.request_id,
1988: x_oinv_rec.program_application_id,
1989: x_oinv_rec.program_id,

Line 3157: l_oinv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

3153: ) RETURN oinv_rec_type AS
3154: l_oinv_rec oinv_rec_type := p_oinv_rec;
3155: BEGIN
3156: l_oinv_rec.LAST_UPDATE_DATE := SYSDATE;
3157: l_oinv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3158: l_oinv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3159: RETURN(l_oinv_rec);
3160: END fill_who_columns;
3161: ----------------------------------

Line 3158: l_oinv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

3154: l_oinv_rec oinv_rec_type := p_oinv_rec;
3155: BEGIN
3156: l_oinv_rec.LAST_UPDATE_DATE := SYSDATE;
3157: l_oinv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
3158: l_oinv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
3159: RETURN(l_oinv_rec);
3160: END fill_who_columns;
3161: ----------------------------------
3162: -- FUNCTION populate_new_record --

Line 3521: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oinv_rec.request_id),

3517: x_oinv_rec := p_oinv_rec;
3518:
3519: -- Begin Post-Generation Change
3520: IF (x_oinv_rec.request_id IS NULL OR x_oinv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
3521: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oinv_rec.request_id),
3522: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oinv_rec.program_application_id),
3523: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oinv_rec.program_id),
3524: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oinv_rec.program_update_date,SYSDATE)
3525: INTO

Line 3522: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oinv_rec.program_application_id),

3518:
3519: -- Begin Post-Generation Change
3520: IF (x_oinv_rec.request_id IS NULL OR x_oinv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
3521: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oinv_rec.request_id),
3522: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oinv_rec.program_application_id),
3523: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oinv_rec.program_id),
3524: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oinv_rec.program_update_date,SYSDATE)
3525: INTO
3526: x_oinv_rec.request_id,

Line 3523: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oinv_rec.program_id),

3519: -- Begin Post-Generation Change
3520: IF (x_oinv_rec.request_id IS NULL OR x_oinv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
3521: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oinv_rec.request_id),
3522: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oinv_rec.program_application_id),
3523: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oinv_rec.program_id),
3524: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oinv_rec.program_update_date,SYSDATE)
3525: INTO
3526: x_oinv_rec.request_id,
3527: x_oinv_rec.program_application_id,

Line 3524: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oinv_rec.program_update_date,SYSDATE)

3520: IF (x_oinv_rec.request_id IS NULL OR x_oinv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
3521: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oinv_rec.request_id),
3522: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oinv_rec.program_application_id),
3523: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oinv_rec.program_id),
3524: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oinv_rec.program_update_date,SYSDATE)
3525: INTO
3526: x_oinv_rec.request_id,
3527: x_oinv_rec.program_application_id,
3528: x_oinv_rec.program_id,