DBA Data[Home] [Help]

APPS.OKL_INA_PVT dependencies on FND_GLOBAL

Line 1448: l_inav_rec.CREATED_BY := FND_GLOBAL.USER_ID;

1444: ) RETURN inav_rec_type IS
1445: l_inav_rec inav_rec_type := p_inav_rec;
1446: BEGIN
1447: l_inav_rec.CREATION_DATE := SYSDATE;
1448: l_inav_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1449: l_inav_rec.LAST_UPDATE_DATE := l_inav_rec.CREATION_DATE;
1450: l_inav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1451: l_inav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1452: RETURN(l_inav_rec);

Line 1450: l_inav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

1446: BEGIN
1447: l_inav_rec.CREATION_DATE := SYSDATE;
1448: l_inav_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1449: l_inav_rec.LAST_UPDATE_DATE := l_inav_rec.CREATION_DATE;
1450: l_inav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1451: l_inav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1452: RETURN(l_inav_rec);
1453: END fill_who_columns;
1454: -----------------------------------------

Line 1451: l_inav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

1447: l_inav_rec.CREATION_DATE := SYSDATE;
1448: l_inav_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1449: l_inav_rec.LAST_UPDATE_DATE := l_inav_rec.CREATION_DATE;
1450: l_inav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1451: l_inav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1452: RETURN(l_inav_rec);
1453: END fill_who_columns;
1454: -----------------------------------------
1455: -- Set_Attributes for:OKL_INS_ASSETS_V --

Line 1466: SELECT NVL(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),p_inav_rec.request_id),

1462: l_org_id NUMBER;
1463: BEGIN
1464: x_inav_rec := p_inav_rec;
1465: x_inav_rec.OBJECT_VERSION_NUMBER := 1;
1466: SELECT NVL(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),p_inav_rec.request_id),
1467: NVL(DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_inav_rec.program_application_id),
1468: NVL(DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_inav_rec.program_id),
1469: DECODE(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_inav_rec.program_update_date,SYSDATE),
1470: MO_GLOBAL.GET_CURRENT_ORG_ID()

Line 1467: NVL(DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_inav_rec.program_application_id),

1463: BEGIN
1464: x_inav_rec := p_inav_rec;
1465: x_inav_rec.OBJECT_VERSION_NUMBER := 1;
1466: SELECT NVL(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),p_inav_rec.request_id),
1467: NVL(DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_inav_rec.program_application_id),
1468: NVL(DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_inav_rec.program_id),
1469: DECODE(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_inav_rec.program_update_date,SYSDATE),
1470: MO_GLOBAL.GET_CURRENT_ORG_ID()
1471: INTO x_inav_rec.request_id,

Line 1468: NVL(DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_inav_rec.program_id),

1464: x_inav_rec := p_inav_rec;
1465: x_inav_rec.OBJECT_VERSION_NUMBER := 1;
1466: SELECT NVL(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),p_inav_rec.request_id),
1467: NVL(DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_inav_rec.program_application_id),
1468: NVL(DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_inav_rec.program_id),
1469: DECODE(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_inav_rec.program_update_date,SYSDATE),
1470: MO_GLOBAL.GET_CURRENT_ORG_ID()
1471: INTO x_inav_rec.request_id,
1472: x_inav_rec.program_application_id,

Line 1469: DECODE(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_inav_rec.program_update_date,SYSDATE),

1465: x_inav_rec.OBJECT_VERSION_NUMBER := 1;
1466: SELECT NVL(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),p_inav_rec.request_id),
1467: NVL(DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_inav_rec.program_application_id),
1468: NVL(DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_inav_rec.program_id),
1469: DECODE(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_inav_rec.program_update_date,SYSDATE),
1470: MO_GLOBAL.GET_CURRENT_ORG_ID()
1471: INTO x_inav_rec.request_id,
1472: x_inav_rec.program_application_id,
1473: x_inav_rec.program_id,

Line 2397: l_inav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2393: ) RETURN inav_rec_type IS
2394: l_inav_rec inav_rec_type := p_inav_rec;
2395: BEGIN
2396: l_inav_rec.LAST_UPDATE_DATE := SYSDATE;
2397: l_inav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2398: l_inav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2399: RETURN(l_inav_rec);
2400: END fill_who_columns;
2401: ----------------------------------

Line 2398: l_inav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2394: l_inav_rec inav_rec_type := p_inav_rec;
2395: BEGIN
2396: l_inav_rec.LAST_UPDATE_DATE := SYSDATE;
2397: l_inav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2398: l_inav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2399: RETURN(l_inav_rec);
2400: END fill_who_columns;
2401: ----------------------------------
2402: -- FUNCTION populate_new_record --

Line 2558: SELECT NVL(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),p_inav_rec.request_id),

2554: ) RETURN VARCHAR2 IS
2555: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2556: BEGIN
2557: x_inav_rec := p_inav_rec;
2558: SELECT NVL(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),p_inav_rec.request_id),
2559: NVL(DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_inav_rec.program_application_id),
2560: NVL(DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_inav_rec.program_id),
2561: DECODE(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_inav_rec.program_update_date,SYSDATE),
2562: MO_GLOBAL.GET_CURRENT_ORG_ID()

Line 2559: NVL(DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_inav_rec.program_application_id),

2555: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2556: BEGIN
2557: x_inav_rec := p_inav_rec;
2558: SELECT NVL(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),p_inav_rec.request_id),
2559: NVL(DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_inav_rec.program_application_id),
2560: NVL(DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_inav_rec.program_id),
2561: DECODE(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_inav_rec.program_update_date,SYSDATE),
2562: MO_GLOBAL.GET_CURRENT_ORG_ID()
2563: INTO x_inav_rec.request_id,

Line 2560: NVL(DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_inav_rec.program_id),

2556: BEGIN
2557: x_inav_rec := p_inav_rec;
2558: SELECT NVL(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),p_inav_rec.request_id),
2559: NVL(DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_inav_rec.program_application_id),
2560: NVL(DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_inav_rec.program_id),
2561: DECODE(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_inav_rec.program_update_date,SYSDATE),
2562: MO_GLOBAL.GET_CURRENT_ORG_ID()
2563: INTO x_inav_rec.request_id,
2564: x_inav_rec.program_application_id,

Line 2561: DECODE(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_inav_rec.program_update_date,SYSDATE),

2557: x_inav_rec := p_inav_rec;
2558: SELECT NVL(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),p_inav_rec.request_id),
2559: NVL(DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),p_inav_rec.program_application_id),
2560: NVL(DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),p_inav_rec.program_id),
2561: DECODE(DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,p_inav_rec.program_update_date,SYSDATE),
2562: MO_GLOBAL.GET_CURRENT_ORG_ID()
2563: INTO x_inav_rec.request_id,
2564: x_inav_rec.program_application_id,
2565: x_inav_rec.program_id,