DBA Data[Home] [Help]

APPS.CS_SRCONTACT_PKG dependencies on CS_HZ_SR_CONTACT_POINTS_S

Line 827: FND_MSG_PUB.ADD_DETAIL(P_ASSOCIATED_COLUMN1=>'CS_HZ_SR_CONTACT_POINTS.SR_CONTACT_POINT_ID');

823: FND_MESSAGE.set_token
824: ( 'INC_ID'
825: , TO_CHAR(p_incident_id)
826: );
827: FND_MSG_PUB.ADD_DETAIL(P_ASSOCIATED_COLUMN1=>'CS_HZ_SR_CONTACT_POINTS.SR_CONTACT_POINT_ID');
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: EXIT;
830: END IF;
831: l_updated_cp_index := l_updated_cp_index + 1;

Line 976: SELECT cs_hz_sr_contact_points_s.NEXTVAL

972: FOR loop_index in p_contact_tbl.FIRST..p_contact_tbl.LAST LOOP
973: l_add_audit := 'N';
974: IF p_old_contact_tbl(loop_index).sr_contact_point_id is NULL
975: THEN
976: SELECT cs_hz_sr_contact_points_s.NEXTVAL
977: INTO l_sr_contact_point_id
978: FROM DUAL;
979: l_activity_code := 'C';
980: --