DBA Data[Home] [Help]

APPS.OKC_CIM_PVT dependencies on FND_GLOBAL

Line 1561: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),

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

Line 1562: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),

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;

Line 1563: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),

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);

Line 1564: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE) );

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:

Line 1654: l_cimv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

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:

Line 1656: l_cimv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

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:

Line 1657: l_cimv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

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;

Line 2482: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_cim_rec.program_id ),

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;

Line 2483: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_cim_rec.request_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:

Line 2484: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_cim_rec.program_update_date,SYSDATE),

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;

Line 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)

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);

Line 2576: l_cimv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

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:

Line 2577: l_cimv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

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;