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