DBA Data[Home] [Help]

APPS.OKL_OIP_PVT dependencies on FND_GLOBAL

Line 1424: l_oipv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1420: ) RETURN oipv_rec_type AS
1421: l_oipv_rec oipv_rec_type := p_oipv_rec;
1422: BEGIN
1423: l_oipv_rec.CREATION_DATE := SYSDATE;
1424: l_oipv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1425: l_oipv_rec.LAST_UPDATE_DATE := l_oipv_rec.CREATION_DATE;
1426: l_oipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1427: l_oipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1428: RETURN(l_oipv_rec);

Line 1426: l_oipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1422: BEGIN
1423: l_oipv_rec.CREATION_DATE := SYSDATE;
1424: l_oipv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1425: l_oipv_rec.LAST_UPDATE_DATE := l_oipv_rec.CREATION_DATE;
1426: l_oipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1427: l_oipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1428: RETURN(l_oipv_rec);
1429: END fill_who_columns;
1430: --------------------------------------------

Line 1427: l_oipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1423: l_oipv_rec.CREATION_DATE := SYSDATE;
1424: l_oipv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1425: l_oipv_rec.LAST_UPDATE_DATE := l_oipv_rec.CREATION_DATE;
1426: l_oipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1427: l_oipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1428: RETURN(l_oipv_rec);
1429: END fill_who_columns;
1430: --------------------------------------------
1431: -- Set_Attributes for:OKL_OPEN_INT_PRTY_V --

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

1441:
1442: -- Begin Post-Generation Change
1443: IF (x_oipv_rec.request_id IS NULL OR x_oipv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1444: SELECT
1445: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1446: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1447: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1448: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1449: INTO

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

1442: -- Begin Post-Generation Change
1443: IF (x_oipv_rec.request_id IS NULL OR x_oipv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1444: SELECT
1445: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1446: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1447: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1448: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1449: INTO
1450: x_oipv_rec.request_id,

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

1443: IF (x_oipv_rec.request_id IS NULL OR x_oipv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1444: SELECT
1445: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1446: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1447: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1448: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1449: INTO
1450: x_oipv_rec.request_id,
1451: x_oipv_rec.program_application_id,

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

1444: SELECT
1445: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1446: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1447: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
1448: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE)
1449: INTO
1450: x_oipv_rec.request_id,
1451: x_oipv_rec.program_application_id,
1452: x_oipv_rec.program_id,

Line 2482: l_oipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2478: ) RETURN oipv_rec_type AS
2479: l_oipv_rec oipv_rec_type := p_oipv_rec;
2480: BEGIN
2481: l_oipv_rec.LAST_UPDATE_DATE := SYSDATE;
2482: l_oipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2483: l_oipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2484: RETURN(l_oipv_rec);
2485: END fill_who_columns;
2486: ----------------------------------

Line 2483: l_oipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2479: l_oipv_rec oipv_rec_type := p_oipv_rec;
2480: BEGIN
2481: l_oipv_rec.LAST_UPDATE_DATE := SYSDATE;
2482: l_oipv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2483: l_oipv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2484: RETURN(l_oipv_rec);
2485: END fill_who_columns;
2486: ----------------------------------
2487: -- FUNCTION populate_new_record --

Line 2746: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oipv_rec.request_id),

2742: x_oipv_rec := p_oipv_rec;
2743:
2744: -- Begin Post-Generation Change
2745: IF (x_oipv_rec.request_id IS NULL OR x_oipv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2746: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oipv_rec.request_id),
2747: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oipv_rec.program_application_id),
2748: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oipv_rec.program_id),
2749: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oipv_rec.program_update_date,SYSDATE)
2750: INTO

Line 2747: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oipv_rec.program_application_id),

2743:
2744: -- Begin Post-Generation Change
2745: IF (x_oipv_rec.request_id IS NULL OR x_oipv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2746: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oipv_rec.request_id),
2747: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oipv_rec.program_application_id),
2748: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oipv_rec.program_id),
2749: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oipv_rec.program_update_date,SYSDATE)
2750: INTO
2751: x_oipv_rec.request_id,

Line 2748: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oipv_rec.program_id),

2744: -- Begin Post-Generation Change
2745: IF (x_oipv_rec.request_id IS NULL OR x_oipv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2746: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oipv_rec.request_id),
2747: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oipv_rec.program_application_id),
2748: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oipv_rec.program_id),
2749: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oipv_rec.program_update_date,SYSDATE)
2750: INTO
2751: x_oipv_rec.request_id,
2752: x_oipv_rec.program_application_id,

Line 2749: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oipv_rec.program_update_date,SYSDATE)

2745: IF (x_oipv_rec.request_id IS NULL OR x_oipv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2746: SELECT NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID), x_oipv_rec.request_id),
2747: NVL(DECODE(Fnd_Global.PROG_APPL_ID, -1,NULL,Fnd_Global.PROG_APPL_ID), x_oipv_rec.program_application_id),
2748: NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID), x_oipv_rec.program_id),
2749: DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE), NULL,x_oipv_rec.program_update_date,SYSDATE)
2750: INTO
2751: x_oipv_rec.request_id,
2752: x_oipv_rec.program_application_id,
2753: x_oipv_rec.program_id,