DBA Data[Home] [Help]

APPS.OKC_PAV_PVT dependencies on FND_GLOBAL

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

2829: l_pav_rec.qualifier_attribute98,
2830: l_pav_rec.qualifier_attribute99,
2831: l_pav_rec.qualifier_attribute100,
2832: l_pav_rec.last_update_login,
2833: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
2834: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
2835: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
2836: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
2837: l_pav_rec.object_version_number);

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

2830: l_pav_rec.qualifier_attribute99,
2831: l_pav_rec.qualifier_attribute100,
2832: l_pav_rec.last_update_login,
2833: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
2834: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
2835: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
2836: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
2837: l_pav_rec.object_version_number);
2838: -- Set OUT values

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

2831: l_pav_rec.qualifier_attribute100,
2832: l_pav_rec.last_update_login,
2833: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
2834: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
2835: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
2836: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
2837: l_pav_rec.object_version_number);
2838: -- Set OUT values
2839: x_pav_rec := l_pav_rec;

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

2832: l_pav_rec.last_update_login,
2833: decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
2834: decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
2835: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
2836: decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
2837: l_pav_rec.object_version_number);
2838: -- Set OUT values
2839: x_pav_rec := l_pav_rec;
2840: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2901: l_pavv_rec.CREATED_BY := FND_GLOBAL.USER_ID;

2897: ) RETURN pavv_rec_type IS
2898: l_pavv_rec pavv_rec_type := p_pavv_rec;
2899: BEGIN
2900: l_pavv_rec.CREATION_DATE := SYSDATE;
2901: l_pavv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2902: l_pavv_rec.LAST_UPDATE_DATE := l_pavv_rec.CREATION_DATE;
2903: l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2904: l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2905: RETURN(l_pavv_rec);

Line 2903: l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

2899: BEGIN
2900: l_pavv_rec.CREATION_DATE := SYSDATE;
2901: l_pavv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2902: l_pavv_rec.LAST_UPDATE_DATE := l_pavv_rec.CREATION_DATE;
2903: l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2904: l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2905: RETURN(l_pavv_rec);
2906: END fill_who_columns;
2907: -----------------------------------------------

Line 2904: l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

2900: l_pavv_rec.CREATION_DATE := SYSDATE;
2901: l_pavv_rec.CREATED_BY := FND_GLOBAL.USER_ID;
2902: l_pavv_rec.LAST_UPDATE_DATE := l_pavv_rec.CREATION_DATE;
2903: l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
2904: l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
2905: RETURN(l_pavv_rec);
2906: END fill_who_columns;
2907: -----------------------------------------------
2908: -- Set_Attributes for:OKC_PRICE_ATT_VALUES_V --

Line 4492: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pav_rec.request_id),

4488: QUALIFIER_ATTRIBUTE98 = l_def_pav_rec.qualifier_attribute98,
4489: QUALIFIER_ATTRIBUTE99 = l_def_pav_rec.qualifier_attribute99,
4490: QUALIFIER_ATTRIBUTE100 = l_def_pav_rec.qualifier_attribute100,
4491: LAST_UPDATE_LOGIN = l_def_pav_rec.last_update_login,
4492: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pav_rec.request_id),
4493: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pav_rec.program_application_id),
4494: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pav_rec.program_id),
4495: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pav_rec.program_update_date,SYSDATE),
4496: OBJECT_VERSION_NUMBER = l_def_pav_rec.object_version_number

Line 4493: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pav_rec.program_application_id),

4489: QUALIFIER_ATTRIBUTE99 = l_def_pav_rec.qualifier_attribute99,
4490: QUALIFIER_ATTRIBUTE100 = l_def_pav_rec.qualifier_attribute100,
4491: LAST_UPDATE_LOGIN = l_def_pav_rec.last_update_login,
4492: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pav_rec.request_id),
4493: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pav_rec.program_application_id),
4494: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pav_rec.program_id),
4495: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pav_rec.program_update_date,SYSDATE),
4496: OBJECT_VERSION_NUMBER = l_def_pav_rec.object_version_number
4497: WHERE ID = l_def_pav_rec.id;

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

4490: QUALIFIER_ATTRIBUTE100 = l_def_pav_rec.qualifier_attribute100,
4491: LAST_UPDATE_LOGIN = l_def_pav_rec.last_update_login,
4492: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pav_rec.request_id),
4493: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pav_rec.program_application_id),
4494: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pav_rec.program_id),
4495: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pav_rec.program_update_date,SYSDATE),
4496: OBJECT_VERSION_NUMBER = l_def_pav_rec.object_version_number
4497: WHERE ID = l_def_pav_rec.id;
4498:

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

4491: LAST_UPDATE_LOGIN = l_def_pav_rec.last_update_login,
4492: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_pav_rec.request_id),
4493: PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_pav_rec.program_application_id),
4494: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_pav_rec.program_id),
4495: PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_pav_rec.program_update_date,SYSDATE),
4496: OBJECT_VERSION_NUMBER = l_def_pav_rec.object_version_number
4497: WHERE ID = l_def_pav_rec.id;
4498:
4499: x_pav_rec := l_def_pav_rec;

Line 4561: l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

4557: ) RETURN pavv_rec_type IS
4558: l_pavv_rec pavv_rec_type := p_pavv_rec;
4559: BEGIN
4560: l_pavv_rec.LAST_UPDATE_DATE := SYSDATE;
4561: l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
4562: l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
4563: RETURN(l_pavv_rec);
4564: END fill_who_columns;
4565: ----------------------------------

Line 4562: l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

4558: l_pavv_rec pavv_rec_type := p_pavv_rec;
4559: BEGIN
4560: l_pavv_rec.LAST_UPDATE_DATE := SYSDATE;
4561: l_pavv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
4562: l_pavv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
4563: RETURN(l_pavv_rec);
4564: END fill_who_columns;
4565: ----------------------------------
4566: -- FUNCTION populate_new_record --