1557: l_cim_rec.creation_date,
1558: l_cim_rec.last_updated_by,
1559: l_cim_rec.last_update_date,
1560: l_cim_rec.last_update_login,
1561: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1562: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1563: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1564: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE) );
1565: -- Set OUT values
1558: l_cim_rec.last_updated_by,
1559: l_cim_rec.last_update_date,
1560: l_cim_rec.last_update_login,
1561: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1562: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1563: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1564: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE) );
1565: -- Set OUT values
1566: x_cim_rec := l_cim_rec;
1559: l_cim_rec.last_update_date,
1560: l_cim_rec.last_update_login,
1561: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1562: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1563: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1564: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE) );
1565: -- Set OUT values
1566: x_cim_rec := l_cim_rec;
1567: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1560: l_cim_rec.last_update_login,
1561: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
1562: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
1563: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
1564: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE) );
1565: -- Set OUT values
1566: x_cim_rec := l_cim_rec;
1567: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1568:
1650: l_cimv_rec cimv_rec_type := p_cimv_rec;
1651: BEGIN
1652:
1653: l_cimv_rec.CREATION_DATE := SYSDATE;
1654: l_cimv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1655: l_cimv_rec.LAST_UPDATE_DATE := l_cimv_rec.CREATION_DATE;
1656: l_cimv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1657: l_cimv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1658:
1652:
1653: l_cimv_rec.CREATION_DATE := SYSDATE;
1654: l_cimv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1655: l_cimv_rec.LAST_UPDATE_DATE := l_cimv_rec.CREATION_DATE;
1656: l_cimv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1657: l_cimv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1658:
1659: RETURN(l_cimv_rec);
1660:
1653: l_cimv_rec.CREATION_DATE := SYSDATE;
1654: l_cimv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1655: l_cimv_rec.LAST_UPDATE_DATE := l_cimv_rec.CREATION_DATE;
1656: l_cimv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1657: l_cimv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1658:
1659: RETURN(l_cimv_rec);
1660:
1661: END fill_who_columns;
2478: CREATION_DATE = l_def_cim_rec.creation_date,
2479: LAST_UPDATED_BY = l_def_cim_rec.last_updated_by,
2480: LAST_UPDATE_DATE = l_def_cim_rec.last_update_date,
2481: LAST_UPDATE_LOGIN = l_def_cim_rec.last_update_login,
2482: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_cim_rec.program_id ),
2483: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_cim_rec.request_id),
2484: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_cim_rec.program_update_date,SYSDATE),
2485: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_cim_rec.program_application_id)
2486: WHERE ID = l_def_cim_rec.id;
2479: LAST_UPDATED_BY = l_def_cim_rec.last_updated_by,
2480: LAST_UPDATE_DATE = l_def_cim_rec.last_update_date,
2481: LAST_UPDATE_LOGIN = l_def_cim_rec.last_update_login,
2482: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_cim_rec.program_id ),
2483: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_cim_rec.request_id),
2484: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_cim_rec.program_update_date,SYSDATE),
2485: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_cim_rec.program_application_id)
2486: WHERE ID = l_def_cim_rec.id;
2487:
2480: LAST_UPDATE_DATE = l_def_cim_rec.last_update_date,
2481: LAST_UPDATE_LOGIN = l_def_cim_rec.last_update_login,
2482: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_cim_rec.program_id ),
2483: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_cim_rec.request_id),
2484: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_cim_rec.program_update_date,SYSDATE),
2485: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_cim_rec.program_application_id)
2486: WHERE ID = l_def_cim_rec.id;
2487:
2488: x_cim_rec := l_def_cim_rec;
2481: LAST_UPDATE_LOGIN = l_def_cim_rec.last_update_login,
2482: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_cim_rec.program_id ),
2483: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_cim_rec.request_id),
2484: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_cim_rec.program_update_date,SYSDATE),
2485: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_cim_rec.program_application_id)
2486: WHERE ID = l_def_cim_rec.id;
2487:
2488: x_cim_rec := l_def_cim_rec;
2489: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2572: l_cimv_rec cimv_rec_type := p_cimv_rec;
2573: BEGIN
2574:
2575: l_cimv_rec.LAST_UPDATE_DATE := SYSDATE;
2576: l_cimv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2577: l_cimv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2578:
2579: RETURN(l_cimv_rec);
2580:
2573: BEGIN
2574:
2575: l_cimv_rec.LAST_UPDATE_DATE := SYSDATE;
2576: l_cimv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2577: l_cimv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2578:
2579: RETURN(l_cimv_rec);
2580:
2581: END fill_who_columns;